def count(self, selection=None, **kwargs):
keys, cmps = parse_selection(selection, **kwargs)
sql, args = self.create_select_statement(keys, cmps, what='COUNT(*)')
con = self._connect()
self._initialize(con)
cur = con.cursor()
cur.execute(sql, args)
return cur.fetchone()[0]
def count(self, selection=None, **kwargs):
keys, cmps = parse_selection(selection, **kwargs)
sql, args = self.create_select_statement(keys, cmps, what='COUNT(*)')
with self.managed_connection() as con:
cur = con.cursor()
cur.execute(sql, args)
return cur.fetchone()[0]
def main(args):
query = parse_selection(args.query)
include = args.include.split(',') if args.include else []
exclude = args.exclude.split(',') if args.exclude else []
for path in allpaths(args.folder, include, exclude):
format, row = check(path, query, args.verbose)
if format:
if args.long:
print('{} {:10} {:15} {}'.format(
''.join(str(p) for p in row.pbc.astype(int)), row.formula,
format, path))
else:
print(path)