upsertClass method

Future<int> upsertClass({
  1. required String code,
  2. required String nameZh,
  3. String? nameEn,
})

Returns the ID of an existing class row, or creates one.

Implementation

Future<int> upsertClass({
  required String code,
  required String nameZh,
  String? nameEn,
}) async {
  return (await into(classes).insertReturning(
    ClassesCompanion.insert(
      code: code,
      nameZh: nameZh,
      nameEn: Value(nameEn),
    ),
    onConflict: DoUpdate(
      (old) => ClassesCompanion(
        nameZh: Value(nameZh),
        nameEn: Value.absentIfNull(nameEn),
      ),
      target: [classes.code],
    ),
  )).id;
}