Description:

sqflite helper new

This Package will make using sqflite much more fun and much easy than making it from zero
Features #
It will help you to create the crude of the sqflite by just calling all the methods like createdatabase, update, delete, insert and get the data from the database
Getting started #
dependencies:
sqflite_helper_new: ^1.0.0
or
write in the terminal
flutter pub add sqflite_helper_new
Usage #
First create a variable
final sqfliteHelper = SqflitehelperNew();
add the createdatabase inside the initialestate
Example of creating the database:
sqfliteHelper.createDatabase(
version: 1,
databasefilename: 'todo.db',
tablename: 'tasks',
columns: [
{
'name': 'id',
'type': 'INTEGER PRIMARY KEY AUTOINCREMENT',
},
{
'name': 'title',
'type': 'TEXT',
},
{
'name': 'description',
'type': 'TEXT',
},
{
'name': 'status',
'type': 'TEXT',
},
]);
Example of the insert:
sqfliteHelper.insert(
tablename: 'tasks',
data: {
'title': titlecontroller.text,
'description': descriptioncontroller.text,
'status': 'new',
},
copied to clipboard
);
Example of the get data from the database with the column name selected by the developer:
sqfliteHelper.getdatafromdatabase(
tablename: 'tasks', columnname: 'title');


without the column name selected by the developer:
sqfliteHelper.getdatafromdatabase(
tablename: 'tasks');

Example of the update the data:

sqfliteHelper.updateRecord(
tablename: 'tasks',
newData: {"title": "ert"},
whereColumn: "title",
oldValue: "xx");

Example of the delete:
sqfliteHelper.deleteFromDatabase(tablename: 'tasks', whereColumn: 'title', value: 'ert');
copied to clipboard
const like = 'sample';
copied to clipboard
Additional information #
This package will be opensourse and it will be always up to date with sqflite and the sqflite_comman_ffi packages also this package can be updated to use much more features

License

For personal and professional use. You cannot resell or redistribute these repositories in their original state.

Share

• Share on Facebook
• Share on Twitter