Subversion Repositories SmartDukaan

Rev

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

Rev 2020 Rev 2641
Line 247... Line 247...
247 
    url = Field(String(200))
 247 
    url = Field(String(200))
248 
    data = Field(String(200))
 248 
    data = Field(String(200))
249 
    using_options(shortnames=True)
 249 
    using_options(shortnames=True)
250 
    using_table_options(mysql_engine="InnoDB")
 250 
    using_table_options(mysql_engine="InnoDB")
251 
 
 251 
 
- 
 
 252 
class UserNote(Entity):
- 
 
 253 
    user_id = Field(Integer)
- 
 
 254 
    entity_id = Field(Integer)
- 
 
 255 
    slide_id = Field(Integer)
- 
 
 256 
    note = Field(String(500))
- 
 
 257 
    using_options(shortnames=True)
- 
 
 258 
    using_table_options(mysql_engine="InnoDB")
- 
 
 259
252 
def initialize(dbname='user'):
 260 
def initialize(dbname='user'):
253 
    #metadata.bind = "sqlite:///user.sqlite" #need to read it from configserver.
 261 
    #metadata.bind = "sqlite:///user.sqlite" #need to read it from configserver.
254 
    engine = create_engine('mysql://root:shop2020@localhost/' + dbname, pool_recycle=7200)
 262 
    engine = create_engine('mysql://root:shop2020@localhost/' + dbname, pool_recycle=7200)
255 
    metadata.bind = engine
 263 
    metadata.bind = engine
256 
    metadata.bind.echo = True
 264 
    metadata.bind.echo = True