Stack Overflow
Stack Overflow

Questions tagged [bulkupdate]

Bulk update a database

Methods to bulk update a database with single or multiple columns of data. This could be either unique data for each row or same data for a column.

299 questions
0
votes
0 answers

how can I use Spring Data JPA bulk select-update not using queryDsl?

I want to bulk update my data using jpa. example update data set status = '' where id in (xxx, xxx); I know, I can change using queryDsl. and I know this way. findAll -> update(List) but I don't want to this two ways. can I use Jpa bulk…
jennyChoi
  • 1
  • 1
0
votes
1 answer

Cannot get promise results with promise.all()

I have mutiple update promises with sequelize and execute them parallely by Promise.all All I get as Result is this: [[1]] Here is the Code: const express = require('express'); const router = express.Router(); const PLZ =…
b0ss
  • 109
  • 1
  • 3
  • 12
0
votes
1 answer

Bulk update in entity framework in web api

I am working on a web api project, where client application will send bulk records to api to update into db. I am using C# and Entity framework. Client application will send list of records…
Vishwakant
  • 111
  • 1
  • 10
0
votes
2 answers

Bulk Copy Update C# ASP.NET MVC

I have 2 tables both with relatively large amounts of information. As part of the process I need to update Table 2(Inv) with the information from Table 1. Essentially copy the CC value from Table 1(Acc) to PCC value in Table 2. The amount of updates…
user2806570
  • 821
  • 2
  • 12
  • 25
0
votes
2 answers

Bulk Copy or Update data from one database to another

I would like to bulk copy or update data from one Database to another by making use of the following criteria: Copy the data row if it doesn't already exist based on the barcode column Update the current data row in the destination database if the…
JohnWayne
  • 105
  • 11
0
votes
0 answers

Mongo bulk update

I have to do bulk update in Mongodb, for that I am using pymongo.bulk_write method with UpdateOne operations only. In case of not matched filters I get more fields from other sources and insert the doc. But this is not possible with bulk write,…
AJ91
  • 140
  • 1
  • 1
  • 12
0
votes
2 answers

Neo4j java.rmi.UnmarshalException: Error unmarshaling return header; nested exception is:

neo4j-sh (?)$ MATCH (n:toy) - [rel:`buy_vendor`] -> (vc) WITH rel,n SET rel.mt=n.buy_type; java.rmi.UnmarshalException: Error unmarshaling return header; nested exception is: java.io.EOFException at…
vinsent paramanantham
  • 953
  • 3
  • 15
  • 34
0
votes
1 answer

Django Restframework(drf) Bulk Update not working?

I am using djangorestframework-bulk to perform bulk update have followed documentation DRF-Bulk but for me update wasnt working.. it says, File "/webapps/env_apibot/local/lib/python2.7/site-packages/rest_framework_bulk/drf3/serializers.py", line 43,…
Mohideen bin Mohammed
  • 18,813
  • 10
  • 112
  • 118
0
votes
1 answer

Bulk update in Laravel

I have a string with multiple update queries, example: $string = "UPDATE `student` SET `isams_id`=0001,`name`='stu name',`registration_id`='258911',`classid`=2,`section`='A',`house_name`='ELM',`status`=1,`updated_at`='2018-06-29 06:49:15' WHERE…
Arya
  • 504
  • 2
  • 8
  • 31
0
votes
1 answer

SQLAlchemy bulk update query fails with AttributeError

Following are model and relationship configurations I have, (not a practical example) class MyUser(Base): __tablename__ = 'my_user' id = Column(Integer, primary_key=True) name = Column(String) class Address(Base): __tablename__ =…
Nikhil Rupanawar
  • 4,061
  • 10
  • 35
  • 51
0
votes
0 answers

SQL Loop through 8 million record and update them

I have a audit table that has about 8 million records. I have recently added two new column which I need to update from existing column with some rules/conditions. Basically initially, whenever a FK was updated in a table, it was storing old and new…
Bhavesh
  • 819
  • 1
  • 17
  • 31
0
votes
1 answer

MongoDB Bulk Find and Replace of ObjectId on a single Document

We have two documents that have merged and they now have one one ObjectId. There exists a configuration document that may have references to the old ObjectId. The old ObjectID can exist all over this document which is full of nested arrays and…
Brock
  • 71
  • 4
0
votes
0 answers

upserting an object in MongoDB using PyMongo

I intend to upsert a specific field into existing mongo object like below - from pymongo import UpdateOne # data_dict has less than 1000 items for content_id, content_rank in data_dict.items(): operations.append(UpdateOne( …
comiventor
  • 3,922
  • 5
  • 50
  • 77
0
votes
0 answers

Elastic Search : Bulk update using Rest Client throws java.io.IOException: An existing connection was forcibly closed by the remote host

I am trying to bulk update few fields in my documents using Rest Client. Here is how my code looks like : String updateLastUsedTimeInBulkPath = "/_bulk"; // Tried with just "_bulk" also StringEntity updateLastUsedTimeRequest = new…
Shobhana Sriram
  • 394
  • 1
  • 2
  • 14
0
votes
1 answer

To import or to update the elasticsearch when data is huge

I need to decide whether to use elasticsearch import or update/upsert based on the following workflow. Elasticsearch is serving as the backend of a business intelligence application. Every day we collect roughly 200GB of log and analytics data from…
Waku-2
  • 1,136
  • 2
  • 13
  • 26
1 2 3
…
19 20