Questions tagged [bulkupdate]
Bulk update a database
bulkupdate
310
questions
0
votes
1
answer
20
views
Moving Wordpress Custom Field Value into Default Editor/Excerpt
I am in the process of migrating posts between an old and a new website. ACF was used on the old website and when I import the posts into the new website it creates the custom fields "...
- 177
4
votes
1
answer
49
views
Patching RavenDb documents using a Dictionary<string, object>
I'm trying to patch a single/multiple documents (identified by their id) with that I receive in a Dictionary<string, object>. The key of the dictionary is the path to the document property to ...
- 1,221
0
votes
0
answers
28
views
ETL design over an existing DDD aggregate
I hope you can help me with the design of a data ingestion process.
Currently, I have an existing aggregate called ExperiencePricing and an existing command called SetExperiencePricingCommand. The ...
- 966
2
votes
2
answers
182
views
What's the best way to update ~500 entities with EF Core? [closed]
Right now I loop through each entity and call ExecuteUpdateAsync then after the loop I call CommitAsync, but I'd like to know if there is a better way for updating ~500 records?
I see this bulk ...
- 14.1k
0
votes
1
answer
66
views
Upsert_all with uniqueness index constraint
I'm facing a dilemma.
I've created a model with an wave_order column with uniqueness db index with wavable. wavable is a polymorphic (but we don't care actually).
# migration
create_table :...
- 1,662
0
votes
1
answer
40
views
How to retrieve ids of inserted or updated rows after "INSERT ON DUPLICATE UPDATE" MySQL?
I'm storing players of my game based on their level :
CREATE TABLE IF NOT EXISTS Player(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(255) NOT NULL UNIQUE,
level TINYINT UNSIGNED ...
0
votes
0
answers
27
views
How to handle before and after update event subscribers in typeorm for bulk update?
In my project i have task entity. When a field of task is updated after and before update EventSubscriber will be triggered which is working fine for a single task update.
When i tried to bulk update ...
- 1
0
votes
0
answers
35
views
How to do a very large bulk update in MySQL?
I need to do a bulk update of a MySQL table. I am updating one column, called Quantity, the same column in all cases. The table primary key is an automatically-assigned numeric ID. I can build a ...
- 1
0
votes
0
answers
31
views
django bulk update with batch in multiple transactions
I've a certain code that updates bulk rows:
from simple_history.utils import bulk_update_with_history
from django.utils.timezone import now
bulk_update_list = []
for chart in updated_chart_records:
...
- 4,033
0
votes
0
answers
15
views
Multiple document operations | Insert rows in bulk in ArangoDB Using HTTP API Python
In ArangoDB, the batch request API has been deprecated since version 3.8.0. To send multiple documents simultaneously to an ArangoDB instance, you must utilize the HTTP interface for documents, which ...
- 27
0
votes
1
answer
61
views
Dapper Plus BulkMerge without identity
We've been using Dapper Plus to do bulk merges using BulkMerge against SQL Server. This works pretty easily with an identity column but we've got many tables that have a primary key with no identity ...
- 1
0
votes
0
answers
43
views
Oracle SQL bulk update based on CSV
Currently working over a Oracle DB, and need to update a specific field from a table called "USERS" This table contain main information, as the user name, ID, EMAIL, etc. We are updating all ...
- 41
0
votes
2
answers
49
views
Update scenario is not working properly when using CASEs or IF statement ON DUPLICATE KEY UPDATE section in MySQL
I need to do bulk insert and update on MySQL so I used the ON DUPLICATE KEY UPDATE. I need to ignore the updated by and updated date fields as existing old data if there are no changes in those record'...
1
vote
2
answers
426
views
How can I filter all rows of a polars dataframe that partially match strings in another?
I want to delete all rows of a dataframe that match one or more rows in a filtering dataframe.
Yes, I know about filter by one regex and I also know how join can be leveraged when there is a full ...
- 11.7k
0
votes
1
answer
334
views
Open Search _bulk update with script and upsert
I am facing a challenge with bulk upsert on the OpenSearch index.
Currently, I am using the below POST method to perform bulk updates
Amazon OpenSearch Service v1.3
Method: POST _bulk
Payload:
{ "...
- 21