-
Notifications
You must be signed in to change notification settings - Fork 0
/
app.js
71 lines (63 loc) · 1.81 KB
/
app.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
// App Setup
const express = require('express');
const app = express();
const PORT = process.env.PORT || 3000;
const path = require('path');
const {spawn} = require('child_process');
// Setup Static Dir
app.set('view engine', 'ejs');
app.use(express.static(__dirname + '/public'));
// Multer Storage Config
const multer = require('multer');
const storage = multer.diskStorage({
destination: function(req, file, callback){
callback(null, './public/uploads/');
},
filename: function(req, file, callback){
callback(null, 'uploadedExcelFile.xlsx');
}
});
const upload = multer({ storage: storage });
// ROUTES
// Get Upload Route
app.get('/', (req, res) => {
res.render('upload');
});
// Post Results Route
app.post('/results', upload.single('file'), (req, res) => {
!req.file?res.redirect("/"):runPython(req, res);
})
// SERVER CONFIG
// Start express server
app.listen(PORT, () => {
console.log(`Server started on port ${PORT}`);
});
// EXTERNAL SCRIPT
// Python run function
async function runPython(req, res) {
let scriptData = {output: [], errors: []};
const subprocess = await spawn('python3', [
"-u",
path.join(__dirname, '/public/lib/read_excel.py'),
"HELLO WORLD!!"
]);
subprocess.stderr.on('data', (error) => {
scriptData.errors.push(error.toString());
})
subprocess.stdout.on('data', (data) => {
scriptData.output.push(data.toString());
})
subprocess.on('close', () => {
console.log("All done!");
if(scriptData.errors.length > 0) {
console.log('THERE WERE ERRORS!');
console.log(scriptData.errors);
res.render('error');
} else {
console.log("SUCCESS!");
const freshData = scriptData.output.filter(item => item !== '' || item !== ' ' || item !== null || item !== '\n')
console.log(freshData);
res.render('results');
}
});
}