Spaces:

umaine
/

COS498-Group7

Sleeping

App Files Files Community

COS498-Group7 / server /db /database.js

izzicooki

Claude Sonnet 4.6

Task 1: Project setup and database schema

0737291 7 months ago

Raw History Blame Contribute Delete

488 Bytes

const Database = require('better-sqlite3');
const path = require('path');
const fs = require('fs');

const DB_PATH = path.join(__dirname, 'pcpal.db');
const SCHEMA_PATH = path.join(__dirname, 'schema.sql');

const db = new Database(DB_PATH);

// Enable WAL mode for better performance
db.pragma('journal_mode = WAL');
db.pragma('foreign_keys = ON');

// Read and execute schema on initialization
const schema = fs.readFileSync(SCHEMA_PATH, 'utf8');
db.exec(schema);

module.exports = db;

	const Database = require('better-sqlite3');
	const path = require('path');
	const fs = require('fs');

	const DB_PATH = path.join(__dirname, 'pcpal.db');
	const SCHEMA_PATH = path.join(__dirname, 'schema.sql');

	const db = new Database(DB_PATH);

	// Enable WAL mode for better performance
	db.pragma('journal_mode = WAL');
	db.pragma('foreign_keys = ON');

	// Read and execute schema on initialization
	const schema = fs.readFileSync(SCHEMA_PATH, 'utf8');
	db.exec(schema);

	module.exports = db;