sql - Interfacing Node-Postgres, Express JS and Node JS -


issue:

so, i'm having typical issue while trying store pagecounter in database. i'm using node js , node pg through remote console don't know versions. it's not connection based problem or wrong database either i've tested using sample database.

p.s: i'm new both javascript , databases(especially) , might silly error bear me.

as can see code, i'm using old syntax i'm following year old video tutorial part of course.

i've gone through question don't think that's issue here.

observations:

  1. everytime, restart server, starts server.js's counter.
  2. henceforth, counter gets incremented every alternate manual refresh.
  3. i've observed database getting altered accordingly.

debug:

  1. re-querieng same select doesn't work.
  2. using temp variable hold count , checking against has no affect either.
  3. the request status toggles between 200 , 304 increment , no change respectively.

code:

var express = require('express'); var morgan = require('morgan'); var path = require('path'); var app = express(); app.use(morgan('combined')); var crypto = require('crypto');     var pool = require('pg').pool;     var config = {         user: 'dragonlordthota717',         database: 'dragonlordthota717',         host: 'db.imad.hasura-app.io',         port: '5432',         password: process.env.db_password     };  var pool = new pool(config);     var counter = {"pageviews":800};     var flag = "from server.js";     app.get('/counter', function (req, res){       pool.query("select pageviews users name='hyperclaw79'",function(err,result){           if(err){             res.status(500).send("flag: "+err.tostring());             }           else{             counter = result.rows[0];             flag = "from query";           }       });       var cnt = counter.pageviews;       cnt = parseint(cnt)+1;       if(isnan(cnt)) res.status(500).send(flag+': returned nan seen in: '+json.stringify(counter));       else pool.query("update users set pageviews = $1 name = 'hyperclaw79'",[cnt]);       return res.send(flag +": " + cnt.tostring());     });

i've set pageviews in db 850 clarity on going on.

however, has typical alternating behaviour. here output i've recieved:

from server.js: 801 query: 851 query: 802 query: 852 query: 803 query: 853 . . . . .

it clear that, select query isn't being sent first time. henceforth, transactions being done database itself. however, though database supposed overwritten 801 , should increment accordingly, somehow old value returning alternatively , too, incremented.

it helpful if can find bug or indicate if i'm mistaken in logic i've been @ whole day , still not able figure out. please don't suggest workarounds using external packages this not have admin priveldges on remote machine. well, in advance if you're able figure out.

the following should work

var express = require('express'); var morgan = require('morgan'); var path = require('path'); var app = express(); app.use(morgan('combined')); var crypto = require('crypto');     var pool = require('pg').pool;     var config = {         user: 'dragonlordthota717',         database: 'dragonlordthota717',         host: 'db.imad.hasura-app.io',         port: '5432',         password: process.env.db_password     };  var pool = new pool(config);     var counter = {"pageviews":800};     var flag = "from server.js";     app.get('/counter', function (req, res){       pool.query("select pageviews users name='hyperclaw79'",function(err,result){           if(err){             res.status(500).send("flag: "+err.tostring());             }           else{             counter = result.rows[0];             flag = "from query";             var cnt = counter.pageviews;             cnt = parseint(cnt)+1;             if(isnan(cnt)) res.status(500).send(flag+': returned nan seen in: '+json.stringify(counter));             else pool.query("update users set pageviews = $1 name = 'hyperclaw79'",[cnt]);             return res.send(flag +": " + cnt.tostring());            }       });      });

in original code, callback pool.query called after counter read, counter not updated when counter stored in variable cnt.


Comments

Post a Comment

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -

here tables: create table customer ( cid int primary key, name varchar(32) ) create table ord ( oid int primary key, cid int foreign key references customer, address varchar(20) ) here's linq-to-sql statement: var aaa = c in db.customer select new { c, o = c.ord.tolist() }; and here's inexplicable query generated linq-to-sql: select [t0].[cid] [cid], [t0].[name] [name], [t1].[oid] [oid], [t1].[cid] [cid2], [t1].[address] [address], (select count(*) [dbo].[ord] [t2] [t2].[cid] = [t0].[cid]) [value] [dbo].[customer] [t0] left outer join [dbo].[ord] [t1] on [t1].[cid] = [t0].[cid] order [t0].[cid], [t1].[oid] i want understand how rid of count(*) part. it's entirely uncalled for! linq needs count(*) in order determine number of entries returned o = c.ord.tolist() .
Read more