finalize WIP API (#10280)

* feat: no more readable / writable

* fix: table typegen

* wip: move data seeding

* chore: add scripts to basics

* feat: data() -> seed file

* refactor: ensure precedence of file name

* feat: db execute command

* fix: test imports

* chore: remove old readable error tests

* feat: support local db with `db execute`

* refactor: remove integrations from test for now

* chore: stray comment

* chore: remove `table` config object

* feat: `db.batch`!

* refactor: move migrations/ inside db/

* fix: move ticketing-example to seed file

* fix: disable foreign keys when recreating tables

* refactor: standardize migrations dir

* feat: move to db/config.ts

* feat: file watching for db/config.ts dependencies

* feat: remove unsafeDisableStudio

* chroe: remove bad import

* feat: parse config.ts from cli

* chore: remove async from localDatabaseClient

* fix: update recipes config and seed

* chore: update unit tests

* chore: update tests to dev server

* refactor: collectionToTable -> asDrizzleTable

* chore: tidy up collection -> table error states

* refactor: regexp -> endsWith

* feat: pretty error inserting into table

* refactor: try/catch -> catch()

* feat: expose utils for integration seed files

* fix: add config import to db client modules

* fix: just use generic "seeding database" error

* chore: remove unused link args

* fix: migration queries im,port

* chore: remove irrelevant glob/ example

* feat: format migration file path

* feat: support all config file names

* chore: remove db.batch() for now

* chore: remove `db` object

* core: remove unused integration file

* chore: changeset

* fix: foreign key empty error message

* chore: remove old TODO

* fix: bad context reference

* refactor: seedDev -> seedLocal

* wip: throw some console logs at github

* wip: avoid seeding astro:db imported by seed file

* wip: use anything in db/

* refactor: only seed when loaded within srcDir

* refactor: avoid resolution when not seeding

* chore: remove logs

* refactor: seed within create local db client

* refactor: use normalizePath

* wip: logs

* wip: logs

* refactor: early return

* chore: more logs

* refactor: no batch

* fix: use beforeAll

* refactor: move all tests to base block

* wip: log dev server starting

* chore: remove logs

* wip: demo ready

* chore: remove duplicate recreateTables() call

* Revert "wip: demo ready"

This reverts commit 37585ce5cb4cce8dcc750d8752e0eb02418b5c87.

* refactor: beforeEach to isolate dev servers

* chore: remove useBundledDbUrl

* refactor: naming and seed scope

* chore: remove stray console logs

* wip: fix windows file import

* wip: try fileURLToPath

* Revert "wip: try fileURLToPath"

This reverts commit 46fd65d61a8a285c2d507d524734369a3b97a1a0.

* Revert "wip: fix windows file import"

This reverts commit 1a669ea646e2dc91ca120539431c10f0793a20f3.

* refactor: dir -> directory

* refactor: move execute file to cli

* refactor: remove seed.dev convention

* wip: attempt fileURLToPath

* wip: debug the file exists

* fix: use mjs??

* chore: remove duplicate seedLocal

* chore: remove log check

* refactor: use in memory db for tests

* chore: clean up test comment

* fix: avoid file writes for db setup on in memory db

* chore: bump db changeset to minor

---------

Co-authored-by: Nate Moore <nate@astro.build>

1 files changed, 9 insertions, 8 deletions

diff --git a/packages/db/test/unit/reference-queries.test.js b/packages/db/test/unit/reference-queries.test.js
index 4c2e3af8d..561879f43 100644
--- a/packages/db/test/unit/reference-queries.test.js
+++ b/packages/db/test/unit/reference-queries.test.js
@@ -1,9 +1,10 @@
 import { expect } from 'chai';
 import { describe, it } from 'mocha';
 import { getCollectionChangeQueries } from '../../dist/core/cli/migration-queries.js';
-import { column, defineReadableTable, tablesSchema } from '../../dist/core/types.js';
+import { column, defineTable } from '../../dist/runtime/config.js';
+import { tablesSchema } from '../../dist/core/types.js';
 
-const BaseUser = defineReadableTable({
+const BaseUser = defineTable({
 	columns: {
 		id: column.number({ primaryKey: true }),
 		name: column.text(),
@@ -13,7 +14,7 @@ const BaseUser = defineReadableTable({
 	},
 });
 
-const BaseSentBox = defineReadableTable({
+const BaseSentBox = defineTable({
 	columns: {
 		to: column.number(),
 		toName: column.text(),
@@ -58,7 +59,7 @@ describe('reference queries', () => {
 	it('adds references with lossless table recreate', async () => {
 		const { SentBox: Initial } = resolveReferences();
 		const { SentBox: Final } = resolveReferences({
-			SentBox: defineReadableTable({
+			SentBox: defineTable({
 				columns: {
 					...BaseSentBox.columns,
 					to: column.number({ references: () => BaseUser.columns.id }),
@@ -82,7 +83,7 @@ describe('reference queries', () => {
 
 	it('removes references with lossless table recreate', async () => {
 		const { SentBox: Initial } = resolveReferences({
-			SentBox: defineReadableTable({
+			SentBox: defineTable({
 				columns: {
 					...BaseSentBox.columns,
 					to: column.number({ references: () => BaseUser.columns.id }),
@@ -108,7 +109,7 @@ describe('reference queries', () => {
 	it('does not use ADD COLUMN when adding optional column with reference', async () => {
 		const { SentBox: Initial } = resolveReferences();
 		const { SentBox: Final } = resolveReferences({
-			SentBox: defineReadableTable({
+			SentBox: defineTable({
 				columns: {
 					...BaseSentBox.columns,
 					from: column.number({ references: () => BaseUser.columns.id, optional: true }),
@@ -131,13 +132,13 @@ describe('reference queries', () => {
 	it('adds and updates foreign key with lossless table recreate', async () => {
 		const { SentBox: InitialWithoutFK } = resolveReferences();
 		const { SentBox: InitialWithDifferentFK } = resolveReferences({
-			SentBox: defineReadableTable({
+			SentBox: defineTable({
 				...BaseSentBox,
 				foreignKeys: [{ columns: ['to'], references: () => [BaseUser.columns.id] }],
 			}),
 		});
 		const { SentBox: Final } = resolveReferences({
-			SentBox: defineReadableTable({
+			SentBox: defineTable({
 				...BaseSentBox,
 				foreignKeys: [
 					{