Migrate Runbooks to Tasks

typescript
Copied
1
import airplane from "airplane";
2

3
export default airplane.task(
4
  {
5
    slug: "lookup_user",
6
    name: "Lookup user (task)",
7
    parameters: { email: { name: "Email", slug: "email", type: "shorttext" } },
8
    resources: ["demo"],
9
  },
10
  async (params) => {
11
    const lookup = await airplane.sql.query<any>(
12
      "demo",
13
      "select id, name, email from users where email like :email;",
14
      {
15
        args: { email: `%${params.email}%` },
16
      },
17
    );
18

19
    if (lookup.output.Q1.length > 0) {
20
      await airplane.slack.message(
21
        "test-noise",
22
        `Found user: *${lookup.output.Q1[0].name}* who can be reached at *${lookup.output.Q1[0].email}*.`,
23
      );
24
    } else {
25
      console.log("Skipping over 'slack_found' because startCondition is false");
26
    }
27

28
    if (lookup.output.Q1.length === 0) {
29
      await airplane.slack.message(
30
        "test-noise",
31
        `Searched for a user named ${params.name} No user found.`,
32
      );
33
    } else {
34
      console.log("Skipping over 'slack_not_found' because startCondition is false");
35
    }
36
  },
37
);