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())