This article briefly introduces databases, and how to use them with Node/Express apps. It then goes on to show how we can use Mongoose to provide database access for the LocalLibrary website. It explains how object schema and models are declared, the main field types, and basic validation. It also briefly shows a few of the main ways in which you can access model data.
| Prerequisites: | Express Tutorial Part 2: Creating a skeleton website |
|---|---|
| Objective: | To be able to design and create your own models using Mongoose. |
Library staff will use the Local Library website to store information about books and borrowers, while library members will use it to browse and search for books, find out whether there are any copies available, and then reserve or borrow them. In order to store and retrieve information efficiently, we will store it in a database .
Express apps can use many different databases, and there are several approaches you can use for performing C reate, R ead, U pdate and D elete (CRUD) operations. This tutorial provides a brief overview of some of the available options and then goes on to show in detail the particular mechanisms selected.
Express apps can use any database supported by 节点 ( Express itself doesn't define any specific additional behavior/requirements for database management). There are many popular options , including PostgreSQL, MySQL, Redis, SQLite, and MongoDB.
When choosing a database, you should consider things like time-to-productivity/learning curve, performance, ease of replication/backup, cost, community support, etc. While there is no single "best" database, almost any of the popular solutions should be more than acceptable for a small-to-medium-sized site like our Local Library.
For more information on the options see Database integration (Express docs).
There are two common approaches for interacting with a database:
The very best 性能 can be gained by using SQL, or whatever query language is supported by the database. ODM's are often slower because they use translation code to map between objects and the database format, which may not use the most efficient database queries (this is particularly true if the ODM supports different database backends, and must make greater compromises in terms of what database features are supported).
The benefit of using an ORM is that programmers can continue to think in terms of JavaScript objects rather than database semantics — this is particularly true if you need to work with different databases (on either the same or different websites). They also provide an obvious place to perform data validation.
注意： Using ODM/ORMs often results in lower costs for development and maintenance! Unless you're very familiar with the native query language or performance is paramount, you should strongly consider using an ODM.
There are many ODM/ORM solutions available on the NPM package manager site (check out the odm and orm tags for a subset!).
A few solutions that were popular at the time of writing are:
As a general rule, you should consider both the features provided and the "community activity" (downloads, contributions, bug reports, quality of documentation, etc.) when selecting a solution. At the time of writing Mongoose is by far the most popular ODM, and is a reasonable choice if you're using MongoDB for your database.
对于 Local Library example (and the rest of this topic) we're going to use the Mongoose ODM to access our library data. Mongoose acts as a front end to MongoDB , an open source NoSQL database that uses a document-oriented data model. A “collection” of “documents” in a MongoDB database is analogous to a “table” of “rows” in a relational database.
This ODM and database combination is extremely popular in the Node community, partially because the document storage and query system looks very much like JSON, and is hence familiar to JavaScript developers.
注意： You don't need to know MongoDB in order to use Mongoose, although parts of the Mongoose documentation are easier to use and understand if you are already familiar with MongoDB.
The rest of this tutorial shows how to define and access the Mongoose schema and models for the LocalLibrary website 范例。
Before you jump in and start coding the models, it's worth taking a few minutes to think about what data we need to store and the relationships between the different objects.
We know that we need to store information about books (title, summary, author, genre, ISBN) and that we might have multiple copies available (with globally unique ids, availability statuses, etc.). We might need to store more information about the author than just their name, and there might be multiple authors with the same or similar names. We want to be able to sort information based on the book title, author, genre, and category.
When designing your models it makes sense to have separate models for every "object" (a group of related information). In this case some obvious candidates for these models are books, book instances, and authors.
You might also want to use models to represent selection-list options (e.g. like a drop-down list of choices), rather than hard-coding the choices into the website itself — this is recommended when all the options aren't known up front or may change. A good example is a genre (e.g. fantasy, science fiction, etc.).
Once we've decided on our models and fields, we need to think about the relationships between them.
With that in mind, the UML association diagram below shows the models we'll define in this case (as boxes). As discussed above, we've created models for the book (the generic details of the book), book instance (status of specific physical copies of the book available in the system), and author. We have also decided to have a model for the genre so that values can be created dynamically. We've decided not to have a model for the
BookInstance:status
— we will hard code the acceptable values because we don't expect these to change. Within each of the boxes, you can see the model name, the field names and types, and also the methods and their return types.
The diagram also shows the relationships between the models, including their
multiplicities
. The multiplicities are the numbers on the diagram showing the numbers (maximum and minimum) of each model that may be present in the relationship. For example, the connecting line between the boxes shows that
Book
和
Genre
are related. The numbers close to the
Book
model show that a
Genre
must have zero or more
Book
s (as many as you like), while the numbers on the other end of the line next to the
Genre
show that a book can have zero or more associated
Genre
。
注意：
As discussed in our
Mongoose primer
below it is often better to have the field that defines the relationship between the documents/models in just
one
model (you can still find the reverse relationship by searching for the associated
_id
in the other model). Below we have chosen to define the relationship between
Book
/
Genre
and
Book
/
作者
in the Book schema, and the relationship between the
Book
/
BookInstance
在
BookInstance
Schema. This choice was somewhat arbitrary — we could equally well have had the field in the other schema.
注意： The next section provides a basic primer explaining how models are defined and used. As you read it, consider how we will construct each of the models in the diagram above.
This section provides an overview of how to connect Mongoose to a MongoDB database, how to define a schema and a model, and how to make basic queries.
注意： This primer is heavily influenced by the Mongoose quick start on npm 和 官方文档编制 .
Mongoose is installed in your project ( package.json ) like any other dependency — using NPM. To install it, use the following command inside your project folder:
npm install mongoose
安装 Mongoose adds all its dependencies, including the MongoDB database driver, but it does not install MongoDB itself. If you want to install a MongoDB server then you can download installers from here for various operating systems and install it locally. You can also use cloud-based MongoDB instances.
注意： For this tutorial, we'll be using the MongoDB Atlas cloud-based database as a service free tier to provide the database. This is suitable for development and makes sense for the tutorial because it makes "installation" operating system independent (database-as-a-service is also one approach you might use for your production database).
Mongoose
requires a connection to a MongoDB database. You can
require()
and connect to a locally hosted database with
mongoose.connect()
, as shown below.
//Import the mongoose module
var mongoose = require('mongoose');
//Set up default mongoose connection
var mongoDB = 'mongodb://127.0.0.1/my_database';
mongoose.connect(mongoDB, {useNewUrlParser: true, useUnifiedTopology: true});
//Get the default connection
var db = mongoose.connection;
//Bind connection to error event (to get notification of connection errors)
db.on('error', console.error.bind(console, 'MongoDB connection error:'));
You can get the default
Connection
对象采用
mongoose.connection
. Once connected, the open event is fired on the
Connection
实例。
注意：
If you need to create additional connections you can use
mongoose.createConnection()
. This takes the same form of database URI (with host, database, port, options etc.) as
connect()
并返回
Connection
对象)。
Models are
defined
使用
Schema
interface. The Schema allows you to define the fields stored in each document along with their validation requirements and default values. In addition, you can define static and instance helper methods to make it easier to work with your data types, and also virtual properties that you can use like any other field, but which aren't actually stored in the database (we'll discuss a bit further below).
Schemas are then "compiled" into models using the
mongoose.model()
method. Once you have a model you can use it to find, create, update, and delete objects of the given type.
注意：
Each model maps to a
collection
of
documents
in the MongoDB database. The documents will contain the fields/schema types defined in the model
Schema
.
The code fragment below shows how you might define a simple schema. First you
require()
mongoose, then use the Schema constructor to create a new schema instance, defining the various fields inside it in the constructor's object parameter.
//Require Mongoose
var mongoose = require('mongoose');
//Define a schema
var Schema = mongoose.Schema;
var SomeModelSchema = new Schema({
a_string: String,
a_date: Date
});
In the case above we just have two fields, a string and a date. In the next sections, we will show some of the other field types, validation, and other methods.
Models are created from schemas using the
mongoose.model()
方法：
// Define schema
var Schema = mongoose.Schema;
var SomeModelSchema = new Schema({
a_string: String,
a_date: Date
});
// Compile model from schema
var SomeModel = mongoose.model('SomeModel', SomeModelSchema );
The first argument is the singular name of the collection that will be created for your model (Mongoose will create the database collection for the above model SomeModel above), and the second argument is the schema you want to use in creating the model.
注意： Once you've defined your model classes you can use them to create, update, or delete records, and run queries to get all records or particular subsets of records. We'll show you how to do this in the Using models section, and when we create our views.
A schema can have an arbitrary number of fields — each one represents a field in the documents stored in MongoDB . An example schema showing many of the common field types and how they are declared is shown below.
var schema = new Schema(
{
name: String,
binary: Buffer,
living: Boolean,
updated: { type: Date, default: Date.now() },
age: { type: Number, min: 18, max: 65, required: true },
mixed: Schema.Types.Mixed,
_someId: Schema.Types.ObjectId,
array: [],
ofString: [String], // You can also have an array of each of the other types too.
nested: { stuff: { type: String, lowercase: true, trim: true } }
})
Most of the SchemaTypes (the descriptors after “type:” or after field names) are self-explanatory. The exceptions are:
ObjectId
: Represents specific instances of a model in the database. For example, a book might use this to represent its author object. This will actually contain the unique ID (
_id
) for the specified object. We can use the
populate()
method to pull in the associated information when needed.
Mixed
: An arbitrary schema type.
[]
: An array of items. You can perform JavaScript array operations on these models (push, pop, unshift, etc.). The examples above show an array of objects without a specified type and an array of
字符串
objects, but you can have an array of any type of object.
The code also shows both ways of declaring a field:
名称
,
binary
and
living
).
type
, and any other
选项
for the field. Options include things like:
字符串
fields should automatically be set to lowercase, uppercase, or trimmed (e.g.
{ type: String, lowercase: true, trim: true }
)
For more information about options see SchemaTypes (Mongoose docs).
Mongoose provides built-in and custom validators, and synchronous and asynchronous validators. It allows you to specify both the acceptable range of values and the error message for validation failure in all cases.
The built-in validators include:
The example below (slightly modified from the Mongoose documents) shows how you can specify some of the validator types and error messages:
var breakfastSchema = new Schema({
eggs: {
type: Number,
min: [6, 'Too few eggs'],
max: 12,
required: [true, 'Why no eggs?']
},
drink: {
type: String,
enum: ['Coffee', 'Tea', 'Water',]
}
});
For complete information on field validation see 验证 (Mongoose docs).
Virtual properties are document properties that you can get and set but that do not get persisted to MongoDB. The getters are useful for formatting or combining fields, while setters are useful for de-composing a single value into multiple values for storage. The example in the documentation constructs (and deconstructs) a full name virtual property from a first and last name field, which is easier and cleaner than constructing a full name every time one is used in a template.
注意：
We will use a virtual property in the library to define a unique URL for each model record using a path and the record's
_id
值。
更多信息见 Virtuals (Mongoose documentation).
A schema can also have
instance methods
,
static methods
，和
query helpers
. The instance and static methods are similar, but with the obvious difference that an instance method is associated with a particular record and has access to the current object. Query helpers allow you to extend mongoose's
chainable query builder API
(for example, allowing you to add a query "byName" in addition to the
find()
,
findOne()
and
findById()
方法)。
Once you've created a schema you can use it to create models. The model represents a collection of documents in the database that you can search, while the model's instances represent individual documents that you can save and retrieve.
We provide a brief overview below. For more information see: 模型 (Mongoose docs).
To create a record you can define an instance of the model and then call
save()
. The examples below assume SomeModel is a model (with a single field "name") that we have created from our schema.
// Create an instance of model SomeModel
var awesome_instance = new SomeModel({ name: 'awesome' });
// Save the new model instance, passing a callback
awesome_instance.save(function (err) {
if (err) return handleError(err);
// saved!
});
Creation of records (along with updates, deletes, and queries) are asynchronous operations — you supply a callback that is called when the operation completes. The API uses the error-first argument convention, so the first argument for the callback will always be an error value (or null). If the API returns some result, this will be provided as the second argument.
还可以使用
create()
to define the model instance at the same time as you save it. The callback will return an error for the first argument and the newly-created model instance for the second argument.
SomeModel.create({ name: 'also_awesome' }, function (err, awesome_instance) {
if (err) return handleError(err);
// saved!
});
Every model has an associated connection (this will be the default connection when you use
mongoose.model()
). You create a new connection and call
.model()
on it to create the documents on a different database.
You can access the fields in this new record using the dot syntax, and change the values. You have to call
save()
or
update()
to store modified values back to the database.
// Access model field values using dot notation
console.log(awesome_instance.name); //should log 'also_awesome'
// Change record by modifying the fields, then calling save().
awesome_instance.name="New cool name";
awesome_instance.save(function (err) {
if (err) return handleError(err); // saved!
});
You can search for records using query methods, specifying the query conditions as a JSON document. The code fragment below shows how you might find all athletes in a database that play tennis, returning just the fields for athlete name and age . Here we just specify one matching field (sport) but you can add more criteria, specify regular expression criteria, or remove the conditions altogether to return all athletes.
var Athlete = mongoose.model('Athlete', yourSchema);
// find all athletes who play tennis, selecting the 'name' and 'age' fields
Athlete.find({ 'sport': 'Tennis' }, 'name age', function (err, athletes) {
if (err) return handleError(err);
// 'athletes' contains the list of athletes that match the criteria.
})
If you specify a callback, as shown above, the query will execute immediately. The callback will be invoked when the search completes.
注意：
All callbacks in Mongoose use the pattern
callback(error, result)
. If an error occurs executing the query, the
error
parameter will contain an error document and
result
will be null. If the query is successful, the
error
parameter will be null, and the
result
will be populated with the results of the query.
注意：
It is important to remember that not finding any results is
not an error
for a search —but it may be a fail-case in the context of your application. If your application expects a search to find a value you can either check the result in the callback (
results==null
) or daisy chain the
orFail()
method on the query.
If you don't specify a callback then the API will return a variable of type
Query
. You can use this query object to build up your query and then execute it (with a callback) later using the
exec()
方法。
// find all athletes that play tennis
var query = Athlete.find({ 'sport': 'Tennis' });
// selecting the 'name' and 'age' fields
query.select('name age');
// limit our results to 5 items
query.limit(5);
// sort by age
query.sort({ age: -1 });
// execute the query at a later time
query.exec(function (err, athletes) {
if (err) return handleError(err);
// athletes contains an ordered list of 5 athletes who play Tennis
})
Above we've defined the query conditions in the
find()
method. We can also do this using a
where()
function, and we can chain all the parts of our query together using the dot operator (.) rather than adding them separately. The code fragment below is the same as our query above, with an additional condition for the age.
Athlete.
find().
where('sport').equals('Tennis').
where('age').gt(17).lt(50). //Additional where query
limit(5).
sort({ age: -1 }).
select('name age').
exec(callback); // where callback is the name of our callback function.
find() method gets all matching records, but often you just want to get one match. The following methods query for a single record:
findById()
: Finds the document with the specified
id
(every document has a unique
id
).
findOne()
: Finds a single document that matches the specified criteria.
findByIdAndRemove()
,
findByIdAndUpdate()
,
findOneAndRemove()
,
findOneAndUpdate()
: Finds a single document by
id
or criteria and either updates or removes it. These are useful convenience functions for updating and removing records.
注意：
There is also a
count()
method that you can use to get the number of items that match conditions. This is useful if you want to perform a count without actually fetching the records.
There is a lot more you can do with queries. For more information see: 查询 (Mongoose docs).
You can create references from one document/model instance to another using the
ObjectId
schema field, or from one document to many using an array of
ObjectIds
. The field stores the id of the related model. If you need the actual content of the associated document, you can use the
populate()
method in a query to replace the id with the actual data.
For example, the following schema defines authors and stories.
Each author can have multiple stories, which we represent as an array of
ObjectId
.
Each story can have a single author.
ref
property tells the schema which model can be assigned to this field.
var mongoose = require('mongoose')
, Schema = mongoose.Schema
var authorSchema = Schema({
name : String,
stories : [{ type: Schema.Types.ObjectId, ref: 'Story' }]
});
var storySchema = Schema({
author : { type: Schema.Types.ObjectId, ref: 'Author' },
title : String
});
var Story = mongoose.model('Story', storySchema);
var Author = mongoose.model('Author', authorSchema);
We can save our references to the related document by assigning the
_id
值。
Below we create an author, then a story, and assign the author id to our story's author field.
var bob = new Author({ name: 'Bob Smith' });
bob.save(function (err) {
if (err) return handleError(err);
//Bob now exists, so lets create a story
var story = new Story({
title: "Bob goes sledding",
author: bob._id // assign the _id from our author Bob. This ID is created by default!
});
story.save(function (err) {
if (err) return handleError(err);
// Bob now has his story
});
});
Our story document now has an author referenced by the author document's ID. In order to get the author information in the story results we use
populate()
, as shown below.
Story
.findOne({ title: 'Bob goes sledding' })
.populate('author') //This populates the author id with actual author information!
.exec(function (err, story) {
if (err) return handleError(err);
console.log('The author is %s', story.author.name);
// prints "The author is Bob Smith"
});
注意：
Astute readers will have noted that we added an author to our story, but we didn't do anything to add our story to our author's
stories
array. How then can we get all stories by a particular author? One way would be to add our story to the stories array, but this would result in us having two places where the information relating authors and stories needs to be maintained.
A better way is to get the
_id
of our
作者
, then use
find()
to search for this in the author field across all stories.
Story
.find({ author : bob._id })
.exec(function (err, stories) {
if (err) return handleError(err);
// returns all stories that have Bob's id as their author.
});
This is almost everything you need to know about working with related items for this tutorial . For more detailed information see Population (Mongoose docs).
While you can create schemas and models using any file structure you like, we highly recommend defining each model schema in its own module (file), then exporting the method to create the model. This is shown below:
// File: ./models/somemodel.js
//Require Mongoose
var mongoose = require('mongoose');
//Define a schema
var Schema = mongoose.Schema;
var SomeModelSchema = new Schema({
a_string: String,
a_date: Date,
});
//Export function to create "SomeModel" model class
module.exports = mongoose.model('SomeModel', SomeModelSchema );
You can then require and use the model immediately in other files. Below we show how you might use it to get all instances of the model.
//Create a SomeModel model just by requiring the module
var SomeModel = require('../models/somemodel')
// Use the SomeModel object (model) to find all SomeModel records
SomeModel.find(callback_function);
Now that we understand something of what Mongoose can do and how we want to design our models, it's time to start work on the LocalLibrary website. The very first thing we want to do is set up a MongoDB database that we can use to store our library data.
For this tutorial, we're going to use the MongoDB Atlas free cloud-hosted sandbox database. This database tier is not considered suitable for production websites because it has no redundancy, but it is great for development and prototyping. We're using it here because it is free and easy to set up, and because MongoDB Atlas is a popular database as a service vendor that you might reasonably choose for your production database (other popular choices at the time of writing include Compose , ScaleGrid and ObjectRocket ).
注意： If you prefer you can set up a MongoDb database locally by downloading and installing the appropriate binaries for your system . The rest of the instructions in this article would be similar, except for the database URL you would specify when connecting. Note, however, that the Express Tutorial Part 7: Deploying to Production tutorial requires some form of remote database, since the free tier of the Heroku service does not provide persistent storage. It is therefore highly recommended to use MongoDB Atlas .
You will first need to create an account with MongoDB Atlas (this is free, and just requires that you enter basic contact details and acknowledge their terms of service).
After logging in, you'll be taken to the home screen:
local_library
.
Collection0
.
0.0.0.0/0
pre-seeded for the IP Address. Click the
Add IP Address
按钮。
注意： It is a best practice to limit the IP addresses that can connect to your database and other resources. Here we allow a connection from anywhere because we don't know where the request will come from after deployment.
注意： Avoid using special characters in your MongoDB user password as mongoose may not parse the connection string properly.
local_library
.
You have now created the database, and have a URL (with username and password) that can be used to access it. This will look something like:
mongodb+srv://your_user_name:your_password@cluster0.a9azn.mongodb.net/local_library?retryWrites=true
Open a command prompt and navigate to the directory where you created your skeleton Local Library website . Enter the following command to install Mongoose (and its dependencies) and add it to your package.json file, unless you have already done so when reading the Mongoose Primer above.
npm install mongoose
打开
/app.js
(in the root of your project) and copy the following text below where you declare the
Express application object
(after the line
var app = express();
). Replace the database url string ('
insert_your_database_url_here
') with the location URL representing your own database (i.e. using the information from
mongoDB Atlas
).
//Set up mongoose connection
var mongoose = require('mongoose');
var mongoDB = 'insert_your_database_url_here';
mongoose.connect(mongoDB, { useNewUrlParser: true , useUnifiedTopology: true});
var db = mongoose.connection;
db.on('error', console.error.bind(console, 'MongoDB connection error:'));
As discussed in the Mongoose primer above , this code creates the default connection to the database and binds to the error event (so that errors will be printed to the console).
We will define a separate module for each model, as discussed above . Start by creating a folder for our models in the project root ( /models ) and then create separate files for each of the models:
/express-locallibrary-tutorial //the project root
/models
author.js
book.js
bookinstance.js
genre.js
拷贝
作者
schema code shown below and paste it into your
./models/author.js
文件。
The schema defines an author as having
字符串
SchemaTypes for the first and family names (required, with a maximum of 100 characters), and
日期
fields for the dates of birth and death.
var mongoose = require('mongoose');
var Schema = mongoose.Schema;
var AuthorSchema = new Schema(
{
first_name: {type: String, required: true, maxLength: 100},
family_name: {type: String, required: true, maxLength: 100},
date_of_birth: {type: Date},
date_of_death: {type: Date},
}
);
// Virtual for author's full name
AuthorSchema
.virtual('name')
.get(function () {
// To avoid errors in cases where an author does not have either a family name or first name
// We want to make sure we handle the exception by returning an empty string for that case
var fullname = '';
if (this.first_name && this.family_name) {
fullname = this.family_name + ', ' + this.first_name
}
if (!this.first_name || !this.family_name) {
fullname = '';
}
return fullname;
});
// Virtual for author's lifespan
AuthorSchema.virtual('lifespan').get(function() {
var lifetime_string = '';
if (this.date_of_birth) {
lifetime_string = this.date_of_birth.getYear().toString();
}
lifetime_string += ' - ';
if (this.date_of_death) {
lifetime_string += this.date_of_death.getYear()
}
return lifetime_string;
});
// Virtual for author's URL
AuthorSchema
.virtual('url')
.get(function () {
return '/catalog/author/' + this._id;
});
//Export model
module.exports = mongoose.model('Author', AuthorSchema);
We've also declared a virtual for the AuthorSchema named "url" that returns the absolute URL required to get a particular instance of the model — we'll use the property in our templates whenever we need to get a link to a particular author.
注意： Declaring our URLs as a virtual in the schema is a good idea because then the URL for an item only ever needs to be changed in one place. At this point, a link using this URL wouldn't work, because we haven't got any routes handling code for individual model instances. We'll set those up in a later article!
At the end of the module, we export the model.
拷贝
Book
schema code shown below and paste it into your
./models/book.js
文件。
Most of this is similar to the author model — we've declared a schema with a number of string fields and a virtual for getting the URL of specific book records, and we've exported the model.
var mongoose = require('mongoose');
var Schema = mongoose.Schema;
var BookSchema = new Schema(
{
title: {type: String, required: true},
author: {type: Schema.Types.ObjectId, ref: 'Author', required: true},
summary: {type: String, required: true},
isbn: {type: String, required: true},
genre: [{type: Schema.Types.ObjectId, ref: 'Genre'}]
}
);
// Virtual for book's URL
BookSchema
.virtual('url')
.get(function () {
return '/catalog/book/' + this._id;
});
//Export model
module.exports = mongoose.model('Book', BookSchema);
The main difference here is that we've created two references to other models:
作者
model object, and is required.
Genre
model objects. We haven't declared this object yet!
Finally, copy the
BookInstance
schema code shown below and paste it into your
./models/bookinstance.js
文件。
BookInstance
represents a specific copy of a book that someone might borrow and includes information about whether the copy is available, on what date it is expected back, and "imprint" (or version) details.
var mongoose = require('mongoose');
var Schema = mongoose.Schema;
var BookInstanceSchema = new Schema(
{
book: { type: Schema.Types.ObjectId, ref: 'Book', required: true }, //reference to the associated book
imprint: {type: String, required: true},
status: {type: String, required: true, enum: ['Available', 'Maintenance', 'Loaned', 'Reserved'], default: 'Maintenance'},
due_back: {type: Date, default: Date.now}
}
);
// Virtual for bookinstance's URL
BookInstanceSchema
.virtual('url')
.get(function () {
return '/catalog/bookinstance/' + this._id;
});
//Export model
module.exports = mongoose.model('BookInstance', BookInstanceSchema);
The new things we show here are the field options:
enum
: This allows us to set the allowed values of a string. In this case, we use it to specify the availability status of our books (using an enum means that we can prevent mis-spellings and arbitrary values for our status).
default
: We use default to set the default status for newly created bookinstances to maintenance and the default
due_back
date to
now
(note how you can call the Date function when setting the date!).
Everything else should be familiar from our previous schema.
Open your ./models/genre.js file and create a schema for storing genres (the category of book, e.g. whether it is fiction or non-fiction, romance or military history, etc).
The definition will be very similar to the other models:
字符串
SchemaType called
名称
to describe the genre.
url
.
That's it. We now have all models for the site set up!
In order to test the models (and to create some example books and other items that we can use in our next articles) we'll now run an independent script to create items of each type:
package.json
).
注意： You don't need to know how populatedb.js works; it just adds sample data into the database.
npm install async
app.js
earlier):
node populatedb <your mongodb url>
注意： On some operating systems/terminals, you may need to wrap the database URL inside double (") or single (') quotation marks.
注意： Go to your database on mongoDB Atlas (in the 集合 tab). You should now be able to drill down into individual collections of Books, Authors, Genres and BookInstances, and check out individual documents.
In this article, we've learned a bit about databases and ORMs on Node/Express, and a lot about how Mongoose schema and models are defined. We then used this information to design and implement
Book
,
BookInstance
,
作者
and
Genre
models for the
LocalLibrary
website.
Last of all, we tested our models by creating a number of instances (using a standalone script). In the next article we'll look at creating some pages to display these objects.
最后修改： , 由 MDN 贡献者