feat: implement or operator #10086

deepkhurana1999 · 2023-05-28T13:22:39Z

This new feature enables typeorm to allow use multiple operators joining with or

Closes: #10054

Pull-Request Checklist

Code is up-to-date with the master branch
npm run format to apply prettier formatting
npm run test passes with this change
This pull request links relevant issues as Fixes #10054
There are new or updated unit tests validating the change
Documentation has been updated to reflect this change
The new commits follow conventions explained in CONTRIBUTING.md

This new feature enables typeorm to allow use multiple operators joining with or Closes: typeorm#10054

Completed code formating using command. Closes: typeorm#10054

Completed the documentation update. Closes: typeorm#10054

deepkhurana1999 · 2023-05-28T13:56:46Z

Note: The implementation is tested with the new test-case.

The following test-cases are failed custom cache provider on the feature as well as master branch. Therefore, not able to run the complete test.

@pleerock

src/index.ts

Renamed Or operator file name. Closes: typeorm#10054

deepkhurana1999

Ok, I have renamed it.

src/index.ts

Renamed Or operator file name. Closes: typeorm#10054

deepkhurana1999 · 2023-05-28T18:21:31Z

Ok, I have renamed it.

[Update:] Seems like visual studio code not detecting file name changes. Therefore, removed and adding it again.

deepkhurana1999 · 2023-05-31T03:46:32Z

@soomtong Any update regarding review?

soomtong · 2023-05-31T04:33:37Z

@soomtong Any update regarding review?

It would be great if you could also include the 'OR' to 'Or' in the readme.md document.
I'm interested in your PR and wanted to give some input, but other maintainers need to review it.
Anyway I like this implementation!

deepkhurana1999 · 2023-06-02T03:57:19Z

@soomtong Any update regarding review?

It would be great if you could also include the 'OR' to 'Or' in the readme.md document. I'm interested in your PR and wanted to give some input, but other maintainers need to review it. Anyway I like this implementation!

Thank you @soomtong.

There is no dedicated section to explain FindOptions in Readme.md, I have already updated the find-options.md. Please let me know should I create a new section about FindOptions?

soomtong

This is what I found, and I hope it helps.

docs/find-options.md

src/find-options/operator/Or.ts

test/github-issues/10054/issue-10054.ts

Renamed Or operator. Closes: typeorm#10054

deepkhurana1999 · 2023-06-09T02:56:40Z

This is what I found, and I hope it helps.

Hello @soomtong,

I have addressed all of the changes you requested. Please take a look and let me know if you have any questions or concerns.

soomtong

LGTM

soomtong · 2023-06-09T04:44:48Z

test/github-issues/10054/issue-10054.ts

+                await dataSource.manager.save([foo, john, dave, foobar])
+                const persons = await dataSource.manager.find(Person, {
+                    where: {
+                        name: Or(ILike("foo%"), Equal("Jane")),


I hope this patch gets merged soon, it would be great for casual users.

Thank you @soomtong

deepkhurana1999 · 2023-06-09T16:34:41Z

Hello @pleerock,

@soomtong has reviewed the PR and everything seems to looking good. Please take a look into the PR and let me know if you have any questions or concerns.

benjefferies · 2023-07-03T14:24:53Z

Top work @deepkhurana1999. Would be great to see this in

hinogi

LGTM

deepkhurana1999 · 2023-10-28T09:35:27Z

LGTM

Thank you, @soomtong @hinogi any plan on merging the changes?

hinogi · 2023-10-29T08:22:03Z

LGTM

Thank you, @soomtong @hinogi any plan on merging the changes?

Sorry, I am unable to do such a thing, I am not a maintainer.

pleerock · 2024-01-02T10:00:54Z

sorry for late review here and thank you for your work.

This PR contains the following updates: | Package | Type | Update | Change | |---|---|---|---| | [typeorm](https://typeorm.io) ([source](https://github.com/typeorm/typeorm)) | dependencies | patch | [`0.3.17` -> `0.3.19`](https://renovatebot.com/diffs/npm/typeorm/0.3.17/0.3.19) | --- ### Release Notes <details> <summary>typeorm/typeorm (typeorm)</summary> ### [`v0.3.19`](https://github.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0319-2024-01-03) [Compare Source](typeorm/typeorm@0.3.18...0.3.19) ##### Bug Fixes - fixed `Cannot read properties of undefined (reading 'sync')` caused after glob package upgrade ### [`v0.3.18`](https://github.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0318-2024-01-03) [Compare Source](typeorm/typeorm@0.3.17...0.3.18) ##### Bug Fixes - add BaseEntity to model-shim ([#10503](typeorm/typeorm#10503)) ([3cf938e](typeorm/typeorm@3cf938e)) - add error handling for missing join columns ([#10525](typeorm/typeorm#10525)) ([122c897](typeorm/typeorm@122c897)), closes [#7034](typeorm/typeorm#7034) - add missing export for View class ([#10261](typeorm/typeorm#10261)) ([7adbc9b](typeorm/typeorm@7adbc9b)) - added fail callback while opening the database in Cordova ([#10566](typeorm/typeorm#10566)) ([8b4df5b](typeorm/typeorm@8b4df5b)) - aggregate function throw error when column alias name is set ([#10035](typeorm/typeorm#10035)) ([022d2b5](typeorm/typeorm@022d2b5)), closes [#9927](typeorm/typeorm#9927) - backport postgres connection error handling to crdb ([#10177](typeorm/typeorm#10177)) ([149226d](typeorm/typeorm@149226d)) - bump better-sqlite3 version range ([#10452](typeorm/typeorm#10452)) ([75ec8f2](typeorm/typeorm@75ec8f2)) - caching always enabled not caching queries ([#10524](typeorm/typeorm#10524)) ([8af533f](typeorm/typeorm@8af533f)) - circular dependency breaking node.js 20.6 ([#10344](typeorm/typeorm#10344)) ([ba7ad3c](typeorm/typeorm@ba7ad3c)), closes [#10338](typeorm/typeorm#10338) - correctly keep query.data from ormOption for commit / rollback subscribers ([#10151](typeorm/typeorm#10151)) ([73ee70b](typeorm/typeorm@73ee70b)) - default value in child table/entity column decorator for multiple table inheritance is ignored for inherited columns ([#10563](typeorm/typeorm#10563)) ([#10564](typeorm/typeorm#10564)) ([af77a5d](typeorm/typeorm@af77a5d)) - deletedAt column leaking as side effect of object update while creating a row ([#10435](typeorm/typeorm#10435)) ([7de4890](typeorm/typeorm@7de4890)) - empty objects being hydrated when eager loading relations that have a `@VirtualColumn` ([#10432](typeorm/typeorm#10432)) ([b53e410](typeorm/typeorm@b53e410)), closes [#10431](typeorm/typeorm#10431) - extend GiST index with range types for Postgres driver ([#10572](typeorm/typeorm#10572)) ([a4900ae](typeorm/typeorm@a4900ae)), closes [#10567](typeorm/typeorm#10567) - ignore changes for columns with `update: false` in persistence ([#10250](typeorm/typeorm#10250)) ([f8fa1fd](typeorm/typeorm@f8fa1fd)), closes [#10249](typeorm/typeorm#10249) - improve helper for cli for commands missing positionals ([#10133](typeorm/typeorm#10133)) ([9f8899f](typeorm/typeorm@9f8899f)) - loading datasource unable to process a regular default export ([#10184](typeorm/typeorm#10184)) ([201342d](typeorm/typeorm@201342d)), closes [#8810](typeorm/typeorm#8810) - logMigration has incorrect logging condition ([#10323](typeorm/typeorm#10323)) ([d41930f](typeorm/typeorm@d41930f)), closes [#10322](typeorm/typeorm#10322) [#10322](typeorm/typeorm#10322) - ManyToMany ER_DUP_ENTRY error ([#10343](typeorm/typeorm#10343)) ([e296063](typeorm/typeorm@e296063)), closes [#5704](typeorm/typeorm#5704) - migrations on indexed TIMESTAMP WITH TIME ZONE Oracle columns ([#10506](typeorm/typeorm#10506)) ([cf37f13](typeorm/typeorm@cf37f13)), closes [#10493](typeorm/typeorm#10493) - mongodb - undefined is not constructor ([#10559](typeorm/typeorm#10559)) ([ad5bf11](typeorm/typeorm@ad5bf11)) - mongodb resolves leaked cursor ([#10316](typeorm/typeorm#10316)) ([2dc9624](typeorm/typeorm@2dc9624)), closes [#10315](typeorm/typeorm#10315) - mssql datasource testonborrow not affecting anything ([#10589](typeorm/typeorm#10589)) ([122b683](typeorm/typeorm@122b683)) - nested transactions issues ([#10210](typeorm/typeorm#10210)) ([25e6ecd](typeorm/typeorm@25e6ecd)) - prevent using absolute table path in migrations unless required ([#10123](typeorm/typeorm#10123)) ([dd59524](typeorm/typeorm@dd59524)) - remove `date-fns` in favor of `DayJs` ([#10306](typeorm/typeorm#10306)) ([cf7147f](typeorm/typeorm@cf7147f)) - remove dynamic require calls ([#10196](typeorm/typeorm#10196)) ([a939654](typeorm/typeorm@a939654)) - resolve circular dependency when using Vite ([#10273](typeorm/typeorm#10273)) ([080528b](typeorm/typeorm@080528b)) - resolve issue building eager relation alias for nested relations ([#10004](typeorm/typeorm#10004)) ([c6f608d](typeorm/typeorm@c6f608d)), closes [#9944](typeorm/typeorm#9944) - resolve issue of generating migration for numeric arrays repeatedly ([#10471](typeorm/typeorm#10471)) ([39fdcf6](typeorm/typeorm@39fdcf6)), closes [#10043](typeorm/typeorm#10043) - resolve issue queryBuilder makes different parameter identifiers for same parameter ([#10327](typeorm/typeorm#10327)) ([6c918ea](typeorm/typeorm@6c918ea)), closes [#7308](typeorm/typeorm#7308) - resolve issues on upsert ([#10588](typeorm/typeorm#10588)) ([dc1bfed](typeorm/typeorm@dc1bfed)), closes [#10587](typeorm/typeorm#10587) - scrub all comment end markers from comments ([#10163](typeorm/typeorm#10163)) ([d937f61](typeorm/typeorm@d937f61)) - serialize bigint when building a query id [#10336](typeorm/typeorm#10336) ([#10337](typeorm/typeorm#10337)) ([bfc1cc5](typeorm/typeorm@bfc1cc5)) - should automatically cache if alwaysEnable ([#10137](typeorm/typeorm#10137)) ([173910e](typeorm/typeorm@173910e)), closes [#9910](typeorm/typeorm#9910) - SQLite simple-enum column parsing ([#10550](typeorm/typeorm#10550)) ([696e688](typeorm/typeorm@696e688)) - update UpdateDateColumn on upsert ([#10458](typeorm/typeorm#10458)) ([fdb9866](typeorm/typeorm@fdb9866)), closes [#9015](typeorm/typeorm#9015) - upgrade ts-node version to latest(10.9.1) version ([#10143](typeorm/typeorm#10143)) ([fcb9904](typeorm/typeorm@fcb9904)) - using async datasource to configure typeorm ([#10170](typeorm/typeorm#10170)) ([fbd45db](typeorm/typeorm@fbd45db)) ##### Features - ability to change default replication mode ([#10419](typeorm/typeorm#10419)) ([72b1d1b](typeorm/typeorm@72b1d1b)) - add concurrent indexes for postgres ([#10442](typeorm/typeorm#10442)) ([f4e6eaf](typeorm/typeorm@f4e6eaf)) - add exists and exists by ([#10291](typeorm/typeorm#10291)) ([b6b46fb](typeorm/typeorm@b6b46fb)) - add isolated where statements ([#10213](typeorm/typeorm#10213)) ([3cda7ec](typeorm/typeorm@3cda7ec)) - add MSSQL disableAsciiToUnicodeParamConversion option and tests ([#10161](typeorm/typeorm#10161)) ([df7c069](typeorm/typeorm@df7c069)), closes [#10131](typeorm/typeorm#10131) - add support for mssql server DefaultAzureCredential usage ([#10246](typeorm/typeorm#10246)) ([c8ee5b1](typeorm/typeorm@c8ee5b1)) - add support for table comment in MySQL ([#10017](typeorm/typeorm#10017)) ([338df16](typeorm/typeorm@338df16)) - allow to use custom type witch extends object type for find where argument ([#10475](typeorm/typeorm#10475)) ([48f5f85](typeorm/typeorm@48f5f85)) - BeforeQuery and AfterQuery events ([#10234](typeorm/typeorm#10234)) ([5c28154](typeorm/typeorm@5c28154)), closes [#3302](typeorm/typeorm#3302) - custom STI discriminator value for EntitySchema ([#10508](typeorm/typeorm#10508)) ([b240d87](typeorm/typeorm@b240d87)), closes [#10494](typeorm/typeorm#10494) - enabled CTE for oracle driver ([#10319](typeorm/typeorm#10319)) ([65858f3](typeorm/typeorm@65858f3)) - entityId in InsertEvent ([#10540](typeorm/typeorm#10540)) ([ae006af](typeorm/typeorm@ae006af)) - expose countDocuments in mongodb ([#10314](typeorm/typeorm#10314)) ([ebd61d1](typeorm/typeorm@ebd61d1)) - exposed entity and criteria properties on EntityNotFoundError ([#10202](typeorm/typeorm#10202)) ([bafcd17](typeorm/typeorm@bafcd17)) - implement column comments for SAP HANA ([#10502](typeorm/typeorm#10502)) ([45e31cc](typeorm/typeorm@45e31cc)) - implement OR operator ([#10086](typeorm/typeorm#10086)) ([a00b1df](typeorm/typeorm@a00b1df)), closes [#10054](typeorm/typeorm#10054) [#10054](typeorm/typeorm#10054) [#10054](typeorm/typeorm#10054) [#10054](typeorm/typeorm#10054) [#10054](typeorm/typeorm#10054) [#10054](typeorm/typeorm#10054) [#10054](typeorm/typeorm#10054) - implement streaming for SAP HANA ([#10512](typeorm/typeorm#10512)) ([7e9cead](typeorm/typeorm@7e9cead)) - implements QueryFailedError generic for driverError typing ([#10253](typeorm/typeorm#10253)) ([78b2f48](typeorm/typeorm@78b2f48)) - modify repository.extend method for chaining repositories ([#10256](typeorm/typeorm#10256)) ([ca29c0f](typeorm/typeorm@ca29c0f)) - nullable embedded entities ([#10289](typeorm/typeorm#10289)) ([e67d704](typeorm/typeorm@e67d704)) - support for MongoDB 6.x ([#10545](typeorm/typeorm#10545)) ([3647b26](typeorm/typeorm@3647b26)) - support mssql@10 ([#10356](typeorm/typeorm#10356)) ([f6bb671](typeorm/typeorm@f6bb671)), closes [#10340](typeorm/typeorm#10340) - use node-oracledb 6 ([#10285](typeorm/typeorm#10285)) ([3af891a](typeorm/typeorm@3af891a)), closes [#10277](typeorm/typeorm#10277) - user-defined index name for STI discriminator column ([#10509](typeorm/typeorm#10509)) ([89c5257](typeorm/typeorm@89c5257)), closes [#10496](typeorm/typeorm#10496) ##### Performance Improvements - improve SapQueryRunner performance ([#10198](typeorm/typeorm#10198)) ([f6b87e3](typeorm/typeorm@f6b87e3)) ##### BREAKING CHANGES - With node-oracledb the thin client is used as default. Added a option to use the thick client. Also added the option to specify the instant client lib - MongoDB: from the previous behavior of returning a result with metadata describing when a document is not found. See: https://github.com/mongodb/node-mongodb-native/blob/HEAD/etc/notes/CHANGES\_6.0.0.md - [new nullable embeds feature](typeorm/typeorm#10289) introduced a breaking change which might enforce you to update types on your entities to ` | null `, if all columns in your embed entity are nullable. Since database queries now return embedded property as `null` if all its column values are null. </details> --- ### Configuration 📅 **Schedule**: Branch creation - At any time (no schedule defined), 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 has been generated by [Renovate Bot](https://github.com/renovatebot/renovate).  Reviewed-on: https://gitea.vylpes.xyz/External/card-drop/pulls/136 Co-authored-by: Renovate Bot <renovate@vylpes.com> Co-committed-by: Renovate Bot <renovate@vylpes.com>

This PR contains the following updates: | Package | Type | Update | Change | |---|---|---|---| | [typeorm](https://typeorm.io) ([source](https://github.com/typeorm/typeorm)) | dependencies | patch | [`0.3.17` -> `0.3.20`](https://renovatebot.com/diffs/npm/typeorm/0.3.17/0.3.20) | --- ### Release Notes <details> <summary>typeorm/typeorm (typeorm)</summary> ### [`v0.3.20`](https://github.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0320-2024-01-26) [Compare Source](typeorm/typeorm@0.3.19...0.3.20) ##### Bug Fixes - added missing parentheses in where conditions ([#10650](typeorm/typeorm#10650)) ([4624930](typeorm/typeorm@4624930)), closes [#10534](typeorm/typeorm#10534) - don't escape indexPredicate ([#10618](typeorm/typeorm#10618)) ([dd49a25](typeorm/typeorm@dd49a25)) - fallback runMigrations transaction to DataSourceOptions ([#10601](typeorm/typeorm#10601)) ([0cab0dd](typeorm/typeorm@0cab0dd)) - hangup when load relations with relationLoadStrategy: query ([#10630](typeorm/typeorm#10630)) ([54d8d9e](typeorm/typeorm@54d8d9e)), closes [#10481](typeorm/typeorm#10481) - include asExpression columns in returning clause ([#10632](typeorm/typeorm#10632)) ([f232ba7](typeorm/typeorm@f232ba7)), closes [#8450](typeorm/typeorm#8450) [#8450](typeorm/typeorm#8450) - multiple insert in SAP Hana ([#10597](typeorm/typeorm#10597)) ([1b34c9a](typeorm/typeorm@1b34c9a)) - resolve issue CREATE/DROP Index concurrently ([#10634](typeorm/typeorm#10634)) ([8aa8690](typeorm/typeorm@8aa8690)), closes [#10626](typeorm/typeorm#10626) - type inferencing of EntityManager#create ([#10569](typeorm/typeorm#10569)) ([99d8249](typeorm/typeorm@99d8249)) ##### Features - add json type support for Oracle ([#10611](typeorm/typeorm#10611)) ([7e85460](typeorm/typeorm@7e85460)) - add postgres multirange column types ([#10627](typeorm/typeorm#10627)) ([d0b7670](typeorm/typeorm@d0b7670)), closes [#10556](typeorm/typeorm#10556) - add table comment for postgres ([#10613](typeorm/typeorm#10613)) ([4493db4](typeorm/typeorm@4493db4)) ##### Reverts - Revert "fix: prevent using absolute table path in migrations unless required ([#10123](typeorm/typeorm#10123))" ([#10624](typeorm/typeorm#10624)) ([8f371f2](typeorm/typeorm@8f371f2)), closes [#10123](typeorm/typeorm#10123) [#10624](typeorm/typeorm#10624) - revert "feat: nullable embedded entities ([#10289](typeorm/typeorm#10289))" ([#10614](typeorm/typeorm#10614)) ([15de46f](typeorm/typeorm@15de46f)), closes [#10289](typeorm/typeorm#10289) [#10614](typeorm/typeorm#10614) ### [`v0.3.19`](https://github.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0319-2024-01-03) [Compare Source](typeorm/typeorm@0.3.18...0.3.19) ##### Bug Fixes - fixed `Cannot read properties of undefined (reading 'sync')` caused after glob package upgrade ### [`v0.3.18`](https://github.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0318-2024-01-03) [Compare Source](typeorm/typeorm@0.3.17...0.3.18) ##### Bug Fixes - add BaseEntity to model-shim ([#10503](typeorm/typeorm#10503)) ([3cf938e](typeorm/typeorm@3cf938e)) - add error handling for missing join columns ([#10525](typeorm/typeorm#10525)) ([122c897](typeorm/typeorm@122c897)), closes [#7034](typeorm/typeorm#7034) - add missing export for View class ([#10261](typeorm/typeorm#10261)) ([7adbc9b](typeorm/typeorm@7adbc9b)) - added fail callback while opening the database in Cordova ([#10566](typeorm/typeorm#10566)) ([8b4df5b](typeorm/typeorm@8b4df5b)) - aggregate function throw error when column alias name is set ([#10035](typeorm/typeorm#10035)) ([022d2b5](typeorm/typeorm@022d2b5)), closes [#9927](typeorm/typeorm#9927) - backport postgres connection error handling to crdb ([#10177](typeorm/typeorm#10177)) ([149226d](typeorm/typeorm@149226d)) - bump better-sqlite3 version range ([#10452](typeorm/typeorm#10452)) ([75ec8f2](typeorm/typeorm@75ec8f2)) - caching always enabled not caching queries ([#10524](typeorm/typeorm#10524)) ([8af533f](typeorm/typeorm@8af533f)) - circular dependency breaking node.js 20.6 ([#10344](typeorm/typeorm#10344)) ([ba7ad3c](typeorm/typeorm@ba7ad3c)), closes [#10338](typeorm/typeorm#10338) - correctly keep query.data from ormOption for commit / rollback subscribers ([#10151](typeorm/typeorm#10151)) ([73ee70b](typeorm/typeorm@73ee70b)) - default value in child table/entity column decorator for multiple table inheritance is ignored for inherited columns ([#10563](typeorm/typeorm#10563)) ([#10564](typeorm/typeorm#10564)) ([af77a5d](typeorm/typeorm@af77a5d)) - deletedAt column leaking as side effect of object update while creating a row ([#10435](typeorm/typeorm#10435)) ([7de4890](typeorm/typeorm@7de4890)) - empty objects being hydrated when eager loading relations that have a `@VirtualColumn` ([#10432](typeorm/typeorm#10432)) ([b53e410](typeorm/typeorm@b53e410)), closes [#10431](typeorm/typeorm#10431) - extend GiST index with range types for Postgres driver ([#10572](typeorm/typeorm#10572)) ([a4900ae](typeorm/typeorm@a4900ae)), closes [#10567](typeorm/typeorm#10567) - ignore changes for columns with `update: false` in persistence ([#10250](typeorm/typeorm#10250)) ([f8fa1fd](typeorm/typeorm@f8fa1fd)), closes [#10249](typeorm/typeorm#10249) - improve helper for cli for commands missing positionals ([#10133](typeorm/typeorm#10133)) ([9f8899f](typeorm/typeorm@9f8899f)) - loading datasource unable to process a regular default export ([#10184](typeorm/typeorm#10184)) ([201342d](typeorm/typeorm@201342d)), closes [#8810](typeorm/typeorm#8810) - logMigration has incorrect logging condition ([#10323](typeorm/typeorm#10323)) ([d41930f](typeorm/typeorm@d41930f)), closes [#10322](typeorm/typeorm#10322) [#10322](typeorm/typeorm#10322) - ManyToMany ER_DUP_ENTRY error ([#10343](typeorm/typeorm#10343)) ([e296063](typeorm/typeorm@e296063)), closes [#5704](typeorm/typeorm#5704) - migrations on indexed TIMESTAMP WITH TIME ZONE Oracle columns ([#10506](typeorm/typeorm#10506)) ([cf37f13](typeorm/typeorm@cf37f13)), closes [#10493](typeorm/typeorm#10493) - mongodb - undefined is not constructor ([#10559](typeorm/typeorm#10559)) ([ad5bf11](typeorm/typeorm@ad5bf11)) - mongodb resolves leaked cursor ([#10316](typeorm/typeorm#10316)) ([2dc9624](typeorm/typeorm@2dc9624)), closes [#10315](typeorm/typeorm#10315) - mssql datasource testonborrow not affecting anything ([#10589](typeorm/typeorm#10589)) ([122b683](typeorm/typeorm@122b683)) - nested transactions issues ([#10210](typeorm/typeorm#10210)) ([25e6ecd](typeorm/typeorm@25e6ecd)) - prevent using absolute table path in migrations unless required ([#10123](typeorm/typeorm#10123)) ([dd59524](typeorm/typeorm@dd59524)) - remove `date-fns` in favor of `DayJs` ([#10306](typeorm/typeorm#10306)) ([cf7147f](typeorm/typeorm@cf7147f)) - remove dynamic require calls ([#10196](typeorm/typeorm#10196)) ([a939654](typeorm/typeorm@a939654)) - resolve circular dependency when using Vite ([#10273](typeorm/typeorm#10273)) ([080528b](typeorm/typeorm@080528b)) - resolve issue building eager relation alias for nested relations ([#10004](typeorm/typeorm#10004)) ([c6f608d](typeorm/typeorm@c6f608d)), closes [#9944](typeorm/typeorm#9944) - resolve issue of generating migration for numeric arrays repeatedly ([#10471](typeorm/typeorm#10471)) ([39fdcf6](typeorm/typeorm@39fdcf6)), closes [#10043](typeorm/typeorm#10043) - resolve issue queryBuilder makes different parameter identifiers for same parameter ([#10327](typeorm/typeorm#10327)) ([6c918ea](typeorm/typeorm@6c918ea)), closes [#7308](typeorm/typeorm#7308) - resolve issues on upsert ([#10588](typeorm/typeorm#10588)) ([dc1bfed](typeorm/typeorm@dc1bfed)), closes [#10587](typeorm/typeorm#10587) - scrub all comment end markers from comments ([#10163](typeorm/typeorm#10163)) ([d937f61](typeorm/typeorm@d937f61)) - serialize bigint when building a query id [#10336](typeorm/typeorm#10336) ([#10337](typeorm/typeorm#10337)) ([bfc1cc5](typeorm/typeorm@bfc1cc5)) - should automatically cache if alwaysEnable ([#10137](typeorm/typeorm#10137)) ([173910e](typeorm/typeorm@173910e)), closes [#9910](typeorm/typeorm#9910) - SQLite simple-enum column parsing ([#10550](typeorm/typeorm#10550)) ([696e688](typeorm/typeorm@696e688)) - update UpdateDateColumn on upsert ([#10458](typeorm/typeorm#10458)) ([fdb9866](typeorm/typeorm@fdb9866)), closes [#9015](typeorm/typeorm#9015) - upgrade ts-node version to latest(10.9.1) version ([#10143](typeorm/typeorm#10143)) ([fcb9904](typeorm/typeorm@fcb9904)) - using async datasource to configure typeorm ([#10170](typeorm/typeorm#10170)) ([fbd45db](typeorm/typeorm@fbd45db)) ##### Features - ability to change default replication mode ([#10419](typeorm/typeorm#10419)) ([72b1d1b](typeorm/typeorm@72b1d1b)) - add concurrent indexes for postgres ([#10442](typeorm/typeorm#10442)) ([f4e6eaf](typeorm/typeorm@f4e6eaf)) - add exists and exists by ([#10291](typeorm/typeorm#10291)) ([b6b46fb](typeorm/typeorm@b6b46fb)) - add isolated where statements ([#10213](typeorm/typeorm#10213)) ([3cda7ec](typeorm/typeorm@3cda7ec)) - add MSSQL disableAsciiToUnicodeParamConversion option and tests ([#10161](typeorm/typeorm#10161)) ([df7c069](typeorm/typeorm@df7c069)), closes [#10131](typeorm/typeorm#10131) - add support for mssql server DefaultAzureCredential usage ([#10246](typeorm/typeorm#10246)) ([c8ee5b1](typeorm/typeorm@c8ee5b1)) - add support for table comment in MySQL ([#10017](typeorm/typeorm#10017)) ([338df16](typeorm/typeorm@338df16)) - allow to use custom type witch extends object type for find where argument ([#10475](typeorm/typeorm#10475)) ([48f5f85](typeorm/typeorm@48f5f85)) - BeforeQuery and AfterQuery events ([#10234](typeorm/typeorm#10234)) ([5c28154](typeorm/typeorm@5c28154)), closes [#3302](typeorm/typeorm#3302) - custom STI discriminator value for EntitySchema ([#10508](typeorm/typeorm#10508)) ([b240d87](typeorm/typeorm@b240d87)), closes [#10494](typeorm/typeorm#10494) - enabled CTE for oracle driver ([#10319](typeorm/typeorm#10319)) ([65858f3](typeorm/typeorm@65858f3)) - entityId in InsertEvent ([#10540](typeorm/typeorm#10540)) ([ae006af](typeorm/typeorm@ae006af)) - expose countDocuments in mongodb ([#10314](typeorm/typeorm#10314)) ([ebd61d1](typeorm/typeorm@ebd61d1)) - exposed entity and criteria properties on EntityNotFoundError ([#10202](typeorm/typeorm#10202)) ([bafcd17](typeorm/typeorm@bafcd17)) - implement column comments for SAP HANA ([#10502](typeorm/typeorm#10502)) ([45e31cc](typeorm/typeorm@45e31cc)) - implement OR operator ([#10086](typeorm/typeorm#10086)) ([a00b1df](typeorm/typeorm@a00b1df)), closes [#10054](typeorm/typeorm#10054) [#10054](typeorm/typeorm#10054) [#10054](typeorm/typeorm#10054) [#10054](typeorm/typeorm#10054) [#10054](typeorm/typeorm#10054) [#10054](typeorm/typeorm#10054) [#10054](typeorm/typeorm#10054) - implement streaming for SAP HANA ([#10512](typeorm/typeorm#10512)) ([7e9cead](typeorm/typeorm@7e9cead)) - implements QueryFailedError generic for driverError typing ([#10253](typeorm/typeorm#10253)) ([78b2f48](typeorm/typeorm@78b2f48)) - modify repository.extend method for chaining repositories ([#10256](typeorm/typeorm#10256)) ([ca29c0f](typeorm/typeorm@ca29c0f)) - nullable embedded entities ([#10289](typeorm/typeorm#10289)) ([e67d704](typeorm/typeorm@e67d704)) - support for MongoDB 6.x ([#10545](typeorm/typeorm#10545)) ([3647b26](typeorm/typeorm@3647b26)) - support mssql@10 ([#10356](typeorm/typeorm#10356)) ([f6bb671](typeorm/typeorm@f6bb671)), closes [#10340](typeorm/typeorm#10340) - use node-oracledb 6 ([#10285](typeorm/typeorm#10285)) ([3af891a](typeorm/typeorm@3af891a)), closes [#10277](typeorm/typeorm#10277) - user-defined index name for STI discriminator column ([#10509](typeorm/typeorm#10509)) ([89c5257](typeorm/typeorm@89c5257)), closes [#10496](typeorm/typeorm#10496) ##### Performance Improvements - improve SapQueryRunner performance ([#10198](typeorm/typeorm#10198)) ([f6b87e3](typeorm/typeorm@f6b87e3)) ##### BREAKING CHANGES - With node-oracledb the thin client is used as default. Added a option to use the thick client. Also added the option to specify the instant client lib - MongoDB: from the previous behavior of returning a result with metadata describing when a document is not found. See: https://github.com/mongodb/node-mongodb-native/blob/HEAD/etc/notes/CHANGES\_6.0.0.md - [new nullable embeds feature](typeorm/typeorm#10289) introduced a breaking change which might enforce you to update types on your entities to ` | null `, if all columns in your embed entity are nullable. Since database queries now return embedded property as `null` if all its column values are null. </details> --- ### Configuration 📅 **Schedule**: Branch creation - At any time (no schedule defined), 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 has been generated by [Renovate Bot](https://github.com/renovatebot/renovate).  Reviewed-on: https://gitea.vylpes.xyz/RabbitLabs/vylbot-app/pulls/395 Reviewed-by: Vylpes <ethan@vylpes.com> Co-authored-by: Renovate Bot <renovate@vylpes.com> Co-committed-by: Renovate Bot <renovate@vylpes.com>

deepkhurana1999 added 3 commits May 28, 2023 17:04

feat: implement or operator

1400953

This new feature enables typeorm to allow use multiple operators joining with or Closes: typeorm#10054

feat: implement or operator

3b08a70

Completed code formating using command. Closes: typeorm#10054

feat: implement or operator

3bf59b0

Completed the documentation update. Closes: typeorm#10054

deepkhurana1999 marked this pull request as ready for review May 28, 2023 13:59

soomtong reviewed May 28, 2023

View reviewed changes

src/index.ts Outdated Show resolved Hide resolved

feat: implement or operator

cee78fb

Renamed Or operator file name. Closes: typeorm#10054

deepkhurana1999 commented May 28, 2023

View reviewed changes

src/index.ts Outdated Show resolved Hide resolved

deepkhurana1999 added 2 commits May 28, 2023 23:46

feat: implement or operator

f22d5e8

Renamed Or operator file name. Closes: typeorm#10054

feat: implement or operator

b4d5043

Renamed Or operator file name. Closes: typeorm#10054

deepkhurana1999 requested a review from soomtong May 31, 2023 03:48

soomtong reviewed Jun 2, 2023

View reviewed changes

feat: implement or operator

99d5910

Renamed Or operator. Closes: typeorm#10054

deepkhurana1999 requested a review from soomtong June 3, 2023 04:56

soomtong reviewed Jun 9, 2023

View reviewed changes

hinogi approved these changes Aug 17, 2023

View reviewed changes

pleerock merged commit a00b1df into typeorm:master Jan 2, 2024

Omrisnyk mentioned this pull request Jan 3, 2024

[Snyk] Security upgrade typeorm from 0.2.24 to 0.3.18 Omrisnyk/goof#206

Open

niabhail mentioned this pull request Jul 18, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 niabhail/kubecon22-snyk-goof#98

Open

sahilbhadana-gamechange mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.45 to 0.3.20 gcsns/gc-doc#168

Open

snyk-matt mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.30 to 0.3.20 snyk-matt/goof-platform#21103

Open

charley04310 mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.3.11 to 0.3.20 charley04310/polydate-backend#41

Open

dstecholution mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 dstecholution/nodejs-goof#172

Open

hunorszegediblack mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 organizationJavascrpt/nodejs-goof#1

Open

akanchhaS mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 akanchhaS/github-goof-npm#1281

Open

amitsnyk mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 amitsnyk/nodejs-goof#181

Open

snyk-io bot mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 DefenderK/nodejs-goof#118

Closed

tehlc mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 tehlc/nodejs-goof#129

Open

slatersnyk mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.25 to 0.3.20 slatersnyk/nodejs-goof#150

Open

devopscast mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 devopscast/goof#235

Open

andygruber mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 mcce22extreme/nodejs-goof-delme#57

Open

sarahwalter22 mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 sarahwalter22/goof#175

Open

vtsmx mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 vtsmx/snyk-labs#93

Open

nphan-ca-vn mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 nphan-ca-vn/nodejs-goof#45

Open

wmporrassnyk mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.25 to 0.3.20 wmporrassnyk/snyk-labs-nodejs-goof#177

Open

WeiLunSnyk mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 WeiLunSnyk/importTest2#19

Open

csrausyan2 mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.25 to 0.3.20 csrausyan2/nodejs-goof#36

Open

ryanotella mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 ryanotella/goof#89

Open

BrunoCosta82-zz mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 BrunoCosta82-zz/goof#209

Open

joxkalna mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 joxkalna/nodejs-goof#105

Open

CAscencio mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.20 to 0.3.20 CAscencio/backend-server-nestjs#215

Open

suellein mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 suellein/github-actions-app#40

Open

SWall16 mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 SWall16/nodejs-goof#231

Open

techwithmack mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 techwithmack/nodejs-goof#30

Open

MedNoun mentioned this pull request Jul 19, 2024

[Snyk] Upgrade typeorm from 0.3.12 to 0.3.20 MedNoun/Nesty-kerberos#81

Open

snyk-io bot mentioned this pull request Jul 20, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 DefenderK/nodejs-goof#120

Open

VeronicaSnyk mentioned this pull request Jul 20, 2024

[Snyk] Upgrade typeorm from 0.2.24 to 0.3.20 VeronicaSnyk/nodejs-goof#99

Open

Rahul-D78 mentioned this pull request Jul 20, 2024

[Snyk] Upgrade typeorm from 0.3.6 to 0.3.20 real-world-system-design/twiiter-node-pg-classic#162

Open

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

feat: implement or operator #10086

feat: implement or operator #10086

deepkhurana1999 commented May 28, 2023 •

edited

Loading

deepkhurana1999 commented May 28, 2023 •

edited

Loading

deepkhurana1999 left a comment

deepkhurana1999 commented May 28, 2023

deepkhurana1999 commented May 31, 2023 •

edited

Loading

soomtong commented May 31, 2023 •

edited

Loading

deepkhurana1999 commented Jun 2, 2023

soomtong left a comment

deepkhurana1999 commented Jun 9, 2023

soomtong left a comment

soomtong Jun 9, 2023

deepkhurana1999 Jun 9, 2023

deepkhurana1999 commented Jun 9, 2023

benjefferies commented Jul 3, 2023

hinogi left a comment

deepkhurana1999 commented Oct 28, 2023

hinogi commented Oct 29, 2023

pleerock commented Jan 2, 2024

feat: implement or operator #10086

feat: implement or operator #10086

Conversation

deepkhurana1999 commented May 28, 2023 • edited Loading

Pull-Request Checklist

deepkhurana1999 commented May 28, 2023 • edited Loading

deepkhurana1999 left a comment

Choose a reason for hiding this comment

deepkhurana1999 commented May 28, 2023

deepkhurana1999 commented May 31, 2023 • edited Loading

soomtong commented May 31, 2023 • edited Loading

deepkhurana1999 commented Jun 2, 2023

soomtong left a comment

Choose a reason for hiding this comment

deepkhurana1999 commented Jun 9, 2023

soomtong left a comment

Choose a reason for hiding this comment

soomtong Jun 9, 2023

Choose a reason for hiding this comment

deepkhurana1999 Jun 9, 2023

Choose a reason for hiding this comment

deepkhurana1999 commented Jun 9, 2023

benjefferies commented Jul 3, 2023

hinogi left a comment

Choose a reason for hiding this comment

deepkhurana1999 commented Oct 28, 2023

hinogi commented Oct 29, 2023

pleerock commented Jan 2, 2024

deepkhurana1999 commented May 28, 2023 •

edited

Loading

deepkhurana1999 commented May 28, 2023 •

edited

Loading

deepkhurana1999 commented May 31, 2023 •

edited

Loading

soomtong commented May 31, 2023 •

edited

Loading