stivio00
/ db-tool.py
Created
February 10, 2025 19:57
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/env python3 | |
| """ | |
| Usage: db-tool-py test.yaml | |
| It will run each query with the correponding db and sql, if not provided it will use the global values | |
| To install deps | |
| $pip install pydantic pyyaml pandas typer sqlalchemy pyodbc jinja2 | |
| Simple case query the same db with two queries: | |
| scan: |
OlderNewer