{
"name": "backend",
"version": "1.0.0",
"description": "",
"main": "index.js",
"type": "module",
"scripts": {
"test": "echo \"Error: no test specified\" && exit 1",
"start": "nodemon index.js"
},
"keywords": [],
"author": "",
"license": "ISC",
"dependencies": {
"express": "^4.18.2",
"mysql": "^2.18.1",
"nodemon": "^2.0.20"
}
}

import express from 'express';
import mysql from "mysql";
const app = express();
const db = mysql.createConnection({
host: "localhost",
user: "root",
password: "akdkfjdkfj;a",
database: "online_sustainability_db"
});
app.use(express.json());   
app.get("/", (req, res) =>{
res.json("Hello. You are connected to backend.");
});
app.get("/data", (req, res) =>{
const query = "SELECT * FROM online_sustainability_db.idea_proposers";
db.query(query, (err, data)=>{
if(err)
return res.json(err);
else 
return res.json(data);
})
});
app.post("/data", (req, res)=>{
const q = "INSERT INTO idea_proposers (`last_name`, `first_name`, `account_no`, `github_repository_link`, `submission_id`) VALUES (?, ?, ?, ?, ?)";
const last_name = req.body.last_name;
const first_name = req.body.first_name; 
const account_no = req.body.account_no; 
const github_link = req.body.github_repository_link; 
const submission_id = req.body.submission_id;
db.query(q, [last_name, first_name, account_no, github_link, submission_id], (err, data)=>{
if(err)
return res.json(err);
else 
return res.json("Provided data were recorded successfully.");
});
});
app.listen(8800, ()=>{
console.log("Connected to backend!");
});