InventoryManagementSystem

Rest based Inventory Management System build on Spring Boot Framework

Setup

• Clone the Repository

   git clone --recursive https://github.com/NeebalLearningPvtLtd/InventoryManagementSystem.git
  

• Import in eclipse File > import > General > Projects from Folder or Archive
• Init DB Schema
  • locate init.py in src/main/resources/database_files/
  • run init.py

     python3 init.py
    

    Description

• This is the code to create an Inventory management automated system for Kossine’s physical classrooms .
• Design pattern used is M ~V~ C of spring boot’s starter web . Note : Views are not done yet .
• Controller’s can be found here , paging support is also added can be accessed using

    http://domain/controller_mapping/get/all?page=0&size=50
  

  it fetches first 50 rows from first slot , for next slot page=1 and so-on Note size can be varied

• Complete controller code for say Model Laptop can be found here which contains all the Request mappings for GET , POST , PUT ,DELETE is done .

• Exception handling of Api is done using @RestControllerAdvice annotation , code can be found here
• Hibernate framework was used for DAO layer and was implemented using JPA standards as well as spring data JPA .

  • JPA’s EntityManager way used in GenericRepo , LaptopRepo , AdapterRepo

  • Spring Data Jpa was used in LaptopUsedByRepo , AdapterUsedByRepo

• Inventory is abstract class for all the inventories .
• Testing was done using Junit 4 and @SpringBootTest annotation provided by spring boot

  Note : H2 Inmemory Db was used during testing , but some queries were incompatible with H2 that runs with no problem in MySql/MariaDb ## dependency see pom.xml ## sub-modules Excel-to-POJO was used for maping excel data to POJO’s found in models package