export const tags = pgTable("tags", {
  id: text("id").primaryKey(),
  postId: integer("post_id"),
  tag: text("tag").notNull(),
});
export type TagType = typeof tags.$inferInsert;
export const links = pgTable("links", {
  id: text("id").primaryKey(),
  postId: integer("post_id"),
  url: text("url").notNull(),
});
export type linkType = typeof links.$inferInsert;
export const posts = pgTable(
  "posts",
  {
    id: text("id").primaryKey(),
    userId: text("user_id").notNull(),
    title: text("title").notNull(),
    featured: boolean("featured"),
    image: text("image"),
    excerpt: text("excerpt").notNull(),
    content: text("content").notNull(),
    status: text("status", { enum: ["draft", "published"] })
      .default("draft")
      .notNull(),
    createdAt: timestamp("created_at").defaultNow().notNull(),
    updatedAt: timestamp("updated_at", { mode: "date" }).$onUpdate(
      () => new Date()
    ),
  },
  (t) => ({
    userIdx: index("post_user_idx").on(t.userId),
    createdAtIdx: index("post_created_at_idx").on(t.createdAt),
  })
);

export const linksRelations = relations(links, ({ one }) => ({
  post: one(posts, {
    fields: [links.postId],
    references: [posts.id],
  }),
}));
export const tagsRelations = relations(tags, ({ one }) => ({
  post: one(posts, {
    fields: [tags.postId],
    references: [posts.id],
  }),
}));
export const postRelations = relations(posts, ({ one, many }) => ({
  user: one(users, {
    fields: [posts.userId],
    references: [users.id],
  }),
  tags: many(tags),
  links: many(links),
}));
export type PostType = typeof posts.$inferInsert; 

 export const tags = pgTable("tags", {
  id: text("id").primaryKey(),
  postId: integer("post_id"),
  tag: text("tag").notNull(),
});
export type TagType = typeof tags.$inferInsert;
export const links = pgTable("links", {
  id: text("id").primaryKey(),
  postId: integer("post_id"),
  url: text("url").notNull(),
});
export type linkType = typeof links.$inferInsert;
export const posts = pgTable(
  "posts",
  {
    id: text("id").primaryKey(),
    userId: text("user_id").notNull(),
    title: text("title").notNull(),
    featured: boolean("featured"),
    image: text("image"),
    excerpt: text("excerpt").notNull(),
    content: text("content").notNull(),
    status: text("status", { enum: ["draft", "published"] })
      .default("draft")
      .notNull(),
    createdAt: timestamp("created_at").defaultNow().notNull(),
    updatedAt: timestamp("updated_at", { mode: "date" }).$onUpdate(
      () => new Date()
    ),
  },
  (t) => ({
    userIdx: index("post_user_idx").on(t.userId),
    createdAtIdx: index("post_created_at_idx").on(t.createdAt),
  })
);

export const linksRelations = relations(links, ({ one }) => ({
  post: one(posts, {
    fields: [links.postId],
    references: [posts.id],
  }),
}));
export const tagsRelations = relations(tags, ({ one }) => ({
  post: one(posts, {
    fields: [tags.postId],
    references: [posts.id],
  }),
}));
export const postRelations = relations(posts, ({ one, many }) => ({
  user: one(users, {
    fields: [posts.userId],
    references: [users.id],
  }),
  tags: many(tags),
  links: many(links),
}));
export type PostType = typeof posts.$inferInsert;