// Database Client
// db.ts
import { drizzle } from "drizzle-orm/libsql";
import { createClient } from "@libsql/client";
import * as users from "./schemas/users";

const databaseURL = process.env.DB_URL;
if (!databaseURL) {
  throw new Error("DB_URL is not set");
}

const client = createClient({
  url: databaseURL,
  authToken: process.env.DB_TOKEN,
});

const db = drizzle(client, {
  schema: { ...users },
});

export default db;

// Database Client
// db.ts
import { drizzle } from "drizzle-orm/libsql";
import { createClient } from "@libsql/client";
import * as users from "./schemas/users";

const databaseURL = process.env.DB_URL;
if (!databaseURL) {
  throw new Error("DB_URL is not set");
}

const client = createClient({
  url: databaseURL,
  authToken: process.env.DB_TOKEN,
});

const db = drizzle(client, {
  schema: { ...users },
});

export default db;

// drizzle.config.ts
import type { Config } from "drizzle-kit";

export default {
  schema: "./app/lib/db/schemas/*",
  out: "./app/lib/db/migrations",
  driver: "turso",
  dbCredentials: {
    url: DB_URL,
    authToken: DB_TOKEN,
  },
  verbose: true,
  strict: true,
} satisfies Config;

// drizzle.config.ts
import type { Config } from "drizzle-kit";

export default {
  schema: "./app/lib/db/schemas/*",
  out: "./app/lib/db/migrations",
  driver: "turso",
  dbCredentials: {
    url: DB_URL,
    authToken: DB_TOKEN,
  },
  verbose: true,
  strict: true,
} satisfies Config;

// I suppose it is more beneficial to wrap it up in a transaction function
await db.transaction(async (tx) => {
    const dog = await tx.query.dogs.findFirst({
        where: (dogs, { eq }) => eq(dogs.breed, 'husky')
    });

    await db.delete(dogs).where(eq(dogs.id, dog.id));
});

// I suppose it is more beneficial to wrap it up in a transaction function
await db.transaction(async (tx) => {
    const dog = await tx.query.dogs.findFirst({
        where: (dogs, { eq }) => eq(dogs.breed, 'husky')
    });

    await db.delete(dogs).where(eq(dogs.id, dog.id));
});