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

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

Authentication Project: Secret Page App Part One (Set up & Create User Model)

So far we only write the RESTful routes to send request and redirect to the related page, but we haven't do anything about authentication. If we can sign up, login, and log out, it will make our app more meaningful. Therefore, the course shows us how to create a secret page app, which will allow us to sign up, login to a secret page, and logout. Since it requires so many pieces, I will divided this project into three parts: set up & create user model, sign up, and login/logout. In this post, I am going to show all the set up process. Set Up Step One: Install packages The first thing we are going to do to create a folder "Auth", and inside of "Auth", we need to create another folder "AuthDemo". Then we cd (change directory) to "AuthDemo". Now we can set up the actual application structure by installing a few packages: passport, passport-local, passport-local-mongoose, mongoose, express, ejs, body-parser, and express-session....
Post a Comment
Read more