def searchSalesRank(input): query = "" params = list() headers = list() if (input.strip() == ""): query = "SELECT Rank, Name, Platform FROM tblSales" headers = list(('Rank', 'Name', 'Platform')) else: query = "SELECT Name FROM tblSales WHERE Rank = ?" params.append(input) headers = list(('Name')) ExecuteQuery(query, params, headers)
def searchSalesTitle(input): query = "" params = list() headers = list() if (input.strip() == ""): query = "SELECT Name, Platform, GlobalSales FROM tblSales" headers = list(('Name', 'Platform')) else: query = "SELECT GlobalSales, Platform FROM tblSales WHERE Name = ?" params.append(input) headers = list(('GlobalSales', 'Platform')) ExecuteQuery(query, params, headers)
def searchSalesYear(input): query = "" params = list() headers = list() if (input.strip() == ""): query = "SELECT Name, Platform, Year FROM tblSales" headers = list(('Name', 'Platform', 'Year')) else: query = "SELECT Name, Platform, Year FROM tblSales WHERE Year = ?" params.append(input) headers = list(('Name', 'Platform', 'Year')) ExecuteQuery(query, params, headers)
def searchRatingsTitle(input): query = "" params = list() headers = list() if (input.strip() == ""): query = "SELECT Name, Platform FROM tblSales UNION SELECT Name, Console FROM tblRatings" headers = list(('Name', 'Platform')) else: query = "SELECT Name FROM tblSales WHERE Name = ?" params.append(input) headers = list(('Name')) ExecuteQuery(query, params, headers)
def searchRatingsUser(input): query = "" params = list() headers = list() if (input.strip() == ""): query = "SELECT Userscore, Name FROM tblRatings" headers = list(('UserScore', 'Name')) else: query = "SELECT Name, Userscore FROM tblRatings WHERE Userscore = ?" params.append(input) headers = list(('Name', 'UserScore')) ExecuteQuery(query, params, headers)
def searchRatingsCritic(input): query = "" params = list() headers = list() if (input.strip() == ""): query = "SELECT Metascore, Name FROM tblRatings" headers = list(('CriticScore', 'Name')) else: query = "SELECT Name, Metascore FROM tblRatings WHERE Metascore = ?" params.append(input) headers = list(('Name', 'CriticScore')) ExecuteQuery(query, params, headers)
def baseSales(): query = "SELECT * FROM tblSales" params = list() headers = list(('Rank', 'Name', 'Platform', 'Year', 'GlobalSales')) ExecuteQuery(query, params, headers)
def baseRatings(): query = "SELECT * FROM tblRatings" params = list() headers = list( ('CriticScore', 'Name', 'Console', 'UserScore', 'ReleaseDate')) ExecuteQuery(query, params, headers)