summaryrefslogtreecommitdiff
authorMichael Krelin <hacker@klever.net>2014-06-29 19:57:38 (UTC)
committer Michael Krelin <hacker@klever.net>2014-06-29 20:48:23 (UTC)
commitce34b3d32a9ae04260f95d6ade4f2d0de43daa8a (patch) (unidiff)
treee06c91d6da51a27043c75d6469805f818b8b71a0
parentd21898d430781387bc128f83e6f8aead1149a4e5 (diff)
downloadclipperz-ce34b3d32a9ae04260f95d6ade4f2d0de43daa8a.zip
clipperz-ce34b3d32a9ae04260f95d6ade4f2d0de43daa8a.tar.gz
clipperz-ce34b3d32a9ae04260f95d6ade4f2d0de43daa8a.tar.bz2
change 'DELETE' to 'TRUNCATE', because why not.
Diffstat (more/less context) (ignore whitespace changes)
-rw-r--r--backend/node/src/clipperz.js2
1 files changed, 1 insertions, 1 deletions
diff --git a/backend/node/src/clipperz.js b/backend/node/src/clipperz.js
index 5b4df0a..37b9cae 100644
--- a/backend/node/src/clipperz.js
+++ b/backend/node/src/clipperz.js
@@ -18,49 +18,49 @@ function clipperz_store(PG) {
18 var rv = function(o) { express_store.call(this,o); } 18 var rv = function(o) { express_store.call(this,o); }
19 rv.prototype.get = function(sid,cb) { PG.Q( 19 rv.prototype.get = function(sid,cb) { PG.Q(
20 "SELECT s_data FROM clipperz.thesession WHERE s_id=$1",[sid], 20 "SELECT s_data FROM clipperz.thesession WHERE s_id=$1",[sid],
21 function(e,r) { cb(e,(e||!r.rowCount)?null:JSON.parse(r.rows[0].s_data)); } 21 function(e,r) { cb(e,(e||!r.rowCount)?null:JSON.parse(r.rows[0].s_data)); }
22 ) }; 22 ) };
23 rv.prototype.set = function(sid,data,cb) { 23 rv.prototype.set = function(sid,data,cb) {
24 var d = JSON.stringify(data); 24 var d = JSON.stringify(data);
25 PG.Q( 25 PG.Q(
26 "UPDATE clipperz.thesession SET s_data=$1, s_mtime=current_timestamp" 26 "UPDATE clipperz.thesession SET s_data=$1, s_mtime=current_timestamp"
27 +" WHERE s_id=$2",[d,sid], function(e,r) { 27 +" WHERE s_id=$2",[d,sid], function(e,r) {
28 if(e) return cb(e); 28 if(e) return cb(e);
29 if(r.rowCount) return cb(); 29 if(r.rowCount) return cb();
30 PG.Q("INSERT INTO clipperz.thesession (s_id,s_data) VALUES ($1,$2)",[sid,d],cb); 30 PG.Q("INSERT INTO clipperz.thesession (s_id,s_data) VALUES ($1,$2)",[sid,d],cb);
31 }); 31 });
32 }; 32 };
33 rv.prototype.destroy = function(sid,cb) { PG.Q( 33 rv.prototype.destroy = function(sid,cb) { PG.Q(
34 "DELETE FROM clipperz.thesession WHERE s_id=$1",[sid],cb 34 "DELETE FROM clipperz.thesession WHERE s_id=$1",[sid],cb
35 ) }; 35 ) };
36 rv.prototype.length = function(cb) { PG.Q( 36 rv.prototype.length = function(cb) { PG.Q(
37 "SELECT count(*) AS c FROM clipperz.thesession", function(e,r) { 37 "SELECT count(*) AS c FROM clipperz.thesession", function(e,r) {
38 cb(e,e?null:r.rows[0].c); 38 cb(e,e?null:r.rows[0].c);
39 } 39 }
40 ) }; 40 ) };
41 rv.prototype.clear = function(cb) { PQ.Q( 41 rv.prototype.clear = function(cb) { PQ.Q(
42 "DELETE FROM clipperz.thesession", cb 42 "TRUNCATE clipperz.thesession", cb
43 ) }; 43 ) };
44 rv.prototype.__proto__ = express_store.prototype; 44 rv.prototype.__proto__ = express_store.prototype;
45 return rv; 45 return rv;
46} 46}
47 47
48var srp_g = BIGNUM(2); 48var srp_g = BIGNUM(2);
49var srp_n = BIGNUM("115b8b692e0e045692cf280b436735c77a5a9e8a9e7ed56c965f87db5b2a2ece3",16); 49var srp_n = BIGNUM("115b8b692e0e045692cf280b436735c77a5a9e8a9e7ed56c965f87db5b2a2ece3",16);
50var n123 = '112233445566778899aabbccddeeff00112233445566778899aabbccddeeff00'; 50var n123 = '112233445566778899aabbccddeeff00112233445566778899aabbccddeeff00';
51 51
52 52
53var CLIPPERZ = module.exports = function(CONFIG) { 53var CLIPPERZ = module.exports = function(CONFIG) {
54 54
55 var LOGGER = CONFIG.logger||{trace:function(){}}; 55 var LOGGER = CONFIG.logger||{trace:function(){}};
56 56
57 var PG = { 57 var PG = {
58 url: CONFIG.psql, 58 url: CONFIG.psql,
59 PG: require('pg').native, 59 PG: require('pg').native,
60 Q: function(q,a,cb) { 60 Q: function(q,a,cb) {
61 if('function'===typeof a) cb=a,a=[]; 61 if('function'===typeof a) cb=a,a=[];
62 LOGGER.trace({query:q,args:a},'SQL: %s',q); 62 LOGGER.trace({query:q,args:a},'SQL: %s',q);
63 PG.PG.connect(PG.url,function(e,C,D) { 63 PG.PG.connect(PG.url,function(e,C,D) {
64 if(e) return cb(e); 64 if(e) return cb(e);
65 var t0=new Date(); 65 var t0=new Date();
66 C.query(q,a,function(e,r) { 66 C.query(q,a,function(e,r) {