| Line 579... |
Line 579... |
| 579 |
user_payout = Field(Float, default=0.0, server_default="0.0")
|
579 |
user_payout = Field(Float, default=0.0, server_default="0.0")
|
| 580 |
payout_description = Field(String(256))
|
580 |
payout_description = Field(String(256))
|
| 581 |
final_user_payout = Field(Integer)
|
581 |
final_user_payout = Field(Integer)
|
| 582 |
using_options(shortnames=True)
|
582 |
using_options(shortnames=True)
|
| 583 |
using_table_options(mysql_engine="InnoDB")
|
583 |
using_table_options(mysql_engine="InnoDB")
|
| - |
|
584 |
|
| - |
|
585 |
class notification_campaigns(Entity):
|
| - |
|
586 |
id = Field(Integer, primary_key=True, autoincrement=True)
|
| - |
|
587 |
name = Field(String(32))
|
| - |
|
588 |
title = Field(String(32))
|
| - |
|
589 |
message = Field(String(512))
|
| - |
|
590 |
type = Field(Enum('url','native','update'))
|
| - |
|
591 |
url = Field(String(512))
|
| - |
|
592 |
sql = Field(String(512))
|
| - |
|
593 |
expiresat = Field(DateTime)
|
| - |
|
594 |
status = Field(Enum('active','inactive'))
|
| - |
|
595 |
created = Field(DateTime)
|
| - |
|
596 |
using_options(shortnames=True)
|
| - |
|
597 |
using_table_options(mysql_engine="InnoDB")
|
| 584 |
|
598 |
|
| 585 |
def initialize(dbname='dtr', db_hostname="localhost", echo=True):
|
599 |
def initialize(dbname='dtr', db_hostname="localhost", echo=True):
|
| 586 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
600 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
| 587 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
601 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
| 588 |
cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|
602 |
cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|