From f351e70fbdf72ec14f335aa74ad3e7f0bc6da5bc Mon Sep 17 00:00:00 2001
From: Christian Cleberg <hello@cleberg.net>
Date: Tue, 6 May 2025 21:54:18 -0500
Subject: add and update READMEs (#7)

* add and update READMEs

* Commit from GitHub Actions (Ruff)

---------

Co-authored-by: github-actions <41898282+github-actions[bot]@users.noreply.github.com>
---
 databases/sql/passwords/test.py | 80 -----------------------------------------
 1 file changed, 80 deletions(-)
 delete mode 100644 databases/sql/passwords/test.py

(limited to 'databases/sql/passwords/test.py')

diff --git a/databases/sql/passwords/test.py b/databases/sql/passwords/test.py
deleted file mode 100644
index 81c1138..0000000
--- a/databases/sql/passwords/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()
-- 
cgit v1.2.3-70-g09d2