309 questions
0
votes
0
answers
61
views
Connection pool in oracle python is taking a lot of time to execute insert/update query
self.connection = oracledb.create_pool(
protocol=self.protocol,
host=self.host,
port=self.port,
service_name=self.service_name,
ssl_server_cert_dn=self.ssl_server_cert_dn,
user=...
2
votes
1
answer
267
views
Using Entity Framework method ExecuteUpdate: Set current property value to another property
With the code fragment below, I would like to update the status properties of multiple database records, for example bookings.
Each record has the properties StatusCurrent and StatusBefore. I would ...
- 21
0
votes
0
answers
43
views
MongoDB Bulk Update With Different Values In a Large Collection
I have a requirement to update a single field of a whole collection in a MongoDB database. However this should update a different value for each document.
e.g. document 1 'key' value should be ...
- 165
-1
votes
1
answer
125
views
Optimizing bulk updates in MySQL for a table: performance issues with 10,000 rows
Consider the following that is designed to contain up to 10000 rows :
CREATE TABLE T(
id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
weight MEDIUMINT NOT NULL,
PRIMARY KEY(id)
);
Every 6 ...
4
votes
1
answer
97
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,285
0
votes
1
answer
351
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,772
0
votes
0
answers
107
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,161
0
votes
0
answers
144
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
1
vote
2
answers
1k
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 ...
- 12.2k
0
votes
1
answer
380
views
Bulk replace values in XML file through Notepad++
I am trying to do a bulk update where I copy the values of one tag to another but have not had any luck. Would appreciate any help that could be provided!
Here is an example of what want to do.
Old
&...
- 23
0
votes
1
answer
302
views
Bulk Update on Account Object Not Working in Salesforce Apex
I am new to Salesforce Apex developement, and am trying to update certain fields (e.g. Organization name, 'EIN' value, issue areas and target population) on the account object based on values brought ...
- 11
1
vote
1
answer
400
views
Unable to cast object of type 'System.Linq.EmptyPartition1[Model]' to type 'System.Collections.Generic.List1[Model]' using EFCore.BulkExtensions
I'm using EFCore 7.0 and EFCoreBulkExtensions 7.1.2
When I'm trying to execute a
_context.BulkUpdate(list, bulkConfig);
It thows an <System.InvalidCastException>:
Unable to cast object of type '...
- 21
0
votes
1
answer
274
views
Oracle- Bulk update data with commit frequency
I want to update and insert millions of data via stored procedure in oracle.
I have used below approach-
Fetching all the data in a list.
Iterating through list and updating the data using commit ...
- 11
-2
votes
1
answer
153
views
Hide bulk actions from admin orders list except for processing status filtered list
Is there any way to hide bulk actions from admin orders list except for processing status filtered list: post_status=wc-processing where I only want to show bulk actions?
I tried to use code from How ...
- 7
-2
votes
1
answer
641
views
BULK INSERT/UPDATE statement syntax error?
I am trying to bulk insert or update the data from a csv file to a pre-existing table in a database in SQL and I keep getting the error "Incorrect syntax near keyword 'BULK'" and I've tried ...
- 9
1
vote
1
answer
237
views
Is there a better way to update as multiple records in Laravel?
I did some research on the subject but at the end I found that my approach was acceptable for updating about a list of 100 records x 10 fields. Is there a better way to do that?
The arrays come from ...
- 1,151
0
votes
0
answers
86
views
I am trying to update and insert multiple google sheets with multiple rows, but not getting the correct API
I am trying to update and insert multiple Google sheets with multiple rows, using the integration with Salesforce, for this, I need an endpoint (API) by which I can hit the Google Sheet API only once ...
2
votes
0
answers
119
views
Bulk Upsert in Couchbase with using Golang
I'm new to Golang
Please help with understanding
I want to use bulk upsert operation via gocb.collection_bulk.go.
How does it work if at the time of replacing the document, it will be blocked
Is this ...
- 69
1
vote
1
answer
960
views
How to Find the first image in post content and add it to Featured Image
I have about 1000 posts on my wordpress website, but these posts do not have featured images. But instead, in all these posts there is one photo (the first photo in the article) that can be used as an ...
0
votes
1
answer
30
views
MongoDB: Access current value of document when adding element to array via $push
I have collection MyCollection which basically consists of its _id and a string called comment.
This collection should be bulk-updatable.
That's done like this:
for (const obj of inputObjects) {
...
- 1,403
0
votes
0
answers
260
views
How do I write this query without using raw query in sequelize?
I would like to a bulk update in sequelize. Unfortunately it seems like sequelize does not support bulk updates I am using sequelize-typescript if that helps and using postgresql 14
My query in raw ...
- 6,362
0
votes
0
answers
176
views
Bulk update Oracle sql table with random guid
I need to update multiple rows of a PLSQL table, something like this:
StringBuilder stringBuilder = new StringBuilder(
"UPDATE review_item SET LAST_MODIFIED_TIMESTAMP = systimestamp, &...
1
vote
0
answers
438
views
BulkCreate in Sequelize but only update values if conditions are met
I need to bulk update in Sequelize, but I would like to update the value only if it is higher than the previous value.
Here's a simplified example table:
const HighestRecord = db.define('highestrecord'...
- 11
0
votes
0
answers
609
views
Why is modifiedCount missing in Mongo bulkWrite() result?
I'm on mongo v4.2. See the below mongo shell script which is an exact copy of the example from mongo bulkWrite related documentation
db.pizzas.insertMany( [
{ _id: 0, type: "pepperoni", ...
- 4,938
1
vote
1
answer
138
views
Domain events with composite pattern
I am trying to model a real-time collaboration application with DDD. A particular feature with some Hotspot events is CAD visualization.
Problem #1
Multiple participants join a 3D virtual environment ...
- 577