| Line 60... |
Line 60... |
| 60 |
preferredInsurer = Field(Integer)
|
60 |
preferredInsurer = Field(Integer)
|
| 61 |
asin = Field(String(20))
|
61 |
asin = Field(String(20))
|
| 62 |
holdInventory = Field(Integer, default=0, server_default="0")
|
62 |
holdInventory = Field(Integer, default=0, server_default="0")
|
| 63 |
defaultInventory = Field(Integer, default=0, server_default="0")
|
63 |
defaultInventory = Field(Integer, default=0, server_default="0")
|
| 64 |
holdOverride = Field(Boolean)
|
64 |
holdOverride = Field(Boolean)
|
| 65 |
packQuantity = Field(Integer)
|
65 |
packQuantity = Field(Integer, default=1, server_default="1")
|
| - |
|
66 |
quantityStep = Field(Integer, default=1, server_default="1")
|
| - |
|
67 |
minimumBuyQuantity = Field(Integer, default=1, server_default="1")
|
| 66 |
using_options(shortnames=True)
|
68 |
using_options(shortnames=True)
|
| 67 |
using_table_options(mysql_engine="InnoDB")
|
69 |
using_table_options(mysql_engine="InnoDB")
|
| 68 |
|
70 |
|
| 69 |
def __repr__(self):
|
71 |
def __repr__(self):
|
| 70 |
return "<Item>%d</item>" % (self.id)
|
72 |
return "<Item>%d</item>" % (self.id)
|
| Line 793... |
Line 795... |
| 793 |
fixedMarginPercentage = Field(Float)
|
795 |
fixedMarginPercentage = Field(Float)
|
| 794 |
logisticCostSnapdeal = Field(Float)
|
796 |
logisticCostSnapdeal = Field(Float)
|
| 795 |
woodenPackagingCost = Field(Float)
|
797 |
woodenPackagingCost = Field(Float)
|
| 796 |
weightSnapdeal = Field(Float)
|
798 |
weightSnapdeal = Field(Float)
|
| 797 |
|
799 |
|
| - |
|
800 |
class BulkItemPricing(Entity):
|
| - |
|
801 |
id = Field(Integer, primary_key=True, autoincrement = True)
|
| - |
|
802 |
item_id = Field(Integer, index=True)
|
| - |
|
803 |
quantity = Field(Integer)
|
| - |
|
804 |
price = Field(Float)
|
| - |
|
805 |
using_options(shortnames=True)
|
| - |
|
806 |
using_table_options(mysql_engine="InnoDB")
|
| - |
|
807 |
|
| 798 |
def initialize(dbname='catalog', db_hostname="localhost", setup=True):
|
808 |
def initialize(dbname='catalog', db_hostname="localhost", setup=True):
|
| 799 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
809 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
| 800 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
810 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
| 801 |
cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|
811 |
cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|
| 802 |
metadata.bind = cengine
|
812 |
metadata.bind = cengine
|