getConnection method

Implementation

Future<MySqlConnection> getConnection() async {
  if (connection == null) {
    connection = await MySqlConnection.connect(
        ConnectionSettings(
            host: config.getRequired<String>('database.host'),
            port: config.getRequired<int>('database.port'),
            user: config.getRequired<String>('database.user'),
            db: config.getRequired<String>('database.database'),
            password: config.getRequired<String>('database.password')
        )
    );
    //temporary fix for new mysql version
    await Future.delayed(Duration(milliseconds: 1));
  }
  return connection!;
}