dart/flutter drift insert, update 예제

# models.py
import 'package:drift/drift.dart';

// https://drift.simonbinder.eu/docs/getting-started/advanced_dart_tables/

@DataClassName('InseTable')
class Inse extends Table {
  // autoIncrement
  IntColumn get id => integer().autoIncrement()();
  // null 허용
  IntColumn get category => integer().nullable()();
  // bool
  // 기본값을 false로 지정
  BoolColumn get enable => boolean().withDefault(const Constant(false))();
  // dateTime
  DateTimeColumn get date => dateTime()();
  // String
  // 최소/최대 길이 제한
  TextColumn get title => text().withLength(min: 1, max: 32)();
  //
  TextColumn get content => text().named('body')();
}


# database.dart
import 'dart:io';
import 'package:drift/drift.dart';
import 'package:drift/native.dart';
import 'package:sqlite3/sqlite3.dart';
// dart에서 사용하기 위해 주석처리
// import 'package:sqlite3_flutter_libs/sqlite3_flutter_libs.dart';
import 'package:example/Drift/models.dart';

part 'database.g.dart';

@DriftDatabase(tables: [Inse])
class Handle extends _$Handle {
  Handle() : super(_openConnection());

  @override
  int get schemaVersion => 1;
  // 테이블 전체 데이터 가져오기(Furture)
  Future<List<InseTable>> get allTodoItems => select(inse).get();
  // 테이블 limit 갯수만큼 데이터 가져오기(Furture)
  Future limitTodos(int limit, {int? offset}) {
    return (select(inse)..limit(limit, offset: offset)).get();
  }
  // 특정 데이터 가져오기(Future)
  Future<InseTable> findById(int id) {
    return (select(inse)..where((table) => table.id.equals(id))).getSingle();
  }
  // 수정하기
  Future updateTodo(InseTable entry) {
    return update(inse).replace(entry);
  }
  // 수정하기2
  Future updateTodoCom(InseCompanion entry) {
    return update(inse).replace(entry);
  }
  // 삽입
  Future<int> insertTodo(InseCompanion entry) {
    return into(inse).insert(entry);
  }
  // 삭제
  Future delTodo(int id) {
    return (delete(inse)..where((table) => table.id.equals(id))).go();
  }
}

LazyDatabase _openConnection() {
  return LazyDatabase(() async {
    final file = File('db.sqlite');
    return NativeDatabase.createInBackground(file);
    // return NativeDatabase.memory();
  });
}

# main.dart
import 'package:example/Drift/database.dart';

void main() async {
  final db = await Handle();
  var a = await db.allTodoItems;
  print('[');
  for (final i in a) {print('  $i');}
  print(']');
  print('='*20);
  await db.insertTodo(InseCompanion.insert(
      date: DateTime.now(), title: '222', content: '2'
  )
  );
  a = await db.allTodoItems;
  print('[');
  for (final i in a) {print('  $i,');}
  print(']');
  print('='*20);print('[');
  await db.insertTodo(InseCompanion.insert(
      date: DateTime.now(), title: '333', content: '33'
  )
  );
  a = await db.allTodoItems;
  print('[');
  for (final i in a) {print('  $i,');}
  print(']');
  print('='*20);print('[');
  await db.insertTodo(InseCompanion.insert(
      date: DateTime.now(), title: '444', content: '4'
  )
  );
  await db.updateTodo(InseTable(id: 2, enable: true, date: DateTime.now(), title: '555', content: '5'));
  await db.updateTodoCom(
      InseCompanion.insert(
        id: Value(3),
        title: '34567',
        content: '76543', date: DateTime.now()
      )
  );
  a = await db.allTodoItems;
  print('[');
  for (final i in a) {print('  $i,');}
  print(']');
  print('='*20);print('[');
}