mongodb how to maintain an unique array

Question

I am using $push to appends a value to an array.

connection.erp_datasets.erp_datasets.update_one({'erp_name': 'erp1'},
                                            {'$push': {'data_set': 'database1'}}, upsert=True)

The problem is whenever I run the query again, multiple erp1 will be appended to the list,

"data_set" : [ 
    "erp1", 
    "erp1"
]

I am wondering how to maintain the array with unique values. so it doesn't matter how many times I executed the above query,data_set will only contain one erp1,

"data_set" : [ 
    "erp1"
]

bgraham · Accepted Answer · 2017-09-22 15:01:42Z

2

use $addToSet

connection.erp_datasets.erp_datasets.update_one({'erp_name': 'erp1'}, {'$addToSet': {'data_set': 'database1'}}, upsert=True)

answered Sep 22, 2017 at 15:01

bgraham

2,0371 gold badge13 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mongodb how to maintain an unique array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related