def deleteCover(request):
news_id=request.GET.get('news_id')
print 'news_id:'+news_id
# 创建Session:
session=db.db_createSession()
# 创建Query查询，filter是where条件，最后调用one()返回唯一行，如果调用all()则返回所有行:
img = session.query(Image).filter(Image.news_id==news_id).one()
if img:
rm='/usr/workspace/news/static/images/'+img.news_cover
os.remove(rm)
imgs = img.news_img[1:-1].split(',')
imgs.remove(img.news_cover)
img.news_img=imgs
img.news_cover=''
session.add(img)
session.commit()
session.close()
resJSON='{"result":"succeed"}'
else:
resJSON='{"result":"failed"}'
response = HttpResponse(json.dumps(resJSON))
response.__setitem__("Content-type", "application/json")
response.__setitem__("Access-Control-Allow-Origin", "*")
return response
def check(request):
user_id = request.POST.get('user_id')
token_id = request.POST.get('token_id')
invite_code = request.POST.get('invite_code')
print invite_code
print token_id
newToken = ''
if not checkToken(token_id):
deleteToken(token_id)
newToken = updateToken('create', None, None)
print newToken
if len(user_id) == 11:
session = db.db_createSession()
user = session.query(User).filter(User.user_id == user_id).all()
if user:
return HttpResponse(json.dumps({"result": 'registered', "newToken": newToken}),
content_type="application/json")
else:
invite = session.query(Invite).filter(Invite.user_id == user_id, Invite.invite_code == invite_code).all()
if len(invite) == 1:
return HttpResponse(json.dumps({"result": 'unregistered', "newToken": newToken}),
content_type="application/json")
else:
return HttpResponse(json.dumps({"result": 'error', "newToken": newToken}),
content_type="application/json")
def addNews(request):
news_id=request.GET.get('news_id')
news_title=urllib.unquote(request.GET.get('news_title'))
news_info=urllib.unquote(request.GET.get('news_info'))
news_img=request.GET.get('news_img')
news_date=request.GET.get('news_date')
news_source=urllib.unquote(request.GET.get('news_source'))
news_url=request.GET.get('news_url')
type_id=request.GET.get('type_id')
session=db.db_createSession()
news = session.query(News).filter(News.news_id==news_id).all()
if len(news)==0 and len(news_id)==8:
newNews=News()
newNews.news_id=news_id
newNews.news_title=news_title
newNews.news_info=news_info
newNews.news_content=news_url
newNews.news_img='{'+news_img+'}'
newNews.news_date=news_date
newNews.news_source=news_source
newNews.news_url=news_url
newNews.news_status=0
newNews.type_id=type_id
session.add(newNews)
session.commit()
session.close()
response=HttpResponse('succeed')
response.__setitem__('Access-Control-Allow-Origin','http://54.223.148.123:8070')
return response
else:
response=HttpResponse('failed')
response.__setitem__('Access-Control-Allow-Origin','http://54.223.148.123:8070')
return response
def headinfo(request):
type_id = request.GET.get("type_id")
session = db.db_createSession()
# 创建Query查询，filter是where条件，最后调用one()返回唯一行，如果调用all()则返回所有行:
newses = session.query(News).filter(News.news_status == "3").all()
results = []
for news in newses:
# 打印类型和对象的name属性:
if type_id in news.type_id.split(","):
image = session.query(Image).filter(Image.news_id == news.news_id).one()
result = [
{
"news_id": news.news_id,
"news_title": news.news_title,
"news_info": news.news_info,
"news_content": news.news_content,
"news_img": "http://54.223.148.123:8090/static/images/" + image.news_cover,
"type_id": type_id,
}
]
print result
results += result
# 关闭Session:
session.close()
response = HttpResponse('{"news":' + json.dumps(results) + "}", content_type="application/json")
response.__setitem__("Access-Control-Allow-Origin", "*")
return response
def resetPwd(request):
pwd_1 = request.POST.get('pwd_1')
pwd_2 = request.POST.get('pwd_2')
user_id = request.POST.get('user_id')
print pwd_1
print pwd_2
print user_id
if pwd_1 == pwd_2:
if 6 <= len(pwd_1) <= 16 and 6 <= len(pwd_2) <= 16:
session = db.db_createSession()
user = session.query(User).filter(User.user_id == user_id).all()
if len(user) == 1:
user[0].user_pwd = pwd_1
session.add(user[0])
telcode = session.query(TelCode).filter(TelCode.user_id == user_id).all()
session.delete(telcode)
session.commit()
session.close()
return render_to_response('pwd-succeed.html', {"user_id": user_id})
else:
return render_to_response('pwd-failed.html')
else:
return render_to_response('resetPwd.html', {"user_id": user_id, "error": "密码长度应在6~16位之间"})
else:
return render_to_response('resetPwd.html', {"user_id": user_id, "error": "两次密码输入不一致，请重新输入！"})
def resIdCode(request):
token_id = request.GET.get('token_id')
im = Image.open('/usr/workspace/news/static/test.png')
draw = ImageDraw.Draw(im)
mp = hashlib.md5()
mp.update(str(datetime.datetime.now()))
mp_src = mp.hexdigest()
rand_str = mp_src[0:4]
draw.text((30, 0), rand_str[0],
font=ImageFont.truetype("/usr/workspace/news/static/DejaVuSans-Bold.ttf",
random.randrange(70, 110)))
draw.text((78, 0), rand_str[1],
font=ImageFont.truetype("/usr/workspace/news/static/DejaVuSans-Bold.ttf",
random.randrange(70, 110)))
draw.text((135, 0), rand_str[2],
font=ImageFont.truetype("/usr/workspace/news/static/DejaVuSans-Bold.ttf",
random.randrange(70, 110)))
draw.text((185, 0), rand_str[3],
font=ImageFont.truetype("/usr/workspace/news/static/DejaVuSans-Bold.ttf",
random.randrange(70, 110)))
del draw
request.session['checkcode'] = rand_str
buf = cStringIO.StringIO()
im.save(buf, 'png')
session = db.db_createSession()
print token_id
token = session.query(Token).filter(Token.token_id == token_id).all()
if len(token) == 1:
print rand_str
token[0].code_id = rand_str
session.add(token[0])
session.commit()
session.close()
return HttpResponse(buf.getvalue(), 'image/png')
def checkUserToken(user_id,token_id):
session=db.db_createSession()
token=session.query(User).filter(User.user_id==user_id,User.token_id==token_id).all()
if len(token)==1:
return True
else:
return False
def getToken(request):
# user_id=request.GET.get('user_id')
# print user_id
session=db.db_createSession()
# now=datetime.datetime.now()
# tokens=session.query(Token).all()
# if len(tokens)>0:
# for token in tokens:
# if datetime.datetime.strptime(token.token_time,"%Y-%m-%d %H:%M:%S")<now:
# session.delete(token)
# session.commit()
chars=string.ascii_letters+string.digits
token_rand=''.join([random.choice(chars) for i in range(8)])
time=datetime.datetime.now()+datetime.timedelta(hours=1)
newtoken=Token()
newtoken.token_id=token_rand
newtoken.token_time=str(time)[:19]
session.add(newtoken)
# if len(user_id)>0:
# user=session.query(User).filter(User.user_id==user_id).all()
# if len(user)==1:
# user[0].token_id=token_rand
# session.add(user[0])
session.commit()
session.close()
# return HttpResponse('{"token":"'+token_rand+'","time":"'+str(time)[:19]+'"}', content_type="application/json")
return HttpResponse('{"token_id":"'+token_rand+'"}', content_type="application/json")
def sendEmail(request):
user_id = request.POST.get('user_id')
user_email = request.POST.get('user_email')
session = db.db_createSession()
user = session.query(User).filter(User.user_email == user_email).all()
session.close()
if len(user) == 0:
mailto_list = [user_email]
mail_host = "smtp.163.com"
mail_user = "******"
mail_pass = "******"
mail_postfix = "163.com"
content = "Please click this url:" + "http://54.223.148.123:8090/user/checkEmail/?user_id=" + user_id + "&user_email=" + user_email + "&time=" + str(
datetime.datetime.now())[:-7].replace(' ', 'T')
me = mail_user + "<" + mail_user + "@" + mail_postfix + ">"
msg = MIMEText(content, _charset='gbk')
msg['Subject'] = "mark邮箱验证"
msg['From'] = "*****@*****.**"
msg['To'] = ";".join(mailto_list)
try:
s = smtplib.SMTP()
s.connect(mail_host)
s.login(mail_user, mail_pass)
s.sendmail(me, mailto_list, msg.as_string())
s.close()
return HttpResponse('{"result":"succeed"}', content_type="application/json")
except Exception, e:
return HttpResponse('{"result":"' + str(e) + '"}', content_type="application/json")
def changePwd(request):
user_id = request.POST.get('user_id')
new_pwd = request.POST.get('new_pwd')
old_pwd = request.POST.get('old_pwd')
user_type = request.POST.get('user_type')
token_id = request.POST.get('token_id')
print user_id,new_pwd,old_pwd,user_type,token_id
newToken = ''
session = db.db_createSession()
user = session.query(User).filter(User.user_id == user_id, User.user_type == user_type,
User.user_pwd == old_pwd, User.token_id == token_id).all()
if user and 6 <= len(new_pwd) <= 16:
if not checkToken(token_id):
deleteToken(token_id)
newToken = updateToken('create', None, None)
user[0].token_id = newToken
user[0].user_pwd = new_pwd
session.add(user[0])
session.commit()
session.close()
return HttpResponse(json.dumps({"result": 'succeed', "newToken": newToken}),
content_type="application/json")
else:
return HttpResponse(json.dumps({"result": 'failed', "newToken": newToken}),
content_type="application/json")
def setCover(request):
print 'a'
news_id=request.GET.get('news_id')
image_id=request.GET.get('image_id')
news_img=request.GET.get('news_img')
print 'news_id:'+news_id
print 'image_id:'+image_id
print 'news_img:'+news_img
file_name=news_id+'_'+image_id+'.'+news_img.split('.').pop().lower()
# file_name=news_id+'_'+image_id+'.jpg'
print 'here:'+file_name
# 创建Session:
session=db.db_createSession()
# 创建Query查询，filter是where条件，最后调用one()返回唯一行，如果调用all()则返回所有行:
img = session.query(Image).filter(Image.news_id==news_id).all()
if img:
img[0].news_cover=file_name
session.add(img[0])
session.commit()
session.close()
else:
img=Image()
img.news_id=news_id
img.news_cover=file_name
session.add(img)
session.commit()
session.close()
response = HttpResponse(file_name)
response.__setitem__("Access-Control-Allow-Origin", "*")
return response
def addImg(request):
news_id=request.GET.get('news_id')
image_id=request.GET.get('image_id')
news_img=request.GET.get('news_img')
print 'news_id:'+news_id
print 'image_id:'+image_id
print 'news_img:'+news_img
path=r'/usr/workspace/news/static/images/'
file_name=news_id+'_'+image_id+'.'+news_img.split('.').pop().lower()
# file_name=news_id+'_'+image_id+'.jpg'
print file_name
dest_dir=os.path.join(path,file_name)
url=news_img
try:
urllib.urlretrieve(url,dest_dir)
except:
print '\tError retrieving the URL:',dest_dir
# 创建Session:
session=db.db_createSession()
# 创建Query查询，filter是where条件，最后调用one()返回唯一行，如果调用all()则返回所有行:
img = session.query(Image).filter(Image.news_id==news_id).all()
if img:
if img[0].news_img:
imgs = img[0].news_img[1:-1].split(',')
else:
imgs =[]
file_name=news_id+'_'+image_id+'.'+news_img.split('.').pop().lower()
# file_name=news_id+'_'+image_id+'.jpg'
# if imgs:
imgs.append(file_name)
img[0].news_img=imgs
# else:
session.add(img[0])
session.commit()
session.close()
# return HttpResponse("192.168.1.104:8080/static/images/"+file_name)
else:
img=Image()
img.image_id=news_id
img.news_img=[file_name]
session.add(img)
session.commit()
session.close()
resJSON='{"newUrl":"http://54.223.148.123:8090/static/images/'+file_name+'","image_id":"'+image_id+'"}'
# response = HttpResponse("http://192.168.1.104:8080/static/images/"+file_name)
response = HttpResponse(json.dumps(resJSON))
response.__setitem__("Content-type", "application/json")
response.__setitem__("Access-Control-Allow-Origin", "*")
return response
def addBlog(request):
print 's'
blog_title = request.POST.get('blog_title')
blog_content = request.POST.get('blog_content')
blog_tel = request.POST.get('blog_tel')
blog_name = request.POST.get('blog_name')
blog_role = request.POST.get('blog_role')
print blog_title,blog_content,blog_tel,blog_name
blog_time=str(datetime.datetime.now())
session = db.db_createSession()
chars=string.ascii_letters+string.digits
ss=''.join([random.choice(chars) for i in range(4)])
print 'a'
blog_id=blog_tel.encode('utf-8')+ss
status=True
print 'b'
while status:
print 'a'
chars=string.ascii_letters+string.digits
ss=''.join([random.choice(chars) for i in range(4)])
blog_id=blog_tel.encode('utf-8')+ss
print 's'
if checkBlog(session,blog_id):
print 'sdfsdfewf---'
status=False
print 'sds'
blog=Blog()
blog.blog_id=blog_id
blog.blog_tel=blog_tel
if blog_name:
blog.blog_name=blog_name
blog.blog_title=blog_title
blog.blog_content=blog_content
blog.blog_role=blog_role
blog.blog_time=blog_time
blog.blog_status='0'
print 's'
f=request.FILES["blog_img"]
# f=request.GET.get('blog_img')
file_name=blog_id+'.jpg'
print 'sd'
with open('/usr/workspace/news/static/images/'+file_name,'wb+') as destination:
# with open('/Users/Csd/PycharmProjects/lokimo/static/images/'+file_name,'wb+') as destination:
for chunk in f.chunks():
destination.write(chunk)
print 'sdfsdf'
session.add(blog)
session.commit()
session.close()
response=HttpResponse("succeed")
response.__setitem__("Access-Control-Allow-Origin","*")
return response
def login(request):
user_id = request.POST.get('user_id')
user_pwd = request.POST.get('user_pwd')
user_type = request.POST.get('user_type')
token_id = request.POST.get('token_id')
newToken = ''
print user_id, user_pwd, user_type, token_id
session = db.db_createSession()
user = session.query(User).filter(User.user_id == user_id, User.user_type == user_type).all()
print 'a'
if user:
print 'sdf'
if user[0].user_pwd == user_pwd:
print 'df'
if checkToken(token_id):
user[0].token_id = token_id
else:
print 'ab'
deleteToken(token_id)
print 'bc'
newToken = updateToken('create', None, None)
print 'sss'
user[0].token_id = newToken
print 'sdfdsf'
session.add(user[0])
session.commit()
print 'ss'
if user[0].user_name:
if user[0].user_email:
print 'sdfd'
return HttpResponse('{"user":'******',"result":"succeed","newToken":"' + newToken + '"}',
content_type="application/json")
else:
return HttpResponse('{"user":'******''}) + ',"result":"succeed","newToken":"' + newToken + '"}',
content_type="application/json")
else:
if user[0].user_email:
return HttpResponse('{"user":'******'',
"user_email": user[0].user_email}) + ',"result":"succeed","newToken":"' + newToken + '"}',
content_type="application/json")
else:
return HttpResponse(
'{"user":'******'', "user_email": ''}) + ',"result":"succeed","newToken":"' + newToken + '"}',
content_type="application/json")
else:
return HttpResponse('{"result":"failed","newToken":"' + newToken + '"}', content_type="application/json")
else:
return HttpResponse('{"result":"failed","newToken":"' + newToken + '"}', content_type="application/json")
def updateToken(type,user_id,token_id):
if type=='create':
session=db.db_createSession()
chars=string.ascii_letters+string.digits
token_rand=''.join([random.choice(chars) for i in range(8)])
time=datetime.datetime.now()+datetime.timedelta(hours=1)
newtoken=Token()
newtoken.token_id=token_rand
newtoken.token_time=str(time)[:19]
session.add(newtoken)
session.commit()
session.close()
return token_rand
if type=='instead':
session=db.db_createSession()
user=session.query(User).filter(User.user_id==user_id).all()
if len(user)==1:
user[0].token_id=token_id
session.add(user[0])
session.commit()
session.close()
def upload(request):
file=request.FILES['Filedata']
session=db.db_createSession()
# 创建Query查询，filter是where条件，最后调用one()返回唯一行，如果调用all()则返回所有行:
img = session.query(Image_).filter(Image_.news_id==file.name[:-6]).all()
if img:
img[0].news_cover=file.name
session.add(img[0])
session.commit()
session.close()
ext_allowed=['gif','jpg','jpeg','png']
max_size=2621440
save_dir='/usr/workspace/news/static/images/'
save_path=save_dir
if not file.name:
print '文件不存在！'
ext=file.name.split('.').pop()
print file.name
if ext not in ext_allowed:
print '不是所要求的图片格式！'
if file.size>max_size:
print '文件太大！'
if not os.path.isdir(save_path):
os.makedirs(save_path)
new_file='%s.%s'%(int(time.time()),ext)
t=save_path+str(file)
# k=t[-46:]
im=Image.open(file)
# im.thumbnail((132,132))
im.save(t)
print 'save ok!'
from boto.s3.connection import S3Connection,OrdinaryCallingFormat,Location
from boto.s3.key import Key
from filechunkio import FileChunkIO
print 'a'
conn=S3Connection('AKIAPAH5ZK4LC32GKVKA','TR3unyBnwuv577UYYPXGOXGkcY7OEFSsBuwpjFlx')
print 'b'
print conn.bucket_class
bucket=conn.get_bucket('markbucket')
print bucket
print bucket.get_all_keys()
k=Key(bucket,'a1')
print 'a'
k.set_contents_from_filename('/usr/workspace/news/static/images/'+file.name)
print 'b'
def forgetSMS(request):
user_id = request.POST.get('user_id')
code_id = request.POST.get('code_id')
token_id = request.POST.get('token_id')
print user_id
print code_id
print token_id
newToken = ''
session = db.db_createSession()
token = session.query(Token).filter(Token.token_id == token_id).all()
if len(token) == 1:
print 'a'
if token[0].code_id == code_id:
telcode=session.query(TelCode).filter(TelCode.user_id==user_id).all()
if len(telcode)==0:
print 'b'
mp = hashlib.md5()
mp.update(str(datetime.datetime.now()))
mp_src = mp.hexdigest()
telcode = mp_src[:10]
newTelCode = TelCode()
newTelCode.user_id = user_id
newTelCode.tel_code = telcode
session.add(newTelCode)
session.commit()
else:
print 'c'
telcode=telcode[0].tel_code
if not checkToken(token_id):
deleteToken(token_id)
newToken = updateToken('create', None, None)
return HttpResponse('{"result":"' + telcode + '","newToken":"' + newToken + '"}',
content_type="application/json")
else:
print 'c'
token[0].code_id = None
session.add(token[0])
session.commit()
session.close()
if not checkToken(token_id):
deleteToken(token_id)
newToken = updateToken('create', None, None)
return HttpResponse('{"result":"error","newToken":"' + newToken + '"}', content_type="application/json")
else:
print 'sd'
newToken = updateToken('create', None, None)
return HttpResponse('{"result":"error","newToken":"' + newToken + '"}', content_type="application/json")
def checkToken(token_id):
session=db.db_createSession()
token=session.query(Token).filter(Token.token_id==token_id).all()
now=datetime.datetime.now()
print 'check a'
if len(token)==1:
print 'check b'
if datetime.datetime.strptime(token[0].token_time,"%Y-%m-%d %H:%M:%S")>now:
print 'check aaa'
return True
else:
print 'check ada'
return False
else:
print 'check aqa'
return False
def forgetPwd(request):
tel_code = request.GET.get('tel_code')
time = request.GET.get('time')
print tel_code
print time
now = datetime.datetime.now()
time = datetime.datetime.strptime(time, "%Y-%m-%dT%H:%M:%S")
if time > now - datetime.timedelta(minutes=1000):
session = db.db_createSession()
telcode = session.query(TelCode).filter(TelCode.tel_code == tel_code).all()
if len(telcode) == 1:
user_id = telcode[0].user_id
return render_to_response('resetPwd.html', {"user_id": user_id})
else:
return render_to_response('pwd-failed.html')
else:
return render_to_response('pwd-failed.html')
def register(request):
print 'a'
user_id = request.POST.get('user_id')
user_pwd = request.POST.get('user_pwd')
user_type = request.POST.get('user_type')
token_id = request.POST.get('token_id')
print user_id, user_pwd, user_type, token_id
newToken = ''
session = db.db_createSession()
user = session.query(User).filter(User.user_id == user_id).all()
invite = session.query(Invite).filter(Invite.user_id == user_id).all()
# 创建Query查询，filter是where条件，最后调用one()返回唯一行，如果调用all()则返回所有行:
if user:
print user[0].user_id
return HttpResponse(json.dumps([{"result": 'failed', }, ]) + '}',
content_type="application/json")
else:
if len(user_id) == 11 and 6 <= len(user_pwd) <= 16:
user = User()
user.user_id = user_id
user.user_pwd = user_pwd
user.user_type = user_type
if checkToken(token_id):
user.token_id = token_id
else:
deleteToken(token_id)
newToken = updateToken('create', None, None)
user.token_id = newToken
now = datetime.datetime.now().date()
user.user_date = now
print invite[0].user_email
user.user_email = invite[0].user_email
print 'a'
session.add(user)
print 'b'
session.commit()
print 'c'
session.close()
return HttpResponse(json.dumps({"result": 'succeed', "newToken": newToken}),
content_type="application/json")
else:
return HttpResponse(json.dumps({"result": 'failed', "newToken": newToken}),
content_type="application/json")
def showCover(request):
news_id=request.GET.get('news_id')
print 'news_id:'+news_id
# 创建Session:
session=db.db_createSession()
# 创建Query查询，filter是where条件，最后调用one()返回唯一行，如果调用all()则返回所有行:
img = session.query(Image).filter(Image.news_id==news_id).one()
if img:
resJSON='{"cover":"http://54.223.148.123:8090/static/images/'+img.news_cover+'"}'
else:
resJSON='{"cover":"none"}'
response = HttpResponse(json.dumps(resJSON))
response.__setitem__("Content-type", "application/json")
response.__setitem__("Access-Control-Allow-Origin", "*")
session.close()
return response
def fresh(request):
type_id=request.POST.get('type_id')
user_id=request.POST.get('user_id')
token_id=request.POST.get('token_id')
if checkUserToken(user_id,token_id):
newToken=''
if not checkToken(token_id):
deleteToken(token_id)
newToken=updateToken('create',None,None)
updateToken('instead',user_id,newToken)
session=db.db_createSession()
# 创建Query查询，filter是where条件，最后调用one()返回唯一行，如果调用all()则返回所有行:
sends=session.query(Send).filter(Send.send_user_id==user_id,Send.send_type_id==type_id).one()
num=0
results=[]
newses = session.query(News).filter(News.news_status=='3', News.type_id==type_id,News.news_date>sends.send_latest).order_by(desc(News.news_date)).all()
if 0<len(newses):
status='get'
for news in newses:
if num==0:
sends.send_latest=news.news_date
image=session.query(Image).filter(Image.news_id==news.news_id).one()
result=[
{
"news_id":news.news_id,
"news_title":news.news_title,
"news_info":news.news_info,
"news_content":news.news_content,
"news_img":"http://54.223.148.123:8090/static/images/"+image.news_cover,
},
]
results+=result
num+=1
session.add(sends)
session.commit()
else:
status='none'
session.close()
# results=results+[{"status":status}]
return HttpResponse('{"news":'+json.dumps(results)+',"status":"'+status+'","newToken":"'+newToken+'"}', content_type="application/json")
def getInviteCode(request):
user_id = request.GET.get('user_id')
user_email = request.GET.get('user_email')
print user_id
print user_email
if len(user_id) == 11 and user_email:
session = db.db_createSession()
invite = session.query(Invite).filter(Invite.user_id == user_id).all()
if len(invite) == 1:
if not invite[0].invite_code:
chars = string.ascii_letters + string.digits
inviteCode = ''.join([random.choice(chars) for i in range(11)])
print inviteCode
invite[0].invite_code = inviteCode
invite[0].user_email = user_email
session.add(invite[0])
session.commit()
session.close()
elif invite[0].user_email == user_email:
inviteCode = invite[0].invite_code
else:
response = HttpResponse(json.dumps('{"result":"invalid"}'))
response.__setitem__("Content-type", "application/json")
response.__setitem__("Access-Control-Allow-Origin", "*")
return response
response = HttpResponse(json.dumps('{"result":"' + inviteCode + '"}'))
response.__setitem__("Content-type", "application/json")
response.__setitem__("Access-Control-Allow-Origin", "*")
return response
else:
response = HttpResponse(json.dumps('{"result":"invalid"}'))
response.__setitem__("Content-type", "application/json")
response.__setitem__("Access-Control-Allow-Origin", "*")
return response
else:
response = HttpResponse(json.dumps('{"result":"invalid"}'))
response.__setitem__("Content-type", "application/json")
response.__setitem__("Access-Control-Allow-Origin", "*")
return response
def checkEmail(request):
user_id = request.GET.get('user_id')
user_email = request.GET.get('user_email')
time = request.GET.get('time')
now = datetime.datetime.now()
time = datetime.datetime.strptime(time, "%Y-%m-%dT%H:%M:%S")
if time > now - datetime.timedelta(minutes=1000):
session = db.db_createSession()
user = session.query(User).filter(User.user_id == user_id).all()
if len(user) == 1 and not user[0].user_email:
user[0].user_email = user_email
session.add(user[0])
session.commit()
session.close()
print user_id
print user_email
return render_to_response('email-succeed.html', {"user_id": user_id, "user_email": user_email})
else:
return render_to_response('email-failed.html')
else:
return render_to_response('email-failed.html')
def delete(request):
type_id=request.POST.get('type_id')
user_id=request.POST.get('user_id')
token_id=request.POST.get('token_id')
if checkUserToken(user_id,token_id):
newToken=''
if not checkToken(token_id):
deleteToken(token_id)
newToken=updateToken('create',None,None)
updateToken('instead',user_id,newToken)
session=db.db_createSession()
# 创建Query查询，filter是where条件，最后调用one()返回唯一行，如果调用all()则返回所有行:
send=session.query(Send).filter(Send.send_user_id==user_id,Send.send_type_id==type_id)
if send:
send.delete()
session.commit()
session.close()
return HttpResponse('{"result":"succeed","newToken":"'+newToken+'"}', content_type="application/json")
else:
return HttpResponse('{"result":"failed","newToken":"'+newToken+'"}', content_type="application/json")
def deleteToken(token_id):
session=db.db_createSession()
token=session.query(Token).filter(Token.token_id==token_id).all()
session.delete(token[0])
session.commit()
session.close()
def init(request):
type_id=request.POST.get('type_id')
user_id=request.POST.get('user_id')
count=request.POST.get('count')
token_id=request.POST.get('token_id')
print type_id,user_id,count,token_id
if checkUserToken(user_id,token_id):
print 'a'
newToken=''
if not checkToken(token_id):
print 'sb'
deleteToken(token_id)
newToken=updateToken('create',None,None)
updateToken('instead',user_id,newToken)
print 'd'
session=db.db_createSession()
# 创建Query查询，filter是where条件，最后调用one()返回唯一行，如果调用all()则返回所有行:
num=0
results=[]
send=session.query(Send).filter(Send.send_user_id==user_id,Send.send_type_id==type_id).all()
print 'ss'
if len(send)==0:
send=Send()
send.send_user_id=user_id
send.send_type_id=type_id
else:
print 's'
send=send[0]
# newses = session.query(News).filter(News.news_status=='3', News.type_id==type_id).order_by(desc(News.news_date)).all()
# newses = session.query(News).filter(News.news_status=='3').order_by(desc(News.news_date)).all()
newses = session.query(News).filter(News.news_status=='3').order_by(desc(News.news_date)).all()
for news in newses:
if type_id in news.type_id.split(','):
if num==0:
send.send_latest=news.news_date
image=session.query(Image).filter(Image.news_id==news.news_id).one()
if type_id=='RDOO':
result=[
{
"news_id":news.news_id,
"news_title":news.news_title,
"news_info":news.news_info,
"news_content":news.news_content,
"news_img":"http://54.223.148.123:8090/static/images/"+image.news_cover,
"type_id":news.type_id[:4],
},
]
else:
result=[
{
"news_id":news.news_id,
"news_title":news.news_title,
"news_info":news.news_info,
"news_content":news.news_content,
"news_img":"http://54.223.148.123:8090/static/images/"+image.news_cover,
},
]
results+=result
num+=1
if num==int(count) and int(count)<len(newses):
send.send_oldest=news.news_date
break
if num==len(newses) and int(count)>=len(newses):
send.send_oldest=news.news_date
break
session.add(send)
session.commit()
session.close()
status='succeed'
return HttpResponse('{"news":'+json.dumps(results)+',"result":"'+status+'","newToken":"'+newToken+'"}', content_type="application/json")
def loading(request):
type_id=request.POST.get('type_id')
user_id=request.POST.get('user_id')
count=request.POST.get('count')
token_id=request.POST.get('token_id')
print type_id,user_id,count,token_id
if checkUserToken(user_id,token_id):
newToken=''
if not checkToken(token_id):
deleteToken(token_id)
newToken=updateToken('create',None,None)
updateToken('instead',user_id,newToken)
session=db.db_createSession()
# 创建Query查询，filter是where条件，最后调用one()返回唯一行，如果调用all()则返回所有行:
num=0
results=[]
sends=session.query(Send).filter(Send.send_user_id==user_id,Send.send_type_id==type_id).one()
newses = session.query(News).filter(News.news_status=='3', News.type_id==type_id , News.news_date<sends.send_oldest).order_by(desc(News.news_date)).all()
if len(newses)>=int(count):
print 'a'
for news in newses:
image=session.query(Image).filter(Image.news_id==news.news_id).one()
result=[
{
"news_id":news.news_id,
"news_title":news.news_title,
"news_info":news.news_info,
"news_content":news.news_content,
"news_img":"http://54.223.148.123:8090/static/images/"+image.news_cover,
},
]
results+=result
num+=1
if num==int(count):
sends.send_oldest=news.news_date
break
elif 0<len(newses)<int(count):
print 'b'
for news in newses:
image=session.query(Image).filter(Image.news_id==news.news_id).one()
result=[
{
"news_id":news.news_id,
"news_title":news.news_title,
"news_info":news.news_info,
"news_content":news.news_content,
"news_img":"http://54.223.148.123:8090/static/images/"+image.news_cover,
},
]
results+=result
num+=1
if num==len(newses):
sends.send_oldest=news.news_date
break
session.merge(sends)
session.commit()
session.close()
return HttpResponse('{"news":'+json.dumps(results)+',"newToken":"'+newToken+'"}', content_type="application/json")
