index.ts

import express, { Request, Response } from 'express';
import dotenv from 'dotenv';
import swaggerJsDoc from 'swagger-jsdoc';
import swaggerUi from 'swagger-ui-express';
import swaggerOptions from './config/swagger';
import userRoutes from './routes/user-routes';
import authRoutes from './routes/auth-routes';
import ddlRoutes from './routes/ddl-routes';
import { sequelize } from './config/database';
import schemaRoutes from './routes/schema-routes';
import dmlRoutes from './routes/dml-routes';
import queryRoutes from './routes/query-routes';
import apikeyRoutes from './routes/apikey-routes';

sequelize
  .sync({ alter: true })
  .then(async () => {
    console.log('Database synchronized successfully.');
  })
  .catch((err) => {
    console.error('Failed to synchronize database:', err);
  });

dotenv.config();

const app = express();
const PORT = process.env.PORT || 3000;

app.use(express.json());

const apiRouter = express.Router();

apiRouter.use('/auth', authRoutes);
apiRouter.use('/users', userRoutes);
apiRouter.use('/migrate', ddlRoutes);
apiRouter.use('/schemas', schemaRoutes);
apiRouter.use('/execute', dmlRoutes);
apiRouter.use('/query', queryRoutes);
apiRouter.use('/apikey', apikeyRoutes);

app.use('/api', apiRouter);

const swaggerDocs = swaggerJsDoc(swaggerOptions);
app.use('/api-docs', swaggerUi.serve, swaggerUi.setup(swaggerDocs));

app.get('/health', (req: Request, res: Response) => {
  res.send('Hello, TypeScript with Express!');
});

app.listen(PORT, () => {
  console.log(`Server is running on http://localhost:${PORT}`);
  console.log(`Swagger Docs available at http://localhost:${PORT}/api-docs`);
});