def find_first(cls, where, *args):
"""通过where语句查询，返回一个查询结果。如果有多个结果，则返回一个第一个"""
d = db.selectone('select * from %s %s' %(cls.__table__, where),*args)
return cls(**d) if d else None
def get_catagory(catagory_id):
sql='''select id, catagory_name, catagory_order, catagory_desc from catagory where id =?'''
return db.selectone(sql, (catagory_id,), return_dict=True)
def get(cls, pk):
"""get by primary_key"""
d = db.selectone('select * from %s where %s = ?' %(cls.__table__, cls.__primary_key__.name), pk)
return cls(**d) if d else None
def get_goods(goods_id):
sql = '''select a.*, b.catagory_name from goods a , catagory b where a.catagory_id = b.id and a.id = ?'''
return db.selectone(sql, (goods_id, ), return_dict=True)
