The findOne function in TypeORM before 0.3.0 can either be supplied with a string or a FindOneOptions object. When input to the function is a user-controlled parsed JSON object, supplying a crafted FindOneOptions instead of an id string leads to SQL injection. NOTE: the vendor's position is that the user's application is responsible for input validation.
Release Notes
typeorm/typeorm (typeorm)
### [`v0.3.0`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#030-2022-03-17)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.45...0.3.0)
Changes in the version includes changes from the `next` branch and `typeorm@next` version.
They were pending their migration from 2018. Finally, they are in the master branch and master version.
##### Features
- compilation `target` now is `es2020`. This requires Node.JS version `14+`
- TypeORM now properly works when installed within different node_modules contexts
(often happen if TypeORM is a dependency of another library or TypeORM is heavily used in monorepo projects)
- `Connection` was renamed to `DataSource`.
Old `Connection` is still there, but now it's deprecated. It will be completely removed in next version.
New API:
```ts
export const dataSource = new DataSource({
// ... options ...
})
// load entities, establish db connection, sync schema, etc.
await dataSource.connect()
```
Previously, you could use `new Connection()`, `createConnection()`, `getConnectionManager().create()`, etc.
They all deprecated in favour of new syntax you can see above.
New way gives you more flexibility and simplicity in usage.
- new custom repositories syntax:
```ts
export const UserRepository = myDataSource.getRepository(UserEntity).extend({
findUsersWithPhotos() {
return this.find({
relations: {
photos: true
}
})
}
})
```
Old ways of custom repository creation were dropped.
- added new option on relation load strategy called `relationLoadStrategy`.
Relation load strategy is used on entity load and determines how relations must be loaded when you query entities and their relations from the database.
Used on `find*` methods and `QueryBuilder`. Value can be set to `join` or `query`.
- `join` - loads relations using SQL `JOIN` expression
- `query` - executes separate SQL queries for each relation
Default is `join`, but default can be set in `ConnectionOptions`:
```ts
createConnection({
/* ... */
relationLoadStrategy: "query"
})
```
Also, it can be set per-query in `find*` methods:
```ts
userRepository.find({
relations: {
photos: true
}
})
```
And QueryBuilder:
```ts
userRepository
.createQueryBuilder()
.setRelationLoadStrategy("query")
```
For queries returning big amount of data, we recommend to use `query` strategy,
because it can be a more performant approach to query relations.
- added new `findOneBy`, `findOneByOrFail`, `findBy`, `countBy`, `findAndCountBy` methods to `BaseEntity`, `EntityManager` and `Repository`:
```ts
const users = await userRepository.findBy({
name: "Michael"
})
```
Overall `find*` and `count*` method signatures where changed, read the "breaking changes" section for more info.
- new `select` type signature in `FindOptions` (used in `find*` methods):
```ts
userRepository.find({
select: {
id: true,
firstName: true,
lastName: true,
}
})
```
Also, now it's possible to specify select columns of the loaded relations:
```ts
userRepository.find({
select: {
id: true,
firstName: true,
lastName: true,
photo: {
id: true,
filename: true,
album: {
id: true,
name: true,
}
}
}
})
```
- new `relations` type signature in `FindOptions` (used in `find*` methods):
```ts
userRepository.find({
relations: {
contacts: true,
photos: true,
}
})
```
To load nested relations use a following signature:
```ts
userRepository.find({
relations: {
contacts: true,
photos: {
album: true,
},
}
})
```
- new `order` type signature in `FindOptions` (used in `find*` methods):
```ts
userRepository.find({
order: {
id: "ASC"
}
})
```
Now supports nested order by-s:
```ts
userRepository.find({
order: {
photos: {
album: {
name: "ASC"
},
},
}
})
```
- new `where` type signature in `FindOptions` (used in `find*` methods) now allows to build nested statements with conditional relations, for example:
```ts
userRepository.find({
where: {
photos: {
album: {
name: "profile"
}
}
}
})
```
Gives you users who have photos in their "profile" album.
- `FindOperator`-s can be applied for relations in `where` statement, for example:
```ts
userRepository.find({
where: {
photos: MoreThan(10),
}
})
```
Gives you users with more than 10 photos.
- `boolean` can be applied for relations in `where` statement, for example:
```ts
userRepository.find({
where: {
photos: true
}
})
```
##### BREAKING CHANGES
- minimal Node.JS version requirement now is `14+`
- drop `ormconfig` support. `ormconfig` still works if you use deprecated methods,
however we do not recommend using it anymore, because it's support will be completely dropped in `0.4.0`.
If you want to have your connection options defined in a separate file, you can still do it like this:
```ts
import ormconfig from "./ormconfig.json"
const MyDataSource = new DataSource(require("./ormconfig.json"))
```
Or even more type-safe approach with `resolveJsonModule` in `tsconfig.json` enabled:
```ts
import ormconfig from "./ormconfig.json"
const MyDataSource = new DataSource(ormconfig)
```
But we do not recommend use this practice, because from `0.4.0` you'll only be able to specify entities / subscribers / migrations using direct references to entity classes / schemas (see "deprecations" section).
We won't be supporting all `ormconfig` extensions (e.g. `json`, `js`, `ts`, `yaml`, `xml`, `env`).
- support for previously deprecated `migrations:*` commands was removed. Use `migration:*` commands instead.
- all commands were re-worked. Please refer to new CLI documentation.
- `cli` option from `BaseConnectionOptions` (now `BaseDataSourceOptions` options) was removed (since CLI commands were re-worked).
- now migrations are running before schema synchronization if you have both pending migrations and schema synchronization pending
(it works if you have both `migrationsRun` and `synchronize` enabled in connection options).
- `aurora-data-api` driver now is called `aurora-mysql`
- `aurora-data-api-pg` driver now is called `aurora-postgres`
- `EntityManager.connection` is now `EntityManager.dataSource`
- `Repository` now has a constructor (breaks classes extending Repository with custom constructor)
- `@TransactionRepository`, `@TransactionManager`, `@Transaction` decorators were completely removed. These decorators do the things out of the TypeORM scope.
- Only junction table names shortened.
**MOTIVATION:** We must shorten only table names generated by TypeORM.
It's user responsibility to name tables short if their RDBMS limit table name length
since it won't make sense to have table names as random hashes.
It's really better if user specify custom table name into `@Entity` decorator.
Also, for junction table it's possible to set a custom name using `@JoinTable` decorator.
- `findOne()` signature without parameters was dropped.
If you need a single row from the db you can use a following syntax:
```ts
const [user] = await userRepository.find()
```
This change was made to prevent user confusion.
See [this issue](https://togithub.com/typeorm/typeorm/issues/2500) for details.
- `findOne(id)` signature was dropped. Use following syntax instead:
```ts
const user = await userRepository.findOneBy({
id: id // where id is your column name
})
```
This change was made to provide a more type-safe approach for data querying.
Due to this change you might need to refactor the way you load entities using MongoDB driver.
- `findOne`, `findOneOrFail`, `find`, `count`, `findAndCount` methods now only accept `FindOptions` as parameter, e.g.:
```ts
const users = await userRepository.find({
where: { /* conditions */ },
relations: { /* relations */ }
})
```
To supply `where` conditions directly without `FindOptions` new methods were added:
`findOneBy`, `findOneByOrFail`, `findBy`, `countBy`, `findAndCountBy`. Example:
```ts
const users = await userRepository.findBy({
name: "Michael"
})
```
This change was required to simply current `find*` and `count*` methods typings,
improve type safety and prevent user confusion.
- `findByIds` was deprecated, use `findBy` method instead in conjunction with `In` operator, for example:
```ts
userRepository.findBy({
id: In([1, 2, 3])
})
```
This change was made to provide a more type-safe approach for data querying.
- `findOne` and `QueryBuilder.getOne()` now return `null` instead of `undefined` in the case if it didn't find anything in the database.
Logically it makes more sense to return `null`.
- `findOne` now limits returning rows to 1 at database level.
**NOTE:** `FOR UPDATE` locking does not work with `findOne` in Oracle since `FOR UPDATE` cannot be used with `FETCH NEXT` in a single query.
- `where` in `FindOptions` (e.g. `find({ where: { ... })`) is more sensitive to input criteria now.
- `FindConditions` (`where` in `FindOptions`) was renamed to `FindOptionsWhere`.
- `null` as value in `where` used in `find*` methods is not supported anymore.
Now you must explicitly use `IsNull()` operator.
Before:
```ts
userRepository.find({
where: {
photo: null
}
})
```
After:
```ts
userRepository.find({
where: {
photo: IsNull()
}
})
```
This change was made to make it more transparent on how to add "IS NULL" statement to final SQL,
because before it bring too much confusion for ORM users.
- if you had entity properties of a non-primitive type (except Buffer) defined as columns,
then you won't be able to use it in `find*`'s `where`. Example:
Before for the `@Column(/*...*/) membership: MembershipKind` you could have a query like:
```ts
userRepository.find({
membership: new MembershipKind("premium")
})
```
now, you need to wrap this value into `Equal` operator:
```ts
userRepository.find({
membership: Equal(new MembershipKind("premium"))
})
```
This change is due to type-safety improvement new `where` signature brings.
- `order` in `FindOptions` (used in `find*` methods) doesn't support ordering by relations anymore.
Define relation columns, and order by them instead.
- `where` in `FindOptions` (used in `find*` methods) previously supported `ObjectLiteral` and `string` types.
Now both signatures were removed. ObjectLiteral was removed because it seriously breaks the type safety,
and `string` doesn't make sense in the context of `FindOptions`. Use `QueryBuilder` instead.
- `MongoRepository` and `MongoEntityManager` now use new types called `MongoFindManyOptions` and `MongoFindOneOptions`
for their `find*` methods.
- `primary relation` (e.g. `@ManyToOne(() => User, { primary: true }) user: User`) support is removed.
You still have an ability to use foreign keys as your primary keys,
however now you must explicitly define a column marked as primary.
Example, before:
```ts
@ManyToOne(() => User, { primary: true })
user: User
```
Now:
```ts
@PrimaryColumn()
userId: number
@ManyToOne(() => User)
user: User
```
Primary column name must match the relation name + join column name on related entity.
If related entity has multiple primary keys, and you want to point to multiple primary keys,
you can define multiple primary columns the same way:
```ts
@PrimaryColumn()
userFirstName: string
@PrimaryColumn()
userLastName: string
@ManyToOne(() => User)
user: User
```
This change was required to simplify ORM internals and introduce new features.
- prefix relation id columns contained in embedded entities ([#7432](https://togithub.com/typeorm/typeorm/pull/7432))
- find by Date object in sqlite driver ([#7538](https://togithub.com/typeorm/typeorm/pull/7538))
- issue with non-reliable `new Date(ISOString)` parsing ([#7796](https://togithub.com/typeorm/typeorm/pull/7796))
##### DEPRECATIONS
- all CLI commands do not support `ormconfig` anymore. You must specify a file with data source instance instead.
- `entities`, `migrations`, `subscribers` options inside `DataSourceOptions` accepting `string` directories support is deprecated.
You'll be only able to pass entity references in the future versions.
- all container-related features (`UseContainerOptions`, `ContainedType`, `ContainerInterface`, `defaultContainer`,
`useContainer`, `getFromContainer`) are deprecated.
- EntityManager's `getCustomRepository` used within transactions is deprecated. Use `withRepository` method instead.
- `Connection.isConnected` is deprecated. Use `.isInitialized` instead.
- `select` in `FindOptions` (used in `find*` methods) used as an array of property names is deprecated.
Now you should use a new object-literal notation. Example:
Deprecated way of loading entity relations:
```ts
userRepository.find({
select: ["id", "firstName", "lastName"]
})
```
New way of loading entity relations:
```ts
userRepository.find({
select: {
id: true,
firstName: true,
lastName: true,
}
})
```
This change is due to type-safety improvement new `select` signature brings.
- `relations` in `FindOptions` (used in `find*` methods) used as an array of relation names is deprecated.
Now you should use a new object-literal notation. Example:
Deprecated way of loading entity relations:
```ts
userRepository.find({
relations: ["contacts", "photos", "photos.album"]
})
```
New way of loading entity relations:
```ts
userRepository.find({
relations: {
contacts: true,
photos: {
album: true
}
}
})
```
This change is due to type-safety improvement new `relations` signature brings.
- `join` in `FindOptions` (used in `find*` methods) is deprecated. Use `QueryBuilder` to build queries containing manual joins.
- `Connection`, `ConnectionOptions` are deprecated, new names to use are: `DataSource` and `DataSourceOptions`.
To create the same connection you had before use a new syntax: `new DataSource({ /*...*/ })`.
- `createConnection()`, `createConnections()` are deprecated, since `Connection` is called `DataSource` now, to create a connection and connect to the database
simply do:
```ts
const myDataSource = new DataSource({ /*...*/ })
await myDataSource.connect()
```
- `getConnection()` is deprecated. To have a globally accessible connection, simply export your data source and use it in places you need it:
```ts
export const myDataSource = new DataSource({ /*...*/ })
// now you can use myDataSource anywhere in your application
```
- `getManager()`, `getMongoManager()`, `getSqljsManager()`, `getRepository()`, `getTreeRepository()`, `getMongoRepository()`, `createQueryBuilder()`
are all deprecated now. Use globally accessible data source instead:
```ts
export const myDataSource = new DataSource({ /*...*/ })
export const Manager = myDataSource.manager
export const UserRepository = myDataSource.getRepository(UserEntity)
export const PhotoRepository = myDataSource.getRepository(PhotoEntity)
// ...
```
- `getConnectionManager()` and `ConnectionManager` itself are deprecated - now `Connection` is called `DataSource`,
and each data source can be defined in exported variable. If you want to have a collection
of data sources, just define them in a variable, simply as:
```ts
const dataSource1 = new DataSource({ /*...*/ })
const dataSource2 = new DataSource({ /*...*/ })
const dataSource3 = new DataSource({ /*...*/ })
export const MyDataSources = {
dataSource1,
dataSource2,
dataSource3,
}
```
- `getConnectionOptions()` is deprecated - in next version we are going to implement different mechanism of connection options loading
- `AbstractRepository` is deprecated. Use new way of custom repositories creation.
- `Connection.name` and `BaseConnectionOptions.name` are deprecated. Connections don't need names anymore since we are going to drop all related methods relying on this property.
- all deprecated signatures will be removed in `0.4.0`
##### EXPERIMENTAL FEATURES NOT PORTED FROM NEXT BRANCH
- `observers` - we will consider returning them back with new API in future versions
- `alternative find operators` - using `$any`, `$in`, `$like` and other operators in `where` condition.
### [`v0.2.45`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0245-2022-03-04)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.44...0.2.45)
##### Bug Fixes
- allow clearing database inside a transaction ([#8712](https://togithub.com/typeorm/typeorm/issues/8712)) ([f3cfdd2](https://togithub.com/typeorm/typeorm/commit/f3cfdd264105ba8cf1c92832b4b95e5a3ca0ed09)), closes [#8527](https://togithub.com/typeorm/typeorm/issues/8527)
- discard duplicated columns on update ([#8724](https://togithub.com/typeorm/typeorm/issues/8724)) ([0fc093d](https://togithub.com/typeorm/typeorm/commit/0fc093d168b54a0fd99bb411a730aad9be1858ac)), closes [#8723](https://togithub.com/typeorm/typeorm/issues/8723)
- fix entityManager.getId for custom join table ([#8676](https://togithub.com/typeorm/typeorm/issues/8676)) ([33b2bd7](https://togithub.com/typeorm/typeorm/commit/33b2bd7acc55d6eb30bfe0681748d6b6abaff0b5)), closes [#7736](https://togithub.com/typeorm/typeorm/issues/7736)
- force web bundlers to ignore index.mjs and use the browser ESM version directly ([#8710](https://togithub.com/typeorm/typeorm/issues/8710)) ([411fa54](https://togithub.com/typeorm/typeorm/commit/411fa54368c8940e94b1cbf7ab64b8d5377f9406)), closes [#8709](https://togithub.com/typeorm/typeorm/issues/8709)
##### Features
- add nested transaction ([#8541](https://togithub.com/typeorm/typeorm/issues/8541)) ([6523526](https://togithub.com/typeorm/typeorm/commit/6523526003bab74a0df8f7d578790c1728b26057)), closes [#1505](https://togithub.com/typeorm/typeorm/issues/1505)
- add transformer to ViewColumnOptions ([#8717](https://togithub.com/typeorm/typeorm/issues/8717)) ([96ac8f7](https://togithub.com/typeorm/typeorm/commit/96ac8f7eece06ae0a8b52ae7da740c92c0c0d4b9))
### [`v0.2.44`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0244-2022-02-23)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.43...0.2.44)
##### Bug Fixes
- alter relation loader to use transforms when present ([#8691](https://togithub.com/typeorm/typeorm/issues/8691)) ([2c2fb29](https://togithub.com/typeorm/typeorm/commit/2c2fb29a67bfd0ca7dd9133a2f85f5b4db5fb195)), closes [#8690](https://togithub.com/typeorm/typeorm/issues/8690)
- cannot read properties of undefined (reading 'joinEagerRelations') ([136015b](https://togithub.com/typeorm/typeorm/commit/136015b04ee72b0ca2439fbff53b1467c12c24b6))
- expo driver doesn't work properly because of new beforeMigration() afterMigration() callbacks ([#8683](https://togithub.com/typeorm/typeorm/issues/8683)) ([5a71803](https://togithub.com/typeorm/typeorm/commit/5a7180378e34ab58ad40c504ebc5195e2413c5f4))
- ng webpack default import ([#8688](https://togithub.com/typeorm/typeorm/issues/8688)) ([2d3374b](https://togithub.com/typeorm/typeorm/commit/2d3374b3b4cb8163764c035bd687b2c81787f338)), closes [#8674](https://togithub.com/typeorm/typeorm/issues/8674)
- support imports of absolute paths of ESM files on Windows ([#8669](https://togithub.com/typeorm/typeorm/issues/8669)) ([12cbfcd](https://togithub.com/typeorm/typeorm/commit/12cbfcde7bc4f56069ed3298064bb91ad0816bf0)), closes [#8651](https://togithub.com/typeorm/typeorm/issues/8651)
##### Features
- add option to upsert to skip update if the row already exists and no values would be changed ([#8679](https://togithub.com/typeorm/typeorm/issues/8679)) ([8744395](https://togithub.com/typeorm/typeorm/commit/87443954b59768ab77fb15097ea9d88822b4a733))
- allow `{delete,insert}().returning()` on MariaDB ([#8673](https://togithub.com/typeorm/typeorm/issues/8673)) ([7facbab](https://togithub.com/typeorm/typeorm/commit/7facbabd2663098156a53983ea38433ed39082d2)), closes [#7235](https://togithub.com/typeorm/typeorm/issues/7235) [#7235](https://togithub.com/typeorm/typeorm/issues/7235)
- Implement deferrable foreign keys for SAP HANA ([#6104](https://togithub.com/typeorm/typeorm/issues/6104)) ([1f54c70](https://togithub.com/typeorm/typeorm/commit/1f54c70b76de34d4420904b72137df746ea9aaed))
### [`v0.2.43`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0243-2022-02-17)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.42...0.2.43)
##### Bug Fixes
- support `require` to internal files without explicitly writing `.js` in the path ([#8660](https://togithub.com/typeorm/typeorm/issues/8660)) ([96aed8a](https://togithub.com/typeorm/typeorm/commit/96aed8aae06df0ae555aa51ed9f1a5ffec141e61)), closes [#8656](https://togithub.com/typeorm/typeorm/issues/8656)
##### Features
- embedded entities with entity schema ([#8626](https://togithub.com/typeorm/typeorm/issues/8626)) ([7dbe956](https://togithub.com/typeorm/typeorm/commit/7dbe956c56da3a430ae6f0e99730e9449deae889)), closes [#3632](https://togithub.com/typeorm/typeorm/issues/3632)
##### Reverts
- Revert "feat: soft delete recursive cascade ([#8436](https://togithub.com/typeorm/typeorm/issues/8436))" ([#8654](https://togithub.com/typeorm/typeorm/issues/8654)) ([6b0b15b](https://togithub.com/typeorm/typeorm/commit/6b0b15b0e68584ed7cd81a658d8606cfdb96817c)), closes [#8436](https://togithub.com/typeorm/typeorm/issues/8436) [#8654](https://togithub.com/typeorm/typeorm/issues/8654)
### [`v0.2.42`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0242-2022-02-16)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.41...0.2.42)
##### Bug Fixes
- proper column comment mapping from database to metadata in aurora-data-api ([baa5880](https://togithub.com/typeorm/typeorm/commit/baa5880001064333eb4eb01765b1d79e17cf1fb5))
- add referencedSchema to PostgresQueryRunner ([#8566](https://togithub.com/typeorm/typeorm/issues/8566)) ([c490319](https://togithub.com/typeorm/typeorm/commit/c49031929aca8f3b932c6593b75447256085bfef))
- adding/removing [@Generated](https://togithub.com/Generated)() will now generate a migration to add/remove the DEFAULT value ([#8274](https://togithub.com/typeorm/typeorm/issues/8274)) ([4208393](https://togithub.com/typeorm/typeorm/commit/42083936e2b65f0d1bd8e23d12689a7f49e2da2f)), closes [#5898](https://togithub.com/typeorm/typeorm/issues/5898)
- adds entity-schema support for createForeignKeyConstraints ([#8606](https://togithub.com/typeorm/typeorm/issues/8606)) ([f224f24](https://togithub.com/typeorm/typeorm/commit/f224f24e5247d3c42385bfc03c89f518aa932310)), closes [#8489](https://togithub.com/typeorm/typeorm/issues/8489)
- allow special keyword as column name for simple-enum type on sqlite ([#8645](https://togithub.com/typeorm/typeorm/issues/8645)) ([93bf96e](https://togithub.com/typeorm/typeorm/commit/93bf96ea635823c7933ea8ef7326be62ccdd6ea7))
- correctly handle multiple-row insert for SAP HANA driver ([#7957](https://togithub.com/typeorm/typeorm/issues/7957)) ([8f2ae71](https://togithub.com/typeorm/typeorm/commit/8f2ae71201e7738fe3c1efd5bbc4584dfe62dcc0))
- disable SQLite FK checks in synchronize / migrations ([#7922](https://togithub.com/typeorm/typeorm/issues/7922)) ([f24822e](https://togithub.com/typeorm/typeorm/commit/f24822ef9cb3051fbe9f3fd5d9e669788852c5a5))
- find descendants of a non-existing tree parent ([#8557](https://togithub.com/typeorm/typeorm/issues/8557)) ([cbb61eb](https://togithub.com/typeorm/typeorm/commit/cbb61eb08139204479110c88d7d1849a24080d11)), closes [#8556](https://togithub.com/typeorm/typeorm/issues/8556)
- For MS SQL Server use lowercase "sys"."columns" reference. ([#8400](https://togithub.com/typeorm/typeorm/issues/8400)) ([#8401](https://togithub.com/typeorm/typeorm/issues/8401)) ([e8a0f92](https://togithub.com/typeorm/typeorm/commit/e8a0f921b4baa7aa7e55ac1fd34c449dfa1e3229))
- improve DeepPartial type ([#8187](https://togithub.com/typeorm/typeorm/issues/8187)) ([b93416d](https://togithub.com/typeorm/typeorm/commit/b93416d7bc25006b34a90c14c497cc7e6e57e28c))
- Lock peer dependencies versions ([#8597](https://togithub.com/typeorm/typeorm/issues/8597)) ([600bd4e](https://togithub.com/typeorm/typeorm/commit/600bd4e5da74b012409d1fdf411a0a0b5265466b))
- make EntityMetadataValidator comply with entitySkipConstructor, cover with test ([#8445](https://togithub.com/typeorm/typeorm/issues/8445)) ([3d6c5da](https://togithub.com/typeorm/typeorm/commit/3d6c5dae76ad0e0640650058ae58fe0addda2ae6)), closes [#8444](https://togithub.com/typeorm/typeorm/issues/8444)
- materialized path being computed as "undefined1." ([#8526](https://togithub.com/typeorm/typeorm/issues/8526)) ([09f54e0](https://togithub.com/typeorm/typeorm/commit/09f54e0273be4dc836824a38e9c78b50ad21bba6))
- MongoConnectionOptions sslCA type mismatch ([#8628](https://togithub.com/typeorm/typeorm/issues/8628)) ([02400da](https://togithub.com/typeorm/typeorm/commit/02400dab662aceca9a722c4aa0dd74a9fa2cb90d))
- mongodb repository.find filters soft deleted rows ([#8581](https://togithub.com/typeorm/typeorm/issues/8581)) ([f7c1f7d](https://togithub.com/typeorm/typeorm/commit/f7c1f7d7c0481f4ada506e5b811a3219519eadf9)), closes [#7113](https://togithub.com/typeorm/typeorm/issues/7113)
- mongodb@4 compatibility support ([#8412](https://togithub.com/typeorm/typeorm/issues/8412)) ([531013b](https://togithub.com/typeorm/typeorm/commit/531013b2f8dfb8d04b0bfb844dc83a5ba6404569))
- must invoke key pragma before any other interaction if SEE setted ([#8478](https://togithub.com/typeorm/typeorm/issues/8478)) ([546b3ed](https://togithub.com/typeorm/typeorm/commit/546b3ed8886c44fbe3d9e167d1904cb9e5961df7)), closes [#8475](https://togithub.com/typeorm/typeorm/issues/8475)
- nested eager relations in a lazy-loaded entity are not loaded ([#8564](https://togithub.com/typeorm/typeorm/issues/8564)) ([1cfd7b9](https://togithub.com/typeorm/typeorm/commit/1cfd7b98ba27032dd0e9429a245c40cea47900f7))
- QueryFailedError when tree entity with JoinColumn ([#8443](https://togithub.com/typeorm/typeorm/issues/8443)) ([#8447](https://togithub.com/typeorm/typeorm/issues/8447)) ([a11c50d](https://togithub.com/typeorm/typeorm/commit/a11c50d5519bda1410ab9ccf67bfcb12ef109c61))
- relation id and afterAll hook performance fixes ([#8169](https://togithub.com/typeorm/typeorm/issues/8169)) ([31f0b55](https://togithub.com/typeorm/typeorm/commit/31f0b5535aa0cc49ff23610b1924c03432f5461f))
- replaced custom uuid generator with `uuid` library ([#8642](https://togithub.com/typeorm/typeorm/issues/8642)) ([8898a71](https://togithub.com/typeorm/typeorm/commit/8898a7175f481f1c171acefef61dc089bc3f8a8e))
- single table inheritance returns the same discriminator value error for unrelated tables where their parents extend from the same entity ([#8525](https://togithub.com/typeorm/typeorm/issues/8525)) ([6523fcc](https://togithub.com/typeorm/typeorm/commit/6523fccda1147dc697afbba57792e5cb4165fbf2)), closes [#8522](https://togithub.com/typeorm/typeorm/issues/8522)
- updating with only `update: false` columns shouldn't trigger [@UpdateDateColumn](https://togithub.com/UpdateDateColumn) column updation ([2834729](https://togithub.com/typeorm/typeorm/commit/2834729e80577bd30f09c2c0e4c949cde173bba3)), closes [#8394](https://togithub.com/typeorm/typeorm/issues/8394) [#8394](https://togithub.com/typeorm/typeorm/issues/8394) [#8394](https://togithub.com/typeorm/typeorm/issues/8394)
- upsert should find unique index created by one-to-one relation ([#8618](https://togithub.com/typeorm/typeorm/issues/8618)) ([c8c00ba](https://togithub.com/typeorm/typeorm/commit/c8c00baf9351973be5780687418303dd87de2077))
##### Features
- add comment param to FindOptions ([#8545](https://togithub.com/typeorm/typeorm/issues/8545)) ([ece0da0](https://togithub.com/typeorm/typeorm/commit/ece0da027dfce4357764dda4b810598ad64af9d9))
- add custom timestamp option in migration creation ([#8501](https://togithub.com/typeorm/typeorm/issues/8501)) ([4a7f242](https://togithub.com/typeorm/typeorm/commit/4a7f2420f1b498465b2a5913b7d848b3eaafb113)), closes [#8500](https://togithub.com/typeorm/typeorm/issues/8500) [#8500](https://togithub.com/typeorm/typeorm/issues/8500)
- add support for node-redis v4.0.0 and newer ([#8425](https://togithub.com/typeorm/typeorm/issues/8425)) ([0626ed1](https://togithub.com/typeorm/typeorm/commit/0626ed1f0bd75fb8e72a462593f33813d85faee8))
- add support for Postgres 10+ GENERATED ALWAYS AS IDENTITY ([#8371](https://togithub.com/typeorm/typeorm/issues/8371)) ([a0f09de](https://togithub.com/typeorm/typeorm/commit/a0f09de8400ac7c94df33f8213ef0eec79b9239d)), closes [#8370](https://togithub.com/typeorm/typeorm/issues/8370)
- add WITH (lock) clause for MSSQL select with join queries ([#8507](https://togithub.com/typeorm/typeorm/issues/8507)) ([3284808](https://togithub.com/typeorm/typeorm/commit/3284808b63552d81456752187c0d130db76007ed)), closes [#4764](https://togithub.com/typeorm/typeorm/issues/4764)
- adds entity-schema support for withoutRowid ([#8432](https://togithub.com/typeorm/typeorm/issues/8432)) ([bd22dc3](https://togithub.com/typeorm/typeorm/commit/bd22dc3b8175ef82967b8265a2388ce16cc08623)), closes [#8429](https://togithub.com/typeorm/typeorm/issues/8429)
- allow soft-deletion of orphaned relation rows using orphanedRow… ([#8414](https://togithub.com/typeorm/typeorm/issues/8414)) ([cefddd9](https://togithub.com/typeorm/typeorm/commit/cefddd95c550191d6a18cb53c8ea4995d0c219ca))
- custom name for typeorm_metadata table ([#8528](https://togithub.com/typeorm/typeorm/issues/8528)) ([f8154eb](https://togithub.com/typeorm/typeorm/commit/f8154eb4c5089a1a0d2c2073f0ea5d64b3252e08)), closes [#7266](https://togithub.com/typeorm/typeorm/issues/7266)
- deferrable option for Unique constraints (Postgres) ([#8356](https://togithub.com/typeorm/typeorm/issues/8356)) ([e52b26c](https://togithub.com/typeorm/typeorm/commit/e52b26c910047d22aa3ea003b62d11c2bf352249))
- ESM support ([#8536](https://togithub.com/typeorm/typeorm/issues/8536)) ([3a694dd](https://togithub.com/typeorm/typeorm/commit/3a694dd3e99699e7284709c53967a5dfcb1e1806)), closes [#6974](https://togithub.com/typeorm/typeorm/issues/6974) [#6941](https://togithub.com/typeorm/typeorm/issues/6941) [#7516](https://togithub.com/typeorm/typeorm/issues/7516) [#7159](https://togithub.com/typeorm/typeorm/issues/7159)
- query builder negating with "NotBrackets" for complex expressions ([#8476](https://togithub.com/typeorm/typeorm/issues/8476)) ([fe7f328](https://togithub.com/typeorm/typeorm/commit/fe7f328fd5b918cab2e7301d57c62e81d9ff34f3))
- separate update events into update, soft-remove, and recover ([#8403](https://togithub.com/typeorm/typeorm/issues/8403)) ([93383bd](https://togithub.com/typeorm/typeorm/commit/93383bd2ee6dc8c22a5cfc0021334fe199da81dc)), closes [#8398](https://togithub.com/typeorm/typeorm/issues/8398)
- soft delete recursive cascade ([#8436](https://togithub.com/typeorm/typeorm/issues/8436)) ([d0f32b3](https://togithub.com/typeorm/typeorm/commit/d0f32b3a17be9ffe9fbc6112e5731bbac91c3691))
- sqlite attach ([#8396](https://togithub.com/typeorm/typeorm/issues/8396)) ([9e844d9](https://togithub.com/typeorm/typeorm/commit/9e844d9ff72fae72578399e24464cd7912c0fe5e))
##### Reverts
- migration:show command must exist with zero status code (Fixes [#7349](https://togithub.com/typeorm/typeorm/issues/7349)) ([#8185](https://togithub.com/typeorm/typeorm/issues/8185)) ([e0adeee](https://togithub.com/typeorm/typeorm/commit/e0adeee48eeb0d5412aa5c0258f7c12e6b1c38ed))
##### BREAKING CHANGES
- update listeners and subscriber no longer triggered by soft-remove and recover
### [`v0.2.41`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0241-2021-11-18)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.40...0.2.41)
##### Bug Fixes
- add `retryWrites` to `MongoConnectionOptions` ([#8354](https://togithub.com/typeorm/typeorm/issues/8354)) ([c895680](https://togithub.com/typeorm/typeorm/commit/c895680dce35f0550f48d92d7dd1a5fb48ab4135)), closes [#7869](https://togithub.com/typeorm/typeorm/issues/7869)
- create typeorm_metadata table when running migrations ([#4956](https://togithub.com/typeorm/typeorm/issues/4956)) ([b2c8168](https://togithub.com/typeorm/typeorm/commit/b2c8168514b23671080e6d384e381e997fbaa11e))
- db caching won't work with replication enabled ([#7694](https://togithub.com/typeorm/typeorm/issues/7694)) ([2d0abe7](https://togithub.com/typeorm/typeorm/commit/2d0abe7140a0aec40d50c15acd98633483db3e29)), closes [#5919](https://togithub.com/typeorm/typeorm/issues/5919)
- incorrect composite `UNIQUE` constraints detection ([#8364](https://togithub.com/typeorm/typeorm/issues/8364)) ([29cb891](https://togithub.com/typeorm/typeorm/commit/29cb89123aaf705437927a8c6ed23204422b71cc)), closes [#8158](https://togithub.com/typeorm/typeorm/issues/8158)
- Postgres enum generates unnecessary queries on schema sync ([#8268](https://togithub.com/typeorm/typeorm/issues/8268)) ([98d5f39](https://togithub.com/typeorm/typeorm/commit/98d5f39e35b6e5dd77ae2aa60f80f4ac98249379))
- resolve issue delete column null on after update event subscriber ([#8318](https://togithub.com/typeorm/typeorm/issues/8318)) ([8a5e671](https://togithub.com/typeorm/typeorm/commit/8a5e6715e2d32da22c2fa71a14a7cf1fe897a159)), closes [#6327](https://togithub.com/typeorm/typeorm/issues/6327)
##### Features
- export interfaces from schema-builder/options ([#8383](https://togithub.com/typeorm/typeorm/issues/8383)) ([7b8a1e3](https://togithub.com/typeorm/typeorm/commit/7b8a1e38f269ba329a153135e12e1a21274b3a18))
- implement generated columns for postgres 12 driver ([#6469](https://togithub.com/typeorm/typeorm/issues/6469)) ([91080be](https://togithub.com/typeorm/typeorm/commit/91080be0cd35a5ee9467d4b50b6b7fb5421ac800))
- lock modes in cockroachdb ([#8250](https://togithub.com/typeorm/typeorm/issues/8250)) ([d494fcc](https://togithub.com/typeorm/typeorm/commit/d494fccc9c6a2d773bcb411ba746a74539373eff)), closes [#8249](https://togithub.com/typeorm/typeorm/issues/8249)
### [`v0.2.40`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0240-2021-11-11)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.39...0.2.40)
##### Bug Fixes
- BaseEntity finder methods to properly type-check lazy relations conditions ([#5710](https://togithub.com/typeorm/typeorm/issues/5710)) ([0665ff5](https://togithub.com/typeorm/typeorm/commit/0665ff5473d075e442f3a93f665bbe087bdf29de))
##### Features
- add depth limiter optional parameter when loading nested trees using TreeRepository's findTrees() and findDescendantsTree() ([#7926](https://togithub.com/typeorm/typeorm/issues/7926)) ([0c44629](https://togithub.com/typeorm/typeorm/commit/0c44629c83c48c27448e7e3cb39faf26994e6e56)), closes [#3909](https://togithub.com/typeorm/typeorm/issues/3909)
- add upsert methods for the drivers that support onUpdate ([#8104](https://togithub.com/typeorm/typeorm/issues/8104)) ([3f98197](https://togithub.com/typeorm/typeorm/commit/3f981975d4347483937547feaa8fa4f63b81a83c)), closes [#2363](https://togithub.com/typeorm/typeorm/issues/2363)
- Postgres IDENTITY Column support ([#7741](https://togithub.com/typeorm/typeorm/issues/7741)) ([969af95](https://togithub.com/typeorm/typeorm/commit/969af958ba27282b9594140a7e2d58dba1192830))
##### Reverts
- "feat: use char(36) for uuid representation in mysql ([#7853](https://togithub.com/typeorm/typeorm/issues/7853))" ([#8343](https://togithub.com/typeorm/typeorm/issues/8343)) ([1588c58](https://togithub.com/typeorm/typeorm/commit/1588c58539e5121dad6b7120f0b5f83f43f1532f))
- regression in ordering by the relation property ([#8346](https://togithub.com/typeorm/typeorm/issues/8346)) ([#8352](https://togithub.com/typeorm/typeorm/issues/8352)) ([0334d10](https://togithub.com/typeorm/typeorm/commit/0334d104d9ce93c8cb079449ce98ffbdc64219c2)), closes [#3736](https://togithub.com/typeorm/typeorm/issues/3736) [#8118](https://togithub.com/typeorm/typeorm/issues/8118)
### [`v0.2.39`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0239-2021-11-09)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.38...0.2.39)
##### Bug Fixes
- attach FOR NO KEY UPDATE lock to query if required ([#8008](https://togithub.com/typeorm/typeorm/issues/8008)) ([9692930](https://togithub.com/typeorm/typeorm/commit/96929302a4dc27a19e94c5532a3ae76951e52552)), closes [#7717](https://togithub.com/typeorm/typeorm/issues/7717)
- cli should accept absolute paths for --config ([4ad3a61](https://togithub.com/typeorm/typeorm/commit/4ad3a61037ad9ead998665d2857d6e4725d7b718))
- create a different cacheId if present for count query in getManyAndCount ([#8283](https://togithub.com/typeorm/typeorm/issues/8283)) ([9f14e48](https://togithub.com/typeorm/typeorm/commit/9f14e488281fb08d8ea1a95c6cc363e1234fa307)), closes [#4277](https://togithub.com/typeorm/typeorm/issues/4277)
- defaults type cast filtering in Cockroachdb ([#8144](https://togithub.com/typeorm/typeorm/issues/8144)) ([28c183e](https://togithub.com/typeorm/typeorm/commit/28c183e9df562e2eb1e3c93afbd1d4687b1b0846)), closes [#7110](https://togithub.com/typeorm/typeorm/issues/7110) [#7110](https://togithub.com/typeorm/typeorm/issues/7110)
- do not generate migration for unchanged enum column ([#8161](https://togithub.com/typeorm/typeorm/issues/8161)) ([#8164](https://togithub.com/typeorm/typeorm/issues/8164)) ([4638dea](https://togithub.com/typeorm/typeorm/commit/4638dea55d0e9239a62fb3143cd96988bf07bc68))
- NativescriptQueryRunner's query method fails when targeting es2017 ([#8182](https://togithub.com/typeorm/typeorm/issues/8182)) ([8615733](https://togithub.com/typeorm/typeorm/commit/861573377bb33b73232399c21b1b3a5c07b58036))
- OneToManySubjectBuilder bug with multiple primary keys ([#8221](https://togithub.com/typeorm/typeorm/issues/8221)) ([6558295](https://togithub.com/typeorm/typeorm/commit/655829592ee10aaa5d28a96691ada0d5510899ea))
- ordering by joined columns for PostgreSQL ([#3736](https://togithub.com/typeorm/typeorm/issues/3736)) ([#8118](https://togithub.com/typeorm/typeorm/issues/8118)) ([1649882](https://togithub.com/typeorm/typeorm/commit/1649882d335587ac78d2203db3a7ab492a942374))
- support DeleteResult in SQLiteDriver ([#8237](https://togithub.com/typeorm/typeorm/issues/8237)) ([b678807](https://togithub.com/typeorm/typeorm/commit/b6788072c20b5f235df9272625c3d1d7522d27e0))
##### Features
- add `typeorm` command wrapper to package.json in project template ([#8081](https://togithub.com/typeorm/typeorm/issues/8081)) ([19d4a91](https://togithub.com/typeorm/typeorm/commit/19d4a914a5da2c28f1eb4ed1c28a52db7dc809d0))
- add dependency configuraiton for views [#8240](https://togithub.com/typeorm/typeorm/issues/8240) ([#8261](https://togithub.com/typeorm/typeorm/issues/8261)) ([2c861af](https://togithub.com/typeorm/typeorm/commit/2c861afaef839f33b5cf1cc2b3bcf8b6e4a0be4f))
- add relation options to all tree queries ([#8080](https://togithub.com/typeorm/typeorm/issues/8080)) ([e4d4636](https://togithub.com/typeorm/typeorm/commit/e4d46363917db57a9107048b973b6a12be8d61fd)), closes [#8076](https://togithub.com/typeorm/typeorm/issues/8076)
- add the ability to pass the driver into all database types ([#8259](https://togithub.com/typeorm/typeorm/issues/8259)) ([2133ffe](https://togithub.com/typeorm/typeorm/commit/2133ffea9c678841bf3537838777d9a5fec3a00e))
- more informative logging in case of migration failure ([#8307](https://togithub.com/typeorm/typeorm/issues/8307)) ([dc6f1c9](https://togithub.com/typeorm/typeorm/commit/dc6f1c91be29e88466614eb8b8d21a92659cfd0b))
- support using custom index with SelectQueryBuilder in MySQL ([#7755](https://togithub.com/typeorm/typeorm/issues/7755)) ([f79ae58](https://togithub.com/typeorm/typeorm/commit/f79ae589cd1a658fea553cb57abc2a41a46523f8))
##### Reverts
- Revert "fix: STI types on children in joins ([#3160](https://togithub.com/typeorm/typeorm/issues/3160))" ([#8309](https://togithub.com/typeorm/typeorm/issues/8309)) ([0adad88](https://togithub.com/typeorm/typeorm/commit/0adad8810e15b8d00259a2635e1c50e85598e1ed)), closes [#3160](https://togithub.com/typeorm/typeorm/issues/3160) [#8309](https://togithub.com/typeorm/typeorm/issues/8309)
### [`v0.2.38`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0238-2021-10-02)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.37...0.2.38)
##### Bug Fixes
- prevent using absolute table path in migrations unless required ([#8038](https://togithub.com/typeorm/typeorm/issues/8038)) ([e9366b3](https://togithub.com/typeorm/typeorm/commit/e9366b33ddff296de1254019589b85e40aa53e12))
- snakecase conversion for strings with numbers ([#8111](https://togithub.com/typeorm/typeorm/issues/8111)) ([749511d](https://togithub.com/typeorm/typeorm/commit/749511d981f6b9a1a08113b23e8779a91cda78f8))
- use full path for table lookups ([#8097](https://togithub.com/typeorm/typeorm/issues/8097)) ([22676a0](https://togithub.com/typeorm/typeorm/commit/22676a04c30b3b49a61003320dfad3ecad3791e8))
##### Features
- support QueryRunner.stream with Oracle ([#8086](https://togithub.com/typeorm/typeorm/issues/8086)) ([b858f84](https://togithub.com/typeorm/typeorm/commit/b858f84e6fb15f801f2564088428d250d1c59e18))
### [`v0.2.37`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0237-2021-08-13)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.36...0.2.37)
##### Bug Fixes
- allow periods in parameter identifiers ([#8022](https://togithub.com/typeorm/typeorm/issues/8022)) ([4201938](https://togithub.com/typeorm/typeorm/commit/420193892ffe857c532130c0c7b18dcc4c8d38e2))
- ConnectionManager `connections` property should include list of `Connection`s ([#8004](https://togithub.com/typeorm/typeorm/issues/8004)) ([2344db6](https://togithub.com/typeorm/typeorm/commit/2344db60c4314da31885f5686e94bb6dcb203a96))
- entity value for date columns that are related ([#8027](https://togithub.com/typeorm/typeorm/issues/8027)) ([5a3767f](https://togithub.com/typeorm/typeorm/commit/5a3767f58f6ef355b01cf6e92342401a051a369c))
- handle brackets when only one condition is passed ([#8048](https://togithub.com/typeorm/typeorm/issues/8048)) ([ab39066](https://togithub.com/typeorm/typeorm/commit/ab39066f182d357fcc999cd976510c0e2a61d6de))
- handle enums with multiple apostrophes in MySQL ([#8013](https://togithub.com/typeorm/typeorm/issues/8013)) ([37c40a6](https://togithub.com/typeorm/typeorm/commit/37c40a610caecfc3b27b48a87b0e98d715f23395)), closes [#8011](https://togithub.com/typeorm/typeorm/issues/8011)
- include all drivers in driverfactory error message ([#8061](https://togithub.com/typeorm/typeorm/issues/8061)) ([fbd1ef7](https://togithub.com/typeorm/typeorm/commit/fbd1ef74e84b59ef0b8d99e311f0aced902190e6))
- resolve not returning soft deleted relations with withDeleted find option ([#8017](https://togithub.com/typeorm/typeorm/issues/8017)) ([65cbcc7](https://togithub.com/typeorm/typeorm/commit/65cbcc79bceac4cf8d15dec8c558dcbc9a037220))
- SAP HANA inserts used incorrect value for returning query ([#8072](https://togithub.com/typeorm/typeorm/issues/8072)) ([36398db](https://togithub.com/typeorm/typeorm/commit/36398dbe467274a9ac08a013ed4daaf307ee2de2))
- some drivers set the wrong database name when defined from url ([#8058](https://togithub.com/typeorm/typeorm/issues/8058)) ([a3a3284](https://togithub.com/typeorm/typeorm/commit/a3a32849c04a83adbf775fcf07843a934551dbfb))
- throw error when not connected in drivers ([#7995](https://togithub.com/typeorm/typeorm/issues/7995)) ([cd71f62](https://togithub.com/typeorm/typeorm/commit/cd71f62cb8125d1bbd92b341aa2eea1de0ac3537))
##### Features
- add relations option to tree queries ([#7981](https://togithub.com/typeorm/typeorm/issues/7981)) ([ca26297](https://togithub.com/typeorm/typeorm/commit/ca26297484542498b8f622f540ca354360d53ed0)), closes [#7974](https://togithub.com/typeorm/typeorm/issues/7974) [#4564](https://togithub.com/typeorm/typeorm/issues/4564)
- add serviceName option for oracle connections ([#8021](https://togithub.com/typeorm/typeorm/issues/8021)) ([37bd012](https://togithub.com/typeorm/typeorm/commit/37bd0124dc81c957b2a036436594ae8c4606eb6c))
- add support to string array on dropColumns ([#7654](https://togithub.com/typeorm/typeorm/issues/7654)) ([91d5b2f](https://togithub.com/typeorm/typeorm/commit/91d5b2fc374c2f7b1545d40ee76577272de21436))
- support Oracle Implicit Results ([#8050](https://togithub.com/typeorm/typeorm/issues/8050)) ([fe78bee](https://togithub.com/typeorm/typeorm/commit/fe78bee3725efef47d5be6f924b9caf13f3299a7))
### [`v0.2.36`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0236-2021-07-31)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.35...0.2.36)
##### Bug Fixes
- add deprecated `WhereExpression` alias for `WhereExpressionBuilder` ([#7980](https://togithub.com/typeorm/typeorm/issues/7980)) ([76e7ed9](https://togithub.com/typeorm/typeorm/commit/76e7ed943779b940212c4e453d97028b5ffed7d0))
- always generate migrations with template string literals ([#7971](https://togithub.com/typeorm/typeorm/issues/7971)) ([e9c2af6](https://togithub.com/typeorm/typeorm/commit/e9c2af610a1c9a632605b71d67b97e048be2e29e))
- use js rather than ts in all `browser` package manifests ([#7982](https://togithub.com/typeorm/typeorm/issues/7982)) ([0d90bcd](https://togithub.com/typeorm/typeorm/commit/0d90bcdc8c77f2080aa200fe9f4f962b7b01c9ee))
- use nvarchar/ntext during transit for SQLServer queries ([#7933](https://togithub.com/typeorm/typeorm/issues/7933)) ([62d7976](https://togithub.com/typeorm/typeorm/commit/62d79762dbfe58219a5673ba4d404fe9f2e40436))
##### Features
- add postgres connection option `applicationName` ([#7989](https://togithub.com/typeorm/typeorm/issues/7989)) ([d365acc](https://togithub.com/typeorm/typeorm/commit/d365acca68069d0bd9acea5b45a73d7f4c1f4d8f))
### [`v0.2.35`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0235-2021-07-28)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.34...0.2.35)
##### Bug Fixes
- `entity` to be `Partial` | `undefined` in `UpdateEvent` ([#7783](https://togithub.com/typeorm/typeorm/issues/7783)) ([f033045](https://togithub.com/typeorm/typeorm/commit/f033045dd6d1dac4f6f7e528997a2c5f8892d763))
- actually return a working ReadStream from SQL Server query runner ([#7893](https://togithub.com/typeorm/typeorm/issues/7893)) ([e80985f](https://togithub.com/typeorm/typeorm/commit/e80985fabbafcb4f5409d72840c3902e1619b8a6))
- added version check before dropping materialized views to keep backward compatibility ([#7716](https://togithub.com/typeorm/typeorm/issues/7716)) ([29f1f86](https://togithub.com/typeorm/typeorm/commit/29f1f86ae2a2dafd70fd958b1980b9f059f42f7a))
- allow for string id in mongo.findByIds call ([#7838](https://togithub.com/typeorm/typeorm/issues/7838)) ([4b45ae1](https://togithub.com/typeorm/typeorm/commit/4b45ae1e8174cf438f9fca92c635957513bff8f8))
- better support of relation-based properties in where clauses ([#7805](https://togithub.com/typeorm/typeorm/issues/7805)) ([3221c50](https://togithub.com/typeorm/typeorm/commit/3221c50d878505b1b8435b07451ec94cd8d04fce))
- Buffer in primary columns causes bugs with relations ([#7952](https://togithub.com/typeorm/typeorm/issues/7952)) ([37e08a7](https://togithub.com/typeorm/typeorm/commit/37e08a7848a92cd4f98fec8f33f120cee739352f)), closes [#4060](https://togithub.com/typeorm/typeorm/issues/4060)
- capacitor does not correctly set journal mode ([#7873](https://togithub.com/typeorm/typeorm/issues/7873)) ([5f20eb7](https://togithub.com/typeorm/typeorm/commit/5f20eb791a3c51410d6759548ec11c9a919659ff))
- Capacitor driver PRAGMA requests failing on Android ([#7728](https://togithub.com/typeorm/typeorm/issues/7728)) ([9620a26](https://togithub.com/typeorm/typeorm/commit/9620a26c4eeb34baddce3a841ffd686d82cd87af))
- condition is optional in SelectQueryBuilder joins ([#7888](https://togithub.com/typeorm/typeorm/issues/7888)) ([2deaa0e](https://togithub.com/typeorm/typeorm/commit/2deaa0e948d7b797c0e4d3ccbc3c9c2f0f253caf))
- correctly handle mongo replica set driver option ([#7908](https://togithub.com/typeorm/typeorm/issues/7908)) ([9212df4](https://togithub.com/typeorm/typeorm/commit/9212df45e3899370efdf9ec67f1a6418ce4ac838))
- correctly load yml in ConnectionOptionsYmlReader ([#7743](https://togithub.com/typeorm/typeorm/issues/7743)) ([57f9254](https://togithub.com/typeorm/typeorm/commit/57f9254499ef07500f5e59df20e778ee0f27b9aa))
- craft oracle connectString as a descriptor with SID ([#7878](https://togithub.com/typeorm/typeorm/issues/7878)) ([b05d093](https://togithub.com/typeorm/typeorm/commit/b05d0936ddabae179a42c9c0f67779a6bec3d5b1))
- delete operation in MongoDB impact all matched documents ([#7811](https://togithub.com/typeorm/typeorm/issues/7811)) ([0fbae53](https://togithub.com/typeorm/typeorm/commit/0fbae53bdd83f5da94ac8a468e1506c2852eed02)), closes [#7809](https://togithub.com/typeorm/typeorm/issues/7809)
- Do not add NULL/NOT NULL for stored columns ([#7708](https://togithub.com/typeorm/typeorm/issues/7708)) ([3c33e9f](https://togithub.com/typeorm/typeorm/commit/3c33e9f54541a12b0d0fd37177c6afebf7a5349f)), closes [#7698](https://togithub.com/typeorm/typeorm/issues/7698)
- do OBJECT_ID lookup for column constraint instead of name in mssql ([#7916](https://togithub.com/typeorm/typeorm/issues/7916)) ([fa8c1b0](https://togithub.com/typeorm/typeorm/commit/fa8c1b088a9a6a2a1ffaec1b1a681be99cf2db3c))
- drop pool.autostart from mssql options because it's unused ([#7877](https://togithub.com/typeorm/typeorm/issues/7877)) ([0d21a4d](https://togithub.com/typeorm/typeorm/commit/0d21a4d07ec275a295df6f78b85c4814c027258a))
- drop SAP statement after `prepare` per Hana client docs ([#7748](https://togithub.com/typeorm/typeorm/issues/7748)) ([8ca05b1](https://togithub.com/typeorm/typeorm/commit/8ca05b11db3ba083c7395cca09a4aa98c70e3d8f))
- eager relation respects children relations ([#5685](https://togithub.com/typeorm/typeorm/issues/5685)) ([e7e887a](https://togithub.com/typeorm/typeorm/commit/e7e887a582cce66bd21044472f4a5288894650c9))
- enable returning additional columns with MSSQL ([#7864](https://togithub.com/typeorm/typeorm/issues/7864)) ([e1db48d](https://togithub.com/typeorm/typeorm/commit/e1db48d8391728455744c91ea7976a334300f77d))
- entity object undefined in `afterUpdate` subscriber ([#7724](https://togithub.com/typeorm/typeorm/issues/7724)) ([d25304d](https://togithub.com/typeorm/typeorm/commit/d25304d9e319157c6b8999932fb9144a67bd84cf))
- find operation in MongoDB do not include nullable values from documents ([#7820](https://togithub.com/typeorm/typeorm/issues/7820)) ([98c13cf](https://togithub.com/typeorm/typeorm/commit/98c13cf710de83783bc5b5576a64327b26d26262)), closes [#7760](https://togithub.com/typeorm/typeorm/issues/7760)
- fix table loading when schemas are used ([3a106a3](https://togithub.com/typeorm/typeorm/commit/3a106a3cca223dadca58af1244c6dda79c60b43c))
- foreign keys in SAP were loading from the wrong table ([#7914](https://togithub.com/typeorm/typeorm/issues/7914)) ([4777a79](https://togithub.com/typeorm/typeorm/commit/4777a795210c3a93a4171a17dbdce248e25b21da))
- handle postgres default when tableColumn.default is not string ([#7816](https://togithub.com/typeorm/typeorm/issues/7816)) ([0463855](https://togithub.com/typeorm/typeorm/commit/0463855223100028e62f7cb2e84319770f54449e))
- handle snake case of ABcD which should become a_bc_d ([#7883](https://togithub.com/typeorm/typeorm/issues/7883)) ([eb680f9](https://togithub.com/typeorm/typeorm/commit/eb680f99b74c335556d23016264fcf1ea6ce1d6f))
- improve query for MSSQL to fetch foreign keys and tables ([#7935](https://togithub.com/typeorm/typeorm/issues/7935)) ([f6af01a](https://togithub.com/typeorm/typeorm/commit/f6af01ad1b20ce67dc03448f050de3127227758c))
- make `OracleQueryRunner` createDatabase if-not-exists not fail ([f5a80ef](https://togithub.com/typeorm/typeorm/commit/f5a80ef3df82120fee8f68e02f320dacbc856607))
- only pass `data` from SaveOptions during that query ([#7886](https://togithub.com/typeorm/typeorm/issues/7886)) ([1de2e13](https://togithub.com/typeorm/typeorm/commit/1de2e13cfe442af99c2cf017f48127e1de3a08d9))
- oracle cannot support DB in table identifiers ([#7954](https://togithub.com/typeorm/typeorm/issues/7954)) ([8c60d91](https://togithub.com/typeorm/typeorm/commit/8c60d917ef5fbfdc11b7c3ad8e2901eba3f9fa4b))
- pass table to namingstrategy when we can instead of table name ([#7925](https://togithub.com/typeorm/typeorm/issues/7925)) ([140002d](https://togithub.com/typeorm/typeorm/commit/140002d1ebc4837071dab83a7bb164a02a7a2732))
- prevent modification of the FindOptions.relations ([#7887](https://togithub.com/typeorm/typeorm/issues/7887)) ([a2fcad6](https://togithub.com/typeorm/typeorm/commit/a2fcad6ef963c3e444765d6a7b4fa1e0e89a72e6))
- prevent reuse of broken connections in postgres pool ([#7792](https://togithub.com/typeorm/typeorm/issues/7792)) ([5cf368a](https://togithub.com/typeorm/typeorm/commit/5cf368a23fa78b9e97dd12b54616f17b8431ffee))
- prevent transactions in the Cordova driver ([#7771](https://togithub.com/typeorm/typeorm/issues/7771)) ([fc4133c](https://togithub.com/typeorm/typeorm/commit/fc4133cf621874c616bf7643c79112b9f68a1e09))
- properly escape oracle table paths ([#7917](https://togithub.com/typeorm/typeorm/issues/7917)) ([7e8687c](https://togithub.com/typeorm/typeorm/commit/7e8687c45283cdb2caffa53ed5ebab527797c3e8))
- regression when making `join` conditions `undefined`-able ([#7892](https://togithub.com/typeorm/typeorm/issues/7892)) ([b0c1cc6](https://togithub.com/typeorm/typeorm/commit/b0c1cc6d6820e93bc7b986d4f18db4020195e170))
- restored `buildColumnAlias` for backward compatibility ([#7706](https://togithub.com/typeorm/typeorm/issues/7706)) ([36ceefa](https://togithub.com/typeorm/typeorm/commit/36ceefa710c0994e054c8e267a1fb1bdf4b25c39))
- return correct DeleteResult and UpdateResult for mongo ([#7884](https://togithub.com/typeorm/typeorm/issues/7884)) ([7a646a2](https://togithub.com/typeorm/typeorm/commit/7a646a212815e6b9c2dda752442075624f9f552d))
- support fully qualified schema in createSchema ([#7934](https://togithub.com/typeorm/typeorm/issues/7934)) ([94edd12](https://togithub.com/typeorm/typeorm/commit/94edd12ca450d4dbcd2e4902e1009fcd27136490))
- support table names between schemas in oracle ([#7951](https://togithub.com/typeorm/typeorm/issues/7951)) ([aa45b93](https://togithub.com/typeorm/typeorm/commit/aa45b935ff33915a86199307c86aabf904d67e28))
- typing so SelectQueryBuilder.getRawOne may return undefined ([#7863](https://togithub.com/typeorm/typeorm/issues/7863)) ([36e5a0c](https://togithub.com/typeorm/typeorm/commit/36e5a0cf09a25dfe98ffa130f35005a8eacc4155)), closes [#7449](https://togithub.com/typeorm/typeorm/issues/7449)
- typo prevented us from pulling the schema correctly in some cases ([c7f2db8](https://togithub.com/typeorm/typeorm/commit/c7f2db8d6999b990308787681a2767e41ad2bdd6))
- update operation in MongoDB impact all matched documents ([#7803](https://togithub.com/typeorm/typeorm/issues/7803)) ([052014c](https://togithub.com/typeorm/typeorm/commit/052014cdba844b1a7867f46606045a494cffc907)), closes [#7788](https://togithub.com/typeorm/typeorm/issues/7788)
- use correct query for cross-database mssql identity check ([
Configuration
📅 Schedule: Branch creation - "" (UTC), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
[ ] If you want to rebase/retry this PR, check this box
This PR contains the following updates:
^0.2.32->^0.3.0GitHub Vulnerability Alerts
CVE-2022-33171
The findOne function in TypeORM before 0.3.0 can either be supplied with a string or a FindOneOptions object. When input to the function is a user-controlled parsed JSON object, supplying a crafted FindOneOptions instead of an id string leads to SQL injection. NOTE: the vendor's position is that the user's application is responsible for input validation.
Release Notes
typeorm/typeorm (typeorm)
### [`v0.3.0`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#030-2022-03-17) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.45...0.3.0) Changes in the version includes changes from the `next` branch and `typeorm@next` version. They were pending their migration from 2018. Finally, they are in the master branch and master version. ##### Features - compilation `target` now is `es2020`. This requires Node.JS version `14+` - TypeORM now properly works when installed within different node_modules contexts (often happen if TypeORM is a dependency of another library or TypeORM is heavily used in monorepo projects) - `Connection` was renamed to `DataSource`. Old `Connection` is still there, but now it's deprecated. It will be completely removed in next version. New API: ```ts export const dataSource = new DataSource({ // ... options ... }) // load entities, establish db connection, sync schema, etc. await dataSource.connect() ``` Previously, you could use `new Connection()`, `createConnection()`, `getConnectionManager().create()`, etc. They all deprecated in favour of new syntax you can see above. New way gives you more flexibility and simplicity in usage. - new custom repositories syntax: ```ts export const UserRepository = myDataSource.getRepository(UserEntity).extend({ findUsersWithPhotos() { return this.find({ relations: { photos: true } }) } }) ``` Old ways of custom repository creation were dropped. - added new option on relation load strategy called `relationLoadStrategy`. Relation load strategy is used on entity load and determines how relations must be loaded when you query entities and their relations from the database. Used on `find*` methods and `QueryBuilder`. Value can be set to `join` or `query`. - `join` - loads relations using SQL `JOIN` expression - `query` - executes separate SQL queries for each relation Default is `join`, but default can be set in `ConnectionOptions`: ```ts createConnection({ /* ... */ relationLoadStrategy: "query" }) ``` Also, it can be set per-query in `find*` methods: ```ts userRepository.find({ relations: { photos: true } }) ``` And QueryBuilder: ```ts userRepository .createQueryBuilder() .setRelationLoadStrategy("query") ``` For queries returning big amount of data, we recommend to use `query` strategy, because it can be a more performant approach to query relations. - added new `findOneBy`, `findOneByOrFail`, `findBy`, `countBy`, `findAndCountBy` methods to `BaseEntity`, `EntityManager` and `Repository`: ```ts const users = await userRepository.findBy({ name: "Michael" }) ``` Overall `find*` and `count*` method signatures where changed, read the "breaking changes" section for more info. - new `select` type signature in `FindOptions` (used in `find*` methods): ```ts userRepository.find({ select: { id: true, firstName: true, lastName: true, } }) ``` Also, now it's possible to specify select columns of the loaded relations: ```ts userRepository.find({ select: { id: true, firstName: true, lastName: true, photo: { id: true, filename: true, album: { id: true, name: true, } } } }) ``` - new `relations` type signature in `FindOptions` (used in `find*` methods): ```ts userRepository.find({ relations: { contacts: true, photos: true, } }) ``` To load nested relations use a following signature: ```ts userRepository.find({ relations: { contacts: true, photos: { album: true, }, } }) ``` - new `order` type signature in `FindOptions` (used in `find*` methods): ```ts userRepository.find({ order: { id: "ASC" } }) ``` Now supports nested order by-s: ```ts userRepository.find({ order: { photos: { album: { name: "ASC" }, }, } }) ``` - new `where` type signature in `FindOptions` (used in `find*` methods) now allows to build nested statements with conditional relations, for example: ```ts userRepository.find({ where: { photos: { album: { name: "profile" } } } }) ``` Gives you users who have photos in their "profile" album. - `FindOperator`-s can be applied for relations in `where` statement, for example: ```ts userRepository.find({ where: { photos: MoreThan(10), } }) ``` Gives you users with more than 10 photos. - `boolean` can be applied for relations in `where` statement, for example: ```ts userRepository.find({ where: { photos: true } }) ``` ##### BREAKING CHANGES - minimal Node.JS version requirement now is `14+` - drop `ormconfig` support. `ormconfig` still works if you use deprecated methods, however we do not recommend using it anymore, because it's support will be completely dropped in `0.4.0`. If you want to have your connection options defined in a separate file, you can still do it like this: ```ts import ormconfig from "./ormconfig.json" const MyDataSource = new DataSource(require("./ormconfig.json")) ``` Or even more type-safe approach with `resolveJsonModule` in `tsconfig.json` enabled: ```ts import ormconfig from "./ormconfig.json" const MyDataSource = new DataSource(ormconfig) ``` But we do not recommend use this practice, because from `0.4.0` you'll only be able to specify entities / subscribers / migrations using direct references to entity classes / schemas (see "deprecations" section). We won't be supporting all `ormconfig` extensions (e.g. `json`, `js`, `ts`, `yaml`, `xml`, `env`). - support for previously deprecated `migrations:*` commands was removed. Use `migration:*` commands instead. - all commands were re-worked. Please refer to new CLI documentation. - `cli` option from `BaseConnectionOptions` (now `BaseDataSourceOptions` options) was removed (since CLI commands were re-worked). - now migrations are running before schema synchronization if you have both pending migrations and schema synchronization pending (it works if you have both `migrationsRun` and `synchronize` enabled in connection options). - `aurora-data-api` driver now is called `aurora-mysql` - `aurora-data-api-pg` driver now is called `aurora-postgres` - `EntityManager.connection` is now `EntityManager.dataSource` - `Repository` now has a constructor (breaks classes extending Repository with custom constructor) - `@TransactionRepository`, `@TransactionManager`, `@Transaction` decorators were completely removed. These decorators do the things out of the TypeORM scope. - Only junction table names shortened. **MOTIVATION:** We must shorten only table names generated by TypeORM. It's user responsibility to name tables short if their RDBMS limit table name length since it won't make sense to have table names as random hashes. It's really better if user specify custom table name into `@Entity` decorator. Also, for junction table it's possible to set a custom name using `@JoinTable` decorator. - `findOne()` signature without parameters was dropped. If you need a single row from the db you can use a following syntax: ```ts const [user] = await userRepository.find() ``` This change was made to prevent user confusion. See [this issue](https://togithub.com/typeorm/typeorm/issues/2500) for details. - `findOne(id)` signature was dropped. Use following syntax instead: ```ts const user = await userRepository.findOneBy({ id: id // where id is your column name }) ``` This change was made to provide a more type-safe approach for data querying. Due to this change you might need to refactor the way you load entities using MongoDB driver. - `findOne`, `findOneOrFail`, `find`, `count`, `findAndCount` methods now only accept `FindOptions` as parameter, e.g.: ```ts const users = await userRepository.find({ where: { /* conditions */ }, relations: { /* relations */ } }) ``` To supply `where` conditions directly without `FindOptions` new methods were added: `findOneBy`, `findOneByOrFail`, `findBy`, `countBy`, `findAndCountBy`. Example: ```ts const users = await userRepository.findBy({ name: "Michael" }) ``` This change was required to simply current `find*` and `count*` methods typings, improve type safety and prevent user confusion. - `findByIds` was deprecated, use `findBy` method instead in conjunction with `In` operator, for example: ```ts userRepository.findBy({ id: In([1, 2, 3]) }) ``` This change was made to provide a more type-safe approach for data querying. - `findOne` and `QueryBuilder.getOne()` now return `null` instead of `undefined` in the case if it didn't find anything in the database. Logically it makes more sense to return `null`. - `findOne` now limits returning rows to 1 at database level. **NOTE:** `FOR UPDATE` locking does not work with `findOne` in Oracle since `FOR UPDATE` cannot be used with `FETCH NEXT` in a single query. - `where` in `FindOptions` (e.g. `find({ where: { ... })`) is more sensitive to input criteria now. - `FindConditions` (`where` in `FindOptions`) was renamed to `FindOptionsWhere`. - `null` as value in `where` used in `find*` methods is not supported anymore. Now you must explicitly use `IsNull()` operator. Before: ```ts userRepository.find({ where: { photo: null } }) ``` After: ```ts userRepository.find({ where: { photo: IsNull() } }) ``` This change was made to make it more transparent on how to add "IS NULL" statement to final SQL, because before it bring too much confusion for ORM users. - if you had entity properties of a non-primitive type (except Buffer) defined as columns, then you won't be able to use it in `find*`'s `where`. Example: Before for the `@Column(/*...*/) membership: MembershipKind` you could have a query like: ```ts userRepository.find({ membership: new MembershipKind("premium") }) ``` now, you need to wrap this value into `Equal` operator: ```ts userRepository.find({ membership: Equal(new MembershipKind("premium")) }) ``` This change is due to type-safety improvement new `where` signature brings. - `order` in `FindOptions` (used in `find*` methods) doesn't support ordering by relations anymore. Define relation columns, and order by them instead. - `where` in `FindOptions` (used in `find*` methods) previously supported `ObjectLiteral` and `string` types. Now both signatures were removed. ObjectLiteral was removed because it seriously breaks the type safety, and `string` doesn't make sense in the context of `FindOptions`. Use `QueryBuilder` instead. - `MongoRepository` and `MongoEntityManager` now use new types called `MongoFindManyOptions` and `MongoFindOneOptions` for their `find*` methods. - `primary relation` (e.g. `@ManyToOne(() => User, { primary: true }) user: User`) support is removed. You still have an ability to use foreign keys as your primary keys, however now you must explicitly define a column marked as primary. Example, before: ```ts @ManyToOne(() => User, { primary: true }) user: User ``` Now: ```ts @PrimaryColumn() userId: number @ManyToOne(() => User) user: User ``` Primary column name must match the relation name + join column name on related entity. If related entity has multiple primary keys, and you want to point to multiple primary keys, you can define multiple primary columns the same way: ```ts @PrimaryColumn() userFirstName: string @PrimaryColumn() userLastName: string @ManyToOne(() => User) user: User ``` This change was required to simplify ORM internals and introduce new features. - prefix relation id columns contained in embedded entities ([#7432](https://togithub.com/typeorm/typeorm/pull/7432)) - find by Date object in sqlite driver ([#7538](https://togithub.com/typeorm/typeorm/pull/7538)) - issue with non-reliable `new Date(ISOString)` parsing ([#7796](https://togithub.com/typeorm/typeorm/pull/7796)) ##### DEPRECATIONS - all CLI commands do not support `ormconfig` anymore. You must specify a file with data source instance instead. - `entities`, `migrations`, `subscribers` options inside `DataSourceOptions` accepting `string` directories support is deprecated. You'll be only able to pass entity references in the future versions. - all container-related features (`UseContainerOptions`, `ContainedType`, `ContainerInterface`, `defaultContainer`, `useContainer`, `getFromContainer`) are deprecated. - EntityManager's `getCustomRepository` used within transactions is deprecated. Use `withRepository` method instead. - `Connection.isConnected` is deprecated. Use `.isInitialized` instead. - `select` in `FindOptions` (used in `find*` methods) used as an array of property names is deprecated. Now you should use a new object-literal notation. Example: Deprecated way of loading entity relations: ```ts userRepository.find({ select: ["id", "firstName", "lastName"] }) ``` New way of loading entity relations: ```ts userRepository.find({ select: { id: true, firstName: true, lastName: true, } }) ``` This change is due to type-safety improvement new `select` signature brings. - `relations` in `FindOptions` (used in `find*` methods) used as an array of relation names is deprecated. Now you should use a new object-literal notation. Example: Deprecated way of loading entity relations: ```ts userRepository.find({ relations: ["contacts", "photos", "photos.album"] }) ``` New way of loading entity relations: ```ts userRepository.find({ relations: { contacts: true, photos: { album: true } } }) ``` This change is due to type-safety improvement new `relations` signature brings. - `join` in `FindOptions` (used in `find*` methods) is deprecated. Use `QueryBuilder` to build queries containing manual joins. - `Connection`, `ConnectionOptions` are deprecated, new names to use are: `DataSource` and `DataSourceOptions`. To create the same connection you had before use a new syntax: `new DataSource({ /*...*/ })`. - `createConnection()`, `createConnections()` are deprecated, since `Connection` is called `DataSource` now, to create a connection and connect to the database simply do: ```ts const myDataSource = new DataSource({ /*...*/ }) await myDataSource.connect() ``` - `getConnection()` is deprecated. To have a globally accessible connection, simply export your data source and use it in places you need it: ```ts export const myDataSource = new DataSource({ /*...*/ }) // now you can use myDataSource anywhere in your application ``` - `getManager()`, `getMongoManager()`, `getSqljsManager()`, `getRepository()`, `getTreeRepository()`, `getMongoRepository()`, `createQueryBuilder()` are all deprecated now. Use globally accessible data source instead: ```ts export const myDataSource = new DataSource({ /*...*/ }) export const Manager = myDataSource.manager export const UserRepository = myDataSource.getRepository(UserEntity) export const PhotoRepository = myDataSource.getRepository(PhotoEntity) // ... ``` - `getConnectionManager()` and `ConnectionManager` itself are deprecated - now `Connection` is called `DataSource`, and each data source can be defined in exported variable. If you want to have a collection of data sources, just define them in a variable, simply as: ```ts const dataSource1 = new DataSource({ /*...*/ }) const dataSource2 = new DataSource({ /*...*/ }) const dataSource3 = new DataSource({ /*...*/ }) export const MyDataSources = { dataSource1, dataSource2, dataSource3, } ``` - `getConnectionOptions()` is deprecated - in next version we are going to implement different mechanism of connection options loading - `AbstractRepository` is deprecated. Use new way of custom repositories creation. - `Connection.name` and `BaseConnectionOptions.name` are deprecated. Connections don't need names anymore since we are going to drop all related methods relying on this property. - all deprecated signatures will be removed in `0.4.0` ##### EXPERIMENTAL FEATURES NOT PORTED FROM NEXT BRANCH - `observers` - we will consider returning them back with new API in future versions - `alternative find operators` - using `$any`, `$in`, `$like` and other operators in `where` condition. ### [`v0.2.45`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0245-2022-03-04) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.44...0.2.45) ##### Bug Fixes - allow clearing database inside a transaction ([#8712](https://togithub.com/typeorm/typeorm/issues/8712)) ([f3cfdd2](https://togithub.com/typeorm/typeorm/commit/f3cfdd264105ba8cf1c92832b4b95e5a3ca0ed09)), closes [#8527](https://togithub.com/typeorm/typeorm/issues/8527) - discard duplicated columns on update ([#8724](https://togithub.com/typeorm/typeorm/issues/8724)) ([0fc093d](https://togithub.com/typeorm/typeorm/commit/0fc093d168b54a0fd99bb411a730aad9be1858ac)), closes [#8723](https://togithub.com/typeorm/typeorm/issues/8723) - fix entityManager.getId for custom join table ([#8676](https://togithub.com/typeorm/typeorm/issues/8676)) ([33b2bd7](https://togithub.com/typeorm/typeorm/commit/33b2bd7acc55d6eb30bfe0681748d6b6abaff0b5)), closes [#7736](https://togithub.com/typeorm/typeorm/issues/7736) - force web bundlers to ignore index.mjs and use the browser ESM version directly ([#8710](https://togithub.com/typeorm/typeorm/issues/8710)) ([411fa54](https://togithub.com/typeorm/typeorm/commit/411fa54368c8940e94b1cbf7ab64b8d5377f9406)), closes [#8709](https://togithub.com/typeorm/typeorm/issues/8709) ##### Features - add nested transaction ([#8541](https://togithub.com/typeorm/typeorm/issues/8541)) ([6523526](https://togithub.com/typeorm/typeorm/commit/6523526003bab74a0df8f7d578790c1728b26057)), closes [#1505](https://togithub.com/typeorm/typeorm/issues/1505) - add transformer to ViewColumnOptions ([#8717](https://togithub.com/typeorm/typeorm/issues/8717)) ([96ac8f7](https://togithub.com/typeorm/typeorm/commit/96ac8f7eece06ae0a8b52ae7da740c92c0c0d4b9)) ### [`v0.2.44`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0244-2022-02-23) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.43...0.2.44) ##### Bug Fixes - alter relation loader to use transforms when present ([#8691](https://togithub.com/typeorm/typeorm/issues/8691)) ([2c2fb29](https://togithub.com/typeorm/typeorm/commit/2c2fb29a67bfd0ca7dd9133a2f85f5b4db5fb195)), closes [#8690](https://togithub.com/typeorm/typeorm/issues/8690) - cannot read properties of undefined (reading 'joinEagerRelations') ([136015b](https://togithub.com/typeorm/typeorm/commit/136015b04ee72b0ca2439fbff53b1467c12c24b6)) - expo driver doesn't work properly because of new beforeMigration() afterMigration() callbacks ([#8683](https://togithub.com/typeorm/typeorm/issues/8683)) ([5a71803](https://togithub.com/typeorm/typeorm/commit/5a7180378e34ab58ad40c504ebc5195e2413c5f4)) - ng webpack default import ([#8688](https://togithub.com/typeorm/typeorm/issues/8688)) ([2d3374b](https://togithub.com/typeorm/typeorm/commit/2d3374b3b4cb8163764c035bd687b2c81787f338)), closes [#8674](https://togithub.com/typeorm/typeorm/issues/8674) - support imports of absolute paths of ESM files on Windows ([#8669](https://togithub.com/typeorm/typeorm/issues/8669)) ([12cbfcd](https://togithub.com/typeorm/typeorm/commit/12cbfcde7bc4f56069ed3298064bb91ad0816bf0)), closes [#8651](https://togithub.com/typeorm/typeorm/issues/8651) ##### Features - add option to upsert to skip update if the row already exists and no values would be changed ([#8679](https://togithub.com/typeorm/typeorm/issues/8679)) ([8744395](https://togithub.com/typeorm/typeorm/commit/87443954b59768ab77fb15097ea9d88822b4a733)) - allow `{delete,insert}().returning()` on MariaDB ([#8673](https://togithub.com/typeorm/typeorm/issues/8673)) ([7facbab](https://togithub.com/typeorm/typeorm/commit/7facbabd2663098156a53983ea38433ed39082d2)), closes [#7235](https://togithub.com/typeorm/typeorm/issues/7235) [#7235](https://togithub.com/typeorm/typeorm/issues/7235) - Implement deferrable foreign keys for SAP HANA ([#6104](https://togithub.com/typeorm/typeorm/issues/6104)) ([1f54c70](https://togithub.com/typeorm/typeorm/commit/1f54c70b76de34d4420904b72137df746ea9aaed)) ### [`v0.2.43`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0243-2022-02-17) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.42...0.2.43) ##### Bug Fixes - support `require` to internal files without explicitly writing `.js` in the path ([#8660](https://togithub.com/typeorm/typeorm/issues/8660)) ([96aed8a](https://togithub.com/typeorm/typeorm/commit/96aed8aae06df0ae555aa51ed9f1a5ffec141e61)), closes [#8656](https://togithub.com/typeorm/typeorm/issues/8656) ##### Features - embedded entities with entity schema ([#8626](https://togithub.com/typeorm/typeorm/issues/8626)) ([7dbe956](https://togithub.com/typeorm/typeorm/commit/7dbe956c56da3a430ae6f0e99730e9449deae889)), closes [#3632](https://togithub.com/typeorm/typeorm/issues/3632) ##### Reverts - Revert "feat: soft delete recursive cascade ([#8436](https://togithub.com/typeorm/typeorm/issues/8436))" ([#8654](https://togithub.com/typeorm/typeorm/issues/8654)) ([6b0b15b](https://togithub.com/typeorm/typeorm/commit/6b0b15b0e68584ed7cd81a658d8606cfdb96817c)), closes [#8436](https://togithub.com/typeorm/typeorm/issues/8436) [#8654](https://togithub.com/typeorm/typeorm/issues/8654) ### [`v0.2.42`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0242-2022-02-16) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.41...0.2.42) ##### Bug Fixes - proper column comment mapping from database to metadata in aurora-data-api ([baa5880](https://togithub.com/typeorm/typeorm/commit/baa5880001064333eb4eb01765b1d79e17cf1fb5)) - add referencedSchema to PostgresQueryRunner ([#8566](https://togithub.com/typeorm/typeorm/issues/8566)) ([c490319](https://togithub.com/typeorm/typeorm/commit/c49031929aca8f3b932c6593b75447256085bfef)) - adding/removing [@Generated](https://togithub.com/Generated)() will now generate a migration to add/remove the DEFAULT value ([#8274](https://togithub.com/typeorm/typeorm/issues/8274)) ([4208393](https://togithub.com/typeorm/typeorm/commit/42083936e2b65f0d1bd8e23d12689a7f49e2da2f)), closes [#5898](https://togithub.com/typeorm/typeorm/issues/5898) - adds entity-schema support for createForeignKeyConstraints ([#8606](https://togithub.com/typeorm/typeorm/issues/8606)) ([f224f24](https://togithub.com/typeorm/typeorm/commit/f224f24e5247d3c42385bfc03c89f518aa932310)), closes [#8489](https://togithub.com/typeorm/typeorm/issues/8489) - allow special keyword as column name for simple-enum type on sqlite ([#8645](https://togithub.com/typeorm/typeorm/issues/8645)) ([93bf96e](https://togithub.com/typeorm/typeorm/commit/93bf96ea635823c7933ea8ef7326be62ccdd6ea7)) - correctly handle multiple-row insert for SAP HANA driver ([#7957](https://togithub.com/typeorm/typeorm/issues/7957)) ([8f2ae71](https://togithub.com/typeorm/typeorm/commit/8f2ae71201e7738fe3c1efd5bbc4584dfe62dcc0)) - disable SQLite FK checks in synchronize / migrations ([#7922](https://togithub.com/typeorm/typeorm/issues/7922)) ([f24822e](https://togithub.com/typeorm/typeorm/commit/f24822ef9cb3051fbe9f3fd5d9e669788852c5a5)) - find descendants of a non-existing tree parent ([#8557](https://togithub.com/typeorm/typeorm/issues/8557)) ([cbb61eb](https://togithub.com/typeorm/typeorm/commit/cbb61eb08139204479110c88d7d1849a24080d11)), closes [#8556](https://togithub.com/typeorm/typeorm/issues/8556) - For MS SQL Server use lowercase "sys"."columns" reference. ([#8400](https://togithub.com/typeorm/typeorm/issues/8400)) ([#8401](https://togithub.com/typeorm/typeorm/issues/8401)) ([e8a0f92](https://togithub.com/typeorm/typeorm/commit/e8a0f921b4baa7aa7e55ac1fd34c449dfa1e3229)) - improve DeepPartial type ([#8187](https://togithub.com/typeorm/typeorm/issues/8187)) ([b93416d](https://togithub.com/typeorm/typeorm/commit/b93416d7bc25006b34a90c14c497cc7e6e57e28c)) - Lock peer dependencies versions ([#8597](https://togithub.com/typeorm/typeorm/issues/8597)) ([600bd4e](https://togithub.com/typeorm/typeorm/commit/600bd4e5da74b012409d1fdf411a0a0b5265466b)) - make EntityMetadataValidator comply with entitySkipConstructor, cover with test ([#8445](https://togithub.com/typeorm/typeorm/issues/8445)) ([3d6c5da](https://togithub.com/typeorm/typeorm/commit/3d6c5dae76ad0e0640650058ae58fe0addda2ae6)), closes [#8444](https://togithub.com/typeorm/typeorm/issues/8444) - materialized path being computed as "undefined1." ([#8526](https://togithub.com/typeorm/typeorm/issues/8526)) ([09f54e0](https://togithub.com/typeorm/typeorm/commit/09f54e0273be4dc836824a38e9c78b50ad21bba6)) - MongoConnectionOptions sslCA type mismatch ([#8628](https://togithub.com/typeorm/typeorm/issues/8628)) ([02400da](https://togithub.com/typeorm/typeorm/commit/02400dab662aceca9a722c4aa0dd74a9fa2cb90d)) - mongodb repository.find filters soft deleted rows ([#8581](https://togithub.com/typeorm/typeorm/issues/8581)) ([f7c1f7d](https://togithub.com/typeorm/typeorm/commit/f7c1f7d7c0481f4ada506e5b811a3219519eadf9)), closes [#7113](https://togithub.com/typeorm/typeorm/issues/7113) - mongodb@4 compatibility support ([#8412](https://togithub.com/typeorm/typeorm/issues/8412)) ([531013b](https://togithub.com/typeorm/typeorm/commit/531013b2f8dfb8d04b0bfb844dc83a5ba6404569)) - must invoke key pragma before any other interaction if SEE setted ([#8478](https://togithub.com/typeorm/typeorm/issues/8478)) ([546b3ed](https://togithub.com/typeorm/typeorm/commit/546b3ed8886c44fbe3d9e167d1904cb9e5961df7)), closes [#8475](https://togithub.com/typeorm/typeorm/issues/8475) - nested eager relations in a lazy-loaded entity are not loaded ([#8564](https://togithub.com/typeorm/typeorm/issues/8564)) ([1cfd7b9](https://togithub.com/typeorm/typeorm/commit/1cfd7b98ba27032dd0e9429a245c40cea47900f7)) - QueryFailedError when tree entity with JoinColumn ([#8443](https://togithub.com/typeorm/typeorm/issues/8443)) ([#8447](https://togithub.com/typeorm/typeorm/issues/8447)) ([a11c50d](https://togithub.com/typeorm/typeorm/commit/a11c50d5519bda1410ab9ccf67bfcb12ef109c61)) - relation id and afterAll hook performance fixes ([#8169](https://togithub.com/typeorm/typeorm/issues/8169)) ([31f0b55](https://togithub.com/typeorm/typeorm/commit/31f0b5535aa0cc49ff23610b1924c03432f5461f)) - replaced custom uuid generator with `uuid` library ([#8642](https://togithub.com/typeorm/typeorm/issues/8642)) ([8898a71](https://togithub.com/typeorm/typeorm/commit/8898a7175f481f1c171acefef61dc089bc3f8a8e)) - single table inheritance returns the same discriminator value error for unrelated tables where their parents extend from the same entity ([#8525](https://togithub.com/typeorm/typeorm/issues/8525)) ([6523fcc](https://togithub.com/typeorm/typeorm/commit/6523fccda1147dc697afbba57792e5cb4165fbf2)), closes [#8522](https://togithub.com/typeorm/typeorm/issues/8522) - updating with only `update: false` columns shouldn't trigger [@UpdateDateColumn](https://togithub.com/UpdateDateColumn) column updation ([2834729](https://togithub.com/typeorm/typeorm/commit/2834729e80577bd30f09c2c0e4c949cde173bba3)), closes [#8394](https://togithub.com/typeorm/typeorm/issues/8394) [#8394](https://togithub.com/typeorm/typeorm/issues/8394) [#8394](https://togithub.com/typeorm/typeorm/issues/8394) - upsert should find unique index created by one-to-one relation ([#8618](https://togithub.com/typeorm/typeorm/issues/8618)) ([c8c00ba](https://togithub.com/typeorm/typeorm/commit/c8c00baf9351973be5780687418303dd87de2077)) ##### Features - add comment param to FindOptions ([#8545](https://togithub.com/typeorm/typeorm/issues/8545)) ([ece0da0](https://togithub.com/typeorm/typeorm/commit/ece0da027dfce4357764dda4b810598ad64af9d9)) - add custom timestamp option in migration creation ([#8501](https://togithub.com/typeorm/typeorm/issues/8501)) ([4a7f242](https://togithub.com/typeorm/typeorm/commit/4a7f2420f1b498465b2a5913b7d848b3eaafb113)), closes [#8500](https://togithub.com/typeorm/typeorm/issues/8500) [#8500](https://togithub.com/typeorm/typeorm/issues/8500) - add support for node-redis v4.0.0 and newer ([#8425](https://togithub.com/typeorm/typeorm/issues/8425)) ([0626ed1](https://togithub.com/typeorm/typeorm/commit/0626ed1f0bd75fb8e72a462593f33813d85faee8)) - add support for Postgres 10+ GENERATED ALWAYS AS IDENTITY ([#8371](https://togithub.com/typeorm/typeorm/issues/8371)) ([a0f09de](https://togithub.com/typeorm/typeorm/commit/a0f09de8400ac7c94df33f8213ef0eec79b9239d)), closes [#8370](https://togithub.com/typeorm/typeorm/issues/8370) - add WITH (lock) clause for MSSQL select with join queries ([#8507](https://togithub.com/typeorm/typeorm/issues/8507)) ([3284808](https://togithub.com/typeorm/typeorm/commit/3284808b63552d81456752187c0d130db76007ed)), closes [#4764](https://togithub.com/typeorm/typeorm/issues/4764) - adds entity-schema support for withoutRowid ([#8432](https://togithub.com/typeorm/typeorm/issues/8432)) ([bd22dc3](https://togithub.com/typeorm/typeorm/commit/bd22dc3b8175ef82967b8265a2388ce16cc08623)), closes [#8429](https://togithub.com/typeorm/typeorm/issues/8429) - allow soft-deletion of orphaned relation rows using orphanedRow… ([#8414](https://togithub.com/typeorm/typeorm/issues/8414)) ([cefddd9](https://togithub.com/typeorm/typeorm/commit/cefddd95c550191d6a18cb53c8ea4995d0c219ca)) - custom name for typeorm_metadata table ([#8528](https://togithub.com/typeorm/typeorm/issues/8528)) ([f8154eb](https://togithub.com/typeorm/typeorm/commit/f8154eb4c5089a1a0d2c2073f0ea5d64b3252e08)), closes [#7266](https://togithub.com/typeorm/typeorm/issues/7266) - deferrable option for Unique constraints (Postgres) ([#8356](https://togithub.com/typeorm/typeorm/issues/8356)) ([e52b26c](https://togithub.com/typeorm/typeorm/commit/e52b26c910047d22aa3ea003b62d11c2bf352249)) - ESM support ([#8536](https://togithub.com/typeorm/typeorm/issues/8536)) ([3a694dd](https://togithub.com/typeorm/typeorm/commit/3a694dd3e99699e7284709c53967a5dfcb1e1806)), closes [#6974](https://togithub.com/typeorm/typeorm/issues/6974) [#6941](https://togithub.com/typeorm/typeorm/issues/6941) [#7516](https://togithub.com/typeorm/typeorm/issues/7516) [#7159](https://togithub.com/typeorm/typeorm/issues/7159) - query builder negating with "NotBrackets" for complex expressions ([#8476](https://togithub.com/typeorm/typeorm/issues/8476)) ([fe7f328](https://togithub.com/typeorm/typeorm/commit/fe7f328fd5b918cab2e7301d57c62e81d9ff34f3)) - separate update events into update, soft-remove, and recover ([#8403](https://togithub.com/typeorm/typeorm/issues/8403)) ([93383bd](https://togithub.com/typeorm/typeorm/commit/93383bd2ee6dc8c22a5cfc0021334fe199da81dc)), closes [#8398](https://togithub.com/typeorm/typeorm/issues/8398) - soft delete recursive cascade ([#8436](https://togithub.com/typeorm/typeorm/issues/8436)) ([d0f32b3](https://togithub.com/typeorm/typeorm/commit/d0f32b3a17be9ffe9fbc6112e5731bbac91c3691)) - sqlite attach ([#8396](https://togithub.com/typeorm/typeorm/issues/8396)) ([9e844d9](https://togithub.com/typeorm/typeorm/commit/9e844d9ff72fae72578399e24464cd7912c0fe5e)) ##### Reverts - migration:show command must exist with zero status code (Fixes [#7349](https://togithub.com/typeorm/typeorm/issues/7349)) ([#8185](https://togithub.com/typeorm/typeorm/issues/8185)) ([e0adeee](https://togithub.com/typeorm/typeorm/commit/e0adeee48eeb0d5412aa5c0258f7c12e6b1c38ed)) ##### BREAKING CHANGES - update listeners and subscriber no longer triggered by soft-remove and recover ### [`v0.2.41`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0241-2021-11-18) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.40...0.2.41) ##### Bug Fixes - add `retryWrites` to `MongoConnectionOptions` ([#8354](https://togithub.com/typeorm/typeorm/issues/8354)) ([c895680](https://togithub.com/typeorm/typeorm/commit/c895680dce35f0550f48d92d7dd1a5fb48ab4135)), closes [#7869](https://togithub.com/typeorm/typeorm/issues/7869) - create typeorm_metadata table when running migrations ([#4956](https://togithub.com/typeorm/typeorm/issues/4956)) ([b2c8168](https://togithub.com/typeorm/typeorm/commit/b2c8168514b23671080e6d384e381e997fbaa11e)) - db caching won't work with replication enabled ([#7694](https://togithub.com/typeorm/typeorm/issues/7694)) ([2d0abe7](https://togithub.com/typeorm/typeorm/commit/2d0abe7140a0aec40d50c15acd98633483db3e29)), closes [#5919](https://togithub.com/typeorm/typeorm/issues/5919) - incorrect composite `UNIQUE` constraints detection ([#8364](https://togithub.com/typeorm/typeorm/issues/8364)) ([29cb891](https://togithub.com/typeorm/typeorm/commit/29cb89123aaf705437927a8c6ed23204422b71cc)), closes [#8158](https://togithub.com/typeorm/typeorm/issues/8158) - Postgres enum generates unnecessary queries on schema sync ([#8268](https://togithub.com/typeorm/typeorm/issues/8268)) ([98d5f39](https://togithub.com/typeorm/typeorm/commit/98d5f39e35b6e5dd77ae2aa60f80f4ac98249379)) - resolve issue delete column null on after update event subscriber ([#8318](https://togithub.com/typeorm/typeorm/issues/8318)) ([8a5e671](https://togithub.com/typeorm/typeorm/commit/8a5e6715e2d32da22c2fa71a14a7cf1fe897a159)), closes [#6327](https://togithub.com/typeorm/typeorm/issues/6327) ##### Features - export interfaces from schema-builder/options ([#8383](https://togithub.com/typeorm/typeorm/issues/8383)) ([7b8a1e3](https://togithub.com/typeorm/typeorm/commit/7b8a1e38f269ba329a153135e12e1a21274b3a18)) - implement generated columns for postgres 12 driver ([#6469](https://togithub.com/typeorm/typeorm/issues/6469)) ([91080be](https://togithub.com/typeorm/typeorm/commit/91080be0cd35a5ee9467d4b50b6b7fb5421ac800)) - lock modes in cockroachdb ([#8250](https://togithub.com/typeorm/typeorm/issues/8250)) ([d494fcc](https://togithub.com/typeorm/typeorm/commit/d494fccc9c6a2d773bcb411ba746a74539373eff)), closes [#8249](https://togithub.com/typeorm/typeorm/issues/8249) ### [`v0.2.40`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0240-2021-11-11) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.39...0.2.40) ##### Bug Fixes - BaseEntity finder methods to properly type-check lazy relations conditions ([#5710](https://togithub.com/typeorm/typeorm/issues/5710)) ([0665ff5](https://togithub.com/typeorm/typeorm/commit/0665ff5473d075e442f3a93f665bbe087bdf29de)) ##### Features - add depth limiter optional parameter when loading nested trees using TreeRepository's findTrees() and findDescendantsTree() ([#7926](https://togithub.com/typeorm/typeorm/issues/7926)) ([0c44629](https://togithub.com/typeorm/typeorm/commit/0c44629c83c48c27448e7e3cb39faf26994e6e56)), closes [#3909](https://togithub.com/typeorm/typeorm/issues/3909) - add upsert methods for the drivers that support onUpdate ([#8104](https://togithub.com/typeorm/typeorm/issues/8104)) ([3f98197](https://togithub.com/typeorm/typeorm/commit/3f981975d4347483937547feaa8fa4f63b81a83c)), closes [#2363](https://togithub.com/typeorm/typeorm/issues/2363) - Postgres IDENTITY Column support ([#7741](https://togithub.com/typeorm/typeorm/issues/7741)) ([969af95](https://togithub.com/typeorm/typeorm/commit/969af958ba27282b9594140a7e2d58dba1192830)) ##### Reverts - "feat: use char(36) for uuid representation in mysql ([#7853](https://togithub.com/typeorm/typeorm/issues/7853))" ([#8343](https://togithub.com/typeorm/typeorm/issues/8343)) ([1588c58](https://togithub.com/typeorm/typeorm/commit/1588c58539e5121dad6b7120f0b5f83f43f1532f)) - regression in ordering by the relation property ([#8346](https://togithub.com/typeorm/typeorm/issues/8346)) ([#8352](https://togithub.com/typeorm/typeorm/issues/8352)) ([0334d10](https://togithub.com/typeorm/typeorm/commit/0334d104d9ce93c8cb079449ce98ffbdc64219c2)), closes [#3736](https://togithub.com/typeorm/typeorm/issues/3736) [#8118](https://togithub.com/typeorm/typeorm/issues/8118) ### [`v0.2.39`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0239-2021-11-09) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.38...0.2.39) ##### Bug Fixes - attach FOR NO KEY UPDATE lock to query if required ([#8008](https://togithub.com/typeorm/typeorm/issues/8008)) ([9692930](https://togithub.com/typeorm/typeorm/commit/96929302a4dc27a19e94c5532a3ae76951e52552)), closes [#7717](https://togithub.com/typeorm/typeorm/issues/7717) - cli should accept absolute paths for --config ([4ad3a61](https://togithub.com/typeorm/typeorm/commit/4ad3a61037ad9ead998665d2857d6e4725d7b718)) - create a different cacheId if present for count query in getManyAndCount ([#8283](https://togithub.com/typeorm/typeorm/issues/8283)) ([9f14e48](https://togithub.com/typeorm/typeorm/commit/9f14e488281fb08d8ea1a95c6cc363e1234fa307)), closes [#4277](https://togithub.com/typeorm/typeorm/issues/4277) - defaults type cast filtering in Cockroachdb ([#8144](https://togithub.com/typeorm/typeorm/issues/8144)) ([28c183e](https://togithub.com/typeorm/typeorm/commit/28c183e9df562e2eb1e3c93afbd1d4687b1b0846)), closes [#7110](https://togithub.com/typeorm/typeorm/issues/7110) [#7110](https://togithub.com/typeorm/typeorm/issues/7110) - do not generate migration for unchanged enum column ([#8161](https://togithub.com/typeorm/typeorm/issues/8161)) ([#8164](https://togithub.com/typeorm/typeorm/issues/8164)) ([4638dea](https://togithub.com/typeorm/typeorm/commit/4638dea55d0e9239a62fb3143cd96988bf07bc68)) - NativescriptQueryRunner's query method fails when targeting es2017 ([#8182](https://togithub.com/typeorm/typeorm/issues/8182)) ([8615733](https://togithub.com/typeorm/typeorm/commit/861573377bb33b73232399c21b1b3a5c07b58036)) - OneToManySubjectBuilder bug with multiple primary keys ([#8221](https://togithub.com/typeorm/typeorm/issues/8221)) ([6558295](https://togithub.com/typeorm/typeorm/commit/655829592ee10aaa5d28a96691ada0d5510899ea)) - ordering by joined columns for PostgreSQL ([#3736](https://togithub.com/typeorm/typeorm/issues/3736)) ([#8118](https://togithub.com/typeorm/typeorm/issues/8118)) ([1649882](https://togithub.com/typeorm/typeorm/commit/1649882d335587ac78d2203db3a7ab492a942374)) - support DeleteResult in SQLiteDriver ([#8237](https://togithub.com/typeorm/typeorm/issues/8237)) ([b678807](https://togithub.com/typeorm/typeorm/commit/b6788072c20b5f235df9272625c3d1d7522d27e0)) ##### Features - add `typeorm` command wrapper to package.json in project template ([#8081](https://togithub.com/typeorm/typeorm/issues/8081)) ([19d4a91](https://togithub.com/typeorm/typeorm/commit/19d4a914a5da2c28f1eb4ed1c28a52db7dc809d0)) - add dependency configuraiton for views [#8240](https://togithub.com/typeorm/typeorm/issues/8240) ([#8261](https://togithub.com/typeorm/typeorm/issues/8261)) ([2c861af](https://togithub.com/typeorm/typeorm/commit/2c861afaef839f33b5cf1cc2b3bcf8b6e4a0be4f)) - add relation options to all tree queries ([#8080](https://togithub.com/typeorm/typeorm/issues/8080)) ([e4d4636](https://togithub.com/typeorm/typeorm/commit/e4d46363917db57a9107048b973b6a12be8d61fd)), closes [#8076](https://togithub.com/typeorm/typeorm/issues/8076) - add the ability to pass the driver into all database types ([#8259](https://togithub.com/typeorm/typeorm/issues/8259)) ([2133ffe](https://togithub.com/typeorm/typeorm/commit/2133ffea9c678841bf3537838777d9a5fec3a00e)) - more informative logging in case of migration failure ([#8307](https://togithub.com/typeorm/typeorm/issues/8307)) ([dc6f1c9](https://togithub.com/typeorm/typeorm/commit/dc6f1c91be29e88466614eb8b8d21a92659cfd0b)) - support using custom index with SelectQueryBuilder in MySQL ([#7755](https://togithub.com/typeorm/typeorm/issues/7755)) ([f79ae58](https://togithub.com/typeorm/typeorm/commit/f79ae589cd1a658fea553cb57abc2a41a46523f8)) ##### Reverts - Revert "fix: STI types on children in joins ([#3160](https://togithub.com/typeorm/typeorm/issues/3160))" ([#8309](https://togithub.com/typeorm/typeorm/issues/8309)) ([0adad88](https://togithub.com/typeorm/typeorm/commit/0adad8810e15b8d00259a2635e1c50e85598e1ed)), closes [#3160](https://togithub.com/typeorm/typeorm/issues/3160) [#8309](https://togithub.com/typeorm/typeorm/issues/8309) ### [`v0.2.38`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0238-2021-10-02) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.37...0.2.38) ##### Bug Fixes - prevent using absolute table path in migrations unless required ([#8038](https://togithub.com/typeorm/typeorm/issues/8038)) ([e9366b3](https://togithub.com/typeorm/typeorm/commit/e9366b33ddff296de1254019589b85e40aa53e12)) - snakecase conversion for strings with numbers ([#8111](https://togithub.com/typeorm/typeorm/issues/8111)) ([749511d](https://togithub.com/typeorm/typeorm/commit/749511d981f6b9a1a08113b23e8779a91cda78f8)) - use full path for table lookups ([#8097](https://togithub.com/typeorm/typeorm/issues/8097)) ([22676a0](https://togithub.com/typeorm/typeorm/commit/22676a04c30b3b49a61003320dfad3ecad3791e8)) ##### Features - support QueryRunner.stream with Oracle ([#8086](https://togithub.com/typeorm/typeorm/issues/8086)) ([b858f84](https://togithub.com/typeorm/typeorm/commit/b858f84e6fb15f801f2564088428d250d1c59e18)) ### [`v0.2.37`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0237-2021-08-13) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.36...0.2.37) ##### Bug Fixes - allow periods in parameter identifiers ([#8022](https://togithub.com/typeorm/typeorm/issues/8022)) ([4201938](https://togithub.com/typeorm/typeorm/commit/420193892ffe857c532130c0c7b18dcc4c8d38e2)) - ConnectionManager `connections` property should include list of `Connection`s ([#8004](https://togithub.com/typeorm/typeorm/issues/8004)) ([2344db6](https://togithub.com/typeorm/typeorm/commit/2344db60c4314da31885f5686e94bb6dcb203a96)) - entity value for date columns that are related ([#8027](https://togithub.com/typeorm/typeorm/issues/8027)) ([5a3767f](https://togithub.com/typeorm/typeorm/commit/5a3767f58f6ef355b01cf6e92342401a051a369c)) - handle brackets when only one condition is passed ([#8048](https://togithub.com/typeorm/typeorm/issues/8048)) ([ab39066](https://togithub.com/typeorm/typeorm/commit/ab39066f182d357fcc999cd976510c0e2a61d6de)) - handle enums with multiple apostrophes in MySQL ([#8013](https://togithub.com/typeorm/typeorm/issues/8013)) ([37c40a6](https://togithub.com/typeorm/typeorm/commit/37c40a610caecfc3b27b48a87b0e98d715f23395)), closes [#8011](https://togithub.com/typeorm/typeorm/issues/8011) - include all drivers in driverfactory error message ([#8061](https://togithub.com/typeorm/typeorm/issues/8061)) ([fbd1ef7](https://togithub.com/typeorm/typeorm/commit/fbd1ef74e84b59ef0b8d99e311f0aced902190e6)) - resolve not returning soft deleted relations with withDeleted find option ([#8017](https://togithub.com/typeorm/typeorm/issues/8017)) ([65cbcc7](https://togithub.com/typeorm/typeorm/commit/65cbcc79bceac4cf8d15dec8c558dcbc9a037220)) - SAP HANA inserts used incorrect value for returning query ([#8072](https://togithub.com/typeorm/typeorm/issues/8072)) ([36398db](https://togithub.com/typeorm/typeorm/commit/36398dbe467274a9ac08a013ed4daaf307ee2de2)) - some drivers set the wrong database name when defined from url ([#8058](https://togithub.com/typeorm/typeorm/issues/8058)) ([a3a3284](https://togithub.com/typeorm/typeorm/commit/a3a32849c04a83adbf775fcf07843a934551dbfb)) - throw error when not connected in drivers ([#7995](https://togithub.com/typeorm/typeorm/issues/7995)) ([cd71f62](https://togithub.com/typeorm/typeorm/commit/cd71f62cb8125d1bbd92b341aa2eea1de0ac3537)) ##### Features - add relations option to tree queries ([#7981](https://togithub.com/typeorm/typeorm/issues/7981)) ([ca26297](https://togithub.com/typeorm/typeorm/commit/ca26297484542498b8f622f540ca354360d53ed0)), closes [#7974](https://togithub.com/typeorm/typeorm/issues/7974) [#4564](https://togithub.com/typeorm/typeorm/issues/4564) - add serviceName option for oracle connections ([#8021](https://togithub.com/typeorm/typeorm/issues/8021)) ([37bd012](https://togithub.com/typeorm/typeorm/commit/37bd0124dc81c957b2a036436594ae8c4606eb6c)) - add support to string array on dropColumns ([#7654](https://togithub.com/typeorm/typeorm/issues/7654)) ([91d5b2f](https://togithub.com/typeorm/typeorm/commit/91d5b2fc374c2f7b1545d40ee76577272de21436)) - support Oracle Implicit Results ([#8050](https://togithub.com/typeorm/typeorm/issues/8050)) ([fe78bee](https://togithub.com/typeorm/typeorm/commit/fe78bee3725efef47d5be6f924b9caf13f3299a7)) ### [`v0.2.36`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0236-2021-07-31) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.35...0.2.36) ##### Bug Fixes - add deprecated `WhereExpression` alias for `WhereExpressionBuilder` ([#7980](https://togithub.com/typeorm/typeorm/issues/7980)) ([76e7ed9](https://togithub.com/typeorm/typeorm/commit/76e7ed943779b940212c4e453d97028b5ffed7d0)) - always generate migrations with template string literals ([#7971](https://togithub.com/typeorm/typeorm/issues/7971)) ([e9c2af6](https://togithub.com/typeorm/typeorm/commit/e9c2af610a1c9a632605b71d67b97e048be2e29e)) - use js rather than ts in all `browser` package manifests ([#7982](https://togithub.com/typeorm/typeorm/issues/7982)) ([0d90bcd](https://togithub.com/typeorm/typeorm/commit/0d90bcdc8c77f2080aa200fe9f4f962b7b01c9ee)) - use nvarchar/ntext during transit for SQLServer queries ([#7933](https://togithub.com/typeorm/typeorm/issues/7933)) ([62d7976](https://togithub.com/typeorm/typeorm/commit/62d79762dbfe58219a5673ba4d404fe9f2e40436)) ##### Features - add postgres connection option `applicationName` ([#7989](https://togithub.com/typeorm/typeorm/issues/7989)) ([d365acc](https://togithub.com/typeorm/typeorm/commit/d365acca68069d0bd9acea5b45a73d7f4c1f4d8f)) ### [`v0.2.35`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0235-2021-07-28) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.34...0.2.35) ##### Bug Fixes - `entity` to be `PartialConfiguration
📅 Schedule: Branch creation - "" (UTC), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
This PR was generated by Mend Renovate. View the repository job log.