'use strict';
const eventData = require('../data/events');
const getAllEvents = async (req, res, next) => {
try {
const eventlist = await eventData.getEvents();
res.send(eventlist);
} catch (error) {
res.status(400).send(error.message);
}
}
const getEvent = async (req, res, next) => {
try {
const eventId = req.params.id;
const event = await eventData.getById(eventId);
res.send(event);
} catch (error) {
res.status(400).send(error.message);
}
}
const addEvent = async (req, res, next) => {
try {
const data = req.body;
const insert = await eventData.creatEvent(data);
res.send(insert);
} catch (error) {
res.status(400).send(error.message);
}
}
const updatEvent = async (req, res, next) => {
try {
const eventId = req.params.id;
const data = req.body;
const updated = await eventData.updateEvent(eventId, data);
res.send(updated);
} catch (error) {
res.status(400).send(error.message);
}
}
const deleteEvent = async (req, res, next) => {
try {
const eventId = req.params.id;
const deletedEvent = await eventData.deleteEvent(eventId);
res.send(deletedEvent);
} catch (error) {
res.status(400).send(error.message);
}
}
module.exports = {
getAllEvents,
getEvent,
addEvent,
updatEvent,
deleteEvent
}
createEvent.sql
INSERT INTO [dbo].[events]
(
[eventTitle],
[eventDescription],
[startDate],
[endDate],
[avenue],
[maxMembers]
)
VALUES
(
@eventTitle,
@eventDescription,
@startDate,
@endDate,
@avenue,
@maxMembers
)
SELECT SCOPE_IDENTITY() AS eventId
deleteEvent.sql
DELETE [dbo].[events]
WHERE [eventId]=@eventId
eventbyId.sql
SELECT [eventId]
,[eventTitle]
,[eventDescription]
,[startDate]
,[endDate]
,[avenue]
,[maxMembers]
FROM [dbo].[events]
WHERE [eventId]=@eventId
eventslist.sql
SELECT [eventId]
,[eventTitle]
,[eventDescription]
,[startDate]
,[endDate]
,[avenue]
,[maxMembers]
FROM [dbo].[events]
index.js
'use strict';
const utils = require('../utils');
const config = require('../../config');
const sql = require('mssql');
const getEvents = async () => {
try {
let pool = await sql.connect(config.sql);
const sqlQueries = await utils.loadSqlQueries('events');
const eventsList = await pool.request().query(sqlQueries.eventslist);
return eventsList.recordset;
} catch (error) {
console.log(error.message);
}
}
const getById = async(eventId) => {
try {
let pool = await sql.connect(config.sql);
const sqlQueries = await utils.loadSqlQueries('events');
const event = await pool.request()
.input('eventId', sql.Int, eventId)
.query(sqlQueries.eventbyId);
return event.recordset;
} catch (error) {
return error.message;
}
}
const creatEvent = async (eventdata) => {
try {
let pool = await sql.connect(config.sql);
const sqlQueries = await utils.loadSqlQueries('events');
const insertEvent = await pool.request()
.input('eventTitle', sql.NVarChar(100), eventdata.eventTitle)
.input('eventDescription', sql.NVarChar(1500), eventdata.eventDescription)
.input('startDate', sql.Date, eventdata.startDate)
.input('endDate', sql.Date, eventdata.endDate)
.input('avenue', sql.NVarChar(200), eventdata.avenue)
.input('maxMembers', sql.Int, eventdata.maxMembers)
.query(sqlQueries.createEvent);
return insertEvent.recordset;
} catch (error) {
return error.message;
}
}
const updateEvent = async (eventId, data) => {
try {
let pool = await sql.connect(config.sql);
const sqlQueries = await utils.loadSqlQueries('events');
const update = await pool.request()
.input('eventId', sql.Int, eventId)
.input('eventTitle', sql.NVarChar(100), data.eventTitle)
.input('eventDescription', sql.NVarChar(1500), data.eventDescription)
.input('startDate', sql.Date, data.startDate)
.input('endDate', sql.Date, data.endDate)
.input('avenue', sql.NVarChar(200), data.avenue)
.input('maxMembers', sql.Int, data.maxMembers)
.query(sqlQueries.updateEvent);
return update.recordset;
} catch (error) {
return error.message;
}
}
const deleteEvent = async (eventId) => {
try {
let pool = await sql.connect(config.sql);
const sqlQueries = await utils.loadSqlQueries('events');
const deleteEvent = await pool.request()
.input('eventId', sql.Int, eventId)
.query(sqlQueries.deleteEvent);
return deleteEvent.recordset;
} catch (error) {
return error.message;
}
}
module.exports = {
getEvents,
getById,
creatEvent,
updateEvent,
deleteEvent
}
updateEvent.sql
UPDATE [dbo].[events]
SET [eventTitle]=@eventTitle,
[eventDescription]=@eventDescription,
[startDate]=@startDate,
[endDate]=@endDate,
[avenue]=@avenue,
[maxMembers]=@maxMembers
WHERE [eventId]=@eventId
SELECT [eventId]
,[eventTitle]
,[eventDescription]
,[startDate]
,[endDate]
,[avenue]
,[maxMembers]
FROM [dbo].[events]
WHERE [eventId]=@eventId
utils.js
'use strict';
const fs = require('fs-extra');
const {join} = require('path');
const loadSqlQueries = async (folderName) => {
const filePath = join(process.cwd(), 'data', folderName);
const files = await fs.readdir(filePath);
const sqlFiles = files.filter(f => f.endsWith('.sql'));
const queries = {};
for (const sqlfile of sqlFiles) {
const query = fs.readFileSync(join(filePath, sqlfile), {encoding: "UTF-8"});
queries[sqlfile.replace(".sql", "")] = query;
}
return queries;
}
module.exports = {
loadSqlQueries
}
eventRoutes.js
'use strict';
const express = require('express');
const eventControll = require('../controllers/eventController');
const router = express.Router();
router.get('/events', eventControll.getAllEvents);
router.get('/event/:id', eventControll.getEvent);
router.post('/event', eventControll.addEvent);
router.put('/event/:id', eventControll.updatEvent);
router.delete('/event/:id', eventControll.deleteEvent);
module.exports = {
routes: router
}
NODE_ENV=development
#express server config
PORT=8080
HOST=localhost
HOST_URL=http://localhost:8080
#sql server config
SQL_USER=sa
SQL_PASSWORD=Welcome@123
SQL_DATABASE=eventmanagement
SQL_SERVER=Nattuthurai
SQL_ENCRYPT=false
config.js
'use strict';
const dotenv = require('dotenv');
const assert = require('assert');
dotenv.config();
const {PORT, HOST, HOST_URL, SQL_USER, SQL_PASSWORD, SQL_DATABASE, SQL_SERVER} = process.env;
const sqlEncrypt = process.env.SQL_ENCRYPT === "true";
assert(PORT, 'PORT is require');
assert(HOST, 'HOST is required');
module.exports = {
port: PORT,
host: HOST,
url: HOST_URL,
sql: {
server: SQL_SERVER,
database: SQL_DATABASE,
user: SQL_USER,
password: SQL_PASSWORD,
options: {
encrypt: sqlEncrypt,
enableArithAbort: true
},
},
};
index.js
'use strict';
const express = require('express');
const config = require('./config');
const cors = require('cors');
const bodyParser = require('body-parser');
const eventRoutes = require('./routes/eventRoutes');
const app = express();
app.use(express.json());
app.use(cors());
app.use(bodyParser.json());
app.use('/api', eventRoutes.routes);
app.listen(config.port, () => {
console.log('app listening on url http://localhost:' + config.port )
});
No comments:
Post a Comment