-
Notifications
You must be signed in to change notification settings - Fork 0
/
server.js
130 lines (90 loc) · 3.2 KB
/
server.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
const express = require("express");
const mongoose = require("mongoose");
const dotenv = require("dotenv");
const cors = require("cors");
const bodyParser = require("body-parser");
const tableRoutes = require("./routes/tableRoutes");
const app = express();
dotenv.config();
const port = process.env.PORT || 8080;
app.use(cors());
app.use(bodyParser.json());
app.use(express.json());
// Define routes
app.get("/", (req, res) => {
res.json({ message: "Backend WORKING" });
});
// Connect routes
app.use("/tables", tableRoutes);
// Connect to MongoDB
mongoose.set("strictQuery", false);
mongoose.connect(
"mongodb+srv://nandini25agarwal:[email protected]/?retryWrites=true&w=majority",
{
useNewUrlParser: true,
useUnifiedTopology: true,
}
);
const db = mongoose.connection;
db.on("error", console.error.bind(console, "connection error:"));
db.once("open", () => {
console.log("Connected to MongoDB");
});
// Start the server
app.listen(port, () => {
console.log(`Server running on port ${port}`);
});
// const express = require('express');
// const app = express();
// const bodyParser = require('body-parser');
// // Assuming you have a JSON file with table data named 'tables.json' in the same directory
// const tables = require('./tables.json');
// // Middleware to parse request bodies as JSON
// app.use(bodyParser.json());
// // Endpoint to retrieve a list of existing tables
// app.get('/api/tables', (req, res) => {
// res.json(tables);
// });
// // Endpoint to retrieve columns and rows of a specific table
// app.get('/api/tables/:id', (req, res) => {
// const { id } = req.params;
// const table = tables.find(table => table.id === id);
// if (!table) {
// return res.status(404).json({ error: 'Table not found' });
// }
// const { columns, rows } = table;
// res.json({ columns, rows });
// });
// // Endpoint to accept new table data and store it
// app.post('/api/tables', (req, res) => {
// const newTable = req.body;
// // Assuming the new table data is in the format { id: 'tableId', columns: [...], rows: [...] }
// tables.push(newTable);
// res.status(201).json({ message: 'Table created successfully' });
// });
// // Endpoint to update column and row data for a specific table
// app.put('/api/tables/:id', (req, res) => {
// const { id } = req.params;
// const updatedTable = req.body;
// const tableIndex = tables.findIndex(table => table.id === id);
// if (tableIndex === -1) {
// return res.status(404).json({ error: 'Table not found' });
// }
// // Update the column and row data of the table
// tables[tableIndex].columns = updatedTable.columns;
// tables[tableIndex].rows = updatedTable.rows;
// res.json({ message: 'Table updated successfully' });
// });
// app.delete('/api/tables/:id', (req, res) => {
// const { id } = req.params;
// const tableIndex = tables.findIndex(table => table.id === id);
// if (tableIndex === -1) {
// return res.status(404).json({ error: 'Table not found' });
// }
// tables.splice(tableIndex, 1);
// res.json({ message: 'Table deleted successfully' });
// });
// // Start the server
// app.listen(3000, () => {
// console.log('Server is running on port 3000');
// });