server.js

import mysql from 'mysql2/promise';
import express from 'express';
import sequelize from './app/Model/dbConfig.js';
import './app/Model/index.js';
import companyRoutes from './app/Routes/companyRoute.js';
import catRoutes from './app/Routes/categoryRoute.js';
import custRoutes from './app/Routes/costumerRoute.js';
import prodRoutes from './app/Routes/productRoute.js'
import salesRoute from './app/Routes/salesRoute.js'
import userRout from './app/Routes/userRoute.js'
import adminRout from './app/Routes/adminRoute.js'

const DB_HOST = 'localhost';
const DB_USER = 'root';
const DB_PASS = ''; 
const DB_NAME = 'Bill_table';

async function ensureDatabase() {
  const connection = await mysql.createConnection({
    host: DB_HOST,
    user: DB_USER,
    password: DB_PASS,
  });

  await connection.query(`CREATE DATABASE IF NOT EXISTS \`${DB_NAME}\`;`);
  await connection.end();
}

const app = express();
app.use(express.json());

app.get('/', (req, res) => {
  res.send('Welcome to server');
});

app.use('/admin', adminRout);
app.use('/companies', companyRoutes);
app.use('/categories', catRoutes);
app.use('/customers', custRoutes);
app.use('/products', prodRoutes);
app.use('/uploads', express.static('uploads'));
app.use('/sales', salesRoute);
app.use('/users', userRout);

const PORT = process.env.PORT || 3000;

const startServer = async () => {
  try {
    await ensureDatabase();

    await sequelize.sync({ alter: true });
    console.log('All models synchronized.');

    app.listen(PORT, () => {
      console.log(`Server is running on http://localhost:${PORT}`);
    });
  } catch (err) {
    console.error('DB connection failed:', err);
  }
};

startServer();