| Line 454... |
Line 454... |
| 454 |
reason = Field(String(255))
|
454 |
reason = Field(String(255))
|
| 455 |
timestamp =Field(DateTime, primary_key=True, autoincrement=False)
|
455 |
timestamp =Field(DateTime, primary_key=True, autoincrement=False)
|
| 456 |
using_options(shortnames=True)
|
456 |
using_options(shortnames=True)
|
| 457 |
using_table_options(mysql_engine="InnoDB")
|
457 |
using_table_options(mysql_engine="InnoDB")
|
| 458 |
|
458 |
|
| - |
|
459 |
class FlipkartItem(Entity):
|
| - |
|
460 |
item_id = Field(Integer, primary_key=True, autoincrement = False)
|
| - |
|
461 |
exceptionPrice = Field(Float)
|
| - |
|
462 |
warehouseId = Field(Integer)
|
| - |
|
463 |
commissionValue = Field(Float)
|
| - |
|
464 |
serviceTaxValue = Field(Float)
|
| - |
|
465 |
maxNlc = Field(Float)
|
| - |
|
466 |
skuAtFlipkart = Field(String(255))
|
| - |
|
467 |
isListedOnFlipkart = Field(Boolean)
|
| - |
|
468 |
suppressPriceFeed = Field(Boolean)
|
| - |
|
469 |
suppressInventoryFeed = Field(Boolean)
|
| - |
|
470 |
updatedOn = Field(DateTime)
|
| - |
|
471 |
updatedBy = Field(String(255))
|
| - |
|
472 |
using_options(shortnames=True)
|
| - |
|
473 |
using_table_options(mysql_engine="InnoDB")
|
| - |
|
474 |
|
| 459 |
def initialize(dbname='catalog', db_hostname="localhost"):
|
475 |
def initialize(dbname='catalog', db_hostname="localhost"):
|
| 460 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
476 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
| 461 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
477 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
| 462 |
cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|
478 |
cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|
| 463 |
metadata.bind = cengine
|
479 |
metadata.bind = cengine
|