summaryrefslogtreecommitdiff
path: root/packages/db/test/libsql-remote.test.js
blob: ca5c021ae180dff7fb1f56f9b719e85e420a54f0 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
import assert from 'node:assert/strict';
import { rm } from 'node:fs/promises';
import { relative } from 'node:path';
import { after, before, describe, it } from 'node:test';
import { fileURLToPath } from 'node:url';
import testAdapter from '../../astro/test/test-adapter.js';
import { loadFixture } from '../../astro/test/test-utils.js';
import { clearEnvironment, initializeRemoteDb } from './test-utils.js';

describe('astro:db local database', () => {
	let fixture;
	before(async () => {
		fixture = await loadFixture({
			root: new URL('./fixtures/libsql-remote/', import.meta.url),
			output: 'server',
			adapter: testAdapter(),
		});
	});

	describe('build --remote with local libSQL file (absolute path)', () => {
		before(async () => {
			clearEnvironment();

			const absoluteFileUrl = new URL('./fixtures/libsql-remote/dist/absolute.db', import.meta.url);
			// Remove the file if it exists to avoid conflict between test runs
			await rm(absoluteFileUrl, { force: true });

			process.env.ASTRO_INTERNAL_TEST_REMOTE = true;
			process.env.ASTRO_DB_REMOTE_URL = absoluteFileUrl.toString();
			await fixture.build();
			await initializeRemoteDb(fixture.config);
		});

		after(async () => {
			delete process.env.ASTRO_INTERNAL_TEST_REMOTE;
			delete process.env.ASTRO_DB_REMOTE_URL;
		});

		it('Can render page', async () => {
			const app = await fixture.loadTestAdapterApp();
			const request = new Request('http://example.com/');
			const response = await app.render(request);
			assert.equal(response.status, 200);
		});
	});

	describe('build --remote with local libSQL file (relative path)', () => {
		before(async () => {
			clearEnvironment();

			const absoluteFileUrl = new URL('./fixtures/libsql-remote/dist/relative.db', import.meta.url);
			const prodDbPath = relative(
				fileURLToPath(fixture.config.root),
				fileURLToPath(absoluteFileUrl),
			);
			// Remove the file if it exists to avoid conflict between test runs
			await rm(prodDbPath, { force: true });

			process.env.ASTRO_INTERNAL_TEST_REMOTE = true;
			process.env.ASTRO_DB_REMOTE_URL = `file:${prodDbPath}`;
			await fixture.build();
			await initializeRemoteDb(fixture.config);
		});

		after(async () => {
			delete process.env.ASTRO_INTERNAL_TEST_REMOTE;
			delete process.env.ASTRO_DB_REMOTE_URL;
		});

		it('Can render page', async () => {
			const app = await fixture.loadTestAdapterApp();
			const request = new Request('http://example.com/');
			const response = await app.render(request);
			assert.equal(response.status, 200);
		});
	});
});