def login():
if request.method == "POST":
playerid = request.form['playerid']
connector = mysql.connector.connect(host='localhost',
user='******',
database='flexplay')
if connector.is_connected():
cursor = connector.cursor()
query = 'SELECT groupid, admin FROM player_groups WHERE playerid = "' + playerid + '"'
cursor.execute(query)
groups = cursor.fetchall()
if groups is not None:
player_groups = {}
for group in groups:
query = 'SELECT groupname FROM group_master WHERE groupid = "' + group + '"'
cursor.execute(query)
group_name = cursor.fetchone()
player_groups[group] = group_name
cursor.close()
connector.close()
return jsonify({'groups': player_groups})
def group_events():
if request.method == "POST":
username = request.form['username']
connector = mysql.connector.connect(host='us-cdbr-east-02.cleardb.com',user='******',password='******',database='heroku_26cfe5af0cd58f4')
if connector.is_connected():
cursor = connector.cursor(buffered=True)
query = 'SELECT teamname FROM players_master WHERE username = "******"'
cursor.execute(query)
teamname = cursor.fetchone()
teamname = teamname[0]
query = 'SELECT username FROM players_master WHERE teamname = "' + teamname + '"'
cursor.execute(query)
group = cursor.fetchall()
group = [x[0] for x in group]
all_group_players = []
for i, player in enumerate(group):
all_group_players.append({'player' : player})
if group is not None:
event_list = []
for player in all_group_players:
query = 'SELECT creater, eventarena, daytime, gameplaytime FROM events_master WHERE creater = "' + player['player'] + '"'
cursor.execute(query)
event = cursor.fetchone()
if event is not None:
event_list.append([{'creater' : event[0]}, {'eventarena' : event[1]}, {'daytime' : event[2]}, {'gameplaytime' : event[3]}])
return jsonify({'events': event_list})
def authorization(username, password):
connector = mysql.connector.connect(host='localhist',
user='******',
database='flexplay')
if connector.is_connected():
cursor = connector.cursor()
query = 'SELECT * FROM players_master WHERE username = "******"'
cursor.execute(query)
Player = cursor.fetchone()
cursor.close()
connector.close()
if Player is not None:
player_info = Player
columns = ('playerid', 'username', 'firstname', 'lastname',
'email', 'phonenumber', 'groupid', 'teamname',
'password')
player_info_tuple = zip(columns, player_info)
player = dict(player_info_tuple)
if Player is None:
response = {'response': 'Player not found'}
access = {'access': False}
elif not check_password_hash(player["password"], password):
response = {'response': 'Incorrect password'}
access = {'access': False}
elif check_password_hash(player['password'], password):
response = player
access = {'access': True}
return access, response
def connexion():
connector = None
mysql_config = None
mysql_config_path = './mysql.ini'
try:
mysql_config = configparser.ConfigParser()
mysql_config.read('flask/mysql.ini')
except Exception as e:
print(e)
try:
connector = mysql.connector.connect(
host=mysql_config['mysql']['host'],
database=mysql_config['mysql']['db'],
user=mysql_config['mysql']['user'],
password=mysql_config['mysql']['password'],
auth_plugin='mysql_native_password')
if connector.is_connected():
yield connector
except Error as e:
print(e)
if connector is not None and connector.is_connected:
connector.close()
def group_event_home():
if request.method == "POST":
eventid = request.form['eventid']
connector = mysql.connector.connect(host='us-cdbr-east-02.cleardb.com',
user='******',
password='******',
database='heroku_26cfe5af0cd58f4')
if connector.is_connected():
cursor = connector.cursor(buffered=True)
query = 'SELECT * FROM events_players WHERE creater = "' + eventid + '"'
cursor.execute(query)
event_players = cursor.fetchall()
cursor.close()
connector.close()
players = []
for player in event_players:
players.append({
'username': player[0],
'firstname': player[1],
'lastname': player[2]
})
return jsonify({'players': players})
def create_group():
if request.method == "POST":
playerid = request.form["playerid"]
groupname = request.form["groupname"]
groupid = randint(100000, 999999)
connector = mysql.connector.connect(
host='localhost',
user='******',
database='flexplay',
auth_plugin='mysql_native_password')
if connector.is_connected():
cursor = connector.cursor(buffered=True)
query = 'SELECT groupid FROM player_groups'
cursor.execute(query)
all_groupid = cursor.fetchall()
while groupid in all_groupid:
groupid = randint(1000000, 9999999)
query = "INSERT INTO player_groups (playerid, groupid, admin) VALUES (%s, %s, %s);"
val = playerid, groupid, True
cursor.execute(query, val)
connector.commit()
query = "INSERT INTO group_master (groupid, groupname) VALUES (%s, %s)"
val = groupid, groupname
cursor.execute(query, val)
connector.commit()
cursor.close()
connector.close()
return "created group successfully"
def login():
if request.method == "POST":
groupid = request.form['groupid']
connector = mysql.connector.connect(host='us-cdbr-east-02.cleardb.com',
user='******',
password='******',
database='heroku_26cfe5af0cd58f4')
if connector.is_connected():
cursor = connector.cursor()
query = 'SELECT username, firstname, lastname FROM group_master WHERE groupid = "' + groupid + '"'
cursor.execute(query)
response = cursor.fetchall()
group_players = []
group_events = []
for player in response:
group_players.append({
'username': player[0],
'firstname': player[1],
'lastname': player[2]
})
for player in group_players:
player_username = player['username']
query = 'SELECT * FROM events_master WHERE creater = "' + player_username + '"'
cursor.execute(query)
response = cursor.fetchall()
for event in response:
group_events.append({
'creater': event[0],
'eventarena': event[1],
'playtime': event[2],
'latitude': event[3],
'longitude': event[4],
'privacy': event[5],
'eventid': event[6],
'datetime': event[7]
})
cursor.close()
connector.close()
return jsonify({
'group_players': group_players,
'group_events': group_events
})
def login(): if request.method == "POST": username = request.form['username'] connector = mysql.connector.connect(host='us-cdbr-east-02.cleardb.com',user='******',password='******',database='heroku_26cfe5af0cd58f4') if connector.is_connected(): cursor = connector.cursor() query = 'SELECT creater,eventarena,daytime,gameplaytime FROM events_master WHERE player = "' + username + '"' cursor.execute(query) your_events = cursor.fetchall() cursor.close() connector.close() print(your_events) print(len(your_events)) print(type(your_events)) return 'Hi'
def join_event():
if request.method == "POST":
username = request.form['username']
firstname = request.form['firstname']
lastname = request.form['lastname']
eventid = request.form['eventid']
connector = mysql.connector.connect(host='us-cdbr-east-02.cleardb.com',user='******',password='******',database='heroku_26cfe5af0cd58f4')
if connector.is_connected():
cursor = connector.cursor(buffered=True)
query = "INSERT INTO event_players (username, firstname, lastname, eventid) VALUES (%s, %s, %s, %s);"
val = username, firstname, lastname, eventid
cursor.execute(query, val)
connector.commit()
cursor.close()
connector.close()
return 'Joined event'
def login():
if request.method == "POST":
invited = request.form['invited']
invitor = request.form['invitor']
team = request.form['team']
connector = mysql.connector.connect(host='us-cdbr-east-02.cleardb.com',
user='******',
password='******',
database='heroku_26cfe5af0cd58f4')
if connector.is_connected():
cursor = connector.cursor()
query = 'INSERT INTO notifications_master(invitor, team, invited) VALUES (%s, %s, %s);'
val = invitor, team, invited
cursor.execute(query, val)
connector.commit()
cursor.close()
connector.close()
return 'Invited'
def login():
if request.method == "POST":
username = request.form['username']
connector = mysql.connector.connect(host='us-cdbr-east-02.cleardb.com',
user='******',
password='******',
database='heroku_26cfe5af0cd58f4')
if connector.is_connected():
cursor = connector.cursor()
query = 'SELECT invitor, team FROM notifications_master WHERE invited = "' + username + '"'
cursor.execute(query)
your_notifications = cursor.fetchall()
cursor.close()
connector.close()
notifications = [
str(x[0] + '-' + x[1] + ' -- ') for x in your_notifications
]
notifications = ''.join(notifications)
print(notifications)
return notifications
def see_event_details():
if request.method == "POST":
event_creater = request.form['creater']
daytime = request.form['daytime']
connector = mysql.connector.connect(host='us-cdbr-east-02.cleardb.com',
user='******',
password='******',
database='heroku_26cfe5af0cd58f4')
if connector.is_connected():
cursor = connector.cursor(buffered=True)
query = 'SELECT player FROM events_master WHERE creater = "' + event_creater + '"'
cursor.execute(query)
group = cursor.fetchall()
players = []
for player in group:
players.append(player[0])
event_players = ','.join(players)
return event_players
def login():
if request.method == "POST":
playerid = request.form['playerid']
connector = mysql.connector.connect(host='localhost',
user='******',
database='flexplay')
if connector.is_connected():
cursor = connector.cursor()
query = 'SELECT groupid, admin FROM player_groups WHERE playerid = ' + playerid
cursor.execute(query)
groups = cursor.fetchall()
if len(groups) != 0:
player_groups = {}
for group in groups:
group = group[0]
query = 'SELECT groupname FROM group_master WHERE groupid = "' + group + '"'
cursor.execute(query)
group_name = cursor.fetchone()
try:
group_name = ''.join(group_name)
except:
None
player_groups[group] = {'name': group_name}
else:
return 'player not associated with any group'
cursor.close()
connector.close()
return jsonify({'groups': player_groups})
def create_event():
if request.method == "POST":
creater = request.form['creater']
username = request.form['username']
firstname = request.form['firstname']
lastname = request.form['lastname']
event_arena = request.form['eventarena']
play_time = request.form['playtime']
latitude = request.form['latitude']
longitude = request.form['longitude']
privacy = 1
eventid = random.randit(100000, 999999)
date_time = request.form['daytime']
connector = mysql.connector.connect(host='us-cdbr-east-02.cleardb.com',
user='******',
password='******',
database='heroku_26cfe5af0cd58f4')
if connector.is_connected():
cursor = connector.cursor(buffered=True)
query = "INSERT INTO events_master (creater, eventarena, playtime, latitude, longitude, privacy, eventid, daytime) VALUES (%s, %s, %s, %s, %s, %s, %s, %s);"
val = creater, even_tarena, playtime, latitude, longitude, privacy, eventid, date_time
cursor.execute(query, val)
connector.commit()
query = "INSERT INTO events_players (username, firstname, lastname, eventid) VALUES (%s %s, %s, %s)"
val = username, firstname, lastname, eventid
cursor.execute(query, val)
connector.commit()
cursor.close()
connector.close()
response = {'response': 'Created Event Successfully'}
else:
response = {'response': 'something went wrong'}
return response
def register():
if request.method == "POST":
player_id = randint(1000000, 9999999)
username = request.form["username"]
firstname = request.form['firstname']
lastname = request.form['lastname']
emailid = request.form['email']
phonenumber = request.form['phonenumber']
password = generate_password_hash(request.form["password"])
connector = mysql.connector.connect(
host='localhost',
user='******',
database='flexplay',
auth_plugin='mysql_native_password')
if connector.is_connected():
cursor = connector.cursor(buffered=True)
query = 'SELECT playerid FROM player_master'
all_playerid = cursor.execute(query)
if all_playerid is not None:
while playerid in all_playerid:
player_id = randint(1000000, 9999999)
query = "INSERT INTO player_master (playerid, username, firstname, lastname, email, phonenumber, password) VALUES (%s, %s, %s, %s, %s, %s, %s);"
val = player_id, username, firstname, lastname, emailid, phonenumber, password
cursor.execute(query, val)
connector.commit()
response = 'Created Account Successfully'
cursor.close()
connector.close()
else:
repsone = 'Cannot connect to database'
return response
def make_match(timeslot, location):
connector = mysql.connector.connect(host='us-cdbr-east-02.cleardb.com',
user='******',
password='******',
database='heroku_26cfe5af0cd58f4')
if connector.is_connected():
privacy = 0
cursor = connector.cursor()
query = 'SELECT * FROM events_master WHERE timeslot = %s AND privacy = 0;'
val = timeslot
cursor.execute(query, (val, ))
events = cursor.fetchall()
if events is None:
response = "No events found"
else:
response = events
cursor.close()
connector.close()
return events
:param this_time: time when rating made
:param last_time: time when last rating made
:return: coefficient for tag calculating
"""
day = (last_time - this_time).days
return min(math.exp((-day + 14) / 320), 1)
#
if __name__ == "__main__":
m = MovieStatistics()
try:
connector = mysql.connector.connect(host='localhost',
database='database255',
user=config.user,
password=config.password)
if connector.is_connected():
db_Info_suggestion = connector.get_server_info()
cursor = connector.cursor()
print("Movie Recommender Connected to MySQL Server version ",
db_Info_suggestion)
except Error as e:
print("Error while connecting to MySQL", e)
sql = 'SELECT DISTINCT userid FROM ratings'
cursor.execute(sql)
rows = cursor.fetchall()
for tup in rows:
movie_recommend_update(tup[0], m)
import mysql.connector
from utilities.credentials import *
from utilities.configuration import *
connector = mysql.connector.connect(host=Get_Host(),
database=Get_DB(),
user=get_SQL_user(),
password=get_SQL_pass())
print(connector.is_connected())
cursor = connector.cursor()
cursor.execute("SELECT * FROM CustomerInfo")
a_single_row = cursor.fetchone()
print(a_single_row) #Returns a tuple with all the column values
print(a_single_row[3])
all_rows = cursor.fetchall(
) #Returns a LIST of tuples with each row's column values
total_sum = 0
for row in all_rows:
print(
row
) #Note how the 1st row (Selenium) was not reprinted, cursor, once moved, stays there.
total_sum += row[2]
print(total_sum)
connector.close()
#Queries with interchangeable data
import mysql.connector as con
con = con.connect(host="localhost",
user="******",
password="******",
database="face_recognition")
if con.is_connected():
print("successfully connected")
else:
print("some")
