"""
Checks SQL Server user data for compliance with Windows policies.
"""

# Import packages
import pandas as pd

# Load the data into a pandas DataFrame
df_input = pd.read_csv('./data.csv')

# Function to apply rules and generate report
def apply_rules_and_report(df):
    """
    Apply defined rules against the input data.

            Parameters:
                df (pandas.DataFrame): SQL login data

            Returns:
                report (list): List of dictionaries containing test results
    """
    report = []
    for _, row in df.iterrows():
        result = {
            'Name': row['name'],
            'Type Check': '',
            'Policy Check': '',
            'Expiration Check': '',
            'Reason': ''
        }

        # Check the type_desc
        if row['type_desc'] == 'SQL_LOGIN':
            result['Type Check'] = 'SQL_LOGIN'
        elif row['type_desc'] == 'WINDOWS_LOGIN':
            result['Type Check'] = 'N/A'
            result['Reason'] = 'Refer to Windows password policy.'
        else:
            result['Type Check'] = 'Manual Review'
            result['Reason'] = 'Reviewer to manually review.'

        # Check if password policy is enforced
        if row['is_policy_checked'] == 1:
            result['Policy Check'] = 'PASS'
            result['Reason'] += '''Password policy is enforced. Reviewer to
            check the assigned policy.'''
        else:
            result['Policy Check'] = 'FAIL'
            result['Reason'] += 'Password policy is not enforced.'

        # Check if password expiration is enforced
        if row['is_expiration_checked'] == 1:
            result['Expiration Check'] = 'PASS'
            result['Reason'] += '''Password expiration is enforced. Reviewer to
            check the expiration policy.'''
        else:
            result['Expiration Check'] = 'FAIL'
            result['Reason'] += 'Password expiration is not enforced.'

        report.append(result)

    return report

# Main function to run the script
def main():
    """
    Apply defined rules against the input data and print the results.
    """
    # Apply rules and generate report
    report = apply_rules_and_report(df_input)
    report_df = pd.DataFrame(report)

    # Print the report
    print(report_df)

if __name__ == "__main__":
    main()