Subversion Repositories SmartDukaan

Rev

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

Rev 9724 Rev 9776
Line 370... Line 370...
370
class ProductFeedSubmit(Entity):
370
class ProductFeedSubmit(Entity):
371
    catalogItemId = Field(Integer, primary_key=True)
371
    catalogItemId = Field(Integer, primary_key=True)
372
    stockLinkedFeed = Field(Boolean)
372
    stockLinkedFeed = Field(Boolean)
373
    using_options(shortnames=True)
373
    using_options(shortnames=True)
374
    using_table_options(mysql_engine="InnoDB")
374
    using_table_options(mysql_engine="InnoDB")
-
 
375
 
-
 
376
class MarketPlaceItemPrice(Entity):    
-
 
377
    item_id = Field(Integer, primary_key=True, autoincrement=False)
-
 
378
    source = Field(Integer, primary_key=True, autoincrement=False)
-
 
379
    sellingPrice = Field(Float)
-
 
380
    lastUpdatedOn = Field(DateTime)
-
 
381
    lastUpdatedOnMarketplace = Field(DateTime,default = datetime.datetime.strptime('01-01-1970 15:00:00', '%d-%m-%Y %H:%M:%S'),server_default = '1970-01-01')
-
 
382
    suppressPriceFeed = Field(Boolean)
-
 
383
    isListedOnSource =  Field(Boolean)
-
 
384
    using_options(shortnames=True)
-
 
385
    using_table_options(mysql_engine="InnoDB")
375
    
386
    
376
def initialize(dbname='catalog', db_hostname="localhost"):
387
def initialize(dbname='catalog', db_hostname="localhost"):
377
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
388
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
378
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
389
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
379
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
390
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)