logo Windmill Hub
Login
All items
1

Execute Query

by
Published Jun 6, 2022
Script mysql Verified
Use in Windmill

The script

Submitted by hugo989 Bun
Verified 17 days ago
All edits
Permalink
1 
import mysql from "mysql2/promise";
2
3 
type Mysql = {
4 
  host: string;
5 
  port: number;
6 
  user: string;
7 
  database: string;
8 
  password: string;
9 
  ssl: boolean;
10 
};
11 
export async function main(mysql_conn: Mysql, query: string) {
12 
  const conn = await mysql.createConnection({
13 
    host: mysql_conn.host,
14 
    port: mysql_conn.port,
15 
    user: mysql_conn.user,
16 
    database: mysql_conn.database,
17 
    password: mysql_conn.password,
18 
    ssl: mysql_conn.ssl ? {} : undefined,
19 
  });
20
21 
  const [rows] = await conn.query(query);
22 
  await conn.end();
23 
  return rows;
24 
}
25
Other submissions
  • Submitted by rossmccrann Deno
    Created 409 days ago
    All edits
    Permalink
    1 
    import { Client } from "https://deno.land/x/mysql/mod.ts";
    2
    3 
    type Mysql = {
    4 
      host: string;
    5 
      port: number;
    6 
      user: string;
    7 
      database: string;
    8 
      password: string;
    9 
      ssl: boolean;
    10 
    };
    11 
    export async function main(mysql_conn: Mysql, query: string) {
    12 
      mysql_conn.db = mysql_conn.database;
    13 
      mysql_conn.hostname = mysql_conn.host;
    14 
      mysql_conn.username = mysql_conn.user;
    15
    16 
      const client = await new Client().connect(mysql_conn);
    17
    18 
      return await client.execute(query);
    19 
    }
    20