3d-interface/server/posts/arrow-clicked/index.js

var pg = require('pg');
var secret = require('../../private');
var Log = require('../../lib/NodeLog.js');

module.exports.index = function(req, res) {

    pg.connect(secret.url, function(err, client, release) {
        client.query(
            "INSERT INTO arrowclicked(exp_id, arrow_id, time) VALUES($1,$2, to_timestamp($3));",
            [req.session.expId, req.body.arrowId, req.body.time],
            function(err, result) {
                if (err !== null)
                    Log.dberror(err + ' arrow-clicked');
                release();
            }
        );
    });

    res.setHeader('Content-Type', 'text/html');
    res.send("");
};