Project Type: Group Project
Little Esty Shop was created by four back end developers. It is a fictitious e-commerce platform where merchants and admins can manage inventory and fulfill customer invoices. We built the application with Ruby on Rails, and focused our learning on advanced routing, rake tasks that read csv files loading them into our database, complex ActiveRecord queries, simple consumption of Nager.Date API, and basic CRUD funtionality while maintaining MVC standards. Our Database uses many different relationships (many-to-many, one-to-many).
For this application I wrote several of the complex ActiveRecord queries such as calculating the total revenue (for all merchants and for a given merchant) on an invoice after any applicable bulk discounts are applied. This required use of subqueries and a combination of ActiveRecord and SQL.