def queryToGetPswByTel(telephone): with session_scope(DB_CONNECT_STRING) as session: data = session.query(Userp).filter( Userp.telephone == telephone).first() newdata = copy.deepcopy(data) return newdata
def addCatePics(cate_ids, pic_id): with session_scope(DB_CONNECT_STRING) as session: re = [] for cate_id in cate_ids: re.append(CatePic(cate_id=cate_id, pic_id=pic_id)) session.add_all(re)
def updateChildInfoById(user_id, info): # can raise an Exp with session_scope(DB_CONNECT_STRING) as session: data = session.query(Userc).filter(Userc.user_id == user_id).first() if not data: raise queryNoneEx data.info = info print("changed")
def queryPiclistByCate(cate): with session_scope(DB_CONNECT_STRING) as session: datas = session.query(CatePic.pic_id).join(Category).filter(Category.cate==cate).all() results = [] for data in datas: results.append(data[0]) return results # a list
def updateCate(cate, cate_id): with session_scope(DB_CONNECT_STRING) as session: data = session.query(Category).filter(Category.cate_id==cate_id).first() if not data: raise queryNoneEx data.cate = cate print("changed")
def queryPicpathByWord(word): with session_scope(DB_CONNECT_STRING) as session: data = session.query(Pic.picpath).filter(Pic.picname == word).first() keys = ['picpath'] results = dataToDic(keys, data) return results
def queryPicnameById(pic_id): with session_scope(DB_CONNECT_STRING) as session: datas = session.query(Pic.pic_id, Pic.picname).filter(Pic.pic_id==pic_id).all() keys = ['pic_id', 'picname'] results = dataToDic(keys, datas) return results
def queryAllCate(): with session_scope(DB_CONNECT_STRING) as session: datas = session.query(Category.cate_id, Category.cate).all() keys = ["cate_id", "cate"] results = dataToDic(keys, datas) return results
def updateCatePic(cate_id, pic_id): with session_scope(DB_CONNECT_STRING) as session: data = session.query(CatePic).filter(CatePic.pic_id==pic_id).first() if not data: raise queryNoneEx data.cate_id = cate_id print("changed")
def queryModelById(user_id): with session_scope(DB_CONNECT_STRING) as session: datas = session.query( Userc.models).filter(Userc.user_id == user_id).first() keys = ['models'] results = dataToDic(keys, datas) return results # [{'models': 'nihao'}]
def queryPicByCateName(cate): with session_scope(DB_CONNECT_STRING) as session: datas = session.query(Pic.pic_id, Pic.picname).join(Category).filter(Category.cate == cate).all() for data in datas: print(data) keys = ['pic_id', 'picname'] results = dataToDic(keys, datas) return results
def queryPicpathById(pic_id): with session_scope(DB_CONNECT_STRING) as session: data = session.query(Pic).filter(Pic.pic_id == pic_id).first() print(data) newdata = copy.deepcopy(data) path = newdata.picpath print(path) return path
def queryChildrenByTel(telephone): with session_scope(DB_CONNECT_STRING) as session: datas = session.query( Userc.user_id, Userc.nickname).filter(Userc.telephone == telephone).all() keys = ['user_id', 'nickname'] results = dataToDic(keys, datas) return results
def addChildren(telephone, nickname, birthyear, gender): with session_scope(DB_CONNECT_STRING) as session: models = generateFileName(telephone) new_user = Userc(telephone=telephone, nickname=nickname, birthyear=birthyear, gender=gender, info='暂无新信息', scores=0, models=models) session.add(new_user)
def queryChildAllInfoById(user_id): with session_scope(DB_CONNECT_STRING) as session: datas = session.query( Userc.user_id, Userc.nickname, Userc.gender, year - Userc.birthyear, Userc.info).filter(Userc.user_id == user_id).first() keys = ['user_id', 'nickname', 'gender', 'birthyear', 'info'] results = dataToDic(keys, datas) return results
def queryCateIdByCate(cate): with session_scope(DB_CONNECT_STRING) as session: data = session.query(Category.cate_id).filter(Category.cate==cate).first() newdata = data return newdata
def addUser(telephone, password): with session_scope(DB_CONNECT_STRING) as session: new_user = Userp(telephone=telephone, password=password) session.add(new_user)
re1.append(Pic(picname='手套', picpath='add1/shoutao.jpg')) re1.append(Pic(picname='书包', picpath='add1/shubao.jpg')) re1.append(Pic(picname='糖果', picpath='add1/tangguo.jpg')) re1.append(Pic(picname='香蕉', picpath='add1/xiangjiao.jpg')) re1.append(Pic(picname='橡皮擦', picpath='add1/xiangpica.jpg')) re1.append(Pic(picname='小狗', picpath='add1/xiaogou.jpg')) re1.append(Pic(picname='眼镜', picpath='add1/yanjing.jpg')) re1.append(Pic(picname='椅子', picpath='add1/yizi.jpg')) re1.append(Pic(picname='月亮', picpath='add1/yueliang.jpg')) re1.append(Pic(picname='蜘蛛', picpath='add1/zhizhu.jpg')) re1.append(Pic(picname='字典', picpath='add1/zidian.jpg')) re1.append(Pic(picname='足球', picpath='add1/zuqiu.jpg')) re1.append(Pic(picname='鹅', picpath='add2/e.jpg')) lists = [ '电脑', '年轮', '牛奶', '森林', '蜗牛', '炒面', '茶叶', '红枣', '汽车', '狮子', '手机', '梳子', '西红柿', '钻石', '钉子', '枫叶', '苹果', '乒乓球', '台灯', '星星', '奥特曼', '杯子', '冰淇淋', '电视机', '鸡蛋', '积木', '鲸鱼', '橘子', '恐龙', '孔雀', '老虎', '猫', '蚂蚁', '面包', '绵羊', '米饭', '奶瓶', '盆景', '蒲公英', '扑克牌', '铅笔', '青蛙', '气球', '秋千', '扇子', '时钟', '手表', '手电', '手套', '书包', '糖果', '香蕉', '橡皮擦', '小狗', '眼镜', '椅子', '月亮', '蜘蛛', '字典', '足球', '鹅' ] if __name__ == '__main__': with session_scope(DB_CONNECT_STRING) as session: session.add_all(re1) for list in lists: categorize2db(list) #categorize2db(list2)
def queryPicIdByPicname(picname): with session_scope(DB_CONNECT_STRING) as session: data = session.query(Pic.pic_id).filter(Pic.picname==picname).first() newdata = data return newdata