Subversion Repositories SmartDukaan

Rev

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

Rev 15791 Rev 15816
Line 326... Line 326...
326 
    message = Field(String(64))
 326 
    message = Field(String(64))
327 
    response_time = Field(DateTime)
 327 
    response_time = Field(DateTime)
328 
    created = Field(DateTime)
 328 
    created = Field(DateTime)
329 
    using_options(shortnames=True)
 329 
    using_options(shortnames=True)
330 
    using_table_options(mysql_engine="InnoDB")
 330 
    using_table_options(mysql_engine="InnoDB")
- 
 
 331
331
332
332 
class MerchantSubOrders(Entity):
 333 
class MerchantSubOrders(Entity):
333 
    orderId = Field(Integer, primary_key= True, autoincrement=False)
 334 
    orderId = Field(Integer, primary_key= True, autoincrement=False)
334 
    merchantOrderId = Field(String(30), primary_key=True)
 335 
    merchantOrderId = Field(String(30), primary_key=True)
335 
    merchantSubOrderId = Field(String(50), primary_key=True)
 336 
    merchantSubOrderId = Field(String(50), primary_key=True)
Line 343... Line 344...
343 
    unitPrice = Field(Float)
 344 
    unitPrice = Field(Float)
344 
    status = Field(String(30))
 345 
    status = Field(String(30))
345 
    createdTime = Field(DateTime)
 346 
    createdTime = Field(DateTime)
346 
    using_options(shortnames=True)
 347 
    using_options(shortnames=True)
347 
    using_table_options(mysql_engine="InnoDB")
 348 
    using_table_options(mysql_engine="InnoDB")
- 
 
 349
- 
 
 350 
class NotificationViews(Entity):
- 
 
 351 
    id = Field(Integer, primary_key= True)
- 
 
 352 
    user_id = Field(Integer(unsigned=True))
- 
 
 353 
    notification_rule_id = Field(Integer(unsigned=True))
- 
 
 354 
    created = Field(DateTime)
- 
 
 355 
    using_options(shortnames=True)
- 
 
 356 
    using_table_options(mysql_engine="InnoDB")
- 
 
 357
- 
 
 358 
class MissingAmazonOrderUsers(Entity):
- 
 
 359 
    user_id = Field(Integer, primary_key= True)
- 
 
 360 
    using_options(shortnames=True)
- 
 
 361 
    using_table_options(mysql_engine="InnoDB")
- 
 
 362 
class PendingToTrackAmazonOrderUsers(Entity):
- 
 
 363 
    user_id = Field(Integer, primary_key= True)
- 
 
 364 
    using_options(shortnames=True)
- 
 
 365 
    using_table_options(mysql_engine="InnoDB")
- 
 
 366
- 
 
 367
348 
 
 368 
 
349
369
350 
def initialize(dbname='dtr', db_hostname="localhost", echo=True):
 370 
def initialize(dbname='dtr', db_hostname="localhost", echo=True):
351 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
 371 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
352 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
 372 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'