Edits history of script submission #22474 for ' Execute Query (mysql)'

• bun

  Ap­pro­ved version

  Edit in Windmill

  Embed

  import mysql from "mysql2/promise";
  
  type Mysql = {
    host: string;
    port: number;
    user: string;
    database: string;
    password: string;
    ssl: boolean;
  };
  export async function main(mysql_conn: Mysql, query: string) {
    const conn = await mysql.createConnection({
      host: mysql_conn.host,
      port: mysql_conn.port,
      user: mysql_conn.user,
      database: mysql_conn.database,
      password: mysql_conn.password,
      ssl: mysql_conn.ssl ? {} : undefined,
    });
  
    const [rows] = await conn.query(query);
    await conn.end();
    return rows;
  }
  

  Submitted by hugo989 17 days ago