import 'dart:io';

import 'package:mysql_client/mysql_client.dart';

void main() {
  DocukeepDB db = DocukeepDB("doc.projekte.it.hs-worms.de", 3306, "docukeep",
      "CORNER-past-CONSIDER-SOUND", "docukeep");

  db.initDB();
  print("huh");
  // db.pool.close();
  // exit(0);
}

class DocukeepDB {
  late MySQLConnectionPool pool;

  DocukeepDB(
      String host, int port, String username, String password, String dbName) {
    pool = MySQLConnectionPool(
      host: host,
      port: port,
      userName: username,
      password: password,
      maxConnections: 10,
      databaseName: dbName,
      secure: false, //FIXME(Eric): Turn on once SSL is available
    );
  }

  Future<void> initDB() async {
    final result = await pool.execute("SELECT * FROM test");
    for (final row in result.rows) {
      print(row.assoc());
    }
    print("done");
  }
}