Subversion Repositories SmartDukaan

'''

Created on 13-Sep-2010

@author: rajveer

'''

from elixir import *

import datetime

class Provider(Entity):

    id = Field(Integer, primary_key=True, autoincrement=True)

    name = Field(String(100))

    awb = OneToMany("AWB")

class AWB(Entity):

    id = Field(Integer, primary_key=True, autoincrement=True)

    awb_number = Field(String(100))

    is_available = Field(Boolean)

    provider = ManyToOne("Provider")

    #shipment = OneToOne("Shipment", inverse="awb")

class ShipmentUpdate(Entity):

    id = Field(Integer, primary_key=True, autoincrement=True)

    pin = Field(String(20))

    timestamp = Field(DateTime)

    description = Field(String(100))

    #awb = ManyToOne("AWB")

    shipment = ManyToOne("Shipment")    

class Shipment(Entity):

    id = Field(Integer, primary_key=True, autoincrement=True) 

    warehouse_name = Field(String(100))

    awb = Field(String(100))

    origin = Field(String(100))

    destination = Field(String(100))

    timestamp = Field(DateTime)

    recepient_name = Field(String(100))

    recepient_address = Field(String(200))

    recepient_pincode = Field(String(20))

    recepient_phone = Field(String(20))

    shipment_weight = Field(String(20))

    shipment_contents = Field(String(100))

    status_message = Field(String(100))

    #awb = ManyToOne("AWB")

    shipment_update = OneToMany("ShipmentUpdate")

class DeliveryEstimate(Entity):

    destination_pin = Field(String(20), primary_key=True)

    warehouse_id = Field(Integer)

    delivery_time = Field(Integer)

    provider = ManyToOne("Provider", primary_key=True)

'''

struct Shipment{

    1:string warehouse_id,

    2:string awb,

    3:string origin,

    4:string destination,

    5:i64 timestamp,

    6:string recepient_name,

    7:string recepient_address,

    8:string recepient_pincode,

    9:string recepient_phone,

    10:string shipment_weight,

    11:string shipment_contents

}

'''

def initialize():

    metadata.bind = "sqlite:///logistics.sqlite" #need to read it from configserver.

    metadata.bind.echo = True

    setup_all(True)

if __name__=="__main__":

    initialize()