Sql-runner

Latest version: v0.5.0

Safety actively analyzes 688087 Python packages for vulnerabilities to keep your Python projects secure.

Scan your dependencies

Page 2 of 4

0.4.5

- Fix bigquery-related errors:
- Quoted identifier parsing
- Type hints
- Class constructor arguments

0.4.3

- Introduce explicit dependencies in functional comments (JSON)

0.4.2

- Fix the `e` query option, that executes the query as-is. See details in commit message.

0.4.1

**Breaking change**

**Safe for most production environments**

- Queries are now being modified on-the-fly to facilitate full forking of data, either with chaining views (when running with `--test`) or to build data in a staging environment (when running with `--staging`)
- DML statements from comments, as well as parsing semicolons from comments is no longer an issue. Comments from statements are being ignored unless they're functional
- Configuration for `--test` and `--staging` has changed. Explicit `schema_prefix` is no longer used.
- `--test` no longer performs `v` action, but rather `mock`, which, in the most part, is the same as `v`, but will be overridden in the future for Snowflake for example, to allow chaining mock structures, as views cause compilation memory issues on Snowflake.
- New `--except-locally-independent` option for `test` runs, that base new views on test views that are being created in this run, otherwise on original data structures. This allows running tests on a limited data model part, when the other mock structures don't exist or aren't updated.
- New `--cold-run` option, forces the sqlrunner to initiate mock database connections that only output every statement. No actual connection is made. This is done purely for debugging purposes.
- Queries now reveal modifiable dependencies, and this functionality can be further extended.
- Cleanup is now happening only on newly created schemata.

0.3.0

**Might be a breaking change**
- Rebrand to _DEPT SQL Runner_.
LEROI is now part of DEPT
- Add Google BigQuery support
- Enable calling the runner with function arguments
- Refactor dependency detection:
- Switch from regular expressions to query tokenizer and state-machine-based parsing
- Make the functionality overrideable from the DB-specific modules
- Rename `src` to `sql_runner` to make it less generic in the directory structure when installed using `pip`

0.2.9

- Fix file decoding with explicit optional `encoding` option in config, that defaults to `utf-8`

Page 2 of 4

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.