sqfentity 1.0.0+1 sqfentity: ^1.0.0+1 copied to clipboard
SqfEntity ORM for Flutter/Dart lets you build and execute SQL commands easily and quickly with the help of fluent methods similar to .Net Entity Framework.
1.0.0+1 #
Example of linking a column to a sequence
This is sample sequence in model
class SequenceIdentity extends SqfEntitySequence {
SequenceIdentity() {
sequenceName = "identity";
maxValue = 10; /* optional. default is max int (9.223.372.036.854.775.807) */
cycle = true; /* optional. default is false; */
//minValue = 0; /* optional. default is 0 */
//incrementBy = 1; /* optional. default is 1 */
// startWith = 0; /* optional. default is 0 */
super.init();
}
static SequenceIdentity _instance;
static SequenceIdentity get getInstance {
if (_instance == null) {
_instance = SequenceIdentity();
}
return _instance;
}
}
How to linking a column to a sequence?
SqfEntityField("rownum", DbType.integer, sequencedBy: SequenceIdentity()
0.2.7+1 #
added some features and methods:
- SEQUENCE Generator
- dbModel.execScalar()
0.2.6 #
added String Primary Key Type WARNING: change the
primaryKeyType = PrimaryKeyType.integer_auto_incremental;
instead of
primaryKeyisIdentity = true
0.2.5+1 #
Fixed some bugs
0.2.4+1 #
New useful methods added dbModel.execSQL(sql), dbModel.execSQLList(sql) and dbModel.execDataTable(sql) see example at https://github.com/hhtokpinar/sqfEntity/blob/master/README.md#run-sql-raw-query-on-database-or-get-datatable
0.2.3 #
WARNING! toCount() return type (BoolResult) changed to (int)
0.2.2 #
startsWith(), endsWith() and contains() methods modified
0.2.1 #
optional parameter added to delete() method delete([bool hardDelete=false])
0.2.0 #
toListString() method added this method Returns List
0.1.0+22 #
dependencies modified
0.1.0+21 #
.fromWebUrl method modified
0.1.0+20 #
dependencies modified
0.1.0+18 #
recover() and delete() methods updated
0.1.0+13 #
create_model.dart modified
0.1.0+12 #
README.md and example/main.dart modified
0.1.0+11 #
README.md and example/main.dart modified
0.1.0+10 #
README.md and example/main.dart modified
0.1.0+9 #
README.md and example/main.dart modified
0.1.0+8 #
README.md and example/main.dart modified
0.1.0+7 #
README.md and example/main.dart modified
0.1.0+6 #
README.md modified
0.1.0+5 #
README.md modified
0.0.5+5 #
README.md modified
0.0.5+4 #
README.md modified
0.0.5+3 #
README.md modified
0.0.5+2 #
README.md modified
0.0.5+1 #
- toList(), toSingle(), getById(), initializeDb(), fromWeb().. etc methods are replaced with async method
0.0.4+1 #
README.md modified
0.0.3+1 #
README.md modified
0.0.2+1 #
README.md modified
0.0.1 #
- Initial experimentation