reorganize db dir (#6)

1 files changed, 0 insertions, 80 deletions

diff --git a/databases/passwords/sql/test.py b/databases/passwords/sql/test.py
deleted file mode 100644
index 81c1138..0000000
--- a/databases/passwords/sql/test.py
+++ /dev/null
@@ -1,80 +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()