typeorm

Bug Fixes

• added missing parentheses in where conditions (#10650) (4624930), closes #10534
• don't escape indexPredicate (#10618) (dd49a25)
• fallback runMigrations transaction to DataSourceOptions (#10601) (0cab0dd)
• hangup when load relations with relationLoadStrategy: query (#10630) (54d8d9e), closes #10481
• include asExpression columns in returning clause (#10632) (f232ba7), closes #8450 #8450
• multiple insert in SAP Hana (#10597) (1b34c9a)
• resolve issue CREATE/DROP Index concurrently (#10634) (8aa8690), closes #10626
• type inferencing of EntityManager#create (#10569) (99d8249)

Features

• add json type support for Oracle (#10611) (7e85460)
• add postgres multirange column types (#10627) (d0b7670), closes #10556
• add table comment for postgres (#10613) (4493db4)

Reverts

• Revert "fix: prevent using absolute table path in migrations unless required (#10123)" (#10624) (8f371f2), closes #10123 #10624
• revert "feat: nullable embedded entities (#10289)" (#10614) (15de46f), closes #10289 #10614

Bug Fixes

• fixed Cannot read properties of undefined (reading 'sync') caused after glob package upgrade

Bug Fixes

• add BaseEntity to model-shim (#10503) (3cf938e)
• add error handling for missing join columns (#10525) (122c897), closes #7034
• add missing export for View class (#10261) (7adbc9b)
• added fail callback while opening the database in Cordova (#10566) (8b4df5b)
• aggregate function throw error when column alias name is set (#10035) (022d2b5), closes #9927
• backport postgres connection error handling to crdb (#10177) (149226d)
• bump better-sqlite3 version range (#10452) (75ec8f2)
• caching always enabled not caching queries (#10524) (8af533f)
• circular dependency breaking node.js 20.6 (#10344) (ba7ad3c), closes #10338
• correctly keep query.data from ormOption for commit / rollback subscribers (#10151) (73ee70b)
• default value in child table/entity column decorator for multiple table inheritance is ignored for inherited columns (#10563) (#10564) (af77a5d)
• deletedAt column leaking as side effect of object update while creating a row (#10435) (7de4890)
• empty objects being hydrated when eager loading relations that have a @VirtualColumn (#10432) (b53e410), closes #10431
• extend GiST index with range types for Postgres driver (#10572) (a4900ae), closes #10567
• ignore changes for columns with update: false in persistence (#10250) (f8fa1fd), closes #10249
• improve helper for cli for commands missing positionals (#10133) (9f8899f)
• loading datasource unable to process a regular default export (#10184) (201342d), closes #8810
• logMigration has incorrect logging condition (#10323) (d41930f), closes #10322 #10322
• ManyToMany ER_DUP_ENTRY error (#10343) (e296063), closes #5704
• migrations on indexed TIMESTAMP WITH TIME ZONE Oracle columns (#10506) (cf37f13), closes #10493
• mongodb - undefined is not constructor (#10559) (ad5bf11)
• mongodb resolves leaked cursor (#10316) (2dc9624), closes #10315
• mssql datasource testonborrow not affecting anything (#10589) (122b683)
• nested transactions issues (#10210) (25e6ecd)
• prevent using absolute table path in migrations unless required (#10123) (dd59524)
• remove date-fns in favor of DayJs (#10306) (cf7147f)
• remove dynamic require calls (#10196) (a939654)
• resolve circular dependency when using Vite (#10273) (080528b)
• resolve issue building eager relation alias for nested relations (#10004) (c6f608d), closes #9944
• resolve issue of generating migration for numeric arrays repeatedly (#10471) (39fdcf6), closes #10043
• resolve issue queryBuilder makes different parameter identifiers for same parameter (#10327) (6c918ea), closes #7308
• resolve issues on upsert (#10588) (dc1bfed), closes #10587
• scrub all comment end markers from comments (#10163) (d937f61)
• serialize bigint when building a query id #10336 (#10337) (bfc1cc5)
• should automatically cache if alwaysEnable (#10137) (173910e), closes #9910
• SQLite simple-enum column parsing (#10550) (696e688)
• update UpdateDateColumn on upsert (#10458) (fdb9866), closes #9015
• upgrade ts-node version to latest(10.9.1) version (#10143) (fcb9904)
• using async datasource to configure typeorm (#10170) (fbd45db)

Features

• ability to change default replication mode (#10419) (72b1d1b)
• add concurrent indexes for postgres (#10442) (f4e6eaf)
• add exists and exists by (#10291) (b6b46fb)
• add isolated where statements (#10213) (3cda7ec)
• add MSSQL disableAsciiToUnicodeParamConversion option and tests (#10161) (df7c069), closes #10131
• add support for mssql server DefaultAzureCredential usage (#10246) (c8ee5b1)
• add support for table comment in MySQL (#10017) (338df16)
• allow to use custom type witch extends object type for find where argument (#10475) (48f5f85)
• BeforeQuery and AfterQuery events (#10234) (5c28154), closes #3302
• custom STI discriminator value for EntitySchema (#10508) (b240d87), closes #10494
• enabled CTE for oracle driver (#10319) (65858f3)
• entityId in InsertEvent (#10540) (ae006af)
• expose countDocuments in mongodb (#10314) (ebd61d1)
• exposed entity and criteria properties on EntityNotFoundError (#10202) (bafcd17)
• implement column comments for SAP HANA (#10502) (45e31cc)
• implement OR operator (#10086) (a00b1df), closes #10054 #10054 #10054 #10054 #10054 #10054 #10054
• implement streaming for SAP HANA (#10512) (7e9cead)
• implements QueryFailedError generic for driverError typing (#10253) (78b2f48)
• modify repository.extend method for chaining repositories (#10256) (ca29c0f)
• nullable embedded entities (#10289) (e67d704)
• support for MongoDB 6.x (#10545) (3647b26)
• support mssql@10 (#10356) (f6bb671), closes #10340
• use node-oracledb 6 (#10285) (3af891a), closes #10277
• user-defined index name for STI discriminator column (#10509) (89c5257), closes #10496

Performance Improvements

• improve SapQueryRunner performance (#10198) (f6b87e3)

BREAKING CHANGES

• With node-oracledb the thin client is used as default. Added a option to use the thick client. Also added the option to specify the instant client lib
• MongoDB: from the previous behavior of returning a result with metadata describing when a document is not found.
  See: https://github.com/mongodb/node-mongodb-native/blob/HEAD/etc/notes/CHANGES_6.0.0.md
• new nullable embeds feature introduced a breaking change which might enforce you to update types on your entities to | null,
  if all columns in your embed entity are nullable. Since database queries now return embedded property as null if all its column values are null.

Bug Fixes

• #10040 TypeORM synchronize database even if it is up to date (#10041) (b1a3a39)
• add missing await (#10084) (f5d4397)

0.3.16 (2023-05-09)

Bug Fixes

• add trustServerCertificate option to SqlServerConnectionOptions (#9985) (0305805), closes #8093
• add directConnection options to MongoDB connection (#9955) (e0165e7)
• add onDelete option validation for oracle (#9786) (938f94b), closes #9189
• added instanceName to options (#9968) (7c5627f)
• added transaction retry logic in cockroachdb (#10032) (607d6f9)
• allow json as alias for longtext mariadb (#10018) (2a2bb4b)
• convert the join table ID to the referenceColumn ID type (#9887) (9460296)
• correct encode mongodb auth credentials (#10024) (96b7ee4), closes #9885
• create correct children during cascade saving entities with STI (#9034) (06c1e98), closes #7758 #7758 #9033 #9033 #7758 #7758
• express option bug in init command (#10022) (5be20e2)
• for running cli-ts-node-esm use exit code from child process (#10030) (a188b1d), closes #10029
• mongodb typings breaks the browser version (#9962) (99bef49), closes #9959
• RelationIdLoader has access to queryPlanner when wrapped in transaction (#9990) (21a9d67), closes #9988
• resolve duplicate subscriber updated columns (#9958) (3d67901), closes #9948
• select + addOrderBy broke in 0.3.14 (#9961) (0e56f0f), closes #9960
• support More/LessThanOrEqual in relations (#9978) (8795c86)

Features

• mariadb uuid inet4 inet6 column data type support (#9845) (d8a2e37)

Reverts

• "refactor: remove date-fns package (#9634)" (54f4f89)

Bug Fixes

• make cache optional fields optional (#9942) (159c60a)
• prevent unique index identical to primary key (all sql dialects) (#9940) (51eecc2)
• SelectQueryBuilder builds incorrectly escaped alias in Oracle when used on entity with composite key (#9668) (83c6c0e)

Features

• support for the latest mongodb v5 (#9925) (f6a3ce7), closes #7907 #7907

Bug Fixes

• drop xml & yml connection option support. Addresses security issues in underlying dependency (#9930) (7dac12c)

Features

• QueryBuilder performance optimizations (#9914) (12e9db0)

Bug Fixes

• firstCapital=true not working in camelCase() function (f1330ad)
• handles "query" relation loading strategy for TreeRepositories (#9680) (a11809e), closes #9673
• improve EntityNotFound error message in QueryBuilder.findOneOrFail (#9872) (f7f6817)
• loading tables with fk in sqlite query runner (#9875) (4997da0), closes #9266
• prevent foreign key support during migration batch under sqlite (#9775) (197cc05), closes #9770
• proper default value on generating migration when default value is a function calling [Postgres] (#9830) (bebba05)
• react-native doesn't properly work in ESM projects because of circular dependency (#9765) (099fcd9)
• resolve issues for mssql migration when simple-enum was changed (cb154d4), closes #7785 #9457 #7785 #9457
• resolves issue with mssql column recreation (#9773) (07221a3), closes #9399
• transform values for FindOperators #9381 (#9777) (de1228d), closes #9816
• use forward slashes when normalizing path (#9768) (58fc088), closes #9766
• use object create if entity skip constructor is set (#9831) (a868979)

Features

• add support for json datatype for sqlite (#9744) (4ac8c00)
• add support for STI on EntitySchema (#9834) (bc306fb), closes #9833
• allow type FindOptionsOrderValue for order by object property (#9895) (#9896) (0814970)
• Broadcast identifier for removed related entities (#9913) (f530811)
• leftJoinAndMapOne and innerJoinAndMapOne map result to entity (#9354) (947ffc3)

Bug Fixes

• allow to pass ObjectLiteral in mongo find where condition (#9632) (4eda5df), closes #9518
• DataSource.setOptions doesn't properly update the database in the drivers (#9635) (a95bed7)
• Fix grammar error in no migrations found log (#9754) (6fb2121)
• improved FindOptionsWhere behavior with union types (#9607) (7726f5a)
• Incorrect enum default value when table name contains dash character (#9685) (b3b0c11)
• incorrect sorting of entities with multi-inheritances (#9406) (54ca9dd)
• make sure "require" is defined in the environment (1a9b9fb)
• materialized hints support for cte (#9605) (67973b4)
• multiple select queries during db sync in sqlite (#9639) (6c928a4)
• overriding caching settings when alwaysEnabled is true (#9731) (4df969e)
• redundant Unique constraint on primary join column in Postgres (#9677) (b8704f8)
• remove unnecessary .js extension in imports (#9713) (6b37e38)
• resolve issue with "simple-enum" synchronization in SQLite (#9716) (c77c43e), closes #9715
• sql expression when where parameter is empty array (#9691) (7df2ccf), closes #9690
• synchronizing View with schema broken for oracle (#9602) (18b659d)

Features

• add find operator json contains (#9665) (d2f37f6)
• allow mysql2 v3 as peerDependency (#9747) (6c9010e), closes #9714
• naming strategy for legacy Oracle (#9703) (0eb7441)
• support busy_timeout param parameter for sqlite (#9623) (8668c29)
• support enableWal for the better-sqlite3 driver (#9619) (8731858)
• support for SQL aggregate functions SUM, AVG, MIN, and MAX to the Repository API (#9737) (7d1f1d6)
• support time travel queries, upsert, enums, spatial types in cockroachdb (#9128) (defb409), closes #9068 #8532 #8532 #9199
• update mssql dependency and other dependencies as well (#9763) (4555211)

Fixes

• boolean parameter escape in SQLiteDriver (#9400) (4a36d0e), closes #1981
• cacheId not used when loading relations with take (#9469) (93e6b3d)
• correctly return insertId for react-native (#9554) (97fae63)
• disable transactionSupport option for CordovaDriver (#9391) (53fad8f)
• explicitly define property for entity relation as enumerable (#9437) (85fa9c6), closes #6631
• fix ormUtils prototype check crashing on null prototype (#9517) (19536ed)
• fixed outdated init command (#9422) (0984307)
• left instead of inner join for where or + optional relations (#9516) (d490793)
• Mark array arguments to find operators as read-only (#9474) (6eb674b)
• pass fake flag to undoLastMigration (#9562) (2458ac7), closes #9561
• resolve issue with migrations and unsigned int columns in aurora-data-api (#9478) (38e0eff), closes #9477
• resolve nameless TableForeign on drop foreign key (#9460) (efb4168), closes #9432
• synchronize with typeorm_metadata table only if needed (#9175) (cdabaa3), closes #9173 #9173 #9173
• the mpath is incorrect when the parent of the tree entity is null (#9535) (658604d)
• typings for Repository.extend function (#9396) (f07fb2c)

Features

• "And" operator in FindOptions (#9489) (fc3b4f8), closes #3113
• add id in migrate:show command logging (#9475) (71efa8e)
• add Open DB Flags and URI DB Name in SQLite (#9468) (73148c9)
• add parseInt8 option to postgres driver. Closes #9341 (#9435) (2473ff0)
• Add synchronize to @JoinTable (#9442) (93e14a9), closes #3443
• added opaque types support over primitives in find-options (#9560) (4ec04fa)
• allow for partial index conditions for on conflict statments in postgres (#8971) (2c54381)
• allow peerDependency of better-sqlite3 version 8.x.x (#9564) (26107e6), closes #9563
• allow per-migration control over transaction behavior (#9459) (6ba48bd), closes #7087
• implement exists query method (#9303) (598e269), closes #2815
• index support for materialized views of PostgreSQL (#9414) (1cb738a)
• migration:generate successful exit the process with zero code (#9288) (f215e2d)
• new virtual column decorator (#9339) (d305e5f), closes #9323 typeorm#9323 typeorm#9323 typeorm#9323 typeorm#9323
• upsert options conflictPaths as Entity keys (#9365) (b282428)

Bug Fixes

• "Cannot commit, no transaction is active" error in sql.js (#9234) (749809a), closes #9100
• add missing support for primaryKeyConstraintName property in EntitySchema (cc63961)
• malformed query when selecting deeply nested embedded entities (#9273) (83f7b88)
• prototype pollution issue (e3aac27)
• typescript 4.8 type issues #9331 (#9357) (a1960e1)
• Update RelationIdLoader to use DriverUtils.getAlias (#9380) (a917d65), closes #9379

Features

• orphanedRowAction=disabled (rebase of PR 8285) (#8678) (de15df1)
• sqlite - deferrable options for foreign keys (#9360) (773a4fe)
• unify Pool max connection size in supported Drivers (#9305) (48976c2), closes #3388
• update db image versions in docker compose (#9367) (f24b262), closes #9326

Bug Fixes

• fixed regression introduced in 0.3.8 - broken CLI because of #8917 (#9332), closes #9330

Bug Fixes

• allow space and no-space syntaxes for SQLite constraints (#9238) (bb07244), closes #9237
• allow where IsNull for ManyToOne relations (#9031) (72728f1), closes #8890
• change postgres driver version checking query (#9319) (c4f4650), closes #9318 #9318
• don't use temporary table name to create foreign key, unique, check constraint with SQLite (#9185) (e519910), closes #9176
• dropIndex now works when providing a tableIndex without name (#8937) (de8aaac)
• entity manager remove using entity schemas (#9221) (f045536)
• find query mongodb properly with @DeleteDateColumn() (#9262) (e49d0c8)
• handle inherited relations insert order (#9242) (14dfadb), closes #9241
• handle inherited relations insert order (#9321) (3671887), closes #9242 #9241
• pass error to pgpool release (#9209) (eb8f0c6), closes #7792 #5112
• QueryBuilder update handles Date objects wrong on a ManyToOne relationship (#8748) (88d0ced), closes #8747
• resolve FindOptionsOrder.nulls to allow FIRST/LAST in uppercase (#8978) (5e5abbd), closes #8970
• resolve issues with new synonymous for GeometryCollection type in MySQL 8 (#8927) (5ebc626)
• sqlite temporary tables now honor withoutRowid (#8431) (b8d04dc), closes #8430
• support async import for DataSource in CLI #8914 (#8917) (15f90e0)
• update date utils to parse year correctly for years 1-999 (#9236) (72a0147), closes #9230

Features

• add fake migrations running and reverting (#8976) (340ab67), closes #6195
• add setOnLocked for SKIP LOCKED and NOWAIT (#9317) (68e8f22)
• add support for non-generated columns with uuid_generate_v4() default (#9065) (dadb658), closes #9063
• new mssql option appName (#9213) (51a0ebe)

Bug Fixes

• add missing enumName support for EntitySchema (#9024) (676fd1b)
• add missing connect call on RedisQueryResultCache connect (#8894) (7dfb69f)
• add SET TRANSACTION AUTOCOMMIT DDL statements (SAP HANA) (#9020) (cac648e)
• call dataSource.destroy() only on initialized dataSource in CLI commands (#9146) (a100a7a)
• expo infinite loop on SAVEPOINT (#8984) (ec23922)
• fixes recursive document to entity attributes mapping (#9050) (40155d6), closes #9049
• log command error prior to calling destroy (#9135) (bf17381)
• make soft-remove and recover events importable from index (#9110) (e296126), closes #9108
• migration successful now displays name of the migration file (#8904) (49cbe23)
• release newly created runner when no runner provided in DbQueryResultCache (#8969) (ec05f1d), closes #4866
• resolve cli init peer dependency issues (#8977) (f7578d4), closes #8975
• resolve ESM module declaration file correctly (#9097) (506133e)
• support for TypeScript 4.8 (#9106) (d924b70), closes /github.com/microsoft/TypeScript/issues/49461#issuecomment-1154443477
• update mssql peerDependency (#8887) (9adab34)
• wrong entity transform of relation id when referenced column is a primary key (#8959) (6e888dd)

Features

• add for_key_share ("FOR KEY SHARE") lock mode for postgres driver (#8879) (4687be8), closes #8878
• add nativeBinding option to better-sqlite3 driver (#9157) (bcdddc3)
• add spanner as a db option for the init command (#9121) (e61cade)
• allow explicitly named primary keys, foreign keys, and indices (#8900) (78df84c), closes #1355
• Cloud Spanner support (#8730) (62518ae)
• fix issues with generated columns and add support in other drivers (#8806) (0418ebc), closes #8761
• implement support for relationids in entity schemas (#9129) (e24cced)
• support TS 4.7+ node16/nodenext module mode (#9043) (862a402)
• upgrade ioredis to v5 (#8997) (723f1e5)

Performance Improvements

• don't recompile escapeRegExp for every query (#8956) (189592c), closes #8955
• partially lift matching from regexp to js (#9032) (bbdc20f), closes #3857 #8955 #8956 /github.com/typeorm/typeorm/issues/3857#issuecomment-699505893

Features

• add for_key_share ("FOR KEY SHARE") lock mode for postgres driver (#8879) (4687be8), closes #8878
• new driver: Cloud Spanner (#8730) (62518ae)

Bug Fixes

• .save repository method not returning generated uuids for aurora-postgres (#8825) (ed06f4c)
• allow hstore type to use transformers in driver postgres (#8823) (b1a0107)
• broken shebang parameters of cli-ts-node-commonjs and cli-ts-node-esm on some linux distros (#8821) (c5dfc11), closes #8818
• find select object api should support false values #8796 (#8807) (9ac8e9e)
• resolve missing ConnectionOptions export in index.ts (#8850) (1693a17), closes #8837
• save correct discriminator with STI (#8819) (9d1e246), closes #2927
• Update DeepPartial for usage of generics with Repository class (#8817) (8ba742e)
• fixed issue with typeorm init command (#8820)

Bug Fixes

• BaseEntity.reload method regression and made findOne to throw error on missing conditions in runtime (#8801) (ee8c1ec)
• improve DeepPartial recursion (#8732) (0494008), closes #8681
• missing timestamp in created migrations filenames (#8802) (ceee439)
• PoolConnection leaked by MysqlDriver (#8803) (d2cfd22)
• remove console.log calls from SelectQueryBuilder (#8795) (54c7db4), closes #8792
• stop crashing when redis is offline and ignoreErrors on cache options is set (#8725) (edc39d1)

Features

• add support for insert with alias (#4003) (#8791) (4b37030)
• applicationName parameter for CockroachDB (#8800) (79b7f5c)

Bug Fixes

• improve initialization of custom repository (#8782) (52a641c)
• resolve entities correctly in datasource when globs are specified (#8778) (a641c5d)
• CLI migration:run missing console output since 0.3.1 (#8781)

Features

• support for Common Table Expressions (#8534) (7cc1848), closes #1116 #5899 #4753

Bug Fixes

• broken CLI in ESM projects since version 0.3.0 (#8773) (97699e8)

Features

• add typeorm CLI variations that include ts-node (#8776) (05fc744)
• allows user to specify which mysql package should be used (#8771) (35106df)

Reverts

• json/jsonb change introduced in 0.3.1 (#8777) (edf27d9)

Bug Fixes

• bugfixes introduced in 0.3.0 (#8764) (d61f857), closes #8762 #8759 #8758 #8757

Features

• new array find operators (ArrayContains, ArrayContainedBy, ArrayOverlap) (#8766) (9f1b8e3):

BREAKING CHANGES

• we do not call JSON.stringify() to json/jsonb column types in Postgres. Instead, we delegate value directly to underlying pg driver. This is a correct way of handling jsons.
• array: true must be explicitly defined for array json/jsonb values
• strings being JSON-stringified must be manually escaped