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,
