db.server.ts RawHistoryFolder

1import { drizzle } from 'drizzle-orm/libsql';
2import { createClient } from '@libsql/client';
3import { TURSO_AUTH_TOKEN, TURSO_DATABASE_URL } from '$env/static/private';
4import schema, { ensureDefaultChatRoom } from './schema';
5
6const client = createClient({ url: TURSO_DATABASE_URL, authToken: TURSO_AUTH_TOKEN });
7const db = drizzle(client, { schema });
8
9// Initialize database with required data
10export const initializeDatabase = async () => {
11    console.debug('Initializing database...');
12    try {
13        await ensureDefaultChatRoom(db);
14        console.debug('Database initialization complete');
15    } catch (error) {
16        console.error('Error initializing database:', error);
17        throw error;
18    }
19};
20
21// Call initialization when the module is loaded
22initializeDatabase().catch(error => {
23    console.error('Failed to initialize database:', error);
24});
25
26export const testConnection = async () => {
27    const result = await db.query.users.findMany();
28    console.log(result);
29};
30
31export default db;