from definitions.attribute import textAttribute, intAttribute, dateAttribute, selectAttribute

# MySQL information
class sql_conf:
    SQL_USER = "assetadmin"
    SQL_PASSWORD = "1234"
    SQL_HOST = "localhost"
    SQL_DB = "asset_test_db"
    SQL_TABLE = "asset_test"

item_attributes = [
    textAttribute(
        attrib_name="assettag",
        display_name="Asset Tag",
        required=True,
        unique=True,
        primary=True,
        regex=r"^[A-Z0-9]+$",  # Only uppercase letters and numbers
        default_val="1000000"
    ),
    textAttribute(
        attrib_name="hostname",
        display_name="Host Name",
        required=True,
        unique=True,
        regex=r"^[a-z0-9._-]+$"  # Lowercase letters, numbers, dots, underscores, hyphens
    ),
    dateAttribute(
        attrib_name="warrantyfrom",
        display_name="Warranty From",
        default_val="2020-03-09",
        required=True
    ),
    selectAttribute(
        attrib_name="status",
        display_name="Status",
        required=True,
        options=["Active", "Inactive"],  # Allowed values
        default_val="Active"
    ),
    intAttribute(
        attrib_name="staffnum",
        display_name="Staff No.",
        required=True,
        min_val=100000,  # 6 digits
        max_val=99999999,  # 8 digits
    )
]