Subversion Repositories SmartDukaan

Rev

Rev 104 | Rev 132 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 104 Rev 115
Line 16... Line 16...
16 
#===============================================================================
 16 
#===============================================================================
17 
# Different entities in the model
 17 
# Different entities in the model
18 
#===============================================================================
 18 
#===============================================================================
19 
 
 19 
 
20 
class Transaction(Entity):
 20 
class Transaction(Entity):
- 
 
 21 
    #using_options(auto_primarykey=False)
21 
    id = Field(Integer, primary_key=True, autoincrement=True)
 22 
    #id = Field(Integer, primary_key=True, autoincrement=True)
22 
    createdOn = Field(DateTime)
 23 
    createdOn = Field(DateTime)
23 
    expected_delivery_time = Field(DateTime)
 24 
    expected_delivery_time = Field(DateTime)
24 
    status = Field(Integer)
 25 
    status = Field(Integer)
25 
    status_message = Field(String(100))
 26 
    status_message = Field(String(100))
26 
    customer_id = Field(Integer)
 27 
    customer_id = Field(Integer)
Line 31... Line 32...
31 
    def __repr__(self):
 32 
    def __repr__(self):
32 
        return "Transaction: id %d" % (self.id)
 33 
        return "Transaction: id %d" % (self.id)
33 
 
 34 
 
34 
 
 35 
 
35 
class Payment(Entity):
 36 
class Payment(Entity):
- 
 
 37 
    #using_options(auto_primarykey=False)
36 
    id = Field(Integer, primary_key=True, autoincrement=True)
 38 
    #id = Field(Integer, primary_key=True, autoincrement=True)
37 
    merchant_tx_id = Field(String(30))
 39 
    merchant_tx_id = Field(String(30))
38 
    bank_tx_id = Field(String(30))
 40 
    bank_tx_id = Field(String(30))
39 
    amount = Field(Float)
 41 
    amount = Field(Float)
40 
    status = Field(Integer)
 42 
    status = Field(Integer)
41 
    status_message = Field(String(100))
 43 
    status_message = Field(String(100))
Line 46... Line 48...
46 
    def __repr__(self):
 48 
    def __repr__(self):
47 
        return "Payment: id %d"%(self.id)
 49 
        return "Payment: id %d"%(self.id)
48
50
49 
 
 51 
 
50 
class Shipment(Entity):
 52 
class Shipment(Entity):
- 
 
 53 
    #using_options(auto_primarykey=False)
51 
    id = Field(Integer, primary_key=True, autoincrement=True)
 54 
    #id = Field(Integer, primary_key=True, autoincrement=True)
52 
    address = Field(String(100))
 55 
    address = Field(String(100))
53 
    tracking_id = Field(String(100))
 56 
    tracking_id = Field(String(100))
54 
    status = Field(Integer)
 57 
    status = Field(Integer)
55 
    status_message = Field(String(100))
 58 
    status_message = Field(String(100))
56 
    shipment_time = Field(DateTime)
 59 
    shipment_time = Field(DateTime)
Line 66... Line 69...
66 
    def __repr__(self):
 69 
    def __repr__(self):
67 
        return "Shipment: id %d"%(self.id)
 70 
        return "Shipment: id %d"%(self.id)
68
71
69 
 
 72 
 
70 
class LineItem(Entity):
 73 
class LineItem(Entity):
- 
 
 74 
    #using_options(auto_primarykey=False)
71 
    id = Field(Integer, primary_key=True, autoincrement=True)
 75 
    #id = Field(Integer, primary_key=True, autoincrement=True)
72 
    added_on = Field(DateTime)
 76 
    added_on = Field(DateTime)
73 
    item_id = Field(Integer)
 77 
    item_id = Field(Integer)
74 
    additional_info = OneToMany("AdditionalInfo")
 78 
    additional_info = OneToMany("AdditionalInfo")
75 
    transaction = ManyToOne("Transaction")
 79 
    transaction = ManyToOne("Transaction")
76 
    billing = OneToOne("Billing")
 80 
    billing = ManyToOne("Billing")
77 
    shipment = ManyToOne("Shipment")
 81 
    shipment = ManyToOne("Shipment")
78
82
79 
    def __repr__(self):
 83 
    def __repr__(self):
80 
        return "id %d item_id %d"%(self.id, self.item_id)
 84 
        return "id %d item_id %d"%(self.id, self.item_id)
81
85
82 
 
 86 
 
83 
class AdditionalInfo(Entity):
 87 
class AdditionalInfo(Entity):
- 
 
 88 
    #using_options(auto_primarykey=False)
84 
    id = Field(Integer, primary_key=True, autoincrement=True)
 89 
    #id = Field(Integer, primary_key=True, autoincrement=True)
85 
    key = Field(String(30))
 90 
    key = Field(String(30))
86 
    value = Field(String(100))
 91 
    value = Field(String(100))
87 
    line_item = ManyToOne("LineItem")
 92 
    line_item = ManyToOne("LineItem")
88
93
89 
    def __repr__(self):
 94 
    def __repr__(self):
90 
        return "Additonal info id %d key %s value %s" %(self.id, self.key, self.value)
 95 
        return "Additonal info id %d key %s value %s" %(self.id, self.key, self.value)
91
96
92 
 
 97 
 
93 
class Billing(Entity):
 98 
class Billing(Entity):
- 
 
 99 
    #using_options(auto_primarykey=False)
94 
    id = Field(Integer, primary_key=True, autoincrement=True)
 100 
    #id = Field(Integer, primary_key=True, autoincrement=True)
95 
    bill_number = Field(String(30))
 101 
    bill_number = Field(String(30))
96 
    created_on = Field(DateTime)
 102 
    created_on = Field(DateTime)
97 
    generated_by = Field(String(30))
 103 
    generated_by = Field(String(30))
- 
 
 104 
    line_item = OneToMany("LineItem")
98 
    line_item = OneToOne("LineItem")
 105 
    #lineitem = OneToOne("LineItem")
99
106
100 
    def __repr__(self):
 107 
    def __repr__(self):
101 
        return "Billing: billing id %d billno %s " % (self.id, self.bill_number)
 108 
        return "Billing: billing id %d billno %s " % (self.id, self.bill_number)
102
109
103 
class TransactionTrail(Entity):
 110 
class TransactionTrail(Entity):
- 
 
 111 
    #using_options(auto_primarykey=False)
104 
    id = Field(Integer, primary_key=True, autoincrement=True)
 112 
    #id = Field(Integer, primary_key=True, autoincrement=True)
105 
    field_changed = Field(String(30))
 113 
    field_changed = Field(String(30))
106 
    old_value = Field(String(30))
 114 
    old_value = Field(String(30))
107 
    new_value = Field(String(30))
 115 
    new_value = Field(String(30))
108 
    description = Field(String(100))
 116 
    description = Field(String(100))
109 
    timestamp = Field(DateTime)
 117 
    timestamp = Field(DateTime)