Skip to content

Instantly share code, notes, and snippets.

@odnanref
Created December 5, 2016 00:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save odnanref/376affbf7a980fc9de346b7ee90ca230 to your computer and use it in GitHub Desktop.
Save odnanref/376affbf7a980fc9de346b7ee90ca230 to your computer and use it in GitHub Desktop.
$1 has no parameter
/**
O nodejs nisto só emite erro quando chamo a função e emite o erro que $1 não tem parametro
demorei a perceber que tinha um ) mal colocado.
Acho que é por causa disto que prefiro scala.
*/
function userAccess(sender_id, message) {
pg.connect(process.env.DATABASE_URL, function(err, client) {
console.log("userAccess>connecting to pgsql");
if (err) {
console.log("useraccess hit " + err);
throw err;
}
console.log("debug sender_id:" + sender_id + " message:" + message);
client.query('INSERT INTO useraccess (sender_id, message) VALUES ( $1 , $2 );'),
[sender_id, message.trim()],
function (err, result) {
if (err) {
console.log("Error inserting to useraccess: " + err);
}
}
});
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment