node.js - Array Manipulation with Mongoose -

-

i have schema employee , team. when update employee can change team. want happen update employee team id , remove employee every other team in database. employee can in 1 team business rule enforcing.

these abridged schemas working with.

employee schema

var employeeschema = new schema({   id: {     type: string,     required: true,     unique: true   },   team: {     type: schema.types.objectid,     ref: 'team'   } });

team schema

var teamschema = new schema({   name: {     type: string,     required: true   },   members: [{     type: schema.types.objectid,     ref: 'employee'   }] });

what want happen when change employees team, want remove employee every teams list of members, update employee's team reference, , update new team's array of members.

current code

var empmongoid = req.params.id; team.update({   $pull: {     members: {       _id:empmongoid     }   } }, {   multi: true }, function (err, numberaffected, raw) {   console.log(err, numberaffected, raw);   callback(null); })

this nothing , log null, 0, undefined.

as mentioned in comment, might want change schema team not contain reference employees, leaving reference on employee. removes need programatically "update" teams keep user lists in sync or construct crazy convoluted update queries.

so, schema this:

var employeeschema = new schema({     id: {         type: string,         required: true,         unique: true     },     team: {         type: schema.types.objectid,         ref: 'team'     } }); mongoose.model('employee', employeeschema)  var teamschema = new schema({     name: {         type: string,         required: true     } });  teamschema.methods.getemployees = function (fn) {     return this.model('employee').find({ team: this._id }, fn) }  mongoose.model('team', teamschema)

to use:

var team = ... //load team somehow team.getemployees(function (err, employees) {     //do list of employees });

the idea here schema enforces many-to-one relationship between employee , team. employee can part of 1 team definition in schema, team needs provide method search employees matching team id. team never directly holds references.

this more or less see in normal relational database well, same ideas can apply when using mongoose give "schema" non-relational schemaless database (which imo means should move database schema, mongodb cool in many ways queries , other stuff justify use in "schema'd" situation).


Comments

Post a Comment

Popular posts from this blog

C# random value from dictionary and tuple -

-
i have following code, , need random item contains string "region_1" dictionary. public static dictionary<int, tuple<string, int, currencytype>> itemarray = new dictionary<int, tuple<string, int, currencytype>>() { { 0xb3e, new tuple<string, int, currencytype>("region_1", 1500, currencytype.fame) } }; public static int generateitemid(string shopid) { var generateditem = itemarray.elementat(new random().next(0, itemarray.count)).key; } how select this? it's not possible efficiently... first create static random @ class level... prevent non-random behaviour if run query on short period of time... (it's seeded discrete clock) static random rnd = new random(); then: var item = itemarray.values .where(t => t.item1 == shopid) .orderby(_ => rnd.next()) .firstordefault()
Read more

cgi - How do I interpret URLs without extension as files rather than missing directories in nginx? -

-
so i'm trying install zoneminder , have run under nginx, has few compiled files need run using fast-cgi. these files lack extension. if file has extension, there no issue , nginx interprets file , return 404 if can't find it. if has no extension, assume it's directory , return 404 when can't find sort of index page. here have now: # security camera domain. server { listen 888; server_name mydomain.com; root /srv/http/zm; # enable php support. include php.conf; location / { index index.html index.htm index.php; } # enable cgi support. location ~ ^/cgi-bin/(.+)$ { alias /srv/cgi-bin/zm/; fastcgi_pass unix:/run/fcgiwrap.sock; fastcgi_param script_filename $document_root/$1; include fastcgi.conf; } } the idea is, under cgi-bin directory goes through fastcgi pipe. any idea on howi can fix this? upon closer inspection, realized zoneminder has 2 cgi sc...
Read more

.htaccess - htaccess convert request to clean url and add slash at the end of the url -

-
ok , searched more 4 days , more 20 posts here in stach or in websites without kind of success first here htaccess file rewriteengine on rewriterule ^([a-za-z0-9_]+)/?$ index.php?page=$1 [nc] rewriterule ^([a-za-z0-9_]+)\/([a-za-z0-9_]+)\/?$ index.php?page=$1&action=$2 [nc] i tried many codes 1 worked me can call request , works me www.example.com/pagename => www.example.com/index.php?page=pagename here questions , please provide me information "in detail" understand code well 1- how convert request automatically www.example.com/index.php?page=pagename www.example.com/pagename 2- if tried add slash @ end shows me page without images or styling mean www.example.com/pagename => works www.example.com/pagename/ => doesn't work that's :) for first part need 301 rule this: rewritecond %{the_request} /index\.php\?page=([^\s&]+) [nc] rewriterule ^ /%1? [r=301,l] for second part use absolute path in css, js, images files r...
Read more