Skip to main content

Data Association Study Notes: Six Steps to Embedded Data


What is Association?

Association will allow us to have multiple pieces of data collections in our database that are related to one another. Just like a Facebook user can have multiple posts or images in his account.

Three Types of Association

One to One: 

One of entity that's related to one another entity. For example, one student has one unique student ID.

One to Many: 

One entity that's related to many of other entity. For example, one student has multiple social media accounts. And those social media accounts only belong to this student.

Many to Many: 

Many entity related to both ways. For example, one student can take many course, and one course has many students.

Embedded Data

In this example, we will do the "One to Many" type. We have user and post. We want one user to have multiple posts.

Step One: Set up and define schema

Firstly, we need to create a new file "embed,js", and npm install mongoose. Then, we require the mongoose and connect to MongoDB inside the file. And, we need to make sure the MongoDB is running in another window.


Then, we define user and post schemas by giving each of them an object with related items. For user, we need to have email, and name. For post, we need to have post title and content. And then, we put each schema into a mongoose model.

Step Two: Test New User

We create a new user with name "Mary" and email "mary@nyu.edu". And then, we save the user data into the database. As we run the server, it shows the new user information with unique id. And we use the same way to create new post and test successful.



Step Three: Embed Data

In order to relate the user to post, we need to embed data. To do that, we need to have a post attribute inside the user. Inside the post attribute, we will have many posts. So, we need to add the post schema inside of an array. Therefore, we tell the mongoose we want it to be a list which is an array of posts.

We also need to move the post schema to the top, so Node can find the post variable first, then related to the user schema.


Step Four: Push post to a new user

We create another new user. Then, we push the posts to the new user which we defined: newUser.posts.push(). Then, we save the new user and new post.


As result, it shows the new user with new posts in the database. The post has an array which includes the post title and content.



Step Five: Retrieve the data

We can use user.findOne({}, function()) to retrieve the a particular data from database. In this case, we retrieve Lily's data, and we see all her information and post.


Step Six: Add new post 

We can also push the post to the same user inside the retrieve function and save the data. 


Once we run the server, it shows Lily has two posts in the post array.


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

Express Study Notes: Five Steps To Develop My First Express App

In the last post, I shared my study note about one of the most important reason that Node is very popular is because Node has the largest package ecosystem of open source libraries in the world. Node's NPM, the package manager for Javascript, contains almost 200,000 packages which are centralized on the NPM website. And more importantly, NPM has a command line tool which help us to install packages really easily. The course instructor told us that we are going to learn Express.js to develop Apps in this course. screenshot for the Express.js.com homepage What is Express.js? Express.js is a web development framework. According to the course, framework is a bunch of code that someone else wrote just like a library is except when we use a framework, we have less control. The goal of using this framework is to make our development of APPs faster. Why do we use Express.js? 1. It is the most popular Node web development framework so far. 2. It is a very lightweight ...
Post a Comment
Read more