Merge branch 'main' into next

1 files changed, 27 insertions, 0 deletions

diff --git a/packages/db/test/static-remote.test.js b/packages/db/test/static-remote.test.js
index 39e4eda0c..ddfe735e5 100644
--- a/packages/db/test/static-remote.test.js
+++ b/packages/db/test/static-remote.test.js
@@ -39,4 +39,31 @@ describe('astro:db', () => {
 			assert.match($('#row').text(), /1/);
 		});
 	});
+
+	describe('static build --remote with custom LibSQL', () => {
+		let remoteDbServer;
+
+		before(async () => {
+			process.env.ASTRO_DB_REMOTE_URL = `memory:`;
+			await fixture.build();
+		});
+
+		after(async () => {
+			await remoteDbServer?.stop();
+		});
+
+		it('Can render page', async () => {
+			const html = await fixture.readFile('/index.html');
+			const $ = cheerioLoad(html);
+
+			assert.equal($('li').length, 1);
+		});
+
+		it('Returns correct shape from db.run()', async () => {
+			const html = await fixture.readFile('/run/index.html');
+			const $ = cheerioLoad(html);
+
+			assert.match($('#row').text(), /1/);
+		});
+	});
 });