Subversion Repositories SmartDukaan

Rev

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

Rev 2747 Rev 35608
Line 77... Line 77...
77 
    name = Field(String(50), primary_key=True)
 77 
    name = Field(String(50), primary_key=True)
78 
    value = Field(String(250))
 78 
    value = Field(String(250))
79 
    using_options(shortnames=True)
 79 
    using_options(shortnames=True)
80 
    using_table_options(mysql_engine="InnoDB")
 80 
    using_table_options(mysql_engine="InnoDB")
81
81
82 
def initialize(dbname='payment'):
 82 
def initialize(dbname='payment', db_hostname='localhost'):
83 
    #metadata.bind = "sqlite:///payment.sqlite" #need to read it from configserver.
 83 
    #metadata.bind = "sqlite:///payment.sqlite" #need to read it from configserver.
84 
    engine = create_engine('mysql://root:shop2020@localhost/' + dbname, pool_recycle=7200)
 84 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname,
- 
 
 85 
                           pool_recycle=3600, pool_timeout=30, pool_pre_ping=True)
85 
    metadata.bind = engine
 86 
    metadata.bind = engine
86 
    metadata.bind.echo = True
 87 
    metadata.bind.echo = False
87 
    setup_all(True)
 88 
    setup_all(True)
88 
 
 89 
 
89 
if __name__=="__main__":
 90 
if __name__=="__main__":
90 
    initialize()
 91 
    initialize()
91 

            92