def insert_registration():
sql = "insert into registration(username, password) values(%s,%s)"
val = (
username,
password,
)
insert(sql, val)
def new_comment(matchid):
comment = request.form["comment"]
matchid = matchid
sql = "insert into msg(writer, message, matchid) VALUES (%s, %s, %s)"
val = session["username"], comment, matchid
insert(sql, val)
return my_game_info(matchid)
def insert_person():
sql = "insert into person(name, email, gender) values(%s,%s,%s)"
name = fName + " " + lName
val = (
name,
email,
gender,
)
insert(sql, val)
def show_past_chatt():
messages = []
sql = "select writer,message,date from msg WHERE writer = %s OR reciever = %s"
val = session["username"], session["username"]
insert(sql, val)
messages = fetchall(sql, val)
return render_template("messages.html",
user=session["username"],
messages=messages)
def booking_game(matchid):
matchid = int(matchid)
players = request.form["players"]
print(players)
if players == "0":
flash("Var vänlig och boka en plats")
print("players = 0" + players)
return render_template("match_profile.html",
match=show_match.show_Match_Profile(matchid))
else:
print("antal högre än 0:" + players)
booked = fetchone("select booked from match where matchid = %s",
[matchid])
def new_booked():
print(players)
if (int(players) + booked[0]) > 4:
return "4"
else:
return int(players) + booked[0]
print(matchid, session["username"])
creatorName = fetchone("select creator from match where matchid = %s",
[matchid])
sql = "insert into booking values(%s,%s,%s,%s)"
val = matchid, session["username"], creatorName, players
insert(sql, val)
sql = "UPDATE match SET booked = %s WHERE matchid = %s;"
val = new_booked(), matchid
update(sql, val)
sql = "UPDATE match SET players = %s WHERE matchid = %s;"
searching = fetchone("select players from match where matchid = %s",
[matchid])
print(searching[0])
searching = searching[0] - int(players)
val = searching, matchid
update(sql, val)
return start_page()
sql = "UPDATE match SET players = %s WHERE matchid = %s;"
searching = fetchone("select players from match where matchid = %s",
[matchid])
print(searching[0])
searching = searching[0] - int(players)
val = searching, matchid
update(sql, val)
return start_page()
def insert_match():
players = request.form["players"]
show_match.create_Game(session["username"])
matchid = fetchone("select max(matchid) from match where matchid > %s",
"0")
if matchid[0] == None:
matchid = 1
sql = "insert into booking (matchid,username,creatorname,booked) values (%s,%s,%s,%s)"
val = matchid, session["username"], session["username"], players
insert(sql, val)
return start_page()
def upload(file):
uploaded_file = file.filename
now = date.today()
filename = uploaded_file
extension = uploaded_file.split(".")[-1]
checkName = db_operations.checkIfFileNameExists(filename)
if checkName:
db_operations.insert(filename, now, extension, size=0)
else:
newFileName = db_operations.extendFileName(filename)
filename = newFileName
db_operations.insert(filename, now, extension, size=0)
load_File(file, filename)
path = "/app/saved_files/" + filename
file_size = os.stat(path).st_size
print(file_size, flush=True)
db_operations.update_size(filename, file_size)
current_row = db_operations.get_row_by_filename(filename)
return current_row.id
def insert_match():
ort = request.form["ort"]
klass = request.form["klass"]
antal = request.form["antal"]
show_match.create_Game(session["username"])
matchid = fetchone("select max(matchid) from match where matchid > %s",
"0")
print(matchid)
if matchid[0] == None:
matchid = 1
print(matchid)
sql = "insert into booking (matchid,username,creatorname) values (%s,%s,%s)"
val = matchid, session["username"], session["username"]
insert(sql, val)
print(matchid, session["username"])
return render_template("find_match.html",
games=show_match.show_Game(ort, klass, antal))
def show_chatt(matchid):
matchid = int(matchid)
print(matchid)
antal = request.form["antal"]
booked = fetchone("select booked from match where matchid = %s", [matchid])
print(booked[0])
new_booked = int(antal) + booked[0]
print(matchid, session["username"])
creatorName = fetchone("select skapare from match where matchid = %s",
[matchid])
sql = "insert into booking values(%s,%s,%s)"
val = matchid, session["username"], creatorName
insert(sql, val)
sql = "UPDATE match SET booked = %s WHERE matchid = %s;"
val = new_booked, matchid
print(matchid, session["username"])
update(sql, val)
sql = "UPDATE match SET antal = %s WHERE matchid = %s;"
sökes = fetchone("select antal from match where matchid = %s", [matchid])
print(sökes[0])
sökes = sökes[0] - int(antal)
val = sökes, matchid
update(sql, val)
# Future chatt fnction
# def sessions():
# return render_template('session.html')
# def messageReceived(methods=['GET', 'POST']):
# print('message was received!!!')
# @socketio.on('my event')
# def handle_my_custom_event(json, methods=['GET', 'POST']):
# print('received my event: ' + str(json))
# socketio.emit('my response', json, callback=messageReceived)
# return render_template('session.html')
return start_page()
def get_comments() -> bytes:
"""
:return: comments for the received status_id
"""
# Extract the received status_id
status_id: str = request.args.get('status_id')
# Fetch rows from DB using the status_id
comments = select(status_id, table='status_text', column='comments')
# if comments diff from "" there are comments
if comments:
return jsonify({"comments": literal_eval(comments)})
# If the we didn't returned yet, we need get the comments from the web and store it in the DB
status_text, comments = get_data_from_web(status_id)
insert(status_id, status_text, comments)
return jsonify({"comments": literal_eval(comments)})
def operation(self, table):
operation_chosen = self.operation_chosen.get()
if operation_chosen == "New":
self.forget_all()
self.label_name.pack()
self.new_name.pack()
self.label_coord.pack()
self.new_coord.pack()
self.accept_button.pack()
self.accept_button.configure(command=lambda: [
insert(table, self.new_name_value.get(),
self.new_coord_value.get()),
self.update_values(table),
self.window.destroy(),
])
elif operation_chosen == "Update":
self.forget_all()
self.label_name.pack()
self.old_values.pack()
self.label_coord.pack()
self.new_coord.pack()
self.accept_button.pack()
self.accept_button.configure(command=lambda: [
update(table, self.old_chosen.get(), self.new_coord_value.get(
)),
self.update_values(table),
self.window.destroy(),
])
elif operation_chosen == "Delete":
self.forget_all()
self.label_name.pack()
self.old_values.pack()
self.accept_button.pack()
self.accept_button.configure(command=lambda: [
remove(table, self.old_chosen.get()),
self.update_values(table),
self.window.destroy(),
])
else:
raise ValueError
return None
import db_operations
while True:
print """
1. insert
2. update
3. delete
4. show
q. quit
"""
opt = raw_input("Enter an option:")
if opt.lower() == "q" or opt.lower() == "quit":
print "thank you!!"
break
if opt == "1":
db_operations.insert()
elif opt == "2":
db_operations.update()
elif opt == "3":
db_operations.delete()
elif opt == "4":
print db_operations.browse()
else:
print "wrong option"
def insert_profile():
sql = "insert into profile(img, level, location) values(%s, %s, %s)"
image = 'static/img/uploads/blank_profile.png'
val = (image, level, location)
insert(sql, val)