var userSchema = new mongoose.Schema({
name: String,
email: String,
createdOn: Date
});
//ObjectId就类似于唯一键值
projectSchema.add({
owner: mongoose.Schema.Types.ObjectId
});
//混合类型,顾名思义,就是说里面可以放置任意类型的数据,有两种方式创建该类型数据
//方式一:直接赋予一个空的字面量对象
vardjSchema= new mongoose.Schema({
mixedUp: {}
});
//方式二:根据Schemas.Types中值来赋予
vardjSchema= new mongoose.Schema({
mixedUp: Schema.Types.Mixed
});
//Array类型数据有两种创建方式,一种是简单数组创建:
var userSchema = new mongoose.Schema({
name: String,
emailAddresses: [String]
});
//第二种方式就是复杂类型数据数组,例如我们可以再数组中添加不同类型的schemas:
var emailSchema = new mongoose.Schema({
email: String,
verified: Boolean
});
var userSchema = new mongoose.Schema({
name: String,
emailAddresses: [emailSchema]
});
//注意:如果定义一个空的数据的话,则会创建为一个混合类型数据的数组:
var emailSchema = new mongoose.Schema({
email: String,
verified: Boolean
});
var userSchema = new mongoose.Schema({
name: String,
emailAddresses: [emailSchema]
});
projectSchema.statics.findByUserID = function (userid, callback) {
this.find({ createdBy: userid }, '_id projectName', {sort: 'modifiedOn'}, callback);
};
Model.findByUserID(userid,callback);
//路由规则:app.get('/project/byuser/:userid', project.byUser);
exports.byUser = function (req, res) {
console.log("Getting user projects");
if (req.params.userid){
Project.findByUserID(req.params.userid,function (err, projects) {
if(!err){
console.log(projects);
res.json(projects);
}else{
console.log(err);
res.json({"status":"error", "error":"Error finding projects"});
}
});
}else{
console.log("No user id supplied");
res.json({"status":"error", "error":"No user id supplied"});
}
};
Mongoose.Model('User', userSchema);
//方式一:
var dbURI = 'mongodb://localhost/mydatabase';
mongoose.connect(dbURI);
//方式二:
var dbURI = 'mongodb://localhost/myadmindatabase';
var adminConnection = mongoose.createConnection(dbURI);
//如果需要声明端口号:
var dbURI = 'mongodb://localhost:27018/mydatabase';
//如果需要定义用户名和密码:
var dbURI = 'mongodb://username:password@localhost/mydatabase';
//也可以像下面这样传一个对象类型的参数:
var dbURI = 'mongodb://localhost/mydatabase';
var dbOptions = {'user':'db_username','pass':'db_password'};
mongoose.connect(dbURI, dbOptions);
adminConnection.model( 'User', userSchema );
//方式一,在创建schema的时候定义collection的名字:
var userSchema = new mongoose.Schema({
name: String,
email: {type: String, unique:true}
},
{
collection: 'myuserlist'
});
//方式二,在创建Model的时候定义collection的名字:
mongoose.model( 'User', userSchema, 'myuserlist' );
var user = new User({ name: 'Simon' });
user.save(function (err) {
if (err) return handleError(err);
});
User.findOne({'name' : 'Sally', function(err,user) {
if(!err){
console.log(user);
}
});
User.find({}, function(err, users) {
if(!err){
console.log(users);
}
});
var newUser = new User({
name: 'Simon Holmes',
email: 'simon@theholmesoffice.com',
lastLogin : Date.now()
}).save( function( err ){
if(!err){
console.log('User saved!');
}
});
User.create({
name: 'Simon Holmes',
email: 'simon@theholmesoffice.com',
lastLogin : Date.now()
}, function( err, user ){
if(!err){
console.log('User saved!');
console.log('Saved user name: ' + user.name);
console.log('_id of saved user: ' + user._id);
}
});
var myQuery = User.find({'name' : 'Simon Holmes'});
myQuery.where('age').gt(18);
myQuery.sort('-lastLogin');
myQuery.select('_id name email');
myQuery.exec(function (err, users){
if (!err){
console.log(users); // output array of users found
}
});
User.find({'name' : 'Simon Holmes'})
.where('age').gt(18)
.sort('-lastLogin')
.select('_id name email')
.exec(function (err, users){
if (!err){
console.log(users); // output array of users found
}
});
Model.find(conditions, [fields], [options], [callback])
User.find({'name', 'simon holmes'}, function(err, user) {});
User.find({'name', 'simon holmes'}, 'name email',function(err, user) {
//console.log('some thing');
});
User.find({'name' : 'Simon Holmes'},
null, // 如果使用null,则会返回所有的字段值
{sort : {lastLogin : -1}}, // 降序排序
function (err, users){
if (!err){console.log(users);}
});
Model.find(query); Model.findOne(query);//返回查找到的所有实例的第一个 Model.findById(ObjectID);//根据ObjectId查找到唯一实例
User.findOne({'email' : req.body.Email},
'_id name email',
function(err, user) {
//todo
});
//在update方法中,options的可选设置为:
{
safe:true|false, //声明是否返回错误信息,默认true
upsert:false|true, //声明如果查询不到需要更新的数据项,是否需要新插入一条记录,默认false
multi:false|true, //声明是否可以同时更新多条记录,默认false
strict:true|false //声明更新的数据中是否可以包含在schema定义之外的字段数据,默认true
}
//对于findOneAndUpdate、findByIdAndUpdate这两个方法,他们的options可选设置项为:
{
new:true|false, //声明返回的数据时更新后的该是更新前的,如果为true则返回更新后的,默认true
upsert:false|trure,
sort:javascriptObject, //如果查询返回多个文档记录,则可以进行排序,在这里是根据传入的javascript object对象进行排序
select:String //这里声明要返回的字段,值是一个字符串
}
User.update({_id:user._id},{$set: {lastLogin: Date.now()}},function(){});
remove(); findOneAndRemove(); findByIdAndRemove();
User.remove({ name : /Simon/ } , function (err){
if (!err){
// 删除名字中包含simon的所有用户
}
});
User.findOne({ email : 'simon@theholmesoffice.com'},function (err,user){
if (!err){
user.remove( function(err){
// 删除匹配到该邮箱的第一个用户
});
}
});
User.findOneAndRemove({name : /Simon/},{sort : 'lastLogin', select : 'name email'},function (err, user){
if (!err) {
console.log(user.name + " removed");
// Simon Holmes removed
};
});
User.findByIdAndRemove(req.body._id,function (err, user) {
if(err){
console.log(err);
return;
}
console.log("User deleted:", user);
});
email: { type: String, unique: true, required: true }
var teenSchema = new Schema({
age : {type: Number, min: 13, max:19}
});
var weekdaySchema = new Schema({
day : {type: String, match: /^(mon|tues|wednes|thurs|fri)day$/i}
});
var weekdays = ['monday', 'tuesday', 'wednesday', 'thursday','friday'];
var weekdaySchema = new Schema({
day : {type: String, enum: weekdays}
});
{
message: 'Validation failed',
name: 'ValidationError',
errors:{
email:{
message: 'Validator "required" failed for path email',
name: 'ValidatorError',
path: 'email',
type: 'required'
},
name:{
message: 'Validator "required" failed for path name',
name: 'ValidatorError',
path: 'name',
type: 'required'
}
}
}
if(err){
Object.keys(err.errors).forEach(function(key) {
var message = err.errors[key].message;
console.log('Validation error for "%s": %s', key, message);
});
}
var lengthValidator = function(val) {
if (val && val.length >= 5){
return true;
}
return false;
};
//usage:
name: {type: String, required: true, validate: lengthValidator }
//code 1
validate: { validator: lengthValidator, msg: 'Too short' }
//code 2
var weekdaySchema = new Schema({
day : {type: String, validate: {validator:/^(mon|tues|wednes|thurs|fri)day$/i, msg: 'Not a day' }
});
var validateLength = [lengthValidator, 'Too short' ];
var validateDay = [/^(mon|tues|wednes|thurs|fri)day$/i, 'Not a day' ];
//usage:
name: {type: String, required: true, validate: validateLength }
day : {type: String, validate: validateDay }
var validateLength = [
{validator: lengthValidator, msg: 'Too short'}
];
var validateUsername = [
{validator: lengthValidator, msg: 'Too short'} ,
{validator: /^[a-z]+$/i, msg: 'Letters only'}
];
userSchema.path('name').validate(lengthValidator, 'Too short');
userSchema.path('name').validate(/^[a-z]+$/i, 'Letters only');
机械节能产品生产企业官网模板...
大气智能家居家具装修装饰类企业通用网站模板...
礼品公司网站模板
宽屏简约大气婚纱摄影影楼模板...
蓝白WAP手机综合医院类整站源码(独立后台)...苏ICP备2024110244号-2 苏公网安备32050702011978号 增值电信业务经营许可证编号:苏B2-20251499 | Copyright 2018 - 2025 源码网商城 (www.ymwmall.com) 版权所有