DatabaseActions extension
Reusable database operations shared across repositories.
- on
Methods
-
deleteEverything(
) → Future< void> -
Available on AppDatabase, provided by the DatabaseActions extension
Drops and recreates all tables, fully resetting the database. -
getOrCreateSemester(
int year, int term) → Future< int> -
Available on AppDatabase, provided by the DatabaseActions extension
Returns the ID of an existing semester row, or creates one if missing. -
upsertClass(
{required String code, required String nameZh, String? nameEn}) → Future< int> -
Available on AppDatabase, provided by the DatabaseActions extension
Returns the ID of an existing class row, or creates one. -
upsertClassroom(
{required String code, required String nameZh}) → Future< int> -
Available on AppDatabase, provided by the DatabaseActions extension
Returns the ID of an existing classroom row, or creates one. -
upsertCourse(
{required String code, required double credits, required int hours, required String nameZh, String? nameEn}) → Future< int> -
Available on AppDatabase, provided by the DatabaseActions extension
Returns the ID of an existing course row, or creates/updates one. -
upsertCourseOffering(
{required int courseId, required int semesterId, required String number, int? phase, String? status, String? language, String? remarks, String? syllabusId}) → Future< int> -
Available on AppDatabase, provided by the DatabaseActions extension
Returns the ID of an existing course offering, or creates/updates one. -
upsertTeacher(
{required String code, required int semesterId, required String nameZh, String? nameEn}) → Future< int> -
Available on AppDatabase, provided by the DatabaseActions extension
Returns the ID of an existing teacher row, or creates/updates one.