feat: upsert with on-conflict support (Sourcery refactored)

[sourcery-ai[bot]]

Pull Request #142 refactored by Sourcery.

Since the original Pull Request was opened as a fork in a contributor's repository, we are unable to create a Pull Request branching from it.

To incorporate these changes, you can either:

1. Merge this Pull Request instead of the original, or

2. Ask your contributor to locally incorporate these commits and push them to the original Pull Request

   Incorporate changes via command line

   git fetch https://github.com/supabase-community/postgrest-py pull/142/head
   git merge --ff-only FETCH_HEAD
   git push

NOTE: As code is pushed to the original Pull Request, Sourcery will re-run and update (force-push) this Pull Request with new refactorings as necessary. If Sourcery finds no refactorings at any point, this Pull Request will be closed automatically.

See our documentation here.

Run Sourcery locally

Reduce the feedback loop during development by using the Sourcery editor plugin:

• VS Code
• PyCharm

Help us improve this pull request!

[sourcery-ai[bot]]

Sourcery Code Quality Report

❌  Merging this PR will decrease code quality in the affected files by 0.50%.

Quality metrics	Before	After	Change
Complexity	0.87 ⭐	0.85 ⭐	-0.02 👍
Method Length	33.16 ⭐	33.40 ⭐	0.24 👎
Working memory	6.46 🙂	6.64 🙂	0.18 👎
Quality	85.63% ⭐	85.13% ⭐	-0.50% 👎

Other metrics	Before	After	Change
Lines	770	777	7

Changed files	Quality Before	Quality After	Quality Change
postgrest/base_request_builder.py	86.78% ⭐	86.24% ⭐	-0.54% 👎
postgrest/_async/request_builder.py	82.94% ⭐	82.57% ⭐	-0.37% 👎
postgrest/_sync/request_builder.py	82.96% ⭐	82.59% ⭐	-0.37% 👎

Here are some functions in these files that still need a tune-up:

File	Function	Complexity	Length	Working Memory	Quality	Recommendation
postgrest/_async/request_builder.py	AsyncRequestBuilder.upsert	0 ⭐	51 ⭐	12 😞	72.70% 🙂	Extract out complex expressions
postgrest/_sync/request_builder.py	SyncRequestBuilder.upsert	0 ⭐	51 ⭐	12 😞	72.70% 🙂	Extract out complex expressions
postgrest/_async/request_builder.py	AsyncRequestBuilder.insert	0 ⭐	46 ⭐	10 😞	77.13% ⭐	Extract out complex expressions
postgrest/_sync/request_builder.py	SyncRequestBuilder.insert	0 ⭐	46 ⭐	10 😞	77.13% ⭐	Extract out complex expressions

Legend and Explanation

The emojis denote the absolute quality of the code:

• ⭐ excellent
• 🙂 good
• 😞 poor
• ⛔ very poor

The 👍 and 👎 indicate whether the quality has improved or gotten worse with this pull request.

---

Please see our documentation here for details on how these metrics are calculated.

We are actively working on this report - lots more documentation and extra metrics to come!

Help us improve this quality report!