def guess_colour(dbo, s):
""" Guesses a colour, returns the default if no match is found """
s = str(s).lower()
guess = db.query_int(
dbo, "SELECT ID FROM basecolour WHERE LOWER(BaseColour) LIKE '%" +
db.escape(s) + "%'")
if guess != 0: return guess
return configuration.default_colour(dbo)
def guess_species(dbo, s):
""" Guesses a species, returns the default if no match is found """
s = str(s).lower()
guess = db.query_int(
dbo, "SELECT ID FROM species WHERE LOWER(SpeciesName) LIKE '%" +
db.escape(s) + "%'")
if guess != 0: return guess
return configuration.default_species(dbo)
def guess_breed(dbo, s):
""" Guesses a breed, returns the default if no match is found """
s = str(s).lower()
guess = db.query_int(
dbo, "SELECT ID FROM breed WHERE LOWER(BreedName) LIKE '%" +
db.escape(s) + "%'")
if guess != 0: return guess
return configuration.default_breed(dbo)
def guess_agegroup(dbo, s):
""" Guesses an agegroup, returns the default if no match is found """
s = str(s).lower()
guess = db.query_string(
dbo,
"SELECT ItemValue FROM configuration WHERE ItemName LIKE 'AgeGroup%Name' AND LOWER(ItemValue) LIKE '%"
+ db.escape(s) + "%'")
if guess != "": return guess
return db.query_string(
dbo,
"SELECT ItemValue FROM configuration WHERE ItemName LIKE 'AgeGroup2Name'"
)
def authenticate(dbo, username, password):
"""
Authenticates whether a username and password are valid.
Returns None if authentication failed, or a user row
"""
username = db.escape(username).replace("\\", "")
pypassword = hash_password(password)
javapassword = hash_password(password, True)
users = db.query(dbo, "SELECT * FROM users WHERE UPPER(UserName) LIKE UPPER(" + db.ds(username) + ")")
for u in users:
dbpass = u["PASSWORD"].strip()
if dbpass == pypassword or dbpass == javapassword:
return u
return None
def authenticate(dbo, username, password):
"""
Authenticates whether a username and password are valid.
Returns None if authentication failed, or a user row
"""
username = db.escape(username).replace("\\", "")
pypassword = hash_password(password)
javapassword = hash_password(password, True)
users = db.query(
dbo, "SELECT * FROM users WHERE UPPER(UserName) LIKE UPPER(" +
db.ds(username) + ")")
for u in users:
dbpass = u["PASSWORD"].strip()
if dbpass == pypassword or dbpass == javapassword:
return u
return None
def convert_to_sql(self):
return "'"+db.escape(str(self._value))+"'"
def guess_species(dbo, s):
""" Guesses a species, returns the default if no match is found """
s = str(s).lower()
guess = db.query_int(dbo, "SELECT ID FROM species WHERE LOWER(SpeciesName) LIKE '%" + db.escape(s) + "%'")
if guess != 0: return guess
return configuration.default_species(dbo)
def guess_colour(dbo, s):
""" Guesses a colour, returns the default if no match is found """
s = str(s).lower()
guess = db.query_int(dbo, "SELECT ID FROM basecolour WHERE LOWER(BaseColour) LIKE '%" + db.escape(s) + "%'")
if guess != 0: return guess
return configuration.default_colour(dbo)
def guess_breed(dbo, s):
""" Guesses a breed, returns the default if no match is found """
s = str(s).lower()
guess = db.query_int(dbo, "SELECT ID FROM breed WHERE LOWER(BreedName) LIKE '%" + db.escape(s) + "%'")
if guess != 0: return guess
return configuration.default_breed(dbo)
def guess_agegroup(dbo, s):
""" Guesses an agegroup, returns the default if no match is found """
s = str(s).lower()
guess = db.query_string(dbo, "SELECT ItemValue FROM configuration WHERE ItemName LIKE 'AgeGroup%Name' AND LOWER(ItemValue) LIKE '%" + db.escape(s) + "%'")
if guess != "": return guess
return db.query_string(dbo, "SELECT ItemValue FROM configuration WHERE ItemName LIKE 'AgeGroup2Name'")
