def _get(name, code):
where = ''
if name:
where = (cc.c.category.in_( name))
elif code:
where = (cc.c.code == code)
query = cc.select().where(where). \
with_only_columns([
cc.c.category,
cc.c.code])
return dict(_exe(query).fetchall())
def _get_category(args):
"""
Underlying implementation to get the category to the database
"""
e = Engine()
engine = e.getEngine()
where = ''
if args.get('category'):
where = (cc.c.category == args['category'])
elif args.get('code'):
where = (cc.c.code == args['code'])
query = cc.select().where(where). \
with_only_columns([
cc.c.category,
cc.c.code])
result = engine.execute(query)
return dict(result.fetchall())
