30 lines
757 B
JavaScript
30 lines
757 B
JavaScript
import fs from 'fs';
|
|
import path from 'path';
|
|
import { DatabaseSync } from 'node:sqlite';
|
|
import { fileURLToPath } from 'url';
|
|
import dotenv from 'dotenv';
|
|
|
|
dotenv.config();
|
|
|
|
const __dirname = path.dirname(fileURLToPath(import.meta.url));
|
|
const sqlPath = path.join(__dirname, '..', 'database', 'init.sql');
|
|
const dbPath =
|
|
process.env.SQLITE_PATH || path.join(__dirname, '..', 'data', 'crm.db');
|
|
|
|
fs.mkdirSync(path.dirname(dbPath), { recursive: true });
|
|
|
|
const sql = fs.readFileSync(sqlPath, 'utf8');
|
|
|
|
const db = new DatabaseSync(dbPath);
|
|
db.exec('PRAGMA foreign_keys = ON');
|
|
|
|
try {
|
|
db.exec(sql);
|
|
console.log('Datenbank-Schema ist bereit.');
|
|
} catch (e) {
|
|
console.error(e);
|
|
process.exit(1);
|
|
} finally {
|
|
db.close();
|
|
}
|