use custom primary key instead of "_id" ?

[Yang Y]

we want to use mongoimport to import into our mongodb,

the import process ***updates*** existing entries with the same key.

for example , in db, we have
{ name:"joe", salary:"100"}


and the new import data contains

{name:"joe", salary:"101"}

we want the old data to be update/overwritten, instead of adding a
second entry for {name:"joe"}


we could do this by setting {_id: } to be the same value as name:
field.


but the problem is that the input data we have come from an upstream
job, and it's bad to expose the internal logic of mongo to the output
of that stage; instead we know that the "name" will always be the
unique field.

so in this case, how can we tell mongo to use "name" as the unique
field, instead of "_id" ?? (I tried creating an unique index on
"name", but it does not allow overwrite, but just fails on save()
with the same key )


Thanks a lot
Yang

[Gaetan Voyer-Perrault]

Take a look here:

http://www.mongodb.org/display/DOCS/Import+Export+Tools#ImportExportTools-mongoimport

mongoimport supports a --upsertFields arg

--upsertFields arg      comma-separated fields for the query part of the
                          upsert. You should make sure this is indexed.

I believe this is what you are looking for.

- Gates 

--
You received this message because you are subscribed to the Google Groups "mongodb-user" group.
To post to this group, send email to mongod...@googlegroups.com.
To unsubscribe from this group, send email to mongodb-user...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/mongodb-user?hl=en.

[Yang]

exactly, thanks!