sql_query 1.1.2+2

Extended Function for sqflite.

sql_query

void main() {
  await DB.init(
    databaseName: 'sesuatu',
    tableList: [
      Produk.tables(),
    ],
  );
}


class Produk {
  static const table = 'produk';
  static const id = 'id';
  static const pNama = 'p_nama';
  static const createdAt = 'created_at';

  static final column = [
    ColumnDatabase(name: id, typeData: DataType.integer, primaryKey: true, autoIncrement: true),
    ColumnDatabase(name: pNama, typeData: DataType.text),
    ColumnDatabase(name: createdAt, typeData: DataType.double),
  ];

  static tables() {
    return TableDatabase(
      tableName: table,
      column: column,
    );
  }

  static get() async {
    final gt = DB.table(table);
    gt.where(createdAt, '<=', DateTime.now().millisecondsSinceEpoch.toString());
    return await gt.get();
  }
}