Subversion Repositories SmartDukaan

Rev

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

Rev 9156 Rev 9242
Line 59... Line 59...
59 
    showSellingPrice = Field(Boolean)
 59 
    showSellingPrice = Field(Boolean)
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 
    isListedOnSnapdeal = Field(Boolean)
 - 
 
65 
    using_options(shortnames=True)
 64 
    using_options(shortnames=True)
66 
    using_table_options(mysql_engine="InnoDB")
 65 
    using_table_options(mysql_engine="InnoDB")
67
66
68 
    def __repr__(self):
 67 
    def __repr__(self):
69 
        return "<Item>%d</item>" % (self.id)
 68 
        return "<Item>%d</item>" % (self.id)
Line 304... Line 303...
304 
 
 303 
 
305 
class SnapdealItem(Entity):
 304 
class SnapdealItem(Entity):
306 
    item_id = Field(Integer, primary_key=True, autoincrement = False)
 305 
    item_id = Field(Integer, primary_key=True, autoincrement = False)
307 
    exceptionPrice = Field(Float)
 306 
    exceptionPrice = Field(Float)
308 
    warehouseId = Field(Integer)
 307 
    warehouseId = Field(Integer)
- 
 
 308 
    transferPrice = Field(Float)
- 
 
 309 
    sellingPrice = Field(Float)
- 
 
 310 
    courierCost =  Field(Float)
- 
 
 311 
    commission  =  Field(Float)
- 
 
 312 
    serviceTax  =  Field(Float)
- 
 
 313 
    updatedOn = Field(DateTime)
- 
 
 314 
    isListedOnSnapdeal = Field(Boolean)
- 
 
 315 
    suppressPriceFeed = Field(Boolean)
- 
 
 316 
    suppressInventoryFeed = Field(Boolean)
309 
    using_options(shortnames=True)
 317 
    using_options(shortnames=True)
310 
    using_table_options(mysql_engine="InnoDB")
 318 
    using_table_options(mysql_engine="InnoDB")
- 
 
 319 
 
- 
 
 320 
class SnapdealItemUpdateHistory(Entity):
- 
 
 321 
    id  = Field(Integer, primary_key=True, autoincrement = True)
- 
 
 322 
    item_id = Field(Integer)
- 
 
 323 
    isListedOnSnapdeal = Field(Boolean)
- 
 
 324 
    exceptionPrice = Field(Float)
- 
 
 325 
    warehouseId = Field(Integer)
- 
 
 326 
    transferPrice = Field(Float)
- 
 
 327 
    sellingPrice = Field(Float)
- 
 
 328 
    courierCost =  Field(Float)
- 
 
 329 
    commission  =  Field(Float)
- 
 
 330 
    serviceTax  =  Field(Float)
- 
 
 331 
    suppressPriceFeed = Field(Boolean)
- 
 
 332 
    suppressInventoryFeed = Field(Boolean)
- 
 
 333 
    updatedOn = Field(DateTime)
- 
 
 334 
    using_options(shortnames=True)
- 
 
 335 
    using_table_options(mysql_engine="InnoDB")
- 
 
 336
311
337
312 
def initialize(dbname='catalog', db_hostname="localhost"):
 338 
def initialize(dbname='catalog', db_hostname="localhost"):
313 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
 339 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
314 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
 340 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
315 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
 341 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
316 
    metadata.bind = cengine
 342 
    metadata.bind = cengine
317 
    metadata.bind.echo = True
 343 
    metadata.bind.echo = True
318 
    setup_all(True)
 344 
    setup_all(True)
319 
 
 345 
 
320 
if __name__=="__main__":
 346 
if __name__=="__main__":
321 
    initialize()
 - 
 
322 

            347
            
    initialize()

          

          

            -
            
 

            348