Subversion Repositories SmartDukaan

Rev

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

Rev 3089 Rev 3187
Line 194... Line 194...
194 
    email = Field(String(100), primary_key=True, autoincrement=False)
 194 
    email = Field(String(100), primary_key=True, autoincrement=False)
195 
    addedOn = Field(DateTime, primary_key=True, autoincrement=False)
195 
    addedOn = Field(DateTime, primary_key=True, autoincrement=False)
196 
    using_options(shortnames=True)
 196 
    using_options(shortnames=True)
197 
    using_table_options(mysql_engine="InnoDB")
 197 
    using_table_options(mysql_engine="InnoDB")
198
198
199 
def initialize(dbname='catalog'):
 199 
def initialize(dbname='catalog', db_hostname="localhost"):
200 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
 200 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
201 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
 201 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
202 
    engine = create_engine('mysql://root:shop2020@localhost/' + dbname, pool_recycle=7200)
 202 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
203 
    metadata.bind = engine
 203 
    metadata.bind = engine
204 
    metadata.bind.echo = True
 204 
    metadata.bind.echo = True
205 
    setup_all(True)
 205 
    setup_all(True)
206 
 
 206 
 
207 
if __name__=="__main__":
 207 
if __name__=="__main__":