Subversion Repositories SmartDukaan

Rev

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

Rev 11095 Rev 11193
Line 447... Line 447...
447
    using_table_options(mysql_engine="InnoDB")
447
    using_table_options(mysql_engine="InnoDB")
448
    
448
    
449
class MarketPlaceHistory(Entity):
449
class MarketPlaceHistory(Entity):
450
    item_id = Field(Integer, primary_key=True, autoincrement=False)
450
    item_id = Field(Integer, primary_key=True, autoincrement=False)
451
    source = Field(Integer, primary_key=True, autoincrement=False)
451
    source = Field(Integer, primary_key=True, autoincrement=False)
452
    lowestTp = Field(Float)
-
 
453
    lowestPossibleTp = Field(Float)
452
    lowestPossibleTp = Field(Float)
454
    lowestPossibleSp = Field(Float)
453
    lowestPossibleSp = Field(Float)
455
    ourInventory = Field(Integer)
454
    ourInventory = Field(Integer)
456
    otherInventory = Field(Integer)
455
    otherInventory = Field(Integer)
457
    secondLowestInventory = Field(Integer)
456
    secondLowestInventory = Field(Integer)
458
    ourRank = Field(Integer)
457
    ourRank = Field(Integer)
-
 
458
    ourOfferPrice = Field(Float)
-
 
459
    ourSellingPrice = Field(Float)
-
 
460
    ourTp = Field(Float)
-
 
461
    ourNlc = Field(Float)
-
 
462
    ourRating = Field(Float)
-
 
463
    ourShippingTime = Field(String(10))
459
    competitionBasis = Field(Integer)
464
    competitionBasis = Field(Integer)
460
    competitiveCategory = Field(Integer)
465
    competitiveCategory = Field(Integer)
461
    risky = Field(Boolean)
466
    risky = Field(Boolean)
462
    lowestOfferPrice = Field(Float)
467
    lowestOfferPrice = Field(Float)
463
    lowestSellingPrice = Field(Float)
468
    lowestSellingPrice = Field(Float)
-
 
469
    lowestTp = Field(Float)
464
    lowestSellerName = Field(String(255))
470
    lowestSellerName = Field(String(255))
465
    lowestSellerCode = Field(String(255))
471
    lowestSellerCode = Field(String(255))
466
    ourOfferPrice = Field(Float)
472
    lowestSellerRating = Field(Float)
467
    ourSellingPrice = Field(Float)
473
    lowestSellerShippingTime = Field(String(10))
468
    ourTp = Field(Float)
-
 
469
    ourNlc = Field(Float)
-
 
470
    proposedSellingPrice = Field(Float)
474
    proposedSellingPrice = Field(Float)
471
    proposedTp = Field(Float)
475
    proposedTp = Field(Float)
472
    targetNlc = Field(Float)
476
    targetNlc = Field(Float)
473
    salesPotential = Field(Integer)
477
    salesPotential = Field(Integer)
474
    secondLowestSellerName = Field(String(255))
478
    secondLowestSellerName = Field(String(255))
475
    secondLowestSellerCode = Field(String(255))
479
    secondLowestSellerCode = Field(String(255))
476
    secondLowestSellingPrice = Field(Float)
480
    secondLowestSellingPrice = Field(Float)
477
    secondLowestOfferPrice = Field(Float)
481
    secondLowestOfferPrice = Field(Float)
478
    secondLowestTp = Field(Float)
482
    secondLowestTp = Field(Float)
-
 
483
    secondLowestSellerRating = Field(Float)
-
 
484
    secondLowestSellerShippingTime = Field(String(10))
-
 
485
    prefferedSellerName = Field(String(255))
-
 
486
    prefferedSellerCode = Field(String(255))
-
 
487
    prefferedSellerSellingPrice = Field(Float)
-
 
488
    prefferedSellerOfferPrice = Field(Float)
-
 
489
    prefferedSellerTp = Field(Float)
-
 
490
    prefferedSellerRating = Field(Float)
-
 
491
    prefferedSellerShippingTime = Field(String(10))
479
    marginIncreasedPotential = Field(Float)
492
    marginIncreasedPotential = Field(Float)
480
    margin = Field(Float)
493
    margin = Field(Float)
481
    competitorEnoughStock = Field(Boolean)
494
    competitorEnoughStock = Field(Boolean)
482
    ourEnoughStock = Field(Boolean)
495
    ourEnoughStock = Field(Boolean)
483
    totalSeller = Field(Integer)
496
    totalSeller = Field(Integer)
484
    salesPotential = Field(Integer)
-
 
485
    avgSales = Field(Float)
497
    avgSales = Field(Float)
486
    decision = Field(Integer)
498
    decision = Field(Integer)
487
    reason = Field(String(255))
499
    reason = Field(String(255))
488
    run = Field(Integer)
500
    run = Field(Integer)
489
    timestamp =Field(DateTime, primary_key=True, autoincrement=False)
-
 
490
    toGroup = Field(Boolean)
501
    toGroup = Field(Boolean)
-
 
502
    timestamp =Field(DateTime, primary_key=True, autoincrement=False)
491
    using_options(shortnames=True)
503
    using_options(shortnames=True)
492
    using_table_options(mysql_engine="InnoDB")
504
    using_table_options(mysql_engine="InnoDB")
-
 
505
 
493
    
506
    
494
class FlipkartItem(Entity):
507
class FlipkartItem(Entity):
495
    item_id = Field(Integer, primary_key=True, autoincrement = False)
508
    item_id = Field(Integer, primary_key=True, autoincrement = False)
496
    exceptionPrice = Field(Float)
509
    exceptionPrice = Field(Float)
497
    warehouseId = Field(Integer)
510
    warehouseId = Field(Integer)