extern static mysql_get_client_info: string

class MYSQL: special

/*
   @desc returns last error message
*/
extern static MYSQL.error: string
extern static MYSQL.connect(host: string, user: string, password: string, database: string, port: int): bool
static MYSQL.connect(host: string, user: string, password: string, database: string): bool
begin
  return connect(host, user, password, database, 0)
end
extern static MYSQL.query(text: string): bool
extern static MYSQL.escape_string(str: string): string


class MYSQL_result: special
extern static MYSQL.result: MYSQL_result
extern static MYSQL_result.fields: array#string
extern static MYSQL_result.num_rows: int
extern static MYSQL_result.fetch: array#string

static MYSQL_result.get: array#hash#string
begin
  var result: array#hash#string
  var names: array#string = fields
  var row: array#string = fetch
  while(row.length > 0) {
    var newline: hash#string = new hash#string
    for(var i: int = 0; i < names.length; i++) {
      newline[names[i]] = row[i]
    }
    result.add(newline)
    row = fetch
  }
  return result
end