3d-interface/server/posts/hovered/index.js

28 lines
784 B
JavaScript
Raw Permalink Normal View History

2015-05-21 15:35:40 +02:00
var pg = require('pg');
var secret = require('../../private');
2015-07-03 13:27:05 +02:00
var Log = require('../../lib/NodeLog.js');
2015-05-21 15:35:40 +02:00
module.exports.index = function(req, res) {
pg.connect(secret.url, function(err, client, release) {
client.query(
"INSERT INTO hovered(exp_id, time, start, arrow_id)" +
2015-05-21 15:35:40 +02:00
"VALUES($1, to_timestamp($2), $3, $4);" ,
[
req.session.expId,
2015-05-21 15:35:40 +02:00
req.body.time,
req.body.start ? true : false,
req.body.arrowId
2015-05-21 15:35:40 +02:00
],
function(err, result) {
2015-07-01 11:31:44 +02:00
if (err !== null)
2015-07-09 15:04:55 +02:00
Log.dberror(err + ' in hovered');
2015-05-21 15:35:40 +02:00
release();
}
);
});
res.setHeader('Content-Type', 'text/html');
res.send("");
};