python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - insert-update

MongoDB "update()" (Update the document of “Reg Rubio” and “Ian Tayao” by adding the “President” to their Reporting file)

I use this codes manually db.employees.update({Name: "Reg Rubio"}, {$set : {ReportingTo: ["Vice-President", "President"]}}) db.employees.update({Name: "Ian Tayao&qu...
test-img

Lightning21Cheetah

database

mongodb

insert-update

Votes: 0

Answers: 1

Latest Answer

So.. no.. , there is no way to update two separate documents using an 2 different inputs in 1 db call. To optimize network traffic you can use bulkWrite, this still executes each update separately in...
test-img

Tom Slabbaert

SQL UPDATE on with data from same table

I have a next situation with a table, Need to update rows from rows in same table, as you see here: TABLE ID SN FID 1 12345 1 2 1122 2 3 12345-RG NULL 4 1122-RG NULL I need to UPDATE...
test-img

user3128539

sql

sql-server

sql-update

temp-tables

insert-update

Votes: 0

Answers: 1

Latest Answer

Asuming [SN] is being augmented with -RG Example with cte as ( Select * ,NV = max(FID) over (partition by replace(SN,'-RG','') ) From YourTable ) Update cte set FID = NV --Where FID is null ...
test-img

John Cappelletti

Periodically process and update documents in elasticsearch index

I need to come up with a strategy to process and update documents in an elasticsearch index periodically and efficiently. I do not have to look at documents that I processed before. My setting is that...
test-img

matthaeus

python

elasticsearch

cron

insert-update

elasticsearch-py

Votes: 0

Answers: 1

Latest Answer

I considered @Jay's comment and ended up with this pattern, for the moment: from elasticsearch import Elasticsearch from elasticsearch.helpers import bulk from elasticsearch.helpers import scan from ...
test-img

matthaeus

MongoDB, update an existing collection via aggregate

I have following mongodb collection { "_id" : "B0006ZPB0S", "title" : "Pretty Diamond-cut Black Hills Gold & Sterling Silver Rose Bud Women's Ring&qu...
test-img

Bubi

arrays

mongodb

concatenation

aggregate

insert-update

Votes: 0

Answers: 1

Latest Answer

This is likely the simplest way to get there. There's not an immediately clear reason to try create a subdoc reviewScore.1 vs. just flattening it into the main doc reviewScore_1. This setup also mak...
test-img

Buzz Moschetti

Posts

Questions

Blogs

Jobs