import { createTRPCRouter, protectedProcedure } from "~/server/api/trpc";
import { timeTable } from "~/drizzle/out/schema";

export const timeTableRouter = createTRPCRouter({
  getAll: protectedProcedure.query(async ({ ctx }) => {
    const timeTables = await ctx.db
      .select()
      .from(timeTable)
      .where(eq(timeTable.userId, ctx.session.user.id));
  }),
});

...
export const timeTable = mysqlTable("TimeTable", {
    id: varchar("id", { length: 191 }).primaryKey().notNull(),
    subjectId: varchar("subjectId", { length: 191 }).notNull(),
    userId: varchar("userId", { length: 191 }).notNull(),
    isLab: tinyint("isLab").default(0).notNull(),
    dayName: mysqlEnum("dayName", ['Monday','Tuesday','Wednesday','Thursday','Friday','Saturday','Sunday']).notNull(),
    endTime: time("endTime").notNull(),
    startTime: time("startTime").notNull(),
    timetableName: varchar("timetableName", { length: 191 }).notNull(),
},
(table) => {
    return {
        subjectIdDayNameStartTimeEndTimeKey: uniqueIndex("TimeTable_subjectId_dayName_startTime_endTime_key").on(table.subjectId, table.dayName, table.startTime, table.endTime),
        subjectIdIdx: index("TimeTable_subjectId_idx").on(table.subjectId),
        userIdIdx: index("TimeTable_userId_idx").on(table.userId),
    }
});
...