我如何使用猫鼬为以下产品设计架构? [英] How can i design Schema for below product using mongoose?
本文介绍了我如何使用猫鼬为以下产品设计架构?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
name: aaaa shirts
category: shirts
subcategory: [{
type: slimline,
model: [{
"type": "twill",
"colour": [{
"name": "red",
"image": "red.jpg"
},
{
"name": "white",
"image": "white.jpg"
}
],
"size": [{
"val": "32",
"price": "1000"
},
{
"val": "24",
"price": "1244"
}
]
},
{
"type": "denim",
"colour": [{
"name": "red",
"image": "red.jpg"
},
{
"name": "white",
"image": "white.jpg"
}
],
"size": [{
"val": "32",
"price": "1000"
},
{
"val": "24",
"price": "1244"
}
]
}
]
},
{
type: superslim,
model: [{
"type": "denim",
"colour": [{
"name": "red",
"image": "red.jpg"
},
{
"name": "white",
"image": "white.jpg"
}
],
"size": [{
"val": "32",
"price": "1000"
},
{
"val": "24",
"price": "1244"
}
]
},
{
"type": "dobby",
"colour": [{
"name": "red",
"image": "red.jpg"
},
{
"name": "white",
"image": "white.jpg"
}
],
"size": [{
"val": "32",
"price": "1000"
},
{
"val": "24",
"price": "1244"
}
]
}
]
}
]
以上是我要为此创建架构的产品设计示例.如何为上述产品创建架构.
Above is my product design example i want to create Schema for this .how can i create Schema for above product .
我如何修改我的架构设计
how can i modify my schema design
'use strict';
import mongoose from 'mongoose';
var Schema = mongoose.Schema,
ObjectId = Schema.ObjectId;
var ProductSchema = new mongoose.Schema({
name : String,
category : String,
subcategory : ??
description : String,
created_at : { type: Date },
updated_at : { type: Date, default: Date.now },
updated: {type: Date, default: Date.now}
}, { versionKey: false });
export default mongoose.model('Product', ProductSchema);
例如，我选择了苗条线，我需要发送带有图像和尺寸(28、30、32、36)的模型(斜纹布，牛仔布，多臂)，并根据颜色(红色，白色)选择颜色，我还需要更改基于所选颜色的衬衫图像 有人提出建议吗?帮助我前进
For example i select slimline i need to send model (twill , denim , dobby) with images and sizes(28,30,32,36) with color based on color(red , white) selection also i need to change the shirt image based on selected color any one give some suggestion ? help me out move forward
推荐答案
//Schema Defination and model.js
var ProductSchema = new mongoose.Schema({
name:String,
category:String,
subcategory:[{
type:String,
model:[{
type:String,
colour:[{
name:String,
image:String
}],
size:[{
val:Number,
price:Number
}]
}]
}],
description:String,
created_at:{ type: Date },
updated_at:{ type: Date, default: Date.now },
updated:{type: Date, default: Date.now}
}, { versionKey: false },{strict: false});
export default mongoose.model('Product', ProductSchema);
在数据库集合中存储产品详细信息 1.静态存储
Storing Product Details in Database Collection 1. Static Storing
//Static Storing into Database
var ProductSchema = require('path/to/ProductSchema.js');
app.post('/Store_Product_Details',function (req,res) {
var Name = 'Mens Formal Shirts';
var Category = 'Shirts';
var SubCategory = [{
type: "slimline",
model: [{
"type": "twill",
"colour": [{
"name": "red",
"image": "red.jpg"
},
{
"name": "white",
"image": "white.jpg"
}
],
"size": [{
"val": 32,
"price": "1000"
},
{
"val": 24,
"price": "1244"
}
]
}, {
"type": "denim",
"colour": [{
"name": "red",
"image": "red.jpg"
},
{
"name": "white",
"image": "white.jpg"
}
],
"size": [{
"val": 32,
"price": 1000
},
{
"val": 24,
"price": 1244
}
]
}
]
},{
type: "superslim",
model: [{
"type": "denim",
"colour": [{
"name": "red",
"image": "red.jpg"
},{
"name": "white",
"image": "white.jpg"
}
],
"size": [{
"val": 32,
"price": 1000
},{
"val": 24,
"price": 1244
}
]
},{
"type": "dobby",
"colour": [{
"name": "red",
"image": "red.jpg"
},
{
"name": "white",
"image": "white.jpg"
}
],
"size": [{
"val": 32,
"price": 1000
},
{
"val": 24,
"price": 1244
}
]
}
]
}
]
var Description = 'Mens Formal Wear';
var date = new Date();
var ProductData = new ProductSchema({
name:Name,
category:Category,
subcategory:SubCategory,
description:Description,
created_at:date
})
ProductData.save(function (err,Status) {
if(!err){
res.send("Product Stored Successfully");
}else {
res.send("Oops! Something went Wrong");
}
})
});
2.)动态存储/从控制器
2.) Dynamic Storing / From Controller
//Dynamically Storing or from Controller
var ProductSchema = require('path/to/ProductSchema.js');
app.post('/Store_Product_Details',function (req,res) {
var Name = req.body.Name;
var Category = req.body.Category;
var SubCategory = req.body.SubCategory;
var Description = req.body.Description;
var date = new Date();
var ProductData = new ProductSchema({
name:Name,
category:Category,
subcategory:SubCategory,
description:Description,
created_at:date
})
ProductData.save(function (err,Status) {
if(!err){
res.send("Product Stored Successfully");
}else {
res.send("Oops! Something went Wrong");
}
})
});
这篇关于我如何使用猫鼬为以下产品设计架构?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
