drift

// model/class_name.dart import 'package:drift/drift.dart'; class ClassNames extends Table { // PRIMARY KEY IntColumn get id => integer().autoIncrement()(); // Content TextColumn get content => text()(); // Date DateTimeColumn get date => dateTime()(); // Start Time IntColumn get startTime => integer()(); // End Time IntColumn get endTime => integer()(); // Category Color Table ID IntColumn get colorId => integer()(); // Created (Default DateTime.now()) DateTimeColumn get createdAt => dateTime().clientDefault( () => DateTime.now(), )(); }

// database/drift_database.dart // drift main layout import 'dart:io'; // DB location package import 'package:drift/drift.dart'; import 'package:drift/native.dart'; import 'package:path/path.dart' as p; import 'package:path_provider/path_provider.dart'; // models modify import '../model/goal.dart'; import '../model/mood.dart'; import '../model/todo_item.dart'; part 'drift_database.g.dart'; // error for now @DriftDatabase( tables: [ Goals, // modify Moods, // modify Todos, // modify ], ) class LocalDatabase extends _$LocalDatabase{ LocalDatabase() : super(_openConnection()); } // set DB location LazyDatabase _openConnection(){ return LazyDatabase(()async{ final dbFolder = await getApplicationDocumentsDirectory(); // bring application directory assigned by OS final file = File(p.join(dbFolder.path, 'db.sqlite')); // Import library 'dart.io'. // set file name as db.sqlite return NativeDatabase(file); }); }

// drift main layout class LocalDatabase extends _$LocalDatabase{ LocalDatabase() : super(_openConnection()); @override int get schemaVersion => 1; // manage schema version }

// Future<int> recieves Primary Key value // parameter as Model/Table/Class Companion (i.e. SchedulesCompanion, CategoryColorCompanion) Future<int> createClassName(ClassNamesCompanion data) => into(classNames).insert(data); // Model/Table/Class in lowercase on first letter

// Recieve List of ClassName Future<List<ClassName>> getClassNames() => select(classNames).get(); // Recieve ClassName by Id Future<ClassName> getClassNameById(int id) => (select(classNames)..where((tbl) => tbl.id.equals(id))).getSingle(); // Unrestricted Stream<List<ClassName>> watchClassNames() => select(classnames).watch(); // Restricted 1 Stream<List<ClassName>> watchClassNames(DateTime date) { return (select(classnames)..where((tbl)=> tbl.date.equals(date))).watch(); } // Restricted 2 Stream<List<ClassName>> watchClassNames(DateTime date) { final query = select(classNames); query.where((tbl) => tbl.date.equals(date)); return query.watch() } // Join & Order see No.8 Stream<List<ClassName1WithClassName2>> watchClassNames(DateTime date) { final query = select(classNames1).join([ innerJoin(classNames2, classNames2.id.equalsExp(classNames1.columnName)) // columnName is FK column name ]); // change query query.where(classNames1.date.eqauls(date)); // order by query.orderBy( [ OderingTerm.asc(classNames!.startingTime), ] ); // rows = all data, row = each data return query.watch().map( (rows) => rows.map( (row) => ClassName1WithClassName2( className1: row.readTable(classNames1), className2: row.readTable(classNames2), ), ).toList(), ); } // order Stream<List<ClassName>> getClassNames() => (select(classNames)..orderBy([(t) => OrderingTerm.desc(t.columnId)])).watch();

// model/table1_with_table2.dart import '../database/drift_database'; class ClassName1WithClassName2 { final ClassName1 className1; final ClassName2 className2; Class1WithClass2({ required this.className1, required this.className2, }); }

// remove all removeAllClassName() => delete(classNames).go(); // remove by Id removeClassNameById(int id) => (delete(classNames)..where((tbl) => tbl.id.equals(id))).go();

Future<int> updateClassNameById(int id, ClassNamesCompanion data) => (update(classNames)..where((tbl) => tbl.id.equals(id))).write(data);

// main.dart import 'package:flutter/material.dart'; void main() async { final database = LocalDatabase(); runApp( MaterialApp( home: HomeScreen(), ); ), }

// main.dart import 'package:flutter/material.dart'; import 'package:get_it/get_it.dart'; // add get_it package void main() async { final database = LocalDatabase(); // Dependency Injection GetIt.I.registerSingleton<LocalDatabase>(database); runApp( MaterialApp( home: HomeScreen(), ); ), }

// when use import 'package:get_it/get_it.dart'; import 'package:project_name/database/drift_database.dart'; @State int? selectedId; FutureBuilder<List<ClassName>>( future: GetIt.I<LocalDatabase>().getClassNames(), builder: (context, snapshot) { // passing Primary Key if (snapshot.hasData && selectedId == null && snapshot.data!.isNotEmpty){ selectedId = snapshot.data![0].PKColumnName; } // pass list of items return CustomWidget( objects: snapshot.hasData ? snapshot.data! : [], list: snapshot.hasData ? snapshot.data!.map((e) => e.columnName).toList() : [], selectedId: selectedId, } ) StreamBuilder<List<ClassName>>( stream: GetIt.I<LocalDatabase>().watchClassNames(), builder: (context, snapshot) { // waiting for data if(!snapshot.hasData){ return Center( child:CircularProgressIndicator() ); } // recieved data with null value if(snapshot.hasData && snapshot.data!.isEmpty){ return Center( child: Text("There's no item"),. ); } return ListView.separated( itemCount: snapshot.data!.length, // widget between each items separatorBuilder: (context, index) { return SizedBox( height: 8.0, ); }, // widget item to build itemBuilder: (context, index) { final itemName = snapshot.data![index]; return ScheduleCard( startTime: itemName.data.startTime, endTime: itemName.endTime, content: itemName.content, color: Colors.red, ); }, ); }, ), // selectId == e.id // when error import 'package:drift/drift.dart' show Value; await GetIt.I<LocalDatabase>().queryName(), // create query on main.dart await database.createClassNames( {ClassNamesCompanion}( // must wrap value with Value columnName: Value(value), columnName: Value(value), ) ) // get query await database.getClassNames()