Subversion Repositories SmartDukaan

Rev

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

Rev 35608 Rev 35701
Line 20... Line 20...
20
 
20
 
21
def initialize(dbname='transaction', db_hostname="localhost", echoOn=False, setup=True):
21
def initialize(dbname='transaction', db_hostname="localhost", echoOn=False, setup=True):
22
    #metadata.bind = "sqlite:///Transactionsnew.sqlite"
22
    #metadata.bind = "sqlite:///Transactionsnew.sqlite"
23
    #metadata.bind = 'mysql://root:shop2020@localhost/transaction'
23
    #metadata.bind = 'mysql://root:shop2020@localhost/transaction'
24
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname,
24
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname,
25
                           pool_recycle=3600, pool_timeout=30, pool_pre_ping=True)
25
                           pool_recycle=3600, pool_timeout=30)
26
    metadata.bind = engine
26
    metadata.bind = engine
27
    metadata.bind.echo = echoOn
27
    metadata.bind.echo = echoOn
28
    setup_all(setup)
28
    setup_all(setup)
29
 
29
 
30
 
30