| Line 529... |
Line 529... |
| 529 |
date = Field(Date)
|
529 |
date = Field(Date)
|
| 530 |
totalPayoutAmount = Field(Integer)
|
530 |
totalPayoutAmount = Field(Integer)
|
| 531 |
totalOfferAmount = Field(Integer)
|
531 |
totalOfferAmount = Field(Integer)
|
| 532 |
using_options(shortnames=True)
|
532 |
using_options(shortnames=True)
|
| 533 |
using_table_options(mysql_engine="InnoDB")
|
533 |
using_table_options(mysql_engine="InnoDB")
|
| 534 |
|
534 |
|
| - |
|
535 |
class app_transactions(Entity):
|
| - |
|
536 |
retailer_id = Field(Integer)
|
| - |
|
537 |
app_id = Field(Integer)
|
| - |
|
538 |
app_name = Field(String(256))
|
| - |
|
539 |
cashback_status= Field(Integer)
|
| - |
|
540 |
redirect_url = Field(String(256))
|
| - |
|
541 |
cash_back_description = Field(String(256))
|
| - |
|
542 |
payout_status = Field(Integer)
|
| - |
|
543 |
overridenCashBack = Field(Integer)
|
| - |
|
544 |
isCashBackOverriden=Field(Boolean)
|
| - |
|
545 |
transaction_time = Field(DateTime)
|
| - |
|
546 |
payout_time = Field(DateTime)
|
| - |
|
547 |
offer_price=Field(Float, default=0.0, server_default="0.0")
|
| - |
|
548 |
payout_amount=Field(Float, default=0.0, server_default="0.0")
|
| - |
|
549 |
user_payout = Field(Float, default=0.0, server_default="0.0")
|
| - |
|
550 |
payout_description = Field(String(256))
|
| - |
|
551 |
using_options(shortnames=True)
|
| - |
|
552 |
using_table_options(mysql_engine="InnoDB")
|
| 535 |
|
553 |
|
| 536 |
def initialize(dbname='dtr', db_hostname="localhost", echo=True):
|
554 |
def initialize(dbname='dtr', db_hostname="localhost", echo=True):
|
| 537 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
555 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
| 538 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
556 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
| 539 |
cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|
557 |
cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|
| 540 |
metadata.bind = cengine
|
558 |
metadata.bind = cengine
|