def bigpage(request, snap_id=None):
if request.method == 'GET':
session = get_session()
snap = session.query(Snap).get(snap_id)
user_session = get_cache('user_session')
if not 'sessionid' in request.COOKIES:
value = None
like = None
else:
key = request.COOKIES['sessionid']
value = user_session.get(key)
like = session.query(SnapLike).filter_by(
snap_id=snap_id, user_id=value['uid']).first()
# template = get_template('bigpage.html')
# variables = Context({'userinfo':value, 'comments':snap.comments, 'likes':snap.likes, 'image_id':snap.image_id, 'likebtn':likebtn})
# output = template.render(variables)
# return HttpResponse(output)
data = {
'snap': snap,
'like': like,
}
return render(request, 'bigpage.html', data)
elif request.method == 'POST':
user_session = get_cache('user_session')
key = request.COOKIES['sessionid']
value = user_session.get(key)
session = get_session()
snap = session.query(Snap).get(snap_id)
form_type = request.POST['form_type']
if form_type == 'comment':
new_comment = request.POST['new_comment']
s = SnapComment(user_id=value['uid'],
snap_id=snap_id,
spot_id=snap.spot_id,
comment=new_comment)
try:
session.add(s)
session.commit()
except:
session.rollback()
session.close()
response = redirect(
'/bigpage/{image_id}'.format(image_id=snap.image_id))
return response
else:
return HttpResponse('Error')
def mainpage(request):
if request.method == 'GET':
session = get_session()
total_num_of_spot = session.query(func.count(Spot.spot_id)).first()[0]
#carousel
selected_spot_id = []
selected_spots = []
while len(selected_spot_id) < 4:
random_spot_id = random.randint(1, total_num_of_spot)
if random_spot_id in selected_spot_id:
continue
snapcheck = session.query(Snap).filter(
Snap.spot_id == random_spot_id).all()
if len(snapcheck) < 4:
continue
selected_spot_id.append(random_spot_id)
snaps = session.query(Snap).filter(
Snap.spot_id == random_spot_id).limit(4).all()
spot_info = session.query(Spot).get(random_spot_id)
selected_spot_data = dict(
snaps=to_dict(snaps),
info=to_dict(spot_info),
)
selected_spots.append(selected_spot_data)
#carousel end
if 'spot' in request.GET:
snaps = session.query(Snap).filter(
Snap.spot_id == request.GET['spot']).limit(18).all()
else:
snaps = session.query(Snap).limit(18).all()
spot_list = session.query(Spot).all()
# 과거의 너의 코드
# template = get_template('mainpage.html')
# variables = Context({'snaps':snaps, 'userinfo':value, 'spotname_a':spotname_a, 'csnaps_a':csnaps_a, 'spotname_b':spotname_b, 'csnaps_b':csnaps_b, 'spotname_c':spotname_c, 'csnaps_c':csnaps_c})
# output = template.render(variables)
# return HttpResponse(output)
# 새롭게 짜야하는 코드
data = {
'spot_list': spot_list,
'snaps': snaps,
'selected_spots': selected_spots,
}
# 이렇게 짜야한다~ 예시이면서 나머지도 다 바꾼다
return render(request, 'mainpage.html', data)
else:
return HttpResponse('Error')
def bigpage(request, snap_id=None):
if request.method == 'GET':
session = get_session()
snap = session.query(Snap).get(snap_id)
user_session = get_cache('user_session')
if not 'sessionid' in request.COOKIES:
value = None
like = None
else :
key = request.COOKIES['sessionid']
value = user_session.get(key)
like = session.query(SnapLike).filter_by(snap_id=snap_id, user_id=value['uid']).first()
# template = get_template('bigpage.html')
# variables = Context({'userinfo':value, 'comments':snap.comments, 'likes':snap.likes, 'image_id':snap.image_id, 'likebtn':likebtn})
# output = template.render(variables)
# return HttpResponse(output)
data = {
'snap':snap,
'like':like,
}
return render(request, 'bigpage.html', data)
elif request.method == 'POST':
user_session = get_cache('user_session')
key = request.COOKIES['sessionid']
value = user_session.get(key)
session = get_session()
snap = session.query(Snap).get(snap_id)
form_type = request.POST['form_type']
if form_type == 'comment':
new_comment = request.POST['new_comment']
s = SnapComment(user_id = value['uid'], snap_id = snap_id, spot_id = snap.spot_id, comment = new_comment)
try :
session.add(s)
session.commit()
except :
session.rollback()
session.close()
response = redirect('/bigpage/{image_id}'.format(image_id = snap.image_id))
return response
else:
return HttpResponse('Error')
def mainpage(request):
if request.method == 'GET':
session = get_session()
total_num_of_spot = session.query(func.count(Spot.spot_id)).first()[0]
#carousel
selected_spot_id = []
selected_spots = []
while len(selected_spot_id) < 4:
random_spot_id = random.randint(1, total_num_of_spot)
if random_spot_id in selected_spot_id:
continue
snapcheck = session.query(Snap).filter(Snap.spot_id==random_spot_id).all()
if len(snapcheck) < 4:
continue
selected_spot_id.append(random_spot_id)
snaps = session.query(Snap).filter(Snap.spot_id==random_spot_id).limit(4).all()
spot_info = session.query(Spot).get(random_spot_id)
selected_spot_data = dict(
snaps = to_dict(snaps),
info = to_dict(spot_info),
)
selected_spots.append(selected_spot_data)
#carousel end
if 'spot' in request.GET :
snaps = session.query(Snap).filter(Snap.spot_id==request.GET['spot']).limit(18).all()
else :
snaps = session.query(Snap).limit(18).all()
spot_list = session.query(Spot).all()
# 과거의 너의 코드
# template = get_template('mainpage.html')
# variables = Context({'snaps':snaps, 'userinfo':value, 'spotname_a':spotname_a, 'csnaps_a':csnaps_a, 'spotname_b':spotname_b, 'csnaps_b':csnaps_b, 'spotname_c':spotname_c, 'csnaps_c':csnaps_c})
# output = template.render(variables)
# return HttpResponse(output)
# 새롭게 짜야하는 코드
data = {
'spot_list': spot_list,
'snaps':snaps,
'selected_spots': selected_spots,
}
# 이렇게 짜야한다~ 예시이면서 나머지도 다 바꾼다
return render(request, 'mainpage.html', data)
else :
return HttpResponse('Error')
def login(request):
if request.method == 'GET':
data = dict()
if 'next' in request.GET:
data['next'] = request.GET['next']
return render(request, 'login.html', data)
elif request.method == 'POST':
session = get_session()
m = session.query(User).filter(
User.user_id == request.POST['user_id']).first()
if m.user_password == md5.new(
request.POST['user_password']).hexdigest():
user_session = get_cache('user_session')
key = str(uuid.uuid4())
value = dict(
uid=m.id,
user_id=m.user_id,
user_gender=m.userinfo.gender,
user_nickname=m.userinfo.nickname,
user_is_admin=m.userinfo.is_admin,
)
user_session.set(key, value, 86400)
if 'next' in request.POST:
response = redirect(request.POST['next'])
else:
response = redirect('/')
response.set_cookie('sessionid', key, 86400)
return response
else:
return HttpResponse('login fail!')
else:
return HttpResponse('Error')
def login(request):
if request.method == 'GET':
data = dict()
if 'next' in request.GET :
data['next'] = request.GET['next']
return render(request, 'login.html', data)
elif request.method == 'POST':
session = get_session()
m = session.query(User).filter(User.user_id==request.POST['user_id']).first()
if m.user_password == md5.new(request.POST['user_password']).hexdigest():
user_session = get_cache('user_session')
key = str(uuid.uuid4())
value = dict(
uid=m.id,
user_id=m.user_id,
user_gender=m.userinfo.gender,
user_nickname=m.userinfo.nickname,
user_is_admin=m.userinfo.is_admin,
)
user_session.set(key,value,86400)
if 'next' in request.POST :
response = redirect(request.POST['next'])
else :
response = redirect('/')
response.set_cookie('sessionid',key,86400)
return response
else:
return HttpResponse('login fail!')
else:
return HttpResponse('Error')
def app(request):
return render(request, 'app.html')
