dolthub / dolthub/dolthub-issues

Allow me to update rows by id when uploading csv files

Open
#104 0 comments 0 reactions 0 assignees View on GitHub
dolthubapi enhancement file upload
Dominant language
No language data
Stars
5
Forks
0
PR merge metrics
No merged PRs in 30d

Description

**Is your feature request related to a problem? Please describe.**
I prefer using dolthub instead of cloning a repo to my local dolt to perform PR's to bounties. This is because all that data is hard to deal with in a local repo.
One of the issues with this is most dolt features aren't avaible directly on dolthub. One in particular is updating rows.

**Describe the solution you'd like**
Dolthub has 3 options when uploading a csv file to a table: Update, Replace and Overwrite.

Update is more like an "Add to" instead of update. Instead, I would like update to have suboptions when it detects key conflicts. Say my files has keys already in the database, I would like to be able to only replace those fields or not replace those fields. It would work as an actual update without needing SQL queries to update specific rows.

**Describe alternatives you've considered**
Creating separate branches or recreating the repository, too much work tho :P

**Additional context**
This is related to file upload on dolthub.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.