Sync from a8e1c0a7402940e0fc5beef669522b315052df1blatest

8 files changed, 149 insertions, 0 deletions

diff --git a/packages/db/test/fixtures/basics/astro.config.ts b/packages/db/test/fixtures/basics/astro.config.ts
new file mode 100644
index 000000000..983a6947d
--- /dev/null
+++ b/packages/db/test/fixtures/basics/astro.config.ts
@@ -0,0 +1,10 @@
+import db from '@astrojs/db';
+import { defineConfig } from 'astro/config';
+
+// https://astro.build/config
+export default defineConfig({
+	integrations: [db()],
+	devToolbar: {
+		enabled: false,
+	},
+});
diff --git a/packages/db/test/fixtures/basics/db/config.ts b/packages/db/test/fixtures/basics/db/config.ts
new file mode 100644
index 000000000..010ed3a18
--- /dev/null
+++ b/packages/db/test/fixtures/basics/db/config.ts
@@ -0,0 +1,29 @@
+import { column, defineDb, defineTable } from 'astro:db';
+import { Themes } from './theme';
+
+const Author = defineTable({
+	columns: {
+		name: column.text(),
+		age2: column.number({ optional: true }),
+	},
+});
+
+const User = defineTable({
+	columns: {
+		id: column.text({ primaryKey: true, optional: false }),
+		username: column.text({ optional: false, unique: true }),
+		password: column.text({ optional: false }),
+	},
+});
+
+const Session = defineTable({
+	columns: {
+		id: column.text({ primaryKey: true, optional: false }),
+		expiresAt: column.number({ optional: false, name: 'expires_at' }),
+		userId: column.text({ optional: false, references: () => User.columns.id, name: 'user_id' }),
+	},
+});
+
+export default defineDb({
+	tables: { Author, Themes, User, Session },
+});
diff --git a/packages/db/test/fixtures/basics/db/seed.ts b/packages/db/test/fixtures/basics/db/seed.ts
new file mode 100644
index 000000000..9a1ef4322
--- /dev/null
+++ b/packages/db/test/fixtures/basics/db/seed.ts
@@ -0,0 +1,24 @@
+import { Author, Session, User, db } from 'astro:db';
+import { asDrizzleTable } from '@astrojs/db/utils';
+import { Themes as ThemesConfig } from './theme';
+
+const Themes = asDrizzleTable('Themes', ThemesConfig);
+export default async function () {
+	await db.batch([
+		db
+			.insert(Themes)
+			.values([{ name: 'dracula' }, { name: 'monokai', added: new Date() }])
+			.returning({ name: Themes.name }),
+		db
+			.insert(Author)
+			.values([
+				{ name: 'Ben' },
+				{ name: 'Nate' },
+				{ name: 'Erika' },
+				{ name: 'Bjorn' },
+				{ name: 'Sarah' },
+			]),
+		db.insert(User).values([{ id: 'mario', username: 'Mario', password: 'itsame' }]),
+		db.insert(Session).values([{ id: '12345', expiresAt: new Date().valueOf(), userId: 'mario' }]),
+	]);
+}
diff --git a/packages/db/test/fixtures/basics/db/theme.ts b/packages/db/test/fixtures/basics/db/theme.ts
new file mode 100644
index 000000000..015dcc588
--- /dev/null
+++ b/packages/db/test/fixtures/basics/db/theme.ts
@@ -0,0 +1,15 @@
+import { NOW, column, defineTable, sql } from 'astro:db';
+
+export const Themes = defineTable({
+	columns: {
+		name: column.text(),
+		added: column.date({
+			default: sql`CURRENT_TIMESTAMP`,
+		}),
+		updated: column.date({
+			default: NOW,
+		}),
+		isDark: column.boolean({ default: sql`TRUE`, deprecated: true }),
+		owner: column.text({ optional: true, default: sql`NULL` }),
+	},
+});
diff --git a/packages/db/test/fixtures/basics/package.json b/packages/db/test/fixtures/basics/package.json
new file mode 100644
index 000000000..af7cbe229
--- /dev/null
+++ b/packages/db/test/fixtures/basics/package.json
@@ -0,0 +1,14 @@
+{
+  "name": "@test/db-aliases",
+  "version": "0.0.0",
+  "private": true,
+  "scripts": {
+    "dev": "astro dev",
+    "build": "astro build",
+    "preview": "astro preview"
+  },
+  "dependencies": {
+    "@astrojs/db": "workspace:*",
+    "astro": "workspace:*"
+  }
+}
diff --git a/packages/db/test/fixtures/basics/src/pages/index.astro b/packages/db/test/fixtures/basics/src/pages/index.astro
new file mode 100644
index 000000000..2be0c4b23
--- /dev/null
+++ b/packages/db/test/fixtures/basics/src/pages/index.astro
@@ -0,0 +1,27 @@
+---
+/// <reference path="../../.astro/db-types.d.ts" />
+import { Author, Themes, db } from 'astro:db';
+
+const authors = await db.select().from(Author);
+const themes = await db.select().from(Themes);
+---
+
+<h2>Authors</h2>
+<ul class="authors-list">
+	{authors.map((author) => <li>{author.name}</li>)}
+</ul>
+
+<h2>Themes</h2>
+<ul class="themes-list">
+	{
+		themes.map((theme) => (
+			<li>
+				<div class="theme-name">{theme.name}</div>
+				<div class="theme-added">{theme.added}</div>
+				<div class="theme-updated">{theme.updated}</div>
+				<div class="theme-dark">{theme.isDark ? 'dark' : 'light'} mode</div>
+				<div class="theme-owner">{theme.owner}</div>
+			</li>
+		))
+	}
+</ul>
diff --git a/packages/db/test/fixtures/basics/src/pages/login.astro b/packages/db/test/fixtures/basics/src/pages/login.astro
new file mode 100644
index 000000000..4551fc483
--- /dev/null
+++ b/packages/db/test/fixtures/basics/src/pages/login.astro
@@ -0,0 +1,18 @@
+---
+import { Session, User, db, eq } from 'astro:db';
+
+const users = await db.select().from(User);
+const sessions = await db.select().from(Session).innerJoin(User, eq(Session.userId, User.id));
+---
+
+<h2>Sessions</h2>
+<ul class="sessions-list">
+	{
+		sessions.map(({ Session, User }) => (
+			<li>
+				<div class="session-id">{Session.id}</div>
+				<div class="username">{User.username}</div>
+			</li>
+		))
+	}
+</ul>
diff --git a/packages/db/test/fixtures/basics/src/pages/run.json.ts b/packages/db/test/fixtures/basics/src/pages/run.json.ts
new file mode 100644
index 000000000..a86619314
--- /dev/null
+++ b/packages/db/test/fixtures/basics/src/pages/run.json.ts
@@ -0,0 +1,12 @@
+import { db, sql } from 'astro:db';
+/// <reference types="@astrojs/db" />
+import type { APIRoute } from 'astro';
+
+export const GET: APIRoute = async () => {
+	const authors = await db.run(sql`SELECT * FROM Author`);
+	return new Response(JSON.stringify(authors), {
+		headers: {
+			'content-type': 'application/json',
+		},
+	});
+};