def get_teamScores(self):
allTeamScores = select_query_dict(
**{
"columns": ["hostTeamScore", "otherTeamScore"],
"filters": {
"roomId": self.roomId,
},
"table_name": "roomInfo"
})
if not allTeamScores:
return {}
return allTeamScores
def get_joinedRoomId(self):
"""
check db for roomId
"""
room_info = select_query_dict(
**{
"columns": ["roomId"],
"filters": {
"userId": self.userId,
},
"table_name": "roomStatus",
"userId": self.userId,
})
self.roomId = room_info.get("roomId")
def get_roomCode(self):
"""
get room code using room ID
"""
if self.roomId:
room_info = select_query_dict(
**{
"columns": ["roomCode"],
"filters": {
"roomId": self.roomId,
},
"table_name": "roomInfo",
})
if room_info:
self.roomCode = room_info.get("roomCode")
return self.roomCode
return None
def otp():
if current_user.is_authenticated:
return redirect(url_for('state_blueprint.index'))
# current_app.logger.info("registring new person.")
form = OtpForm()
current_app.logger.info(f'current user is {request.cookies.get("userId")}')
if not request.cookies.get("userId"):
flash('Please register to verify account.')
return redirect(url_for('state_blueprint.register'))
if form.validate_on_submit():
current_app.logger.info("OTP is validated.")
# current_app.logger.info(f'{column_names}')
try:
# be careful with this ooutput dict
user_info = select_query_dict(
**{
"columns": ["userId", "emailId", "passwordHash"],
"filters": {
"userId": request.cookies.get("userId"),
},
"table_name": "tempUsers",
"userId": request.cookies.get("userId"),
})
insert_row(
**{
"userId": user_info["userId"],
"columns": user_info,
"table_name": "users"
})
except Exception as e:
current_app.logger.error("unable to insert row.")
current_app.logger.error(f'{e}')
flash('Unable to validate OTP.'
' Please try again or contact the owner.')
return redirect(url_for('state_blueprint.otp'))
# db.session.add(user)
# db.session.commit()
# flash('Congratulations, you are now a registered user!')
flash('Email has been Successfully validated.')
return redirect(url_for('state_blueprint.login'))
return render_template('otp.html', title='Register', form=form)
def createroom():
user = current_user
user.get_roomId()
infoLogger(user.roomId)
if user.roomId:
flash(f'Already a room is created. Room ID: {user.roomId}')
# if not user.roomCode:
# user.get_roomCode()
return redirect(url_for('ui_blueprint.room', roomId=user.roomId))
else:
roomCode = random.randint(1000, 9999)
user.set_roomCode(roomCode)
insert_row(
**{
"userId": user.userId,
"columns": {
"roomState": "N",
"roomCode": roomCode,
"host": user.userId,
"starter": user.userId,
"hostTeamScore": 0,
"otherTeamScore": 0,
},
"table_name": "roomInfo"
})
room_info = select_query_dict(
**{
"columns": ["roomId"],
"filters": {
"host": user.userId,
"roomCode": roomCode,
},
"table_name": "roomInfo",
"userId": user.userId,
})
user.set_roomId(room_info.get("roomId"))
room = Room(room_info.get("roomId"))
room.add_host(current_user.userId)
room.add_roomToGameStatus()
flash('created a new room' f' code: {roomCode}')
return redirect(url_for('ui_blueprint.room', roomId=user.roomId))