def _runPropQuery(self, name, prop, valu=None, limit=None, mintime=None, maxtime=None, meth=None, nolim=False): limit = self._getDbLimit(limit) qkey = (s_compat.typeof(valu), s_compat.typeof(mintime), s_compat.typeof(maxtime)) qargs = [prop] qargs.extend([v for v in (valu, mintime, maxtime) if v != None]) if not nolim: qargs.append(limit) qstr = self.qbuild[name][qkey] #print('QNAM: %r' % (name,)) #print('QKEY: %r' % (qkey,)) #print('QSTR: %r' % (qstr,)) #print('QARG: %r' % (qargs,)) if meth == None: meth = self.select rows = meth(qstr, qargs) #print('QROW: %r' % (rows,)) return rows
def _runPropQuery(self, name, prop, valu=None, limit=None, mintime=None, maxtime=None, meth=None, nolim=False): limit = self._getDbLimit(limit) qkey = (s_compat.typeof(valu), s_compat.typeof(mintime), s_compat.typeof(maxtime)) qstr = self.qbuild[name][qkey] if meth == None: meth = self.select rows = meth(qstr, prop=prop, valu=valu, limit=limit, mintime=mintime, maxtime=maxtime) return rows
def _runPropQuery(self, name, prop, valu=None, limit=None, mintime=None, maxtime=None, meth=None, nolim=False): limit = self._getDbLimit(limit) qkey = (s_compat.typeof(valu),s_compat.typeof(mintime),s_compat.typeof(maxtime)) qargs = [ prop ] qargs.extend( [ v for v in (valu,mintime,maxtime) if v != None ] ) if not nolim: qargs.append(limit) qstr = self.qbuild[name][qkey] #print('QNAM: %r' % (name,)) #print('QKEY: %r' % (qkey,)) #print('QSTR: %r' % (qstr,)) #print('QARG: %r' % (qargs,)) if meth == None: meth = self.select rows = meth(qstr,qargs) #print('QROW: %r' % (rows,)) return rows
from __future__ import absolute_import,unicode_literals import time import sqlite3 import synapse.compat as s_compat import synapse.cores.common as common from synapse.compat import queue int_t = s_compat.typeof(0) str_t = s_compat.typeof('visi') none_t = s_compat.typeof(None) istable = ''' SELECT name FROM sqlite_master WHERE type='table' AND name=? ''' inittable = ''' CREATE TABLE %s ( id VARCHAR, prop VARCHAR, strval TEXT, intval BIGINT,
from __future__ import absolute_import, unicode_literals import time import sqlite3 import synapse.compat as s_compat import synapse.cores.common as common from synapse.compat import queue int_t = s_compat.typeof(0) str_t = s_compat.typeof('visi') none_t = s_compat.typeof(None) istable = ''' SELECT name FROM sqlite_master WHERE type='table' AND name=? ''' inittable = ''' CREATE TABLE %s ( id VARCHAR, prop VARCHAR, strval TEXT, intval BIGINT,