Subversion Repositories SmartDukaan

Rev

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

Rev 10452 Rev 10544
Line 208... Line 208...
208 
    heldOrders = Field(Integer)
 208 
    heldOrders = Field(Integer)
209 
    is_oos = Field(Boolean)
 209 
    is_oos = Field(Boolean)
210 
    lastUpdatedOnFlipkart =  Field(DateTime)
 210 
    lastUpdatedOnFlipkart =  Field(DateTime)
211 
    using_options(shortnames=True)
 211 
    using_options(shortnames=True)
212 
    using_table_options(mysql_engine="InnoDB")
 212 
    using_table_options(mysql_engine="InnoDB")
213
213
- 
 
 214 
class SnapdealStockAtEOD(Entity):
- 
 
 215 
    item_id = Field(Integer, primary_key=True,autoincrement=False)
- 
 
 216 
    availability = Field(Integer)
- 
 
 217 
    date =  Field(DateTime)
- 
 
 218 
    using_options(shortnames=True)
- 
 
 219 
    using_table_options(mysql_engine="InnoDB")
- 
 
 220
- 
 
 221 
class FlipkartStockAtEOD(Entity):
- 
 
 222 
    item_id = Field(Integer, primary_key=True,autoincrement=False)
- 
 
 223 
    availability = Field(Integer)
- 
 
 224 
    date =  Field(DateTime)
- 
 
 225 
    using_options(shortnames=True)
- 
 
 226 
    using_table_options(mysql_engine="InnoDB")
- 
 
 227
214
228
215 
def initialize(dbname='inventory', db_hostname="localhost"):
 229 
def initialize(dbname='inventory', db_hostname="localhost"):
216 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
 230 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
217 
    #metadata.bind = 'mysql://root:shop2020@localhost/inventory'
 231 
    #metadata.bind = 'mysql://root:shop2020@localhost/inventory'
218 
    iengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
 232 
    iengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)