示例#1
0
    def get_item_list(qp):
        table = DBOperations.get_meta().tables[Constants.PRODUCT_TABLE]
        select_st = select([table])
        conn = DBOperations.get_db_engine().connect()
        if 'item_id' in qp:
            select_st = select([table
                                ]).where(table.c.product_id == qp['item_id'])

        res = conn.execute(select_st)
        data_list = Helpers.generate_list(res)
        return data_list