5.0.0 preview : type safe api

[synw]

A new type safe api has landed in master and will be introduced in version 5.0.0. Instead of dealing with maps it provides DbRow and typed DbRecord objects.

Note: the original api will still work, backward compatibility is guarantied. The example has been updated to use this api. Feel free to post what you think about this

Type safe api

Create a schema:

DbTable category = DbTable("category")..varchar("name", unique: true);
DbTable product = DbTable("product")
   ..varchar("name", unique: true)
   ..integer("price")
   ..text("descripton", nullable: true)
   ..foreignKey("category", onDelete: OnDelete.cascade)
   ..index("name");
List<DbTable> schema = [category, product];

Initialize a database:

final SqlDb db = SqlDb();
String dbpath = "db.sqlite"; // relative to the documents directory
try {
  await db.init(path: dbpath, schema: schema);
} catch(e) {
  rethrow;
}

Insert

try {
  final lastInsertedId = await db.insert(
      table: "product",
      row: DbRow(<DbRecord>[
        DbRecord<String>("name", "Product 2"),
        DbRecord<int>("price", 50),
        DbRecord<int>("category", 1),
      ]));
} catch (e) {
  rethrow;
}

Select

try {
  final List<DbRow> rows = await db.select(
      table: "product",
      limit: 20,
      columns: "id,name",
      where: "name LIKE '%something%'",
      orderBy: "name ASC");
  rows.forEach((row) {
    final int id = row.record<int>("id");
    final String name = row.record<String>("name");
    print("Product : $id $name");
  });
} catch (e) {
  rethrow;
}