class Database {
    handler = null;

    constructor(host, user, pass, db) {
        handler = mysql_connect(host, user, pass, db);

        if(handler){
            print("Connected with database: " + host);
        }else if(!handler){
            throw "Can't connect with database: " + host;
        }
    }

    function escape_string(string){
        return mysql_real_escape_string(this.handler, string)
    }

    function exec(q){
        local result = mysql_query(this.handler, q);
    }

    function query(q, ...){
        foreach(i, v in vargv)
            q = format(q, escape_string(v))

        local result = mysql_query(this.handler, q);

        local rows = []
        local row = -1;
        while (row = mysql_fetch_assoc(result))
        {
            rows.append(row);
        }

        mysql_free_result(result);

        return rows;
    }
}