def sign_in(input_credential):
statement = """SELECT * FROM UserAccount WHERE Username = ?"""
user = User.User(Get.read(statement=statement, row_id=input_credential[0]))
user_credential = user.username, user.password
return (False, "null") if common.isNone(input_credential) \
else (True, "success") if common.verify(input_credential, user_credential) \
else (False, "fail")
def validate_user(user):
statement = """SELECT * FROM UserAccount WHERE Username = ?"""
required_field = (user.user_id, user.fullname, user.username,
user.password, user.email, user.phone, user.privilege)
if common.isNone(required_field) is False:
if Get.read(statement=statement, row_id=user.username) is None:
if common.valid_email(user.email) is True:
if user.bank_name is not None:
if user.bank_account is not None:
if common.valid_integer(user.bank_account):
return True, "success"
return False, "Data Type Not Match!"
return False, "Bank Account Not Filled!"
return True, "success"
return False, "Invalid Email!"
return False, "Username Existed!"
return False, "Required Field Not Filled!"
def display(property_id): # view property details
statement = """SELECT * FROM BaseProperty WHERE PropertyID = ?"""
base_property = BaseProperty.BaseProperty(
Get.read(statement=statement, row_id=property_id))
return vars(base_property)