Releases: sainsburys-tech/snowflake-multisql
Releases · sainsburys-tech/snowflake-multisql
Upgrade snowflake-promise to 4.5.0
inline tags
What:
- inline tags replaces text that are not bind to variables. Resuming it replaces string without adding the string quotes (""). It's useful for the cases when there is need to replace a table name or schema or even the database depending on the logic built in the code.
- Use cases: replace database name depending on the environment used (ex: db_name_dev, db_name_prod)
emitter from within, renamed progress event
What:
- emitter removed as extended class since
- emitter as readonly public field, renamed progress event to "news" since progress is the internal variable name. (hopefully is more verbose).
executeAll<T>
What
- executeAll now accepts generic type, so you can get back a response according to bespoken types!
response data type extracted
What:
- response data type extracted
improving response data type
What
- upgraded data response to a Record type
matches typescript version
What
- Matches typescript version used on snowflake-promise
Statement exported
What
- Statement export forgotten and now it's fixed.
Added progress event
What:
- Add "progress" event to help monitoring the duration of each chunk.
- Swaps test framework to Mocha/Chai/Sinon
- Removes logs on loadFiles utils
- Updates readme
Why:
- For long running multi statement queries, it's useful to know how much time each chunk is taking.
"tags" converts named tags into binds, "replace" deprecated
What:
- param replace renamed as tags
- tags now convert named tags into a sequential binds approach by the original library
Why:
- since the original library manages already sql injection and other security flaws through SF API, this method just extend the functionality allowing named tags but keeping the security features of the original library