from pathlib import Path
import unittest


ROOT = Path(__file__).resolve().parents[1]


class DependencyPolicyTests(unittest.TestCase):
    def test_security_fixed_versions_are_pinned(self) -> None:
        requirements = (ROOT / "requirements.txt").read_text(encoding="utf-8")
        self.assertIn("mysql-connector-python==9.1.0", requirements)
        self.assertIn("python-dotenv==1.2.2", requirements)
        self.assertIn("requests==2.33.0", requirements)


if __name__ == "__main__":
    unittest.main()