Subversion Repositories SmartDukaan

'''
Created on 22-Mar-2010

@author: ashish
'''
from elixir import *
from elixir.entity import Entity
from elixir.fields import Field
from sqlalchemy.types import Integer
from elixir.relationships import OneToMany, ManyToOne
import datetime



class BestSellers(Entity):
    item_id = Field(Integer, primary_key=True)
    priority = Field(Integer)
    status = Field(Integer)
    
class BestDeals(Entity):
    item_id = Field(Integer, primary_key=True)
    priority = Field(Integer)
    status = Field(Integer)

class Warehouse(Entity):
    id = Field(Integer, primary_key=True, autoincrement=True)
    location = Field(String(200))
    status = Field(Integer)
    addedOn = Field(DateTime)
    lastCheckedOn = Field(DateTime)
    tinNumber = Field(String(50))
    pincode = Field(String(10))
    vendorString = Field(String(50))
    inventory = OneToMany('CurrentInventorySnapshot')
    inventoryHistory = OneToMany('ItemInventoryHistory')
    
    def __repr__(self):
        return "<warehouse>%s</warehouse>" %(self.location)

    @property
    def all_items(self):
        items = []
        for ci in self.inventory:
            items.append(ci.item)
        return items 
    
class Item(Entity):
    id = Field(Integer, primary_key=True, autoincrement=True)
    manufacturer_name = Field(String(100))
    model_number = Field(String(50))
    model_name = Field(String(50))
    category = Field(String(50))
    comments = Field(String(200))
    catalog_item_id = Field(Integer)
    vendor_item_id = Field(String(50))
    feature_id = Field(Integer)
    feature_description = Field(String(200))
    mrp = Field(Float)
    mop = Field(Float)
    sellingPrice = Field(Float)
    weight = Field(Float)
    addedOn = Field(DateTime)
    startDate = Field(DateTime)
    retireDate = Field(DateTime)
    status = Field(Integer)
    currentInventory = OneToMany('CurrentInventorySnapshot')
    inventoryHistory = OneToMany('ItemInventoryHistory')
    iteminfo = OneToMany("ItemInfo")
    statusChangeLog = OneToMany("ItemChangeLog")
    
    def __repr__(self):
        return "<Item>%d</item>" % (self.id)
    
    @property
    def get_total_inventory(self):
        if self.currentInventory:
            i = 0
            for entry in self.currentInventory:
                i += entry.availability
            return i
        
        else:
            return 0;
    
    @property
    def get_all_warehouses(self):
        warehouses = []
        for ci in self.currentInventory:
            warehouses.append(ci.warehouse)
        return warehouses


class Price(Entity):
    id = Field(Integer, primary_key=True, autoincrement=True)
    price = Field(Float)
    warehouse_id = Field(Integer)
    item = ManyToOne("Item")
    
    def __repr__(self):
        return "<price><item_id> %d </item_id><warehouse_id> %d </warehouse_id><val> %f </val> </price>" % (self.item.id, self.warehouse_id, self.price)

    
class ItemInfo(Entity):
    id = Field(Integer, primary_key=True, autoincrement=True)
    key = Field(String(30))
    value = Field(String(100))
    item = ManyToOne("Item")
    
    def __repr__(self):
        return "<ItemInfo><key>%s</key><value>%s</value></ItemInfo>" % (self.key, self.value)
    

class CurrentInventorySnapshot(Entity):
    #id = Field(Integer, primary_key=True)
    #checkedOn = Field(DateTime, default=datetime.datetime.now())
    availibility = Field(Integer)
    item = ManyToOne("Item")
    warehouse = ManyToOne("Warehouse")
    
    def __repr__(self):
        return "<current inventory><availability> %s </availability><time>%s</time><item>%s</item><warehouse>%s</warehouse></current inventory>" %(self.availibility, self.checkedOn, self.item, self.warehouse)

class ItemInventoryHistory(Entity):
    id = Field(Integer, primary_key=True, autoincrement = True)    
    timestamp = Field(DateTime, default=datetime.datetime.now())
    availibility = Field(Integer)
    item = ManyToOne("Item")
    warehouse = ManyToOne("Warehouse")
    
    def __repr__(self):
        pass

class ItemChangeLog(Entity):
    id = Field(Integer, primary_key=True, autoincrement=True)
    old_status = Field(Integer)
    new_status = Field(Integer)
    timestamp = Field(DateTime, default=datetime.datetime.now())
    item = ManyToOne("Item")
    
    def __repr__(self):
        return "<Log><id>%d</id><item>%d</item><old_status>%d</old_status><new_status>%d</new_status></Log>" %(self.id,self.item.id, self.old_status, self.new_status)    


def initialize():
    metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
    metadata.bind.echo = True
    setup_all(True)

if __name__=="__main__":
    initialize()