Subversion Repositories SmartDukaan

Rev

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

Rev 19421 Rev 19426
Line 124... Line 124...
124 
    minimumCodCollectionCharges = Field(Float)
 124 
    minimumCodCollectionCharges = Field(Float)
125 
    codCollectionFactor = Field(Float, default=0)
 125 
    codCollectionFactor = Field(Float, default=0)
126 
    using_options(shortnames=True)
 126 
    using_options(shortnames=True)
127 
    using_table_options(mysql_engine="InnoDB")
 127 
    using_table_options(mysql_engine="InnoDB")
128 
 
 128 
 
129 
def initialize(dbname="logistics",db_hostname="localhost"):
 129 
def initialize(dbname="logistics",db_hostname="localhost", echoOn=True, setup=True):
130 
    #metadata.bind = "sqlite:///logistics.sqlite" #need to read it from configserver.
 130 
    #metadata.bind = "sqlite:///logistics.sqlite" #need to read it from configserver.
131 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
 131 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
132 
    metadata.bind = engine
 132 
    metadata.bind = engine
133 
    metadata.bind.echo = True
 133 
    metadata.bind.echo = echoOn
134 
    setup_all(True)
 134 
    setup_all(setup)
135 
 
 135 
 
136 
if __name__=="__main__":
 136 
if __name__=="__main__":
137 
    initialize()
 137 
    initialize()
138
138
139 

            139