author | Michael Krelin <hacker@klever.net> | 2013-11-25 20:52:56 (UTC) |
---|---|---|
committer | Michael Krelin <hacker@klever.net> | 2013-11-25 20:52:56 (UTC) |
commit | fab898af773b3bbf28ed6c67c89b032d740d19f1 (patch) (unidiff) | |
tree | 0e7f59253d11556dcb29dc5372f7a77e91de086d | |
parent | 352f2216eec032efce4bdeddd2ffe5a9e326a99d (diff) | |
download | clipperz-fab898af773b3bbf28ed6c67c89b032d740d19f1.zip clipperz-fab898af773b3bbf28ed6c67c89b032d740d19f1.tar.gz clipperz-fab898af773b3bbf28ed6c67c89b032d740d19f1.tar.bz2 |
PG: also tracelog error (if any)
-rw-r--r-- | backend/node/src/clipperz.js | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/backend/node/src/clipperz.js b/backend/node/src/clipperz.js index 73af0a0..b98c00e 100644 --- a/backend/node/src/clipperz.js +++ b/backend/node/src/clipperz.js | |||
@@ -35,83 +35,83 @@ function clipperz_store(PG) { | |||
35 | "SELECT count(*) AS c FROM clipperz.thesession", function(e,r) { | 35 | "SELECT count(*) AS c FROM clipperz.thesession", function(e,r) { |
36 | cb(e,e?null:r.rows[0].c); | 36 | cb(e,e?null:r.rows[0].c); |
37 | } | 37 | } |
38 | ) }; | 38 | ) }; |
39 | rv.prototype.length = function(cb) { PQ.Q( | 39 | rv.prototype.length = function(cb) { PQ.Q( |
40 | "DELETE FROM clipperz.thesession", cb | 40 | "DELETE FROM clipperz.thesession", cb |
41 | ) }; | 41 | ) }; |
42 | rv.prototype.__proto__ = express_store.prototype; | 42 | rv.prototype.__proto__ = express_store.prototype; |
43 | return rv; | 43 | return rv; |
44 | } | 44 | } |
45 | 45 | ||
46 | var srp_g = BIGNUM(2); | 46 | var srp_g = BIGNUM(2); |
47 | var srp_n = BIGNUM("115b8b692e0e045692cf280b436735c77a5a9e8a9e7ed56c965f87db5b2a2ece3",16); | 47 | var srp_n = BIGNUM("115b8b692e0e045692cf280b436735c77a5a9e8a9e7ed56c965f87db5b2a2ece3",16); |
48 | var n123 = '112233445566778899aabbccddeeff00112233445566778899aabbccddeeff00'; | 48 | var n123 = '112233445566778899aabbccddeeff00112233445566778899aabbccddeeff00'; |
49 | 49 | ||
50 | 50 | ||
51 | var CLIPPERZ = module.exports = function(CONFIG) { | 51 | var CLIPPERZ = module.exports = function(CONFIG) { |
52 | 52 | ||
53 | var LOGGER = CONFIG.logger||{trace:function(){}}; | 53 | var LOGGER = CONFIG.logger||{trace:function(){}}; |
54 | 54 | ||
55 | var PG = { | 55 | var PG = { |
56 | url: CONFIG.psql, | 56 | url: CONFIG.psql, |
57 | PG: require('pg').native, | 57 | PG: require('pg').native, |
58 | Q: function(q,a,cb) { | 58 | Q: function(q,a,cb) { |
59 | if('function'===typeof a) cb=a,a=[]; | 59 | if('function'===typeof a) cb=a,a=[]; |
60 | LOGGER.trace({query:q,args:a},'SQL: %s',q); | 60 | LOGGER.trace({query:q,args:a},'SQL: %s',q); |
61 | PG.PG.connect(PG.url,function(e,C,D) { | 61 | PG.PG.connect(PG.url,function(e,C,D) { |
62 | if(e) return cb(e); | 62 | if(e) return cb(e); |
63 | var t0=new Date(); | 63 | var t0=new Date(); |
64 | C.query(q,a,function(e,r) { | 64 | C.query(q,a,function(e,r) { |
65 | var t1=new Date(), dt=t1-t0; | 65 | var t1=new Date(), dt=t1-t0; |
66 | D(); | 66 | D(); |
67 | LOGGER.trace({query:q,args:a,ms:dt,rows:r&&r.rowCount},"SQL query '%s' took %dms",q,dt); | 67 | LOGGER.trace({query:q,args:a,ms:dt,rows:r&&r.rowCount,err:e},"SQL query '%s' took %dms",q,dt); |
68 | cb(e,r); | 68 | cb(e,r); |
69 | }); | 69 | }); |
70 | }); | 70 | }); |
71 | }, | 71 | }, |
72 | T: function(cb) { | 72 | T: function(cb) { |
73 | PG.PG.connect(PG.url,function(e,C,D) { | 73 | PG.PG.connect(PG.url,function(e,C,D) { |
74 | if(e) return cb(e); | 74 | if(e) return cb(e); |
75 | C.query('BEGIN',function(e){ | 75 | C.query('BEGIN',function(e){ |
76 | if(e) return D(),cb(e); | 76 | if(e) return D(),cb(e); |
77 | cb(null,{ | 77 | cb(null,{ |
78 | Q: function(q,a,cb) { | 78 | Q: function(q,a,cb) { |
79 | LOGGER.trace({query:q,args:a},'SQL: %s',q); | 79 | LOGGER.trace({query:q,args:a},'SQL: %s',q); |
80 | if(this.over) return cb(new Error('game over')); | 80 | if(this.over) return cb(new Error('game over')); |
81 | if('function'===typeof a) cb=a,a=[]; | 81 | if('function'===typeof a) cb=a,a=[]; |
82 | var t0=new Date(); | 82 | var t0=new Date(); |
83 | C.query(q,a,function(e,r) { | 83 | C.query(q,a,function(e,r) { |
84 | var t1=new Date(), dt=t1-t0; | 84 | var t1=new Date(), dt=t1-t0; |
85 | LOGGER.trace({query:q,args:a,ms:dt,rows:r&&r.rowCount},"SQL query '%s' took %dms",q,dt); | 85 | LOGGER.trace({query:q,args:a,ms:dt,rows:r&&r.rowCount,err:e},"SQL query '%s' took %dms",q,dt); |
86 | cb(e,r); | 86 | cb(e,r); |
87 | }); | 87 | }); |
88 | }, | 88 | }, |
89 | commit: function(cb) { | 89 | commit: function(cb) { |
90 | LOGGER.trace('SQL: commit'); | 90 | LOGGER.trace('SQL: commit'); |
91 | if(this.over) return cb(new Error('game over')); | 91 | if(this.over) return cb(new Error('game over')); |
92 | return (this.over=true),C.query('COMMIT',function(e){D();cb&&cb(e)}); | 92 | return (this.over=true),C.query('COMMIT',function(e){D();cb&&cb(e)}); |
93 | }, | 93 | }, |
94 | rollback: function(cb) { | 94 | rollback: function(cb) { |
95 | LOGGER.trace('SQL: rollback'); | 95 | LOGGER.trace('SQL: rollback'); |
96 | if(this.over) return cb(new Error('game over')); | 96 | if(this.over) return cb(new Error('game over')); |
97 | return (this.over=true),C.query('ROLLBACK',function(e){D();cb&&cb(e)}); | 97 | return (this.over=true),C.query('ROLLBACK',function(e){D();cb&&cb(e)}); |
98 | }, | 98 | }, |
99 | end: function(e,cb) { | 99 | end: function(e,cb) { |
100 | if(e) return LOGGER.trace(e,"rolling back transaction due to an error"),this.rollback(cb); | 100 | if(e) return LOGGER.trace(e,"rolling back transaction due to an error"),this.rollback(cb); |
101 | this.commit(cb); | 101 | this.commit(cb); |
102 | } | 102 | } |
103 | }); | 103 | }); |
104 | }); | 104 | }); |
105 | }); | 105 | }); |
106 | } | 106 | } |
107 | }; | 107 | }; |
108 | 108 | ||
109 | 109 | ||
110 | var rv = { | 110 | var rv = { |
111 | 111 | ||
112 | json: function clipperz_json(req,res,cb) { | 112 | json: function clipperz_json(req,res,cb) { |
113 | var method = req.body.method, pp = JSON.parse(req.body.parameters).parameters; | 113 | var method = req.body.method, pp = JSON.parse(req.body.parameters).parameters; |
114 | var message = pp.message; | 114 | var message = pp.message; |
115 | var ppp = pp.parameters; | 115 | var ppp = pp.parameters; |
116 | res.res = function(o) { return res.json({result:o}) }; | 116 | res.res = function(o) { return res.json({result:o}) }; |
117 | LOGGER.trace({method:method,parameters:pp},"JSON request"); | 117 | LOGGER.trace({method:method,parameters:pp},"JSON request"); |