Subversion Repositories SmartDukaan

Rev

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

Rev 12725 Rev 12730
Line 257... Line 257...
257 
    tin = Field(String(20), unique=True)
 257 
    tin = Field(String(20), unique=True)
258 
    spCounterSize = Field(Integer)
 258 
    spCounterSize = Field(Integer)
259 
    fpCounterSize = Field(Integer)
 259 
    fpCounterSize = Field(Integer)
260 
    dob = Field(String(20))
 260 
    dob = Field(String(20))
261 
    createdOn = Field(DateTime)
 261 
    createdOn = Field(DateTime)
- 
 
 262 
    lastPurchasedOn = Field(DateTime)
262 
    using_options(shortnames=True)
 263 
    using_options(shortnames=True)
263 
    using_table_options(mysql_engine="InnoDB")
 264 
    using_table_options(mysql_engine="InnoDB")
264 
 
 265 
 
265 
def initialize(dbname='user', db_hostname="localhost"):
 266 
def initialize(dbname='user', db_hostname="localhost"):
266 
    #metadata.bind = "sqlite:///user.sqlite" #need to read it from configserver.
 267 
    #metadata.bind = "sqlite:///user.sqlite" #need to read it from configserver.
267 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200, max_overflow=20)
 268 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200, max_overflow=20)
268 
    metadata.bind = engine
 269 
    metadata.bind = engine
269 
    metadata.bind.echo = False
 270 
    metadata.bind.echo = True
270 
    setup_all(True)
 271 
    setup_all(True)
271 
 
 272 
 
272 
if __name__=="__main__":
 273 
if __name__=="__main__":
273 
    initialize()
 274 
    initialize()