Subversion Repositories SmartDukaan

Rev

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

Rev 8140 Rev 8182
Line 271... Line 271...
271 
    sessionId = Field(String(255))
 271 
    sessionId = Field(String(255))
272 
    eventTimestamp = Field(DateTime,index=True)
 272 
    eventTimestamp = Field(DateTime,index=True)
273 
    using_options(shortnames=True)
 273 
    using_options(shortnames=True)
274 
    using_table_options(mysql_engine="InnoDB")
 274 
    using_table_options(mysql_engine="InnoDB")
275
275
- 
 
 276 
class EbayItem(Entity):
- 
 
 277 
    ebayListingId = Field(String(32), primary_key=True)
- 
 
 278 
    itemId = Field(Integer, primary_key=True, autoincrement = False)
- 
 
 279 
    listingName = Field(String(255))
276
280 
    listingPrice = Field(Float)
- 
 
 281 
    listingExpiryDate = Field(DateTime)
277
282 
    subsidy = Field(Float)
- 
 
 283 
    defaultWarehouseId = Field(Integer)
- 
 
 284 
    using_options(shortnames=True)
- 
 
 285 
    using_table_options(mysql_engine="InnoDB")
278
286
279 
def initialize(dbname='catalog', db_hostname="localhost"):
 287 
def initialize(dbname='catalog', db_hostname="localhost"):
280 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
 288 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
281 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
 289 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
282 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
 290 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)