Questions tagged [insert-update]
A mixed flavour of data entry mode and data modification mode. It can be used when insert is required for case of non-existing data and modification if data exists.
insert-update
1,310
questions
0
votes
1
answer
51
views
Batch update of records in MongoDB
I iterated over records in the batch step and in Batch Aggregator I wanted to update all of them at once in mongoDb. Is there a way to update them all together or I need to separately update each one ...
- 13
2
votes
1
answer
57
views
Microsoft Access SQL [duplicate]
I am looking for a solution to fill fields in an Access DB SQL statement.
Any suggestions?
Example of the dataset attached:
Goal:
I am looking for a solution to fill fields in an Access DB SQl ...
- 23
-1
votes
0
answers
14
views
Updating Postgres Table using a Datastream in spark
I am using scala Api "2.12.15" of spark "3.5.0" and i am trying to use a data stream to update the rows of my Postgres table :
my data stream and my table both has the same columns
...
- 5
0
votes
0
answers
44
views
SQLAlchemy ORM 2.0 - create audits (Insert/ Update/ Delete)
I am trying to create audits (get columns with values before and after Update)
Update statement per ORM 2.0 style :
engine = create_engine("sqlite:///sales.db", echo=True)
Base = ...
- 11
1
vote
0
answers
40
views
Unable to Update Data in ScyllaDB
I'm encountering an issue while attempting to update data in ScyllaDB using Go. Below is the code snippet I'm using for updating a session record:
func (q *Queries) EndSession(Sessionid string) error {...
- 11
0
votes
1
answer
26
views
ORA-30926: unable to get a stable set of rows in the source tables when updating a a table in a database using another table in another database
I am trying to update a table in a database using another table in another database. This script was working fine until recently when I started getting the error: ORA-30926: unable to get a stable set ...
- 15
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
1
answer
25
views
Update many documents by pushing an object to an array field when id field matches the id field in the object
Ok that question doesn't sound very clear. I will try to explain.
I have a collection of F1 drivers that contains an array field to store the points earned from each race.
I use a web form to submit ...
0
votes
1
answer
52
views
Creating a datafactory pipeline for updating an insering records
I have one csv file which has data of 3 months and have a key column but it has empty values and I have a second file which has also three months records but one week after the records from the first ...
- 23
0
votes
0
answers
215
views
Delta Tables...do we need partitions for concurrent write/update?
I am starting to use Databricks in AWS. I have a delta table that contains KPIs, with each KPI having a KPI ID (1000, 1001, 1002, etc...). We want to have concurrent processes that update those KPIs ...
- 63
0
votes
0
answers
29
views
How to save each instance from a patch request in Djanog
In my Django appliations, I have four models, Exercise, Workout, Target, and TargetExerciseSet. Here are the models below along with my current Workout View and patch request function. The patch ...
- 59
0
votes
0
answers
50
views
PHP Update API php://input returning unexpected response
I am creating an API to update. When I call the API in Postman, I get a strange response when I var_dump what I am to get.
Here is my code:
$data = json_decode(file_get_contents("php://input&...
- 428
0
votes
0
answers
19
views
Value of one field in one entity has been changed after hibernate call saveOrUpdate
One object has been sent to hibernate saveOrUpdate method for updating the data. Before save the value of one field was different and after save the value in the object got changed. Is this one of the ...
1
vote
1
answer
338
views
Update Access Database Table using Excel VBA
I have a Time In and Time Out buttons in a form.
And I have a VBA Module code that saves the last entered data/last row of an entry from an Excel Table to Access Table and it works perfectly fine. ...
- 610
0
votes
0
answers
81
views
how to write a update statement SQL Oracle developer to get data from tables and input it into their own columns
This is my problem "There can be errors preventing data to be properly inserted into the database. This will require you to go into tables individually to add, delete, or modify data. You see ...
0
votes
2
answers
298
views
How to rightly configure an Azure data factory data flow with a delta file as sink?
I am trying to sink data to a delta file. I want to use a insert and update method using the unique Id column: (sink settings)
Whenever the update method is allowed a AlterRow operation will appear. ...
- 409
-1
votes
1
answer
44
views
If I have multiple entries in a cloumn in mysql that need to be changed
So I want to change all the fields in the column allow_two_day_ordering to False. How can I change them all without doing it one by one. I have a much bigger list than this.
+-------+------------------...
- 113
2
votes
1
answer
53
views
R6 array member, copy on update
the following code
require(R6)
Array <- R6Class(
"Array",
public=list(
x=matrix(0,0,0),
initialize=function(a,b,c){
self$x <- matrix(a,b,c)
},
assign=function(...
- 411
0
votes
1
answer
534
views
How to up files with Bitrix24 api
How can I update a CRM contact field, this field is type file? I'm using the bitrix24 API
I want to update an image of a contact, in the bitrix23 documentation I can't find anything
This is where I am ...
0
votes
1
answer
39
views
How to insert new key-value pairs to an existing elastic document using python?
I tried the typical _update method in elastic, which isn't working.
data_to_send ={
"new_key1": new_value1,
"new_key2": new_value2,
"new_key3": ...
- 52
0
votes
0
answers
234
views
Stored Procedure: Update or Insert data between two databases on the same mysql server
I am trying to create a procedure to Insert or update data into a user table in a different database on the same MariaDB server. I am using phpMyAdmin.
I have the following two tables:
Database 1: ...
0
votes
1
answer
600
views
pentaho insert/update transformation
Have someone any idea why when I used insert/update in pentaho, it insert/update only with this values?
The tables are in the same database. One of transformation that I have in pentaho worked with ...
- 1
1
vote
1
answer
335
views
Azure SQL - Select Into - Update if exists, else create
I am using Azure SQL for an Application DB, and am trying to create (and subsequently kep updated) some lightweight tables from the more complete tables the Application uses.
Main reason for this is ...
- 11
0
votes
1
answer
29
views
R data.table update by condition based on current row
I have a data.table where each row corresponds to a set with assigned mass. Sometimes, the mass assigned is (NA). I would like to update it by the minimum of numerical masses assigned to its subsets.
...
0
votes
1
answer
76
views
mongodb update one with upset is not working as expected
This is my mongoose schema.
const CurrencySchema = new mongoose.Schema({
source: { type: String, uppercase: true, required: true, minlength: 3, maxlength: 3, trim: true },
convert: { type: ...
- 2,757
1
vote
0
answers
89
views
Adding item in wishlist , but after adding showing red heart when i refresh i want that instant in laravel
I am adding an item in wishlist in laravel , item is adding in wishlist and showing red heart but after adding when i refresh then only it shows red heart, how can i make it red heart instantly after ...
- 41
0
votes
2
answers
225
views
Insert Into On Conflict With a Where Clause
I have a SQL query that looks like this:
INSERT INTO testing.names
(
id,
first_name,
active_status
)
-------------------------------------
SELECT
stage.id,
stage.first_name,
...
2
votes
1
answer
584
views
Django REST PATCH request field is required problem
I have a Student model. And I want to update some specific fields. But when I go to update one or two fields but the other field value is as it is then which fields are not changing those fields show ...
0
votes
1
answer
75
views
How can I insert data into a 1-n relation table in Spring Boot JPA without updating the User table?
User
@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
@Entity
@Table(name = "user")
public class User {
@Id
@GeneratedValue(strategy = GenerationType.UUID)
@Column(name = &...
0
votes
1
answer
212
views
Change the content of ${body} in Apache Camel XML DSL
Given the following XML ${body} payload object
<list>
<library>
<name>xxx</name>
<address>
<line1>aaa</line1>
<line2>...
- 1