// Utility function to create a new record with optional Zod validation
export function createEntityMutation<T extends TableNames>({
  tableName,
  schema,
  authCallback = checkEmployeeAuth,
  validationSchema,
}: {
  tableName: T;
  schema: any;
  authCallback?: AuthCallback;
  validationSchema?: ZodSchema<any>;
}) {
  // Optional Zod schema for validation
  return authMutation({
    args: schema,
    handler: async (ctx, args) => {
      await authCallback(ctx, args.facilityId);

      // Perform Zod validation if a schema is provided
      if (validationSchema) {
        validationSchema.parse(args);
      }

      return await ctx.db.insert(tableName, {
        ...args,
        created_by: ctx.user._id,
        created_at: new Date().toISOString(),
        updated_by: ctx.user._id,
        updated_at: new Date().toISOString(),
      });
    },
  });
}

export const createSport = createEntityMutation({
  tableName: SPORTS_TABLE_NAME,
  schema: {
    name: v.string(),
    facilityId: v.id('facilities'),
    description: v.optional(v.string()),
  },
});

// Utility function to create a new record with optional Zod validation
export function createEntityMutation<T extends TableNames>({
  tableName,
  schema,
  authCallback = checkEmployeeAuth,
  validationSchema,
}: {
  tableName: T;
  schema: any;
  authCallback?: AuthCallback;
  validationSchema?: ZodSchema<any>;
}) {
  // Optional Zod schema for validation
  return authMutation({
    args: schema,
    handler: async (ctx, args) => {
      await authCallback(ctx, args.facilityId);

      // Perform Zod validation if a schema is provided
      if (validationSchema) {
        validationSchema.parse(args);
      }

      return await ctx.db.insert(tableName, {
        ...args,
        created_by: ctx.user._id,
        created_at: new Date().toISOString(),
        updated_by: ctx.user._id,
        updated_at: new Date().toISOString(),
      });
    },
  });
}

export const createSport = createEntityMutation({
  tableName: SPORTS_TABLE_NAME,
  schema: {
    name: v.string(),
    facilityId: v.id('facilities'),
    description: v.optional(v.string()),
  },
});