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

Intermediate Express.js: How To Add Styles & Partials in EJS File?

So far, we only have simple HTML tags and ejs tags in each ejs file. Every template page has no style at all. And the basic HTML header and footer are also missing. Today, I learned how to add styles and partials in ejs file. Link Style Step One: Touch a Separate CSS file I create a new directory "Style" under the "EJSDemo" directory, then I add a new CSS file "app.css" inside "Style" folder. Step Two: Add app.use(express.static()) in the app.js I add app.use(express.static("style")) in the "app.js". This will tell Express.js to serve the content of "Style" directory. Step Three: Write styles in CSS file I simple give body an orange background color and set text color to be grey. Step Four: Link to CSS file in the EJS file I just add <link> tag to link the "app.css" file on the top of the h1 tag in each ejs template. As the result, when I run the app and...
Post a Comment
Read more

Intermediate Express.Js: Write Conditions and Loops In The EJS (study note)

We continue to use the app.js which we have build to be the study example. In the last post, we only add a simple EJS tag <%= thingVar %> inside h1 tag. This will match the "thing" to any "thing" request from the user. If Statement Today, the course shows us to write a simple if statement in the EJS file. I learn to apply it to my own app. In the if statement, if users send"/wantto/workout" request, the page will show a new content "Good Idea!". We wrote the if statement in the "diet.ejs" file, and we add "<% %>" tags around the code. We have to wrap every line of JavaScript anytime JavaScript starts and ends. Moreover, you may see there are two types of ejs tags here: <%= %> The one with equal sign. According to the course, when we add equal sign, the value that is returned inside of the tag will be rendered to the HTML page. it will be added to the HTML. For example, if we write ...
Post a Comment
Read more

My Story: A Mommy Start To Learn Code From Zero

From Google Image I am not a programmer, and I thought I would never become one. Everytime I see someone is coding, I think he or she must be very talent.  For me, coding is a very difficult subject to learn. Not only the language has so many rules, but also the logical reasoning behind the language is complex.  In my graduated school, I knew many friends who didn't have any coding background, but they are doing programmer or developer jobs now. Some of them went to school to study coding, and some of them  learned to code by themselves. Their stories are so impressive.  I wasn't ready to learn code until I finished my first Chinese book "留学，我的青春呀!" recently. I always want to be a writer and write my own book. I started writing blog three years ago, and I updated my post two to three times every week. As I enjoyed writing , I started to get some followers, likes, and good comments on my blog. Then, I decided to plan my first book. My First...
Post a Comment
Read more