flutter_sqlite_m8_generator 0.2.3 flutter_sqlite_m8_generator: ^0.2.3 copied to clipboard
Flutter package to generate SQLite fixture in conjuction with the package flutter_orm_m8.
Sqlite ORM Mate Generator (flutter-sqlite-m8-generator) #
Introduction #
Dart package to generate SQLite ready-to-go fixture. Uses Dart Build System builders. Based on flutter-orm-m8 annotations convention this package generates proxies and database adapter for SQLite.
Dependencies #
It depends on dart package flutter-orm-m8. Read README.md for implemented annotation convention.
Usage #
-
Create a flutter project
-
Add flutter_orm_m8, sqflite, build_runner, flutter_sqlite_m8_generator dependencies to
pubspec.yaml
-
Before
dependencies: flutter: sdk: flutter cupertino_icons: ^0.1.2 dev_dependencies: flutter_test: sdk: flutter
-
After
dependencies: flutter_orm_m8: ^0.4.0 sqflite: ^1.1.0 flutter: sdk: flutter cupertino_icons: ^0.1.2 dev_dependencies: build_runner: ^1.0.0 flutter_sqlite_m8_generator: ^0.1.0 flutter_test: sdk: flutter
-
-
Add build.yaml file with the following content
targets: $default: builders: flutter_sqlite_m8_generator|orm_m8: generate_for: - lib/models/*.dart - lib/main.dart
-
Refresh packages
flutter packages get
-
In the lib folder create a new one named
models
-
In the models folder add model classes for your business objects.
-
Using flutter-orm-m8 annotations convention mark:
- classes with @DataTable
- fields with @DataColumn
-
Run the build_runner
flutter packages pub run build_runner build --delete-conflicting-outputs
The build_runner will generate:
- in models folder, a *.g.m8.dart file for each model file
- in lib folder, a main.adapter.g.m8.dart file
Example #
A full, flutter working example is maintained on https://github.com/matei-tm/flutter-sqlite-m8-generator/tree/master/example
A DbEntity implementation #
Adding a model file independent.dart
with the following content:
import 'package:flutter_orm_m8/flutter_orm_m8.dart';
@DataTable(
"health_entries", TableMetadata.TrackCreate | TableMetadata.TrackUpdate)
class HealthEntry implements DbEntity {
@DataColumn(
"id",
ColumnMetadata.PrimaryKey |
ColumnMetadata.Unique |
ColumnMetadata.AutoIncrement)
int id;
@DataColumn("description", ColumnMetadata.Unique)
String description;
@DataColumn("diagnosys_date")
DateTime diagnosysDate;
@DataColumn("my_future_column", ColumnMetadata.Ignore | ColumnMetadata.Unique)
int futureData;
}
the builder creates independent.g.m8.dart
file with content
// GENERATED CODE - DO NOT MODIFY BY HAND
// **************************************************************************
// Generator: OrmM8GeneratorForAnnotation
// **************************************************************************
import 'package:sqflite/sqflite.dart';
import 'dart:async';
import 'package:example/models/independent.dart';
class HealthEntryProxy extends HealthEntry {
DateTime dateCreate;
DateTime dateUpdate;
HealthEntryProxy();
Map<String, dynamic> toMap() {
var map = Map<String, dynamic>();
map['id'] = id;
map['description'] = description;
map['diagnosys_date'] = diagnosysDate.millisecondsSinceEpoch;
map['date_create'] = dateCreate.millisecondsSinceEpoch;
map['date_update'] = dateUpdate.millisecondsSinceEpoch;
return map;
}
HealthEntryProxy.fromMap(Map<String, dynamic> map) {
this.id = map['id'];
this.description = map['description'];
this.diagnosysDate =
DateTime.fromMillisecondsSinceEpoch(map['diagnosys_date']);
this.dateCreate = DateTime.fromMillisecondsSinceEpoch(map['date_create']);
this.dateUpdate = DateTime.fromMillisecondsSinceEpoch(map['date_update']);
}
}
mixin HealthEntryDatabaseHelper {
Future<Database> db;
final theHealthEntryColumns = ["id", "description", "diagnosys_date"];
final String _theHealthEntryTableHandler = 'health_entries';
Future createHealthEntryTable(Database db) async {
await db.execute(
'CREATE TABLE $_theHealthEntryTableHandler (id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE, description TEXT UNIQUE, diagnosys_date INTEGER , date_create INTEGER, date_update INTEGER)');
}
Future<int> saveHealthEntry(HealthEntryProxy instanceHealthEntry) async {
var dbClient = await db;
instanceHealthEntry.dateCreate = DateTime.now();
instanceHealthEntry.dateUpdate = DateTime.now();
var result = await dbClient.insert(
_theHealthEntryTableHandler, instanceHealthEntry.toMap());
return result;
}
Future<List> getHealthEntrysAll() async {
var dbClient = await db;
var result = await dbClient.query(_theHealthEntryTableHandler,
columns: theHealthEntryColumns, where: '1');
return result.toList();
}
Future<int> getHealthEntrysCount() async {
var dbClient = await db;
return Sqflite.firstIntValue(await dbClient.rawQuery(
'SELECT COUNT(*) FROM $_theHealthEntryTableHandler WHERE 1'));
}
Future<HealthEntry> getHealthEntry(int id) async {
var dbClient = await db;
List<Map> result = await dbClient.query(_theHealthEntryTableHandler,
columns: theHealthEntryColumns, where: '1 AND id = ?', whereArgs: [id]);
if (result.length > 0) {
return HealthEntryProxy.fromMap(result.first);
}
return null;
}
Future<int> deleteHealthEntry(int id) async {
var dbClient = await db;
return await dbClient
.delete(_theHealthEntryTableHandler, where: 'id = ?', whereArgs: [id]);
}
Future<bool> deleteHealthEntrysAll() async {
var dbClient = await db;
await dbClient.delete(_theHealthEntryTableHandler);
return true;
}
Future<int> updateHealthEntry(HealthEntryProxy instanceHealthEntry) async {
var dbClient = await db;
instanceHealthEntry.dateUpdate = DateTime.now();
return await dbClient.update(
_theHealthEntryTableHandler, instanceHealthEntry.toMap(),
where: "id = ?", whereArgs: [instanceHealthEntry.id]);
}
}
and database adapter file main.adapter.g.m8.dart
// GENERATED CODE - DO NOT MODIFY BY HAND
// **************************************************************************
// DatabaseHelperGenerator
// **************************************************************************
import 'dart:async';
import 'package:sqflite/sqflite.dart';
import 'package:path/path.dart';
import 'package:example/models/independent.g.m8.dart';
import 'package:example/models/account_related.g.m8.dart';
import 'package:example/models/account.g.m8.dart';
import 'dart:async';
import 'package:sqflite/sqflite.dart';
import 'package:path/path.dart';
import 'package:example/models/independent.g.m8.dart';
import 'package:example/models/account_related.g.m8.dart';
import 'package:example/models/account.g.m8.dart';
class DatabaseHelper
with
HealthEntryDatabaseHelper,
HealthEntryAccountRelatedDatabaseHelper,
UserAccountDatabaseHelper {
static final DatabaseHelper _instance = DatabaseHelper.internal();
static Database _db;
/// if [extremeDevelopmentMode] is true then the database will be deleteted on each init
bool extremeDevelopmentMode = false;
factory DatabaseHelper() => _instance;
DatabaseHelper.internal();
Future<Database> get db async {
if (_db != null) {
return _db;
}
_db = await initDb();
return _db;
}
initDb() async {
String databasesPath = await getDatabasesPath();
String path = join(databasesPath, 'm8_store_0.2.0.db');
if (extremeDevelopmentMode) {
await deleteDatabase(path);
}
var db = await openDatabase(path, version: 2, onCreate: _onCreate);
return db;
}
void _onCreate(Database db, int newVersion) async {
await createHealthEntryTable(db);
await createHealthEntryAccountRelatedTable(db);
await createUserAccountTable(db);
}
Future close() async {
var dbClient = await db;
return dbClient.close();
}
Future deleteAll() async {
await deleteHealthEntrysAll();
await deleteHealthEntryAccountRelatedsAll();
await deleteUserAccountsAll();
}
}