开发者

Is this query possible in nosql (with mongodb)?

开发者 https://www.devze.com 2023-02-23 06:04 出处:网络
I use mongoose in my node.js app, and basically have the following models: // Define Car model CarSchema = new Schema({

I use mongoose in my node.js app, and basically have the following models:

// Define Car model
CarSchema = new Schema({
  brand  : String,
  type: String,    
  maxSpeed : Number
});
mongoose.model('Car', CarSchema);
// Define User model
UserSchema = new Schema({
  lastname        : String,
  firstname : String,
  cars   : [CarSchema]
});
mongoose.model('User', UserSchema);

I'm really new to NoSQL and I really want to give it a try but I first need to study if this really fits my needs.

With the above models, will I be able to create a query listing all the Users who have a particular type of c开发者_Go百科ar among their personal cars ?


I don't how to do it in mongoose. But in mongodb it possible. So, in mongodb shell query will looks like this:

db.users.find({"cars.type":"sport"})

Above query return all users thats have car with type 'sport' in their nested collection of cars.

Mongodb dot notation documentation.

0

精彩评论

暂无评论...
验证码 换一张
取 消