// src/db/schema.ts
export const contentItems = sqliteTable("content_items", {
  id: integer("id").primaryKey(),
  title: text("title"),
});

export const contentItemRelations = relations(
  contentItems,
  ({ one, many }) => ({
    contentParts: many(contentParts),
  }),
);

export const contentParts = sqliteTable("content_parts", {
  id: integer("id").primaryKey(),
  contentItemId: integer("content_item_id").references(() => contentItems.id),
  title: text("title"),
});

export const contentPartRelations = relations(
  contentParts,
  ({ one, many }) => ({
    contentItem: one(contentItems, {
      fields: [contentParts.contentItemId],
      references: [contentItems.id],
    }),
  }),
);

// src/db/index.ts
import { drizzle } from "drizzle-orm/better-sqlite3";
import * as schema from "./schema";
import type { BetterSQLite3Database } from "drizzle-orm/better-sqlite3";
import Database from "better-sqlite3";

export const sqliteDatabase = new Database("./sqlite.db", {
  verbose: console.log,
});
export const db: BetterSQLite3Database = drizzle(sqliteDatabase, { schema });

// src/content-items/index.ts
import { db } from "@src/db";
import {
  contentItems as contentItemsTable,
} from "@src/db/schema";


export async function getContentItemById(contentItemId: number) {
  const contentItem = await db.query.contentItems.findFirst({
    where: (contentItemsTable, { eq }) => eq(contentItemsTable.id, contentItemId),
    with: {
      contentParts: true,
    },
  });
  return contentItem;
}

// src/db/schema.ts
export const contentItems = sqliteTable("content_items", {
  id: integer("id").primaryKey(),
  title: text("title"),
});

export const contentItemRelations = relations(
  contentItems,
  ({ one, many }) => ({
    contentParts: many(contentParts),
  }),
);

export const contentParts = sqliteTable("content_parts", {
  id: integer("id").primaryKey(),
  contentItemId: integer("content_item_id").references(() => contentItems.id),
  title: text("title"),
});

export const contentPartRelations = relations(
  contentParts,
  ({ one, many }) => ({
    contentItem: one(contentItems, {
      fields: [contentParts.contentItemId],
      references: [contentItems.id],
    }),
  }),
);

// src/db/index.ts
import { drizzle } from "drizzle-orm/better-sqlite3";
import * as schema from "./schema";
import type { BetterSQLite3Database } from "drizzle-orm/better-sqlite3";
import Database from "better-sqlite3";

export const sqliteDatabase = new Database("./sqlite.db", {
  verbose: console.log,
});
export const db: BetterSQLite3Database = drizzle(sqliteDatabase, { schema });

// src/content-items/index.ts
import { db } from "@src/db";
import {
  contentItems as contentItemsTable,
} from "@src/db/schema";


export async function getContentItemById(contentItemId: number) {
  const contentItem = await db.query.contentItems.findFirst({
    where: (contentItemsTable, { eq }) => eq(contentItemsTable.id, contentItemId),
    with: {
      contentParts: true,
    },
  });
  return contentItem;
}