예제 #1
0
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())