幸运飞行艇-168开奖体彩网-开奖结果/开奖历史、记录
for internal tools

1import airplane from "airplane";
2
3export default airplane.task(
4  {
5    slug: "find_customers_by_email",
6    resources: ["demo_db"],
7    parameters: { email: "shorttext" },
8  },
9  async (params) => {
10    const run = await airplane.sql.query(
11      // The slug of the SQL resource to query
12      "demo_db",
13      // SQL query to execute
14      "select * from users where email ilike :email",
15      // Query arguments
16      { args: { email: `%${params.email}%` } },
17    );
18
19    return run.output.Q1;
20  }
21);