Skip to main content

Database Project Study: How To Use Mongoose To Model Your Database?


What is Mongoose?


According to Mongoose, Mongoose is an elegant MongoDB object modeling for Node.js. It provides a straight-forward, schema-based solution to model your application data.



Basically, Mongoose is a package which helps us interact with Mongo DB. It is a JavaScript layer on top of Mongo DB, and it adds some extra special methods that makes our live easier.

How to Install Mongoose?


The installation is very simple. We just need to npm install mongoose in our server. Then, we create a JavaScript file, and require the mongoose.


Since the Mongoose needs to interact with MongoDB, we need to open another terminal window to call "./mongod"and make sure the MongoDB is running . 

Then, we connect Mongoose with MongoDB: mongoose.connect("mongodb://localhost/score_app").

Score Database Project Study

In this project, I am going to create a score app which contains student score data. The score data includes three main entries: name, gpa, and subject.

  • Adding New Score to the Database


Once we connect the Mongoose with MongoDB, we need to define "scoreSchema" by creating a variable. It tells the JavaScript that we want to be able to add score to our database. A score should be define like this:



We compile the scoreSchema into a model which is "new mongoose.Schema()". And we save it to a variable score. In this model, it takes that score pattern and builds this complex model that has all of the method we need to use.

Now we can start to use that score variable to create some new scores. The first score data I create is for student name "Zark" whose Math GPA is 3.3.


Even we add the new data, it is not saved to our database yet. We need to use name.save() method to save it to our database. We pass a call back function to save, and this function will be called when save is done.

In the call back function, we give two parameters. The first one is to check if there has any potential error such as internet connect fail or code is not correctly. The second one is the score we want to return. 

When I run the score.js, it shows the data I just created, and it is saved to database successfully.


Then, I added a new score data by using the same method, and it is also saved to database.


If we want to view all the data, we can run MongoDB by type "mongo", and type use "score_app), then find our scores.



  • Retrieving Scores From the Database 
If we want to retrieve our score data from the Database, we need to use find method: Score.find({}, function(){}).

We are passing an empty object in the find method because we are not looking for a particular score. The function also has two parameters: one is to check error, and one is scores which is the result of our find. 


At the end, we run the score.js, and it retrieves all the scores data from database.






Labels:

Comments

Post a Comment

Popular posts from this blog

GIT Study Note: Six Git Commands You Should Know!

What is Git? According to Git website , Git is a free and open source distributed version control system designed to handle everything from small to very large projects with speed and efficiency. Basically, we can use Git to track all of changes and revert them back if we made mistakes. The version control system is a way for us to work with different versions of our code, so that we can save different features and make notes as we progress. It is also very useful for team collaboration. Six Git Command You Should Know 1. Git Init In our server, we need to create a "Git" directory and inside of "Git", we make another direcory "git_inro". Then, we add a file "app,js" in the "git_intro" folder. The first thing we need to run is "git init" . When we run git init, it will make a directory which is hidden called ".git". Wherever I run that git init command, it's going to track all of our changes. ...
Post a Comment
Read more

Intermediate Express.js: How To Render HTML From A EJS File?

The Express.js apps we have developed so far are just simply getting requests from users and sending matched message back to them. However, it is not what we want in the real web application. In most case, we want to send back a relevant web page when our app receives request from user. In order to do that, we need to npm install ejs file in the Express, create HTML page in the ejs file, and render HTMl from the ejs file. I know it sounds confuse now. I am going to explain more details in the example. EJS stands for embedded JavaScript. It lets us embed JavaScript code variables if statements loops inside of HTML. How to render HTML from a EJS file? Step One: Create a HTML page in EJS file Firstly, in our server, we create a folder named "EJSDemo". In this folder, we touch two files, one is "app.js", and the other one is "home.ejs". We are going to write a simple HTML code in the "home.ejs" file. The instructor create a dog page,...
Post a Comment
Read more

Intro To Authentication: Three Useful Tools Will Make Everything Easier

Authentication is very important for both users and websites. It helps to keep users' information safe and also helps us to manage the accounts. Authentication is also complex because there is a lot of moving pieces that have to fit together in just the right way to make that work. The course introduce three tools to make authentication more quickly and safely. 1. Passport.js Passport.js will make our life easier and make our code shorter. It also helps to make implementation faster. Most importantly, it is used a lot in the real word. 2. Passport Local Passport Local is for username and password. It's about providing this entry point into all sorts of destinations. 3. Passport Local Mongoose This package will help us implement authentication with passport, and it's specially made to work with mongoose. We are also going to use these three tools into a Secret Page App project, which will show in next few posts.
Post a Comment
Read more