Subversion Repositories SmartDukaan

'''

Created on 29-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

#===============================================================================

# Different entities in the model

#===============================================================================

class Transaction(Entity):

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

    createdOn = Field(DateTime)

    expected_delivery_time = Field(DateTime)

    status = Field(Integer)

    status_message = Field(String(100))

    customer_id = Field(Integer)

    shopping_cart_id = Field(Integer)

    payments = OneToMany("Payment")

    shipments = OneToMany("Shipment")

    lineitems = OneToMany("LineItem")

    trails = OneToMany("TransactionTrail")

    def __repr__(self):

        return "Transaction: id %d" % (self.id)

class Payment(Entity):

    #using_options(auto_primarykey=False)

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

    payment_id = Field(Integer)

    merchant_tx_id = Field(String(30))

    bank_tx_id = Field(String(30))

    mode = Field(String(30))

    amount = Field(Float)

    status = Field(Integer)

    status_message = Field(String(100))

    start_time = Field(DateTime)

    finish_time = Field(DateTime)

    transaction = ManyToOne("Transaction")

    def __repr__(self):

        return "Payment: id %d"%(self.id)

class Shipment(Entity):

    #using_options(auto_primarykey=False)

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

    address = Field(String(100))

    tracking_id = Field(String(100))

    status = Field(Integer)

    status_message = Field(String(100))

    shipment_time = Field(DateTime)

    delivery_time = Field(DateTime)

    declared_value = Field(Float)

    insurance_value = Field(Float)

    weight = Field(Float)

    airway_bill_no = Field(String(30))

    provider = Field(String(30))

    transaction = ManyToOne("Transaction")

    lineitems = OneToMany("LineItem")

    def __repr__(self):

        return "Shipment: id %d"%(self.id)

class LineItem(Entity):

    #using_options(auto_primarykey=False)

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

    added_on = Field(DateTime)

    item_id = Field(Integer)

    additional_info = OneToMany("AdditionalInfo")

    transaction = ManyToOne("Transaction")

    billing = ManyToOne("Billing")

    shipment = ManyToOne("Shipment")

    item_info = OneToOne("ItemInfo")

    def __repr__(self):

        return "id %d item_id %d"%(self.id, self.item_id)

class ItemInfo(Entity):

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

    price = Field(Float)

    weight = Field(Float)

    line_item = ManyToOne("LineItem")

class AdditionalInfo(Entity):

    #using_options(auto_primarykey=False)

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

    key = Field(String(30))

    value = Field(String(100))

    line_item = ManyToOne("LineItem")

    def __repr__(self):

        return "Additonal info id %d key %s value %s" %(self.id, self.key, self.value)

class Billing(Entity):

    #using_options(auto_primarykey=False)

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

    bill_number = Field(String(30))

    created_on = Field(DateTime)

    generated_by = Field(String(30))

    line_item = OneToMany("LineItem")

    def __repr__(self):

        return "Billing: billing id %d billno %s " % (self.id, self.bill_number)

class TransactionTrail(Entity):

    #using_options(auto_primarykey=False)

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

    field_changed = Field(String(30))

    old_value = Field(String(30))

    new_value = Field(String(30))

    description = Field(String(100))

    timestamp = Field(DateTime)

    transaction = ManyToOne("Transaction")

def initialize():

    metadata.bind = "sqlite:///Transactionsnew.sqlite"

    metadata.bind.echo = True

    setup_all(True)

if __name__=="__main__":

    initialize()