All notable changes to this project will be documented in this file. See standard-version for commit guidelines.
3.4.1 (2024-02-27)
- types:
ToOutBinds
had incorrect types when dealing with optional properties (6bed6d4)
3.4.0 (2024-02-20)
- deprecate the
configuration
settings (78b47b8) - pools: add ability to set global defaults using
setPoolDefaults
(b7f22cd) - properly export an es module build (dd81c5b)
- sql: add
Sql#join
instance method (8a9cbde) - sql: add
sql
as a separate export for use without the rest of the helpers (d801b7a) - types: add
toDBType
utility type (8f7f20c) - types: make the outbind types automatically convert objects to the correct format. (3f31ae2)
- sql: remove unexpected dedent behavior (735db78)
3.3.1 (2024-01-09)
- toBindDefs: prevent confusing error when only nulls exist (6f93997)
3.3.0 (2023-08-09)
- pools: add
closePools
to close all pools that oracle-helpers manages (3dced36) - pools: add
getPool
to get the pool object created by the helpers (99189e8) - pools: add
setPoolDefaults
andgetPoolDefaults
(198765e) - pools: if a pool is closed, a new pool will be created (eb42540)
- sqlHelpers: Add
isDBError
to typeguard DBError type from oracledb (f827ec6)
- pools: pool keys are connectString and user (8a0ba25)
- pools: specify exclude unused pool attributes (41bd671)
- pools: use more of the dbConfig settings for the pool by default (6b34ecf)
- raw: allow number inputs to
raw
and convert to string (42a5251) - setSqlErrorLogger should accept undefined to unset it (d571714)
3.2.5 (2022-05-17)
- docs: remove references to AbbVie internals (964796f)
- pools: clear timeouts when the promise finishes (3384166)
- sqlHelpers: Pass entire connection argument through (9cc7f74)
- sql: make sql's inspect setup use a symbol (87922aa)
- sql: Remove extra useless handling for arrays with bind names (2ada9f4)
- toBindDefs: consolidate Buffer/String handling and remove an uneeded
?.
(cf8293f)
3.2.4 (2022-05-12)
- docs: remove references to AbbVie internals (964796f)
3.2.3 (2022-04-25)
- make
join
be empty for undefined values, and it will ignore non array values (7561f2a)
3.2.2 (2022-04-22)
- make
join
not throw on empty arrays (5fc06e2)
3.2.1 (2022-04-19)
- sqlHelpers: make default poolMin 0 for resource savings (f8e5b3c)
3.2.0 (2021-08-16)
toBindDefs
failed on non-array entry (1f0c8bc)toBindDefs
to work with unicode inputs (6dced61)toBindDefs
will now look through all rows for the type (a8b8e8f)- sqlHelpers: Don't automatically release passed in connections (d93f7cf)
- sqlHelpers: Improve error message when config is undefined (cb36957)
3.1.0 (2021-02-17)
-
Add ability to bind values with a name to be used (c88ce86)
-
Add toBindDefs (b377e9c)
This will assist with using
returning
in mutateManySql
- possible failure in deduping (5479b13)
3.0.1 (2020-11-16)
- tag: deduping now works correctly in more complicated cases (f128be0)
3.0.0 (2020-11-06)
-
Requires newer versions of Node and OracleDb. Won't support older versions due to changes in constants
-
move support to OracleDb 5 (bd3d6a1)
2.1.1 (2020-10-20)
- tag: Make tags work using named parameters (6c7c85f)
2.1.0 (2020-10-19)
- helpers: Add support for the sql tagged templates in the sql helpers (46e68c6)
- docs: Add words to the tests so that they are recognized in the docs (6bd3639)
2.0.1 (2020-09-22)
- pools: Prevents lockdown when there are a lot of errors all at once (e.g. internet down) (13c37ec)
2.0.0 (2020-09-21)
-
Rename all helper functions
SQL
/SQLPool
variants toSql
/SqlPool
. E.g.getSQL
togetSql
fix(pools): MakeconnectionTimeout
default to 10s from 3s. As 3s is a bit too quick for heavy usage -
Rename a bunch of properties (7df8a99)
1.1.1 (2020-09-21)
1.1.0 (2020-09-21)
- pools: Add pingTime and connectionTimeout (44d0f71)