(sql, params)
| 62 | |
| 63 | |
| 64 | def swap_params(sql, params): |
| 65 | p = params.items() if params else {} |
| 66 | for k, v in p: |
| 67 | fmt_k = re.escape(str(k).lower()) |
| 68 | regex = re.compile(rf"\$\${fmt_k}(?:\|([^\$\:]+))?(?:\:([^\$]+))?\$\$", re.I) |
| 69 | sql = regex.sub(str(v), sql) |
| 70 | return sql |
| 71 | |
| 72 | |
| 73 | def extract_params(text): |
no outgoing calls