import { sql } from "drizzle-orm";
import { pgTable, text, varchar, integer, boolean, timestamp, serial } from "drizzle-orm/pg-core";
import { createInsertSchema } from "drizzle-zod";
import { z } from "zod";

export const articles = pgTable("articles", {
  id: serial("id").primaryKey(),
  title: text("title").notNull(),
  slug: varchar("slug", { length: 255 }).notNull().unique(),
  excerpt: text("excerpt").notNull(),
  content: text("content").notNull(),
  coverImage: text("cover_image"),
  category: varchar("category", { length: 100 }).notNull().default("News"),
  author: varchar("author", { length: 255 }).notNull().default("Folx Music Television"),
  featured: boolean("featured").notNull().default(false),
  views: integer("views").notNull().default(0),
  publishedAt: timestamp("published_at").notNull().defaultNow(),
});

export const insertArticleSchema = createInsertSchema(articles).omit({
  id: true,
  views: true,
  publishedAt: true,
});

export type InsertArticle = z.infer<typeof insertArticleSchema>;
export type Article = typeof articles.$inferSelect;

export const dailyHoroscopes = pgTable("daily_horoscopes", {
  id: serial("id").primaryKey(),
  signIndex: integer("sign_index").notNull(),
  signName: varchar("sign_name", { length: 50 }).notNull(),
  dateStr: varchar("date_str", { length: 10 }).notNull(),
  general: text("general").notNull(),
  love: text("love").notNull(),
  career: text("career").notNull(),
  health: text("health").notNull(),
  tip: text("tip").notNull(),
  weekly: text("weekly").notNull(),
  monthly: text("monthly").notNull(),
  createdAt: timestamp("created_at").notNull().defaultNow(),
});

export type DailyHoroscope = typeof dailyHoroscopes.$inferSelect;

export const users = pgTable("users", {
  id: varchar("id").primaryKey().default(sql`gen_random_uuid()`),
  username: text("username").notNull().unique(),
  password: text("password").notNull(),
});

export const insertUserSchema = createInsertSchema(users).pick({
  username: true,
  password: true,
});

export type InsertUser = z.infer<typeof insertUserSchema>;
export type User = typeof users.$inferSelect;
