Questions tagged [batch-updates]
171 questions
1
vote
0 answers
Java Spring Boot batch inserts show-sql showing seperate inserts
I am using Spring Boot and am trying to insert Ingredients in bulk by uploading an Excel file in the frontend application.
The Spring Boot API recieves a list of Ingredients but it is very slow on inserting. Updates go fast, but inserts go very…
Sander van Maurik
- 56
- 6
1
vote
3 answers
Jdbc batched updates good key retrieval strategy
I insert alot of data into a table with a autogenerated key using the batchUpdate functionality of JDBC. Because JDBC doesn't say anything about batchUpdate and getAutogeneratedKeys I need some database independant workaround.
My ideas:
Somehow…
Franz Kafka
- 10,623
- 20
- 93
- 149
1
vote
1 answer
Python + Sheet | May I know the syntax to change BGcolor using BatchUpdate?
The following python code is a BatchUpdate that:
Add a number 'x' to Column H of row
Change the whole row to green
There can be 1 or many rows involved.
How do I change the background color?
Also, if rowListTH[] only has 1 item, will this code…
user2741620
- 305
- 2
- 7
- 21
1
vote
1 answer
Codeigniter batch update for checkbox
I have a situation like this, I want to update some data where the input are checkboxes, I was tried this code below. Data already saved in database, but data saved in another row,
For example : I checked color red, yellow and grey for BirdA and I…
karisma
- 156
- 5
- 18
1
vote
1 answer
Invalid JSON Payload with Sheets.Spreadsheets.BatchUpdate
Trying to work with Sheets.Spreadsheets.Get and Sheets.Spreadsheets.Batchupdate. I'm trying to get pull formatting from one spreadsheet and paste that formatting to another. This is simply a proof of concept for further application. I get a JSON…
LANCE
- 111
- 11
1
vote
0 answers
Neo4j batch update with UNWIND gets slower or even stuck
Following the popular article https://dzone.com/articles/tips-for-fast-batch-updates-of-graph-structures-wi. I'm doing my batch update. I'm using java API to update it and my query looks like:
UNWIND $props as row MERGE (n:Entity{eid:row.eid}) ON…
Yunzhou Ning
- 11
- 1
1
vote
2 answers
Using SQL to batch update columns based on position in resulting sort operation?
My brain decided to stop working this morning. I need a MySQL and SQLite compatible query that will allow me to batch update the "display_order" column of a table based on sorting by another column.
For example, say I have the following fields: …
humble_coder
- 2,777
- 7
- 34
- 46
1
vote
0 answers
UITableViewAlertForLayoutOutsideViewHierarchy error during batch update of UITableView with CATransaction
My app uses a tableView that is updated by batch updates.
The cells have an indicatorImage that depends on the section of the table.
When a cell is moved between sections, this indicator changes, and I want to animate the change of the indicator…
Reinhard Männer
- 14,022
- 5
- 54
- 116
1
vote
2 answers
Oracle Batch Insert w/No Primary Key Missing Inserts
I'm trying to insert over 100,000 records into an Oracle 9i table with no primary key using the ojdbc14.jar driver and Spring's SimpleJdbcTemplate batchUpdate method. Here's my code snippet:
private static final String TABLE_INSERT = "insert into…
jlentz
- 21
- 5
1
vote
1 answer
Bulk/Batch update using Spring Data JPA/Hibernate on Mysql
I am using Mysql, Spring Data JPA. In my use case, I have only 1 table e.g. Customer (ID, FIRST_NAME, LAST_NAME)
What I am trying to achieve is to update in a batch/bulk where update statements are a group as shown above in the example to reduce…
Dhruv
- 10,291
- 18
- 77
- 126
1
vote
1 answer
CodeIgniter update_batch without replacing the previous data next updated value will puts by comma separated as increment
Although I am not sure. update_batch is it possible to without replacing the previous data next updated value will puts by comma separated as an array-form on the SAME FILED . I shown 2 Demo image for better understand. My Code is already running…
Biswajit17
- 41
- 11
1
vote
0 answers
Hide Sheets with Google PHP SpreadSheets client
I am using the following code to hide some sheets of a spreadsheet. I use php client library. My target is to export only the desired sheets into a PDF file. Since there is not method to achieve that, I am trying to hide the undesired sheets and…
ÁngelBlanco
- 438
- 4
- 11
1
vote
1 answer
How does the Cloud Firestore Batched writes work in offline mode
In the doc about Cloud Firestore Batched writes I read "You can perform batched writes even when the user's device is offline."
Can this be turned off or is it off by default since the text say "can". The Cloud Firestore Transaction will fail if…
Erik
- 5,039
- 10
- 63
- 119
1
vote
1 answer
Strange issue with privateQueue managedObjectContext
SETUP (You can read this later and skip to the scenario section first)
It's an old app, with manually setup CoreData stack like this:
+ (NSManagedObjectContext *)masterManagedObjectContext
{
if (_masterManagedObjectContext) {
return…
Eddie
- 1,903
- 2
- 21
- 46
1
vote
0 answers
cassandra cqlengine batch update if exists
I am a newbie to the world of cassandra. I am trying to find the right api in cassandra cqlengine, which I can use to update a record only if one exists previously.
The examples that I have come across do not tackle this particular case and my brute…
user1855193
- 123
- 3
- 10