Subversion Repositories SmartDukaan

Rev

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

Rev 7770 Rev 7977
Line 244... Line 244...
244 
    mfnPriceLastUpdatedOnSc = Field(DateTime)
 244 
    mfnPriceLastUpdatedOnSc = Field(DateTime)
245 
    fbaPriceLastUpdatedOnSc = Field(DateTime)
 245 
    fbaPriceLastUpdatedOnSc = Field(DateTime)
246 
    using_options(shortnames=True)
 246 
    using_options(shortnames=True)
247 
    using_table_options(mysql_engine="InnoDB")
 247 
    using_table_options(mysql_engine="InnoDB")
248
248
- 
 
 249 
class PageViewEvents(Entity):
- 
 
 250 
    id = Field(Integer, primary_key=True, autoincrement=True)
- 
 
 251 
    catalogId = Field(Integer)
- 
 
 252 
    url = Field(String(255))
- 
 
 253 
    sellingPrice = Field(Float)
- 
 
 254 
    comingSoon = Field(Boolean)
- 
 
 255 
    ip = Field(String(255))
- 
 
 256 
    sessionId = Field(String(255))
- 
 
 257 
    eventTimestamp = Field(DateTime)
- 
 
 258 
    using_options(shortnames=True)
- 
 
 259 
    using_table_options(mysql_engine="InnoDB")
- 
 
 260
- 
 
 261 
class CartEvents(Entity):
- 
 
 262 
    id = Field(Integer, primary_key=True, autoincrement=True)
- 
 
 263 
    catalogId = Field(Integer)
- 
 
 264 
    itemId = Field(Integer)
- 
 
 265 
    sellingPrice = Field(Float)
- 
 
 266 
    inStock = Field(Boolean)
- 
 
 267 
    comingSoon = Field(Boolean)
- 
 
 268 
    ip = Field(String(255))
- 
 
 269 
    sessionId = Field(String(255))
- 
 
 270 
    eventTimestamp = Field(DateTime)
- 
 
 271 
    using_options(shortnames=True)
- 
 
 272 
    using_table_options(mysql_engine="InnoDB")
- 
 
 273
- 
 
 274
- 
 
 275
- 
 
 276
249 
def initialize(dbname='catalog', db_hostname="localhost"):
 277 
def initialize(dbname='catalog', db_hostname="localhost"):
250 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
 278 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
251 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
 279 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
252 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
 280 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
253 
    metadata.bind = cengine
 281 
    metadata.bind = cengine