JavaScript SDK

bash
Copied
1
$ npm install airplane

bash
Copied
1
$ yarn add airplane

1. Select users from a database filtered by name
2. Display the selected users in a table
3. Return the number of users that matched

typescript
Copied
1
import airplane from "airplane";
2

3
export default airplane.task(
4
  {
5
    slug: "lookup_users",
6
    name: "Lookup users",
7
    parameters: {
8
      name: "shorttext",
9
    },
10
    resources: ["demo_db"],
11
  },
12
  async (params) => {
13
    console.log(`Looking up users like '${params.name}'`);
14
    const run = await airplane.sql.query<{
15
      id: string;
16
      name: string;
17
      email: string;
18
    }>(
19
      "demo_db",
20
      `
21
      select id, name, email from users
22
      where (name ilike :name or email ilike :name)
23
      order by name asc
24
      `,
25
      { args: { name: `%${params.name}%` } }
26
    );
27

28
    const users = run.output.Q1;
29
    await airplane.display.table(users);
30

31
    return {
32
      numUsers: users.length,
33
    };
34
  }
35
);