Best way to prepare hierarchical data for easy querying in MongoDB? -

-

i'm starting use mongodb new project , wanted insert customer data using scheme:

{     admin: {mail: "", realname: {first: "", last: ""}, address: {street: "", city: "", state: ""}, payment: {type: "", blz: "", account: ""}},     users: [         {mail: "", password: "", realname: {first: "", last: ""}},         ...     ],     categories: [         {name: "", assignedusers: [{id: "", readonly: true}, ...], entries: [             {name: "", tags: "", site: "", user: "", pass: "", notes: ""}         ],         ...     ] }

however, i've found out isn't possible to, example, 1 of users in "users" array it's mail address or categories 1 user assigned id.

so seems i'd have split hierarchical data multiple collections, i'm not sure best way is. how recommend me split data?

  • you locking projection , this. optional operator specifies fields return using projection operators , it's boolean 1 - show & 0 - hide

    db.customers.findone({"users.mail": "mail@address.org"}, {users: 1})

  • that's not secure use findone({"users.mail": "mail"}) authentication, there special node.js module passportjs.


Comments

Post a Comment

Popular posts from this blog

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more