Typeorm Versions Save

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