Database.ts

import {Client} from "https://deno.land/x/mysql/mod.ts";
import "https://deno.land/x/dotenv/load.ts";

export class Database {
    client: Client;

    constructor() {
        this.client = new Client();
        this.client.connect({
            hostname: Deno.env.get('DATABASE_HOST'),
            db: Deno.env.get('DATABASE_NAME'),
            username: Deno.env.get('DATABASE_USER'),
            password: Deno.env.get('DATABASE_PASSWORD'),
        });
    }

    async query(sql: string) {
        return await this.client.query(sql);
    }
}