a1ea321
This file contains 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
| from sensor import Sensor | |
| from pymouse import PyMouse | |
| s = Sensor() | |
| m = PyMouse() | |
| # init sensor | |
| while not s.get_single_sample(): pass |
a1ea321
/ sql_deps.py
Created
August 21, 2024 05:42
Outputs a set of tables (or table-like stuff such as views) that are mentioned in a query. "dep" for "dependency".
This file contains 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
| import logging | |
| from typing import Set, Iterator, Tuple, Optional | |
| import mo_sql_parsing | |
| def deps(query:str, db='', debug=False) -> Set[str]: | |
| if query.strip() == '': | |
| if debug: | |
| return {}, set() |