quds_db
एक sqflite विस्तार पैकेज जो डेटाबेस और तालिकाओं के निर्माण, CRUD ऑपरेशन, मॉडलिंग के साथ प्रश्नों को सरल बनाता है
MohammedAsaadAsaad/flutter_quds_db open-source repository details.
यह अंग्रेज़ी मूल स्नैपशॉट है। नवीनतम सामग्री GitHub पर देखें।
Is an automated version of sqflite!
Model classes should extend DbModel class. Define the schema of your model, Supported field type:
| Integers | Strings | DateTimes | Others |
|---|---|---|---|
| IdField | StringField | DateTimeField (saved as num) | BlobField |
| IntField | DateTimeStringField (Saved as string) | BoolField | |
| NumField | |||
| DoubleField | ColorField | ||
| EnumField |
class Note extends DbModel {
var title = StringField(columnName: 'title');
var content = StringField(columnName: 'content');
var isImportant = BoolField(columnName: 'isImportant');
var color = ColorField(columnName: 'color');
@override
List<FieldWithValue>? getFields() => [title, content, isImportant, color];
}
Note that: Every model has default fields:
class NotesProvider extends DbTableProvider<Note> {
NotesProvider() : super(() => Note());
@override
String get tableName => 'Notes';
}
As shown, to set the name of the table:
@override
String get tableName => 'Notes';
Note that: In provider class constructor, you should provide it with model object creation function.
NotesProvider() : super(() => Note());
To create a provider instance,
NotesProvider notesProvider = NotesProvider();
single:
Note n = Note();
n.title.value = 'New note';
n.content.value = 'Note content, describe your self';
n.isImportant.value = ([true, false]..shuffle()).first;
n.color.value = ([Colors.red, Colors.blue, Colors.yellow, Colors.orange]
..shuffle())
.first;
await notesProvider.insertEntry(n);
multiple:
await notesProvider.insertCollection([n1,n2,n3,...]);
var allNotes = await notesProvider.select();
var importantNotes = await notesProvider.select(where:(n)=>n.isImportant.isTrue);
var imortantRed = await notesProvider.select(where:(n)=>n.isImportant.isTrue & n.color.equals(Color(0xffff0000)));
n.title = 'new title';
await notesProvider.updateEntry(n);
await notesProvider.deleteEntry(n);
To handle the changes in some table:
notesProvider.addEntryChangeListner((changeType, entry) {
switch (changeType) {
case EntryChangeType.Insertion:
//New Note added (entry)
break;
case EntryChangeType.Deletion:
//(entry) has been deleted
break;
case EntryChangeType.Modification:
//(entry) has been modified
break;
}
});
Where are the data being stored? By default, your data will be saved in app data folder / 'data.db', and to change it:
DbHelper.mainDbPath = 'your db path';
And if you want to save a table in other file:
class NotesProvider extends DbTableProvider<Note> {
NotesProvider()
: super(() => Note(), specialDbFile: 'your specified file path');
@override
String get tableName => 'Notes';
}
निर्भरता सूची 8 आइटम
^1.10.0^1.8.0^2.0.4^2.5.3^2.3.0^0.5.20^3.0.0^3.0.1उपयोग के अनुसार छाँटें, गतिविधि की तुलना करें और अपनाने से पहले मूल प्रोजेक्ट की आवश्यकताएँ जाँचें।
“A repository is the most basic element of GitHub.”
GitHub Docs — About repositories ↗