README

An app build with the express purpose of exposing the rich spirit and inventory information made available by the Washington State Liquor Control Board.

This app allows the user to find what spirits are aavilable at Washington State Liquor stores.  They can search by store, spirit brand or category and even filter based on what results are near them or what stores are open.

Data Model

Stores
|Id|Store Type|Retail|Store Number|City|Address|Hours|Contact|

Store Contacts
|Store Id|Role|Name|Number|

Store Hours
|Store Id|Start Day|End Day|Open|Close|Summer Hours|

Spirits
|Id|Category|Brand Name|Brand Code|Retail Price|Sales Tax|Total Retail Price|Class H Price|Merchandising Special Note|Size (Liters)|Case Price|Proof OR %|Liter Cost|On Sale|Closeout|

Store Inventory
|Store Id|Spirit Id|Quantity In Stock|

Todo:
 - Geocode store location
 - Add store name to datamodel for use with store inventory

REST API

  VERB    URI             Query String    Comment
X GET     /categories                     
  PUT     /categories                     Not Allowed
  POST    /categories                     Not Allowed
  DELETE  /categories                     Not Allowed
                             
X GET     /stores        id,              Get all stores, just 'id' 
X                        brand_code       or those with a certain spirit
                         lat,long,dist    or certain distance from me
  PUT     /stores                         Not Allowed
  POST    /stores                         Not Allowed
  DELETE  /stores                         Not Allowed

X GET     /spirits       brand_code,      Loads all or searches
X                        name,
X                        category
  PUT     /spirits                        Not Allowed
  POST    /spirits                        Not Allowed
  DELETE  /spirits                        Not Allowed

X GET     /spirit/{id}                    
  PUT     /spirit/{id}                    Not Allowed
  POST    /spirit/{id}                    Not Allowed
  DELETE  /spirit/{id}                    Not Allowed

X GET     /spirit/{id}/stores             Returns stores that have spirit       
  PUT     /spirit/{id}/stores             Not Allowed
  POST    /spirit/{id}/stores             Not Allowed
  DELETE  /spirit/{id}/stores             Not Allowed

X GET     /store/{id}                     
  PUT     /store/{id}                     Updates store (Not Implemented)
  POST    /store/{id}                     Not Allowed
  DELETE  /store/{id}                     Not Allowed

X GET     /store/{id}/spirits             Just the spirits in this store         
  PUT     /store/{id}/spirits             Not Allowed
  POST    /store/{id}/spirits             Not Allowed
  DELETE  /store/{id}/spirits             Not Allowed