Execute Query ( mysql)

Verified

import { Client } from "https://deno.land/x/mysql/mod.ts";
import * as wmill from "https://deno.land/x/windmill@v1.13.0/index.ts";

export async function main(mysql_conn: wmill.Resource<"mysql">, query: string) {
    mysql_conn.db = mysql_conn.database;
    mysql_conn.hostname = mysql_conn.host;
    mysql_conn.username = mysql_conn.user;

    const client = await new Client().connect(
        mysql_conn,
    );

    return (await client.execute(query));
}