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)