| Server IP : 69.164.203.165 / Your IP : 216.73.216.219 Web Server : nginx/1.18.0 System : Linux localhost 6.14.3-x86_64-linode168 #1 SMP PREEMPT_DYNAMIC Mon Apr 21 19:47:55 EDT 2025 x86_64 User : www-data ( 33) PHP Version : 8.1.31 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /opt/homecoming-api/routes/ |
Upload File : |
const _ = require('lodash');
const csv = require('express-csv');
const mysql = require('mysql');
const mc = mysql.createConnection({
host: 'localhost',
user: 'cameron',
password: 'GnsHMdBF9934eZz2',
database: 'cameron_homecoming'
});
mc.connect();
var sendCSV = function(error, results, fields, res) {
if (error) {
throw new Error(error);
res.status(400);
res.send({
code: 400,
failed: "error ocurred"
});
} else {
var keys = _.keys(results[0]);
res.csv([keys].concat(results));
}
};
exports.registrations = function (req, res) {
mc.query("SELECT * FROM user_registration", function(error, results, fields) {
return sendCSV(error, results, fields, res);
});
};
exports.guests = function (req, res) {
mc.query("SELECT * FROM guest_registration", function(error, results, fields) {
return sendCSV(error, results, fields, res);
});
};