const payingUserIds = ctx.db
  .select({
    id: users.id,
  })
  .from(users)
  .where(inArray(users.subscriptionId, paidPlans))
  .getSQL();

const update = await ctx.db
  .update(userUsages)
  .set({
    lastResetAt: sql`CURRENT_TIMESTAMP`,
    audioRecordingsMetered: 0,
  })
  .where(
    and(
      inArray(userUsages.userId, payingUserIds),
      sql`${userUsages.lastResetAt} <= (CURRENT_DATE - INTERVAL '1 month')`,
    ),
  );

const payingUserIds = ctx.db
  .select({
    id: users.id,
  })
  .from(users)
  .where(inArray(users.subscriptionId, paidPlans))
  .getSQL();

const update = await ctx.db
  .update(userUsages)
  .set({
    lastResetAt: sql`CURRENT_TIMESTAMP`,
    audioRecordingsMetered: 0,
  })
  .where(
    and(
      inArray(userUsages.userId, payingUserIds),
      sql`${userUsages.lastResetAt} <= (CURRENT_DATE - INTERVAL '1 month')`,
    ),
  );

export const users = pgTable("users", {
  id: uuid("id").defaultRandom().primaryKey().notNull(),
  email: varchar("email", { length: 256 }),
  stripeId: varchar("stripe_id", { length: 256 }),
  subscriptionId: varchar("subscription_id", { length: 256 }).default("unsubscribed"),
  paymentStatus: varchar("payment_status", { length: 256 }).default("none"),
  hasUsedTrial: boolean("has_used_trial").default(false),
});
export type User = InferSelectModel<typeof users>;

export const userUsages = pgTable("user_usage", {
  id: uuid("id").defaultRandom().primaryKey().notNull(),
  userId: uuid("user_id"),
  lastResetAt: timestamp("last_reset_at", { mode: "string" })
    .defaultNow()
    .notNull(),
  audioRecordingsMetered: integer("audio_recordings_metered"),
  audioRecordingsTotal: integer("audio_recordings_total"),
});

export const usersRelations = relations(users, ({ one }) => ({
  userUsage: one(userUsages, {
    fields: [users.id],
    references: [userUsages.userId],
  }),
  plan: one(plans, {
    fields: [users.subscriptionId],
    references: [plans.stripeLookupKey],
  }),
}));

export const users = pgTable("users", {
  id: uuid("id").defaultRandom().primaryKey().notNull(),
  email: varchar("email", { length: 256 }),
  stripeId: varchar("stripe_id", { length: 256 }),
  subscriptionId: varchar("subscription_id", { length: 256 }).default("unsubscribed"),
  paymentStatus: varchar("payment_status", { length: 256 }).default("none"),
  hasUsedTrial: boolean("has_used_trial").default(false),
});
export type User = InferSelectModel<typeof users>;

export const userUsages = pgTable("user_usage", {
  id: uuid("id").defaultRandom().primaryKey().notNull(),
  userId: uuid("user_id"),
  lastResetAt: timestamp("last_reset_at", { mode: "string" })
    .defaultNow()
    .notNull(),
  audioRecordingsMetered: integer("audio_recordings_metered"),
  audioRecordingsTotal: integer("audio_recordings_total"),
});

export const usersRelations = relations(users, ({ one }) => ({
  userUsage: one(userUsages, {
    fields: [users.id],
    references: [userUsages.userId],
  }),
  plan: one(plans, {
    fields: [users.subscriptionId],
    references: [plans.stripeLookupKey],
  }),
}));

[✓] 6  tables fetched
[✓] 72 columns fetched
[✓] 0  enums fetched
[✓] 1  indexes fetched
[✓] 0  foreign keys fetched

[i] No SQL generated, you already have migrations in project
[✓] You schema file is ready ➜ drizzle/generated/schema.ts 🚀

[✓] 6  tables fetched
[✓] 72 columns fetched
[✓] 0  enums fetched
[✓] 1  indexes fetched
[✓] 0  foreign keys fetched

[i] No SQL generated, you already have migrations in project
[✓] You schema file is ready ➜ drizzle/generated/schema.ts 🚀