Subversion Repositories SmartDukaan

Rev

Rev 21097 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 21097 Rev 35608
Line 138... Line 138...
138 
    pin = Field(Integer(6), primary_key=True)
 138 
    pin = Field(Integer(6), primary_key=True)
139 
    statename = Field(String(64))
 139 
    statename = Field(String(64))
140 
    using_options(shortnames=True)
 140 
    using_options(shortnames=True)
141 
    using_table_options(mysql_engine="InnoDB")
 141 
    using_table_options(mysql_engine="InnoDB")
142 
 
 142 
 
143 
def initialize(dbname="logistics",db_hostname="localhost", echoOn=True, setup=True):
 143 
def initialize(dbname="logistics",db_hostname="localhost", echoOn=False, setup=True):
144 
    #metadata.bind = "sqlite:///logistics.sqlite" #need to read it from configserver.
 144 
    #metadata.bind = "sqlite:///logistics.sqlite" #need to read it from configserver.
145 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
 145 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname,
- 
 
 146 
                           pool_recycle=3600, pool_timeout=30, pool_pre_ping=True)
146 
    metadata.bind = engine
 147 
    metadata.bind = engine
147 
    metadata.bind.echo = echoOn
 148 
    metadata.bind.echo = echoOn
148 
    setup_all(setup)
 149 
    setup_all(setup)
149 
 
 150 
 
150 
if __name__=="__main__":
 151 
if __name__=="__main__":