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