Skip to main content

CRUD in MongoDB & Spring Data

Now, since we have already been introduced to mongo and its server is setup. We shall now move on to performing basic CRUD operations.
Lets take a use case example of ‘Company’ database that stores employee information. 

We wish to store employee name, email address, age and multiple addresses. Traditionally in RDBMS we would create an Employee table and Address Table having foreign key reference to ‘employee id ‘




Incase of NoSQL, we will be creating Employee documnet which will have store employee information like name, email, age and an array of employes address. Following is a snippet of the schema defined
{
"name" : "",
"email" : "",
"age" : “”,
"address" : [ ... ]
}
Thus to begin with, we will first define the entities. We have employee as an aggregate root entity that stores list of address having 1-M relatioship. Address Entity is represend as @Embeddable as it is embaded in another aggregate root entity. Employee is represented as @Document as the object to presist. The Employees id property is annotated with @Id so that JPA will recognize it as the object’s ID. The id property is also annotated with @GeneratedValue to indicate that the ID should be generated automatically.

Employee.java

Address.java

We have to specify the server host & port in the configuration file here localhost : 27017. Mongo Template offers convenience to create, update, delete and query for MongoDB documents and provides a mapping between your domain objects and MongoDB documents.Here, we will be creating & mapping employee bean which is our domain object.

ApplicationContext.xml

Now creating repository interface with CRUD methods.
 


EmployeeRepository.java
EmployeeRepositoryImpl.java





EmployeeMain.java

We shall also define a web service that would return the list of all employees and also an employee by id


EmployeeWS.java

EmployeeWSImpl.java

You can also find the complete source code at  https://github.com/meta-magic/MongoDB.git

Output
Displaying all Employees [
******************************************************************
     Employee Information :=1, name:=aaa, age:=10, email:= a@y.com
      Employee Address
     Address :=home addr, pin:=22235  
     Address :=ofc addr, pin:=21345    ,
******************************************************************
     Employee Information :=2, name:=bbb, age:=3, email:= b@y.com
      Employee Address
     Address :=home addr 2, pin:=22235  
     Address :=ofc addr 2, pin:=21345    ]
Find Employee with EMPID:1
******************************************************************
     Employee Information :=1, name:=aaa, age:=10, email:= a@y.com
      Employee Address
     Address :=home addr, pin:=22235  
     Address :=ofc addr, pin:=21345  
Displaying all Employees after update EMPID:1[
******************************************************************
     Employee Information :=1, name:=abc, age:=10, email:= a@y.com
      Employee Address
     Address :=home addr, pin:=22235  
     Address :=ofc addr, pin:=21345    ,
******************************************************************
     Employee Information :=2, name:=bbb, age:=3, email:= b@y.com
      Employee Address
     Address :=home addr 2, pin:=22235  
     Address :=ofc addr 2, pin:=21345    ]
Displaying all Employees after deleting EMPID:2 [
******************************************************************
     Employee Information :=1, name:=zzz, age:=10, email:= a@y.com
      Employee Address
     Address :=home addr, pin:=22235  
     Address :=ofc addr, pin:=21345    ]

Comments

Popular posts from this blog

Function Point Analysis : ISO/IEC 20926:2009

This blog focuses on explaining the Function Point calculations. Software Sizing Background Function Point Rules for Counting FP Deep Dive - Function Point Analysis Case Study General Software Characteristics Details History - Measurement Methodologies Lines of Code (Oldest) Use case based Software Sizing IPFUG Function Point Analysis (ISO) Need for Software Sizing. Estimation and Budgeting Phasing Development Work Prioritization of Work Monitoring the Progress Bidding for Projects Allocating Testing Resources To measure and Manage Productivity Risk Assessment Software Asset Valuation CMMi Level 2 and 3 require that a valid sizing method be used. Software Sizing - Lines of Code The easiest and historically the most common method in Sizing Software project has been counting the number of lines of code and / or the number of screens. Advantages Automation of the counting process can be done Intuitive as the measurements are easily u

Redis Installation Steps

“ Redis is an in-memory key-value store known for its flexibility, performance, and wide language support” Inorder to install redis on your machine you need ubuntu 16.4 and a non-root user with sudo privileges to perform the administrative functions required for this process. Download and Extract the Source Code Create a tmp directory cd /tmp Download the latest stable version of Redis curl -O http://download.redis.io/redis-stable.tar.gz untar tar xzvf redis-stable.tar.gz Move into the Redis source directory structure that was just extracted cd redis-stable Build and Install Redis Now, we can compile the Redis binaries by typing make After the binaries are compiled, run the test suite to make sure everything was built correctly. You can do this by typing: make test This will typically take a few minutes to run. Once it is complete, you can install the binaries onto the system by typing: sudo

Eureka-Server with spring cloud netflix

In this write-up we will focus on Service Registry – Eureka Server Rest service (auth-service application, eureka client) which register itself to registry. Web application which consumes Rest service using service registry. Service discovery  allows services to find and communicate with each other without hardcoding hostname and port. Eureka Server In spring-boot application enable the Eureka-Server by adding @EnableEurekaServer annotation to spring boot application. We have put all the configuration on GIT and this is accessed using config-server. To now more about centralized configuration (config-server) click  here eurekaserver.yml Place below bootstrap.yml in application, it basically connects to config-server and gets it required configuration. Start the spring-boot application and access eureka server using http://localhost:8760/ you will get below screen. Right now there is no application which is registered to e