def __iter__( self ):
if (self.query is not None) and sqlite.is_read_only_query(self.query):
cur = self.connection.cursor()
for row in cur.execute(self.query):
yield [dict((cur.description[i][0], value) for i, value in enumerate(row))]
else:
yield
def __iter__( self ):
if (self.query is not None) and sqlite.is_read_only_query(self.query):
cur = self.connection.cursor()
for row in cur.execute(self.query):
yield [dict((cur.description[i][0], value) for i, value in enumerate(row))]
else:
yield
def __iter__(self):
if (self.query is not None) and sqlite.is_read_only_query(self.query):
cur = self.connection.cursor()
results = cur.execute(self.query)
if self.headers:
yield [col[0] for col in cur.description]
for i, row in enumerate(results):
if i >= self.limit:
break
yield [val for val in row]
else:
yield
def __iter__( self ):
if (self.query is not None) and sqlite.is_read_only_query(self.query):
cur = self.connection.cursor()
results = cur.execute(self.query)
if self.headers:
yield [col[0] for col in cur.description]
for i,row in enumerate(results):
if i >= self.limit:
break
yield [val for val in row]
else:
yield
def __iter__(self):
if (self.query is not None) and sqlite.is_read_only_query(self.query):
for row in self.connection.cursor().execute(self.query):
yield row
else:
yield
def __iter__( self ):
if (self.query is not None) and sqlite.is_read_only_query(self.query):
for row in self.connection.cursor().execute(self.query):
yield row
else:
yield
def __assert_not_allowed(query):
assert not sqlite.is_read_only_query(query), "Query [%s] incorrectly fails allowlist." % query
def __assert_allowed(query):
assert sqlite.is_read_only_query(query), "Query [%s] fails allowlist." % query
def __assert_not_whitelisted(query):
assert not sqlite.is_read_only_query(
query), "Query [%s] incorrectly fails whitelist." % query
def __assert_whitelisted(query):
assert sqlite.is_read_only_query(
query), "Query [%s] fails whitelist." % query
def __assert_not_whitelisted( query ):
assert not sqlite.is_read_only_query(query), "Query [%s] incorrectly fails whitelist." % query
def __assert_whitelisted( query ):
assert sqlite.is_read_only_query(query), "Query [%s] fails whitelist." % query
