From 2ee3e7af7b9133da946dff2643505a3d7013b3c0 Mon Sep 17 00:00:00 2001
From: Christian Cleberg <hello@cleberg.net>
Date: Sat, 28 Dec 2024 11:30:03 -0600
Subject: restructure directories

---
 db_passwords/sql/test.py | 77 ------------------------------------------------
 1 file changed, 77 deletions(-)
 delete mode 100644 db_passwords/sql/test.py

(limited to 'db_passwords/sql/test.py')

diff --git a/db_passwords/sql/test.py b/db_passwords/sql/test.py
deleted file mode 100644
index bfacb20..0000000
--- a/db_passwords/sql/test.py
+++ /dev/null
@@ -1,77 +0,0 @@
-"""
-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()
-- 
cgit v1.2.3-70-g09d2