Subversion Repositories SmartDukaan

Rev

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

Rev 7589 Rev 8182
Line 95... Line 95...
95
class CurrentInventorySnapshot(Entity):
95
class CurrentInventorySnapshot(Entity):
96
    item_id = Field(Integer, primary_key=True)
96
    item_id = Field(Integer, primary_key=True)
97
    warehouse = ManyToOne("Warehouse", primary_key=True)
97
    warehouse = ManyToOne("Warehouse", primary_key=True)
98
    availability = Field(Integer)
98
    availability = Field(Integer)
99
    reserved = Field(Integer)
99
    reserved = Field(Integer)
-
 
100
    held = Field(Integer)
-
 
101
    using_options(shortnames=True)
-
 
102
    using_table_options(mysql_engine="InnoDB")
-
 
103
 
-
 
104
class HoldInventoryDetail(Entity):
-
 
105
    item_id = Field(Integer, primary_key=True)
-
 
106
    warehouse = ManyToOne("Warehouse", primary_key=True)
-
 
107
    held = Field(Integer)
-
 
108
    source = Field(Integer)
100
    using_options(shortnames=True)
109
    using_options(shortnames=True)
101
    using_table_options(mysql_engine="InnoDB")
110
    using_table_options(mysql_engine="InnoDB")
102
 
111
 
103
class CurrentReservationSnapshot(Entity):
112
class CurrentReservationSnapshot(Entity):
104
    item_id = Field(Integer, primary_key=True)
113
    item_id = Field(Integer, primary_key=True)
Line 169... Line 178...
169
class OOSStatus(Entity):
178
class OOSStatus(Entity):
170
    item_id = Field(Integer, primary_key=True, autoincrement=False)
179
    item_id = Field(Integer, primary_key=True, autoincrement=False)
171
    date = Field(DateTime, primary_key=True, autoincrement=False)
180
    date = Field(DateTime, primary_key=True, autoincrement=False)
172
    is_oos = Field(Boolean)
181
    is_oos = Field(Boolean)
173
    num_orders = Field(Integer)
182
    num_orders = Field(Integer)
-
 
183
    rto_orders = Field(Integer)
174
    using_options(shortnames=True)
184
    using_options(shortnames=True)
175
    using_table_options(mysql_engine="InnoDB")
185
    using_table_options(mysql_engine="InnoDB")
176
    
186
    
177
class AmazonInventorySnapshot(Entity):
187
class AmazonInventorySnapshot(Entity):
178
    item_id = Field(Integer, primary_key=True)
188
    item_id = Field(Integer, primary_key=True)