def testInserExpert(self, name='未知'): u = Userclassifies(name) print(u) db_session.add(u) db_session.commit() id = u.id return id
def articledetails(self, uid, aid): obj = db_session.query(Article).filter(Article.aid == aid).first() list = [] # 获取现在的时间 now_time = datetime.now() timestr = datetime.strftime(now_time, '%Y/%m/%d %H:%M:%S') if obj == None: dict = {} dict['status'] = 0 list.append(dict) else: dict = {} dict['aid'] = obj.aid dict['type'] = obj.type dict['title'] = obj.title dict['fromid'] = obj.fromid dict['time'] = obj.time dict['content'] = obj.content dict['like'] = obj.like list.append(dict) # 写入用户足迹 footstep = Footstep(uid=uid, aid=aid, time=timestr) db_session.add(footstep) try: db_session.commit() except Exception as r: current_app.logger.info(r) current_app.logger.info('{}的用户浏览了{}的文章'.format(uid, aid)) return list
def like(self, aid): re = db_session.query(Article).filter(Article.aid == aid).first() list = [] if re == None: dict = {} dict['status'] = 0 list.append(dict) return list else: likes = re.like + 1 u = db_session.query(Article).filter(Article.aid == aid).update({"like": likes}) if u == 1: current_app.logger.info('id为{}的文章点赞成功'.format(aid)) try: db_session.commit() dict = {} dict['status'] = 1 list.append(dict) return list except Exception as r: dict = {} dict['status'] = 0 list.append(dict) return list
def add(): add = [] speices1 = Speices('name{}'.format(randint(0, 10)), 'info', '栽培技术') add.append(speices1) speices2 = Speices('name{}'.format(randint(0, 10)), 'info', '栽培技术') add.append(speices2) speices3 = Speices('name{}'.format(randint(0, 10)), 'info', '栽培技术') add.append(speices3) speices4 = Speices('name{}'.format(randint(0, 10)), 'info', '栽培技术') add.append(speices4) disease1 = Disease('name{}'.format(randint(0, 100)), 'info', '治疗方法', '防治方法', 1) add.append(disease1) disease2 = Disease('name{}'.format(randint(0, 100)), 'info', '治疗方法', '防治方法', 1) add.append(disease2) disease3 = Disease('name{}'.format(randint(0, 100)), 'info', '治疗方法', '防治方法', 1) add.append(disease3) disease4 = Disease('name{}'.format(randint(0, 100)), 'info', '治疗方法', '防治方法', 1) add.append(disease4) for i in add: print(i) db_session.add_all(add) db_session.commit()
def register(self, username, passward, phone, mail, varifiycode): # username需要适当的名字 username = getRadomStr() if username == None else username username = getRadomStr() if len(username) < 3 else username mail = '' if mail == None else mail if passward != None and varifiycode != None and phone != None and \ len(passward) > 3 and len(varifiycode) == 4 and len(phone) == 11: # 这里验证验证码 if varifiycode != '1234': current_app.logger.info('验证码错误,系统验证码:{}用户输入的验证码:{}'.format( varifiycode, 1234)) return 0 # 查询是否已经有注册了 u = db_session.query(User).filter(User.phone == phone).first() if u != None: current_app.logger.info('手机号{}已经注册过了'.format(phone)) return 0 u = User(username, generate_password_hash(passward), phone, mail, 'N', 2, 0) # 2 设置为注册用户 db_session.add(u) try: db_session.commit() current_app.logger.info('添加用户:{}'.format(u)) except Exception as r: current_app.logger.error(r) return 0 return 1 else: current_app.logger.info('数据错误') return 0
def changeMail(self, uid, mail, varifiycode): if uid != None and mail != None and varifiycode != None and \ len(uid) > 0 and len(mail) >= 3 and len(varifiycode) == 4: # 这里验证验证码 if varifiycode != '1234': current_app.logger.info('验证码错误,系统验证码:{}用户输入的验证码:{}'.format( varifiycode, 1234)) return 0 u = db_session.query(User).filter(User.uid == uid).first() if u == None: current_app.logger.info('查询不到用户id:{}'.format(uid)) return 0 current_app.logger.info('查询到用户{}'.format(u)) u.mail = mail try: db_session.commit() current_app.logger.info('修改用户{}邮箱成功,新邮箱:{}'.format(u, u.mail)) except Exception as r: current_app.logger.error(r) return 0 return 1 else: current_app.logger.info('数据错误') return 0
def delete(): speices = Speices.query.all() print('删除:', speices[2]) db_session.delete(speices[2]) disease = Disease.query.all() print('删除:', disease[2]) db_session.delete(disease[2]) db_session.commit()
def update(): speices = Speices.query.all() u2 = speices[0] u2.sname = '修改' diseases = Disease.query.all() uc2 = diseases[0] uc2.dname = '修改' db_session.commit()
def applyExpert(self, name, degree, userId, pic1, pic2, pic3): expert = Expert(name, degree, pic1, pic2, pic3, userId) db_session.add(expert) try: db_session.commit() current_app.logger.info('添加专家:{}'.format(expert)) except Exception as r: current_app.logger.error(r) return 0 return 1
def update(): users = User.query.all() u2 = users[0] u2.username = '******' ucs = Userclassifies.query.all() uc2 = ucs[0] uc2.classname = '修改' experts = Expert.query.all() expert2 = experts[0] expert2.ename = '修改' db_session.commit()
def addhelpfor(self, title, content, fromid, toid): now_time = datetime.now() timestr = datetime.strftime(now_time, '%Y/%m/%d %H:%M:%S') list = [] dict = {} help = Help(title=title, content=content, time=timestr, fromid=fromid, toid=toid) db_session.add(help) try: db_session.commit() except Exception as r: current_app.logger.info(r) dict['status'] = '成功向{}发起定向求助'.format(toid) list.append(dict) return list
def addshoppingcar(self, uid, sid): list = [] dict = {} shoppingcar = Shoppingcar(uid=uid, sid=sid) db_session.add(shoppingcar) try: db_session.commit() dict['status'] = 1 list.append(dict) except Exception as r: current_app.logger.info(r) dict['status'] = 0 list.append(dict) return list
def delete(): delete = [] users = User.query.all() print('删除:', users[0]) db_session.delete(users[0]) ucs = Userclassifies.query.all() print('删除:', ucs[0]) db_session.delete(ucs[0]) experts = Expert.query.all() print('删除', experts[0]) db_session.delete(experts[0]) db_session.commit()
def addcollect(self, uid, sid): list = [] dict = {} collect = Collect(uid=uid, sid=sid) db_session.add(collect) try: db_session.commit() dict['status'] = 1 list.append(dict) except Exception as r: current_app.logger.info(r) dict['status'] = 0 list.append(dict) return list
def delcollect(self, data): list = [] dict = {} datalist = data['list'] for item in datalist: #循环删除 db_session.query(Collect).filter(Collect.cid == item).delete() try: db_session.commit() dict['status'] = 1 list.append(dict) except Exception as r: current_app.logger.info(r) dict['status'] = 0 list.append(dict) return list
def add(): add = [] addUser1 = User('name{}'.format(randint(0, 10)), '123456', 18200244217, '*****@*****.**', 'N', 1, 0) add.append(addUser1) addUser2 = User('name{}'.format(randint(0, 10)), '123456', 18200244217, '*****@*****.**', 'N', 1, 0) add.append(addUser2) addUser3 = User('name{}'.format(randint(0, 10)), '123456', 18200244217, '*****@*****.**', 'N', 1, 0) add.append(addUser3) addUser4 = User('name{}'.format(randint(0, 10)), '123456', 18200244217, '*****@*****.**', 'N', 1, 0) add.append(addUser4) addUserClassfiies1 = Userclassifies('专家{}'.format(randint(0, 100))) add.append(addUserClassfiies1) addUserClassfiies2 = Userclassifies('专家{}'.format(randint(0, 100))) add.append(addUserClassfiies2) addUserClassfiies3 = Userclassifies('专家{}'.format(randint(0, 100))) add.append(addUserClassfiies3) addUserClassfiies4 = Userclassifies('专家{}'.format(randint(0, 100))) add.append(addUserClassfiies4) addExpert1 = Expert('name{}'.format(randint(0, 10)), 'academic{}'.format(randint(0, 10)), 'academic{}'.format(randint(0, 10))) add.append(addExpert1) addExpert2 = Expert('name{}'.format(randint(0, 10)), 'academic{}'.format(randint(0, 10)), 'academic{}'.format(randint(0, 10))) add.append(addExpert2) addExpert3 = Expert('name{}'.format(randint(0, 10)), 'academic{}'.format(randint(0, 10)), 'academic{}'.format(randint(0, 10))) add.append(addExpert3) addExpert4 = Expert('name{}'.format(randint(0, 10)), 'academic{}'.format(randint(0, 10)), 'academic{}'.format(randint(0, 10))) add.append(addExpert4) for i in add: print(i) db_session.add_all(add) db_session.commit()
def comment(self, type, id, uid, content): # 获取现在的时间 now_time = datetime.now() timestr = datetime.strftime(now_time, '%Y/%m/%d %H:%M:%S') list = [] dict = {} if type is '1' or type is '2': comment = Comment(replyid=id, uid=uid, content=content, time=timestr, type=type) db_session.add(comment) try: db_session.commit() dict['status'] = 'success' except Exception as r: current_app.logger.info(r) dict['status'] = 'fail' else: dict['status'] = '该类型不存在' list.append(dict) return list
def changePhone(self, uid, passward, phone): if uid != None and passward != None and phone != None and \ len(uid) > 0 and len(passward) >= 3 and len(phone) == 11: u = db_session.query(User).filter(User.uid == uid).first() if u == None: current_app.logger.info('查询不到用户id:{}'.format(uid)) return 0 current_app.logger.info('查询到用户{}'.format(u)) u.phone = phone try: db_session.commit() current_app.logger.info('修改用户{}手机号码成功,新手机号:{}'.format( u, u.phone)) except Exception as r: current_app.logger.error(r) return 0 return 1 else: current_app.logger.info('数据错误') return 0
def changeUserName(self, uid, userName): if uid != None and userName != None and \ len(uid) > 0 and len(userName) >= 3: u = db_session.query(User).filter(User.uid == uid).first() if u == None: current_app.logger.info('查询不到用户id:{}'.format(uid)) return 0 current_app.logger.info('查询到用户{}'.format(u)) u.username = userName try: db_session.commit() current_app.logger.info('修改用户{}用户名成功,新用户名:{}'.format( u, u.username)) except Exception as r: current_app.logger.error(r) return 0 return 1 else: current_app.logger.info('数据错误') return 0
def changePassward(self, uid, old, new1, new2): if new1 != None and new2 != None and \ len(new1) >= 3 and len(new2) >= 3 and \ new1 == new2 and uid != None: u = db_session.query(User).filter(User.uid == uid).first() if u == None: current_app.logger.info('查询不到用户id:{}'.format(uid)) return 0 current_app.logger.info('查询到用户{}'.format(u)) if check_password_hash(u.passward, old): u.passward = generate_password_hash(new1) try: db_session.commit() current_app.logger.info('修改用户{}密码成功,新密码:{}'.format( u, generate_password_hash(u.passward))) except Exception as r: current_app.logger.error(r) return 0 return 1 else: current_app.logger.info('用户{}旧密码输入错误,修改失败'.format(u)) return 0
from utils.dataBase import init_db import random init_db() from utils.dataBase import db_session from models.UserSubSysModels import Userclassifies string = '专家{}'.format(random.randint(0, 100)) u = Userclassifies(string) print('写入专家:', u) db_session.add(u) db_session.commit() print(u.query.all())