| Line 543... |
Line 543... |
| 543 |
flipkartSerialNumber = Field(String(255))
|
543 |
flipkartSerialNumber = Field(String(255))
|
| 544 |
updatedOn = Field(DateTime)
|
544 |
updatedOn = Field(DateTime)
|
| 545 |
updatedBy = Field(String(255))
|
545 |
updatedBy = Field(String(255))
|
| 546 |
using_options(shortnames=True)
|
546 |
using_options(shortnames=True)
|
| 547 |
using_table_options(mysql_engine="InnoDB")
|
547 |
using_table_options(mysql_engine="InnoDB")
|
| - |
|
548 |
|
| - |
|
549 |
'''
|
| - |
|
550 |
class DealTag(Entity):
|
| - |
|
551 |
id = Field(Integer, primary_key=True, autoincrement = True)
|
| - |
|
552 |
name = Field(String(100))
|
| - |
|
553 |
using_options(shortnames=True)
|
| - |
|
554 |
using_table_options(mysql_engine="InnoDB")
|
| - |
|
555 |
|
| - |
|
556 |
class ItemTag(Entity):
|
| - |
|
557 |
itemId= Field(Integer, primary_key=True)
|
| - |
|
558 |
tagId = Field(Integer, primary_key=True)
|
| - |
|
559 |
startDate = Field(DateTime)
|
| - |
|
560 |
endDate = Field(DateTime)
|
| - |
|
561 |
status = Field(Boolean)
|
| - |
|
562 |
using_options(shortnames=True)
|
| - |
|
563 |
using_table_options(mysql_engine="InnoDB")
|
| 548 |
|
564 |
'''
|
| - |
|
565 |
|
| 549 |
class PrivateDeals(Entity):
|
566 |
class PrivateDeals(Entity):
|
| 550 |
item_id = Field(Integer, primary_key=True, autoincrement = False)
|
567 |
item_id = Field(Integer, primary_key=True, autoincrement = False)
|
| 551 |
dealFreebieItemId = Field(Integer)
|
568 |
dealFreebieItemId = Field(Integer)
|
| 552 |
dealPrice = Field(Float)
|
569 |
dealPrice = Field(Float)
|
| 553 |
startDate = Field(DateTime)
|
570 |
startDate = Field(DateTime)
|
| Line 722... |
Line 739... |
| 722 |
class OutboundAffiliateMaster(Entity):
|
739 |
class OutboundAffiliateMaster(Entity):
|
| 723 |
id = Field(Integer, primary_key=True, autoincrement=True)
|
740 |
id = Field(Integer, primary_key=True, autoincrement=True)
|
| 724 |
name = Field(String(100))
|
741 |
name = Field(String(100))
|
| 725 |
using_options(shortnames=True)
|
742 |
using_options(shortnames=True)
|
| 726 |
using_table_options(mysql_engine="InnoDB")
|
743 |
using_table_options(mysql_engine="InnoDB")
|
| - |
|
744 |
|
| - |
|
745 |
class HsItem(Entity):
|
| - |
|
746 |
hsItemId = Field(String(32), primary_key=True)
|
| - |
|
747 |
itemId = Field(Integer, primary_key=True, autoincrement = False)
|
| - |
|
748 |
hsProductId = Field(String(32))
|
| - |
|
749 |
listingPrice = Field(Float)
|
| - |
|
750 |
defaultWarehouseId = Field(Integer)
|
| - |
|
751 |
addedTimestamp = Field(DateTime)
|
| - |
|
752 |
addedBy = Field(String(100))
|
| - |
|
753 |
using_options(shortnames=True)
|
| - |
|
754 |
using_table_options(mysql_engine="InnoDB")
|
| 727 |
|
755 |
|
| 728 |
def initialize(dbname='catalog', db_hostname="localhost"):
|
756 |
def initialize(dbname='catalog', db_hostname="localhost"):
|
| 729 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
757 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
| 730 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
758 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
| 731 |
cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|
759 |
cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|