quds_db
데이터베이스 및 테이블 생성, CRUD 작업, 모델링된 쿼리를 단순화하는 sqflite 확장 패키지
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 ↗