main.ts

import { drizzle } from "drizzle-orm/libsql/node";
import { eq } from "drizzle-orm";
import { usersTable } from "./db/schema.ts";

const db = drizzle({
  connection: {
    url: Deno.env.get("DB_URL")!,
    authToken: Deno.env.get("DB_AUTH_TOKEN"),
  },
});

async function main() {
  const user: typeof usersTable.$inferInsert = {
    name: "John",
    age: 30,
    email: "john@example.com",
  };

  await db.insert(usersTable).values(user);
  console.log("New user created!");

  const users = await db.select().from(usersTable);
  console.log("Getting all users from the database:", users);

  await db
    .update(usersTable)
    .set({ age: 31 })
    .where(eq(usersTable.email, user.email));
  console.log("User info updated!");

  await db.delete(usersTable).where(eq(usersTable.email, user.email));
  console.log("User deleted!");
}

main();