def check_company(self, cname): self.cursor.execute("SELECT company_name FROM company WHERE company_name='{}' ".format(cname)) company = dictfetchall(self.cursor) if len(company) <= 0: return False else: return True
def list_company(self): self.cursor.execute("SELECT company_name FROM company ORDER BY created_date DESC ") company = dictfetchall(self.cursor) if len(company) <= 0: return False else: return company
def get_all_games(self): try: self.cursor.execute( "SELECT name, logo, price, content, id FROM game") except: return False games = dictfetchall(self.cursor) return games
def list_category(self): try: self.cursor.execute("Select genre_name from genre ") except: return False category = dictfetchall(self.cursor) return category
def list_platform(self): try: self.cursor.execute("Select platform_name from platform") except: return False platform = dictfetchall(self.cursor) return platform
def check_game(self, gname): self.cursor.execute( "SELECT name FROM game WHERE name='{}' ".format(gname)) company = dictfetchall(self.cursor) if len(company) <= 0: return False else: return True
def get_game_byid(self, game_id): try: self.cursor.execute( "SELECT name, logo, price, id FROM game WHERE id = {}".format( game_id)) except: return False game = dictfetchall(self.cursor) return game
def game_search(self, search_text): try: self.cursor.execute( "select name from game where name ilike '%{}%'".format( str(search_text))) except: return False games = dictfetchall(self.cursor) return games
def find_user(self, username): """ Gets the user for given username and returns user Returns false if the user does not exist """ ''' Sercan : 13.07.2017 ''' self.cursor.execute("SELECT email, full_name FROM users WHERE username='******'".format(username)) user = dictfetchall(self.cursor) if len(user) <= 0: return False else: return user
def list_game(self): try: """Inner join ile company_name pltform_name genre_name game tablosu ile cekildi""" self.cursor.execute( "select game.*,company.company_name,platform.platform_name,genre.genre_name from game INNER JOIN company ON game.company_id = company.id INNER JOIN platform ON game.platform_id = platform.id INNER JOIN genre on game.genre_id = genre.id ORDER BY game.update_date DESC ;" ) except: return False game = dictfetchall(self.cursor) return game
def check_user(self): """ Check whether the corresponding user exists or not If user exists returns True, if not returns False """ ''' Sercan : 13.07.2017 ''' t1 = self.request_object['username'] t2 = self.request_object['email'] self.cursor.execute("SELECT username FROM users WHERE username='******' or email='{}'".format(t1, str(t2))) user = dictfetchall(self.cursor) if len(user) <= 0: return False else: return True
def login_event(self): """ Checks if the username and password matches in the database Returns username as a dictionary """ ''' Sercan : 12.07.2017''' t1 = self.request_object['username'] t2 = self.request_object['password'] if ("'" in t1 or "'" in t2): return False self.cursor.execute( "SELECT username, admin_id FROM users WHERE username='******' AND password='******'" .format(t1, str(t2))) user = dictfetchall(self.cursor) return user
def list_users(self): """ Returns all users as a list of dictionaries""" ''' Sercan : 13.07.2017 ''' self.cursor.execute("SELECT username, email, full_name, status_id, admin_id FROM users ORDER BY c_date DESC ") users = dictfetchall(self.cursor) return users
def xbox_games(self, id): if (id == 4): self.cursor.execute( "select name from game where platform_id = {}".format(id)) return dictfetchall(self.cursor)