Subversion Repositories SmartDukaan

Rev

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

Rev 6367 Rev 6389
Line 200... Line 200...
200 
    url = Field(String(200))
 200 
    url = Field(String(200))
201 
    data = Field(String(200))
 201 
    data = Field(String(200))
202 
    using_options(shortnames=True)
 202 
    using_options(shortnames=True)
203 
    using_table_options(mysql_engine="InnoDB")
 203 
    using_table_options(mysql_engine="InnoDB")
204 
 
 204 
 
205 
class UserNote(Entity):
 - 
 
206 
    user_id = Field(Integer)
 - 
 
207 
    entity_id = Field(Integer)
 - 
 
208 
    slide = Field(String(30))
 - 
 
209 
    note = Field(String(500))
 - 
 
210 
    using_options(shortnames=True)
 - 
 
211 
    using_table_options(mysql_engine="InnoDB")
 - 
 
212
- 
 
213 
def initialize(dbname='user', db_hostname="localhost"):
 205 
def initialize(dbname='user', db_hostname="localhost"):
214 
    #metadata.bind = "sqlite:///user.sqlite" #need to read it from configserver.
 206 
    #metadata.bind = "sqlite:///user.sqlite" #need to read it from configserver.
215 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200, max_overflow=20)
 207 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200, max_overflow=20)
216 
    metadata.bind = engine
 208 
    metadata.bind = engine
217 
    metadata.bind.echo = True
 209 
    metadata.bind.echo = True