Closed matei-tm closed 5 years ago
Type mapping https://pub.dartlang.org/packages/sqflite DateTime is not a supported SQLite type. Personally I store them as int (millisSinceEpoch) or string (iso8601)
bool is not a supported SQLite type. Use INTEGER and 0 and 1 values.
INTEGER
Dart type: int
Supported values: from -2^63 to 2^63 - 1
REAL
Dart type: num
TEXT
Dart type: String
BLOB
Dart type: Uint8List
Dart type List
I am integrating two other projects: https://github.com/matei-tm/flutter-sqlite-m8-generator https://github.com/matei-tm/flutter-orm-m8
Furthermore I will close this issue, due to it's behavior surpassed by the mentioned projects.
A code-first approach must be implemented with annotations: @table, @primaryKey, @autoIncrement, @column, @unique, @maxLength, @indexed, @notNull, @ignore