Subversion Repositories SmartDukaan

Rev

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

Rev 7272 Rev 7281
Line 203... Line 203...
203 
    maxPrice = Field(Float)
 203 
    maxPrice = Field(Float)
204 
    minAdvancePrice = Field(Float)
 204 
    minAdvancePrice = Field(Float)
205 
    using_options(shortnames=True)
 205 
    using_options(shortnames=True)
206 
    using_table_options(mysql_engine="InnoDB")
 206 
    using_table_options(mysql_engine="InnoDB")
207
207
- 
 
 208 
class Amazonlisted(Entity):
- 
 
 209 
    itemId = Field(Integer, primary_key=True, autoincrement=True)
- 
 
 210 
    asin = Field(String(255))
- 
 
 211 
    name = Field(String(255))
- 
 
 212 
    brand = Field(String(255))
- 
 
 213 
    model = Field(String(255))
- 
 
 214 
    manufacturer_name = Field(String(255))
- 
 
 215 
    part_number = Field(String(255))
- 
 
 216 
    ean = Field(String(255))
- 
 
 217 
    upc = Field(String(255))
- 
 
 218 
    fbaPrice = Field(Float)
- 
 
 219 
    sellingPrice = Field(Float)
- 
 
 220 
    isFba = Field(Boolean)
- 
 
 221 
    isNonFba = Field(Boolean)
- 
 
 222 
    isInventoryOverride = Field(Boolean)
- 
 
 223 
    color = Field(String(255))
- 
 
 224 
    category = Field(String(255))
- 
 
 225 
    using_options(shortnames=True)
- 
 
 226 
    using_table_options(mysql_engine="InnoDB")
- 
 
 227
208 
def initialize(dbname='catalog', db_hostname="localhost"):
 228 
def initialize(dbname='catalog', db_hostname="localhost"):
209 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
 229 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
210 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
 230 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
211 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
 231 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
212 
    metadata.bind = cengine
 232 
    metadata.bind = cengine