upsertClassroom method

Future<int> upsertClassroom({
  1. required String code,
  2. required String nameZh,
})

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

Implementation

Future<int> upsertClassroom({
  required String code,
  required String nameZh,
}) async {
  return (await into(classrooms).insertReturning(
    ClassroomsCompanion.insert(code: code, nameZh: nameZh),
    onConflict: DoUpdate(
      (old) => ClassroomsCompanion(nameZh: Value(nameZh)),
      target: [classrooms.code],
    ),
  )).id;
}