athena_mysql 1.0.11

athena_mysql: ^1.0.11 copied to clipboard

example/main.dart

import 'package:athena_mysql/athena_mysql.dart';

void main(List<String> args) async {
  final athenaSql = AthenaMySQL(MySqlDatabaseConfig('localgost', 3306,
      userName: 'userName', password: 'password', maxConnections: 10));

  await athenaSql.open();

  await athenaSql.create
      .table('users')
      .column((t) => t.string('name'))
      .column((t) => t.string('email'))
      .column((t) => t.int_('age'))
      .run();
  await athenaSql.insert
      .into('users')
      .values({'name': 'juan', 'email': 'juan@example.com'}).run();

  final selected = await athenaSql
      .select(['name', 'email'])
      .from('users')
      .as('u')
      .where((w) => w['u.name'].noEq('@name'))
      .run(mapValues: {'name': 'juan'});
  print(selected);
}