| Line 318... |
Line 318... |
| 318 |
isListedOnSnapdeal = Field(Boolean)
|
318 |
isListedOnSnapdeal = Field(Boolean)
|
| 319 |
suppressPriceFeed = Field(Boolean)
|
319 |
suppressPriceFeed = Field(Boolean)
|
| 320 |
suppressInventoryFeed = Field(Boolean)
|
320 |
suppressInventoryFeed = Field(Boolean)
|
| 321 |
supc = Field(String(255))
|
321 |
supc = Field(String(255))
|
| 322 |
shippingTime = Field(Integer)
|
322 |
shippingTime = Field(Integer)
|
| - |
|
323 |
priceUpdatedBy = Field(String(255))
|
| 323 |
using_options(shortnames=True)
|
324 |
using_options(shortnames=True)
|
| 324 |
using_table_options(mysql_engine="InnoDB")
|
325 |
using_table_options(mysql_engine="InnoDB")
|
| 325 |
|
326 |
|
| 326 |
class SnapdealItemUpdateHistory(Entity):
|
327 |
class SnapdealItemUpdateHistory(Entity):
|
| 327 |
id = Field(Integer, primary_key=True, autoincrement = True)
|
328 |
id = Field(Integer, primary_key=True, autoincrement = True)
|
| Line 338... |
Line 339... |
| 338 |
suppressInventoryFeed = Field(Boolean)
|
339 |
suppressInventoryFeed = Field(Boolean)
|
| 339 |
maxNlc = Field(Float)
|
340 |
maxNlc = Field(Float)
|
| 340 |
skuAtSnapdeal = Field(String(255))
|
341 |
skuAtSnapdeal = Field(String(255))
|
| 341 |
updatedOn = Field(DateTime)
|
342 |
updatedOn = Field(DateTime)
|
| 342 |
supc = Field(String(255))
|
343 |
supc = Field(String(255))
|
| - |
|
344 |
priceUpdatedBy = Field(String(255))
|
| 343 |
using_options(shortnames=True)
|
345 |
using_options(shortnames=True)
|
| 344 |
using_table_options(mysql_engine="InnoDB")
|
346 |
using_table_options(mysql_engine="InnoDB")
|
| 345 |
|
347 |
|
| 346 |
class MarketplaceItems(Entity):
|
348 |
class MarketplaceItems(Entity):
|
| 347 |
itemId = Field(Integer,primary_key=True, autoincrement = False)
|
349 |
itemId = Field(Integer,primary_key=True, autoincrement = False)
|
| Line 382... |
Line 384... |
| 382 |
suppressPriceFeed = Field(Boolean)
|
384 |
suppressPriceFeed = Field(Boolean)
|
| 383 |
isListedOnSource = Field(Boolean)
|
385 |
isListedOnSource = Field(Boolean)
|
| 384 |
using_options(shortnames=True)
|
386 |
using_options(shortnames=True)
|
| 385 |
using_table_options(mysql_engine="InnoDB")
|
387 |
using_table_options(mysql_engine="InnoDB")
|
| 386 |
|
388 |
|
| - |
|
389 |
class SourcePercentageMaster(Entity):
|
| - |
|
390 |
source = Field(Integer, primary_key=True, autoincrement=False)
|
| - |
|
391 |
emiFee = Field(Float)
|
| - |
|
392 |
closingFee = Field(Float)
|
| - |
|
393 |
returnProvision = Field(Float)
|
| - |
|
394 |
commission = Field(Float)
|
| - |
|
395 |
serviceTax = Field(Float)
|
| - |
|
396 |
using_options(shortnames=True)
|
| - |
|
397 |
using_table_options(mysql_engine="InnoDB")
|
| - |
|
398 |
|
| - |
|
399 |
class SourceItemPercentage(Entity):
|
| - |
|
400 |
item_id = Field(Integer, primary_key=True, autoincrement=False)
|
| - |
|
401 |
source = Field(Integer, primary_key=True, autoincrement=False)
|
| - |
|
402 |
emiFee = Field(Float)
|
| - |
|
403 |
closingFee = Field(Float)
|
| - |
|
404 |
returnProvision = Field(Float)
|
| - |
|
405 |
commission = Field(Float)
|
| - |
|
406 |
serviceTax = Field(Float)
|
| - |
|
407 |
using_options(shortnames=True)
|
| - |
|
408 |
using_table_options(mysql_engine="InnoDB")
|
| - |
|
409 |
|
| 387 |
def initialize(dbname='catalog', db_hostname="localhost"):
|
410 |
def initialize(dbname='catalog', db_hostname="localhost"):
|
| 388 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
411 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
| 389 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
412 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
| 390 |
cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|
413 |
cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|
| 391 |
metadata.bind = cengine
|
414 |
metadata.bind = cengine
|