const { Sequelize } = require('sequelize');
const path = require('path');
const fs = require('fs');
// Ensure the data directory exists
const dataDir = path.join(__dirname, '../../data');
if (!fs.existsSync(dataDir)) {
fs.mkdirSync(dataDir, { recursive: true });
}
// Database file path
const dbPath = path.join(dataDir, 'mcp.sqlite');
// Initialize Sequelize with SQLite
const sequelize = new Sequelize({
dialect: 'sqlite',
storage: dbPath,
logging: false, // Set to console.log to see SQL queries
});
// Test database connection
async function testConnection() {
try {
await sequelize.authenticate();
console.log('Database connection has been established successfully.');
} catch (error) {
console.error('Unable to connect to the database:', error);
}
}
testConnection();
module.exports = {
sequelize,
};