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())
