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 LatestArrivals(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()