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)