TypeORM changelog

Changelog History

Page 1

• v0.2.38 Changes

  October 02, 2021

  🐛 Bug Fixes

  • prevent using absolute table path in migrations unless required (#8038) (e9366b3)
  • snakecase conversion for strings with numbers (#8111) (749511d)
  • 👉 use full path for table lookups (#8097) (22676a0)

  🔋 Features

  • 👌 support QueryRunner.stream with Oracle (#8086) (b858f84)

• v0.2.37 Changes

  August 13, 2021

  🐛 Bug Fixes

  • 👍 allow periods in parameter identifiers (#8022) (4201938)
  • ConnectionManager connections property should include list of Connections (#8004) (2344db6)
  • entity value for date columns that are related (#8027) (5a3767f)
  • 🖐 handle brackets when only one condition is passed (#8048) (ab39066)
  • 🖐 handle enums with multiple apostrophes in MySQL (#8013) (37c40a6), closes #8011
  • include all drivers in driverfactory error message (#8061) (fbd1ef7)
  • resolve not returning soft deleted relations with withDeleted find option (#8017) (65cbcc7)
  • SAP HANA inserts used incorrect value for returning query (#8072) (36398db)
  • some drivers set the wrong database name when defined from url (#8058) (a3a3284)
  • throw error when not connected in drivers (#7995) (cd71f62)

  🔋 Features

  • ➕ add relations option to tree queries (#7981) (ca26297), closes #7974 #4564
  • ➕ add serviceName option for oracle connections (#8021) (37bd012)
  • ➕ add support to string array on dropColumns (#7654) (91d5b2f)
  • 👌 support Oracle Implicit Results (#8050) (fe78bee)

• v0.2.36 Changes

  July 31, 2021

  🐛 Bug Fixes

  • ➕ add deprecated WhereExpression alias for WhereExpressionBuilder (#7980) (76e7ed9)
  • always generate migrations with template string literals (#7971) (e9c2af6)
  • 📦 use js rather than ts in all browser package manifests (#7982) (0d90bcd)
  • 👉 use nvarchar/ntext during transit for SQLServer queries (#7933) (62d7976)

  🔋 Features

  • ➕ add postgres connection option applicationName (#7989) (d365acc)

• v0.2.35 Changes

  July 28, 2021

  🐛 Bug Fixes

  • ⚡️ entity to be Partial<Entity> | undefined in UpdateEvent (#7783) (f033045)
  • actually return a working ReadStream from SQL Server query runner (#7893) (e80985f)
  • ➕ added version check before dropping materialized views to keep backward compatibility (#7716) (29f1f86)
  • 👍 allow for string id in mongo.findByIds call (#7838) (4b45ae1)
  • 👍 better support of relation-based properties in where clauses (#7805) (3221c50)
  • Buffer in primary columns causes bugs with relations (#7952) (37e08a7), closes #4060
  • capacitor does not correctly set journal mode (#7873) (5f20eb7)
  • Capacitor driver PRAGMA requests failing on Android (#7728) (9620a26)
  • condition is optional in SelectQueryBuilder joins (#7888) (2deaa0e)
  • correctly handle mongo replica set driver option (#7908) (9212df4)
  • correctly load yml in ConnectionOptionsYmlReader (#7743) (57f9254)
  • craft oracle connectString as a descriptor with SID (#7878) (b05d093)
  • ✂ delete operation in MongoDB impact all matched documents (#7811) (0fbae53), closes #7809
  • Do not add NULL/NOT NULL for stored columns (#7708) (3c33e9f), closes #7698
  • do OBJECT_ID lookup for column constraint instead of name in mssql (#7916) (fa8c1b0)
  • ⬇️ drop pool.autostart from mssql options because it's unused (#7877) (0d21a4d)
  • ⬇️ drop SAP statement after prepare per Hana client docs (#7748) (8ca05b1)
  • eager relation respects children relations (#5685) (e7e887a)
  • enable returning additional columns with MSSQL (#7864) (e1db48d)
  • ⚡️ entity object undefined in afterUpdate subscriber (#7724) (d25304d)
  • find operation in MongoDB do not include nullable values from documents (#7820) (98c13cf), closes #7760
  • 🛠 fix table loading when schemas are used (3a106a3)
  • foreign keys in SAP were loading from the wrong table (#7914) (4777a79)
  • 0️⃣ handle postgres default when tableColumn.default is not string (#7816) (0463855)
  • handle snake case of ABcD which should become a_bc_d (#7883) (eb680f9)
  • 👌 improve query for MSSQL to fetch foreign keys and tables (#7935) (f6af01a)
  • 👉 make OracleQueryRunner createDatabase if-not-exists not fail (f5a80ef)
  • only pass data from SaveOptions during that query (#7886) (1de2e13)
  • 👍 oracle cannot support DB in table identifiers (#7954) (8c60d91)
  • pass table to namingstrategy when we can instead of table name (#7925) (140002d)
  • prevent modification of the FindOptions.relations (#7887) (a2fcad6)
  • prevent reuse of broken connections in postgres pool (#7792) (5cf368a)
  • prevent transactions in the Cordova driver (#7771) (fc4133c)
  • properly escape oracle table paths (#7917) (7e8687c)
  • regression when making join conditions undefined-able (#7892) (b0c1cc6)
  • 🏗 restored buildColumnAlias for backward compatibility (#7706) (36ceefa)
  • ⚡️ return correct DeleteResult and UpdateResult for mongo (#7884) (7a646a2)
  • 👌 support fully qualified schema in createSchema (#7934) (94edd12)
  • 👌 support table names between schemas in oracle (#7951) (aa45b93)
  • typing so SelectQueryBuilder.getRawOne may return undefined (#7863) (36e5a0c), closes #7449
  • typo prevented us from pulling the schema correctly in some cases (c7f2db8)
  • ⚡️ update operation in MongoDB impact all matched documents (#7803) (052014c), closes #7788
  • 👉 use correct query for cross-database mssql identity check (#7911) (7869fb1)
  • 👉 use fully qualified and escaped table names for oracle (#7857) (2b90725), closes #7779
  • ⚡️ use ObjectLiteral in UpdateEvent rather than Entity (#7910) (78fbc14)
  • 👉 use only table name in constraint naming strategy (5dc777f)

  🔋 Features

  • ➕ add retryWrites to allowed mongo extra options (#7869) (dcdaaca)
  • ➕ add capacitor driver options for encryption & version (#7868) (a2bd94b)
  • ➕ add connection option entitySkipConstructor (f43d561)
  • ➕ add ObjectLiteral typing to andWhere / orWhere (#7786) (525381d)
  • ➕ add parseTableName to Driver interface (#7956) (cffbf43)
  • ➕ add path, database, and schema to Table (#7913) (444e38b)
  • ➕ add property for database and schema in views (#7953) (4c5bbd9)
  • ➕ add referenced database & schema to TableForeignKey (fff6b11)
  • ➕ add writeConcern option as a possible extras for mongodb (#7801) (90894c7)
  • 📜 consistent parsing and escaping of table names in QueryRunners (bd9e767)
  • implement OracleQueryRunner.hasDatabase (128b982)
  • 👉 make parameter to getTables optional (#7901) (ba86602)
  • 👉 make postgres extensions install optional (#7725) (92b96a5), closes #7662
  • publicly export Transaction*Event types (#7949) (2436a66), closes /github.com/typeorm/typeorm/blob/master/src/subscriber/EntitySubscriberInterface.ts#L12
  • set enableArithAbort for SQLServerDriver (#7894) (1f64da2)
  • 👌 support absolute path in migration:generate (#7720) (b690c27)
  • 👉 use char(36) for uuid representation in mysql (#7853) (063aafa)
  • 👉 use column length from driver when creating columns (#7858) (b107ad9)

• v0.2.34 Changes

  June 03, 2021

  🐛 Bug Fixes

  • 🏗 restored buildColumnAlias for backward compatibility (#7706) (36ceefa)

• v0.2.33 Changes

  June 01, 2021

  🐛 Bug Fixes

  • @Unique constraint is not created with specified name (beea2e1)
  • 🔀 MATERIALIZED VIEW is treated as a regular VIEW which causes issues on sync (#7592) (f85f436)
  • ➕ added error handler for slave connections in MySQL and AuroraDataApi drivers (#7641) (882a740)
  • call listeners for array embeddeds in MongoDB (#4260) (2dc355b)
  • closing pool incorrectly works on Postgres (#7596) (1310c97), closes #6958 #6958 #6958
  • column name with empty spaces causes bug in Index/Unique decorators #7534 (a3a6e06)
  • 0️⃣ correctly strip type conversion in postgres for default values (#7681) (069b8b6), closes #1532 #7647 #5132
  • 🔀 datetime functions in column "default" leads to unnecessary queries during synchronization (#7517) (03f3285), closes #3991 #3991 #2737 #2737 #6412 #4281 #4658 #3991 #2333 #7381 #4658 #3991 #3991 #3991 #3991
  • 🔀 default schema defined in entity/connection leads to unnecessary queries during schema sync (#7575) (7eb0327), closes #7276 #7276
  • 👀 do a deep comparison to see if the default value has changed for json types in Postgres (#7650) (a471c1b)
  • ⚡️ Incorrect migration generated when multiple views are updated in a single migration (#7587) (0b103dd), closes #7586
  • issues with custom enum name in Postgres (#7661) (ad0262a), closes #7614 #7541 #7647 #6540
  • 📜 mongodb connectionURL parse options (#7560) (b2ac41a)
  • mongodb typings for Cursor (#7526) (daf3991)
  • 🚚 only first \0 is removed in comments, only first \ is escaped etc. (#7532) (36b14cb)
  • 📇 pass ManyToMany onUpdate option to foreign key metadata (#5714) (198d2c5), closes #4980
  • Postgres identifier exceeds limit on eager relations (#7508) (#7509) (e4ec429)
  • ✂ remove enableExtension for slave connections in Postgres (#7693) (620aac9), closes #7691
  • 🗄 replaced deprecated insert method with insertOne for MongoDriver in MigrationExecutor. (#7594) (83fed60)
  • resolve issue when enum that has functions is used in entity (#7653) (dba327d), closes #7651
  • Silent failure in createDatabase and dropDatabase with Postgres (#7590) (974d2d4), closes #6867
  • STI types on children in joins (#3160) (60a6c5d)
  • 👉 use host if hostReplicaSet is not provided in MongoDriver (#7559) (9b6d7bc)
  • 👉 use migrationsTransactionMode while running migration from cli (#7576) (7953ebb)
  • 👉 use most specific matching relation type (#2967) (ee3c00a)

  🔋 Features

  • ➕ add orphanedRowAction option to EntitySchemaRelationOptions (#7625) (a8eb49a), closes #7417
  • ➕ add set datatype support for aurora-data-api (#7665) (b6c1836)
  • ➕ add support for specifying ioredis cache with a URL (#7689) (e017f9b), closes #7631
  • ➕ add tree entities update and delete logic (#7156) (9c8a3fb), closes #7155
  • ➕ added Capacitor driver (#7695) (0f7a778)
  • cache option to ignore errors (#7630) (5fde0ea), closes #926
  • define class properties for QueryFailedError to allow users to access a typed error (#7529) (b43dcba)
  • support MAX_EXECUTION_TIME for MySQL driver. (#7638) (0564c34)

• v0.2.32 Changes

  March 30, 2021

  🐛 Bug Fixes

  • aurora-data-api get correct increment primary key for multiple entities inserted (#7434) (fc8af5f), closes #7385
  • ⚡️ aurora-data-api return number of affected rows in UpdatedResult and DeleteResult (#7433) (46aba1d), closes #7386
  • RelationLoader load with existing queryRunner (#7471) (2dcb493), closes #5338
  • 0️⃣ Array type default value should not generate SQL commands without change (#7409) (7f06e44)
  • correctly get referenceColumn value in getEntityValueMap (#7005) (7fe723b), closes #7002
  • ⚡️ don't transform json(b) column value when computing update changes (#6929) (6be54d4)
  • empty entity when query with nested relations (#7450) (9abf727), closes #7041 #7041 #7041
  • 🛠 fixed all known enum issues (#7419) (724d80b), closes #5371 #6471 #7217 #6047 #7283 #5871 #5729 #5478 #5882 #5275 #2233 #5648 #4897 #6376 #6115
  • 👌 improve EntityManager.save() return type (#7391) (66fbfda)
  • Only first single quote in comments is escaped (#7514) (e1e9423)
  • 🐎 performance issues of RelationId. (#7318) (01a215a), closes #5691
  • 📇 rename a sequence related to generated primary key when a table is renamed (#5406) (25b457f)
  • 🏗 resolve issue building tree entities with embeded primary column (#7416) (dc81814), closes #7415
  • 0️⃣ wrong migration generation when column default value is set to null #6950 (#7356) (5a3f9ff)

  🔋 Features

  • ➕ add check and dry-run to migration generate (#7275) (d6df200), closes #3037 #6978
  • ➕ add option for installing package using CLI (#6889) (3d876c6)
  • ➕ Add support for Access Token Authentication for SQL Server Driver (mssql) (#7477) (e639772)
  • ➕ added socketPath support for replicas in MySQL driver (#7459) (8d7afaf)
  • 👍 allow to pass the given table name as string in RelationDecorators (#7448) (4dbb10e)
  • ⚡️ implement "FOR UPDATE OF" for postgres driver (#7040) (fde9f07)
  • 🔧 introduced a new configuration option "formatOptions.castParameters" to delegate the prepare/hydrate parameters to the driver which will result in casting the parameters to their respective column type (#7483) (7793b3f)
  • output Javascript Migrations instead of TypeScript (#7294) (b97cc4f)

• v0.2.31 Changes

  February 08, 2021

  🐛 Bug Fixes

  • append condition to STI child entity join (#7339) (68bb82e)
  • avoid regex lookbehind for compatibility (#7270) (063d27f), closes #7026
  • 👍 cache from ENV - add ioredis support (#7332) (5e2117c)
  • datetime2 rounding in mssql (#7264) (4711a71), closes #3202
  • ⚡️ escape columns in InsertQueryBuilder.orUpdate (#6316) (ab56e07)
  • incorrect postgres uuid type in PrimaryGeneratedColumnType (#7298) (2758502)
  • MariaDB VIRTUAL + [NOT NULL|NULL] error (#7022) (82f2b75), closes #2691
  • reject nullable primary key columns (#7001) (cdace6e)
  • resolve issue with find with relations returns soft-deleted entities (#7296) (d7cb338), closes #6265
  • 💾 save does not return id, save does not return generated (#7336) (01a6aee)

  🔋 Features

  • enable explicitly inserting IDENTITY values into mssql (#6199) (4abbd46), closes #2199
  • export all errors (#7006) (56300d8)
  • option to disable foreign keys creation (#7277) (cb17b95), closes #3120 #3120
  • 👌 support maxdecimaldigits option by geometry type (#7166) (d749008)
  • 👉 useUTC connection option for oracle and postgres (#7295) (e06a442)

  💥 BREAKING CHANGES

  • passing ColumnOptions to @PrimaryColumn does not function anymore. One must use PrimaryColumnOptions instead.
  • minor breaking change on "conflict*" options - column names used are now automatically escaped.

• v0.2.30 Changes

  January 12, 2021

  🐛 Bug Fixes

  • ➕ add missing "comment" field to QB clone method (#7205) (f019771), closes #7203
  • 🚀 avoid early release of PostgresQueryRunner (#7109) (#7185) (9abe007)
  • Error when sorting by an embedded entity while using join and skip/take (#7082) (d27dd2a), closes #7079
  • 🛠 Fix CLI query command TypeError (#7043) (b35397e)
  • get length attribute of postgres array columns (#7239) (eb82f78), closes #6990
  • 🖐 handle overlapping property / database names in querybuilder (#7042) (b518fa1), closes #7030
  • 👌 improve stack traces when using persist executor (#7218) (0dfe5b8)
  • order should allow only model fields, not methods (#7188) (0194193), closes #7178
  • ⚡️ resolve migration for UpdateDateColumn without ON UPDATE clause (#7057) (ddd8cbc), closes #6995
  • resolves Postgres sequence identifier length error (#7115) (568ef35), closes #7106
  • return 'null' (instead of 'undefined') on lazy relations that have no results (#7146) (#7147) (9b278c9)
  • 👌 support MongoDB DNS seed list connection (#7136) (f730bb9), closes #3347 #3133
  • data-api: Fixed how data api driver uses and reuses a client (#6869) (6ce65fb)
  • 0️⃣ use default import of yargs for --help (#6986) (6ef8ffe)

  🔋 Features

  • ➕ add NOWAIT and SKIP LOCKED lock support for MySQL (#7236) (9407507), closes #6530
  • closure table custom naming (#7120) (bcd998b)
  • JavaScript file migrations output (#7253) (ce9cb87)
  • relations: Orphaned row action (#7105) (efc2837)

• v0.2.29 Changes

  November 02, 2020

  🐛 Bug Fixes

  • 👍 allow falsey discriminator values (#6973) (f3ba242), closes #3891
  • 👍 allow for complex jsonb primary key columns (#6834) (f95e9d8), closes #6833
  • 👍 Allows valid non-object JSON to be retrieved in simple-json columns (#6574) (0aedf43), closes #5501
  • 📇 Cannot read property 'hasMetadata' of undefined (#5659) (0280cdc), closes #3685
  • check if the connection is closed before executing a query. This prevents SQLITE_MISUSE errors (https://sqlite.org/rescode.html#misuse) originating from sqlite itself (#6975) (5f6bbec)
  • check mysql constraint schema on join (#6851) (d2b914d), closes #6169 #6169
  • correct reading of custom ormconfig.env files (#6922) (a09fb7f)
  • explicitly define query command's param (#6899) (4475d80), closes #6896
  • findRoots should get the defined primary key column (#6982) (f2ba901), closes #6948 #6948
  • 🛠 Fix Mongodb delete by ObjectId. Closes #6552 (#6553) (e37eb1e)
  • 🛠 fixes the typescript errors in EntityCreateCommand & SubscriberCreateCommand (#6824) (0221a93)
  • 🖐 handle count multiple PK & edge cases more gracefully (#6870) (4abfb34), closes #5989 #5314 #4550
  • 🖐 Handle undefined querysets in QueryCommand (#6910) (6f285dc), closes #6612
  • 🖐 handle Undefined values in driver URL options (#6925) (6fa2df5)
  • ILike operator generally available for any driver (#6945) (37f0d8f)
  • Only check for discriminator conflicts on STI entities (#2985) (06903d1), closes #2984
  • postgresql connection URL can use an UNIX Socket (#2614) (#6042) (21c4166)
  • prevent create-type commands edge-case TypeErrors (#6836) (08ec0a8), closes #6831
  • 0️⃣ redundant migration with decimal default (#6879) (6ff67f7), closes #6140 #5407
  • ✂ remove @DiscriminatorValue from error message (#5256) (2bf15ca), closes #5255
  • resolves issue proto-less object validation (#6884) (e08d9c6), closes #2065
  • return null for nullable RelationId() column (#6848) (7147a0d), closes #6815
  • subscribers should use the subscribersDir (5ef9450)
  • 👌 support changing comments in MySQL columns (#6903) (c5143aa)
  • 👌 support combination of many-to-one/cacade/composte PK (#6417) (9a0497b)
  • 👌 support empty IN clause across all dialects (#6887) (9635080), closes #4865 #2195
  • 👌 support multiple row insert on oracle (#6927) (a5eb946), closes #2434
  • 🔀 sync the typeorm-model-shim (#6891) (c72e48b), closes #6288 #5920
  • 👍 TreeRepository based entities primary column supports custom name. (#6942) (7ec1b75)
  • 👉 use require in ReactNativeDriver (#6814) (1a6383c), closes #6811
  • 👉 use correct type for MongoQueryRunner.databaseConnection (#6906) (da70b40), closes #6453
  • 👉 use pg ⁸ in init command (6ed9906)
  • wrong FK loaded in multi-database environment (#6828) (c060f95), closes #6168

  🔋 Features

  • ➕ add ability for escaping for Raw() find operator (#6850) (91b85bf)
  • ➕ add absolute path support to other CLI commands (#6807) (d9a76e9)
  • ➕ Add SelectQueryBuilder.getOneOrFail() (#6885) (920e781), closes #6246
  • backport ilike from next (#6862) (c8bf81e)
  • Exit with code 1 on empty migration:generate (#6978) (8244ea1)
  • 🔀 schema synchronization for partitioned tables with PostgreSQL 12+ (#6780) (990442e)
  • 👌 support autoEncryption option for MongoDB (#6865) (b22c27f)
  • 👌 Support column comments in Postgres and CockroachDB (#6902) (bc623a4), closes #3360
  • 👌 support ESM in ormconfig js & ts (#6853) (7ebca2b), closes #5003
  • 👌 support query comments in the query builder (#6892) (84c18a9), closes #3643
  • transactional events in subscriber interface + "transaction" option in FindOptions (#6996) (0e4b239)

  🐎 Performance Improvements

  • 👌 Improve MySQL LoadTables Performance (#6886) (0f0e0b6), closes #6800
  • 👌 Improve replacePropertyNames (#4760) (d86671c)

• 1
• 2
• 3
• 4
• 5
• Next ›
• Last »