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")