const express = require('express');
const cors = require('cors');
const mysql = require('mysql');
const path = require('path');
const fs = require('fs');
const app = express();
const PORT = 3008;
// MySQL connection configuration
const db = mysql.createConnection({
host: 'localhost',
user: 'vareprint_Inkedoodle',
password: 'vareprint@244',
database: 'vareprint_inkedoodle' // Replace with your MySQL database name
});
// Connect to MySQL database
db.connect(err => {
if (err) {
console.error('Error connecting to database: ' + err.stack);
return;
}
console.log('Connected to database as ID ' + db.threadId);
});
// Middleware for session store
const sessionStore = new MySQLStore({
expiration: 86400000, // 1 day in milliseconds
endConnectionOnClose: false // Keep the database connection open
}, db);
// CORS configuration
app.use(cors({
origin: 'http://localhost:3000', // Adjust this to your frontend's URL
credentials: true
}));
// Example data
const databaseData = [
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Success!