| Line 672... |
Line 672... |
| 672 |
total = Field(Integer, default=0)
|
672 |
total = Field(Integer, default=0)
|
| 673 |
request_failed = Field(Integer, default=0)
|
673 |
request_failed = Field(Integer, default=0)
|
| 674 |
invalid_tin = Field(Integer, default=0)
|
674 |
invalid_tin = Field(Integer, default=0)
|
| 675 |
using_options(shortnames=True)
|
675 |
using_options(shortnames=True)
|
| 676 |
using_table_options(mysql_engine="InnoDB")
|
676 |
using_table_options(mysql_engine="InnoDB")
|
| - |
|
677 |
|
| - |
|
678 |
class profitmandi_sms(Entity):
|
| - |
|
679 |
id = Field(Integer(unsigned=True), primary_key=True)
|
| - |
|
680 |
mobile_number = Field(String(10))
|
| - |
|
681 |
identifier = Field(Integer(unsigned=True))
|
| - |
|
682 |
sms_type = Field(Enum('code'))
|
| - |
|
683 |
sms_id = Field(String(128))
|
| - |
|
684 |
status = Field(String(512))
|
| - |
|
685 |
created = Field(DateTime, default=func.now())
|
| - |
|
686 |
modified = Field(DateTime, default=func.now(), onupdate=func.now())
|
| - |
|
687 |
using_options(shortnames=True)
|
| - |
|
688 |
using_table_options(mysql_engine="InnoDB")
|
| 677 |
|
689 |
|
| 678 |
def initialize(dbname='dtr', db_hostname="localhost", echo=True, setup=True):
|
690 |
def initialize(dbname='dtr', db_hostname="localhost", echo=True, setup=True):
|
| 679 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
691 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
| 680 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
692 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
| 681 |
cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|
693 |
cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|
| 682 |
metadata.bind = cengine
|
694 |
metadata.bind = cengine
|