SoftwareTree/gilhari_ecommerce_example

Copyright (c) 2025 Software Tree

Gilhari E-commerce Microservice

Automated e-commerce microservice with PostgreSQL integration and Docker deployment

This repository contains a complete e-commerce microservice built with Gilhari ORM, featuring automatic environment detection for seamless local development and Docker deployment. The system automatically handles database connectivity across different environments without manual configuration.

🎯 Key Features

• 🔄 Automated Environment Detection: Automatically switches between local and Docker configurations
• 🐳 Docker-Ready: Complete containerization with proper networking
• 📊 PostgreSQL Integration: Full CRUD operations with complex business relationships
• 🚀 One-Command Build: Complete automation from reverse engineering to deployment
• 🤖 ORMCP Compatible: Ready for AI-powered database interactions
• 📈 Business Intelligence: Advanced queries and aggregations

🏗️ Architecture Overview

The microservice provides RESTful APIs for six core e-commerce entities with sophisticated business relationships. This example uses a sophisticated object model found in a typical eCommerce application. For example:

• Supplier has a 1-many relationship with Product
• Customer has a 1-many relationship with CustomerOrder. Customer also has a 1-many relationship with Address
• CustomerOrder has a 1-many relationship with OrderItem
• Product has a 1-many relationship with OrderItem

The above model was automatically inferred from an existing database schema by the reverse-engineering tool shipped with the Gilhari SDK. Please see REVERSE_ENGINEERING.md to learn how you can easily work with an existing relational schema and use its data in an intuitive object-oriented way without writing any SQL code.

Post Reverse-Engineering Customization

The reverse-engineered ORM specification gives us a jump-start, but it can be refi