Subversion Repositories SmartDukaan

Rev

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

Rev 1248 Rev 1395
Line 30... Line 30...
30
    password = Field(String(30))
30
    password = Field(String(30))
31
    providerId = Field(Integer)
31
    providerId = Field(Integer)
32
    using_options(shortnames=True)
32
    using_options(shortnames=True)
33
    using_table_options(mysql_engine="InnoDB")
33
    using_table_options(mysql_engine="InnoDB")
34
 
34
 
-
 
35
class UserEmail(Entity):
-
 
36
    emailTo = Field(String(100))
-
 
37
    emailFrom = Field(String(60))
-
 
38
    subject = Field(String(120))
-
 
39
    body = Field(Text())
-
 
40
    source = Field(String(20))
-
 
41
    emailType = Field(String(40))
-
 
42
    status = Field(Boolean())
-
 
43
    timestamp = Field(DateTime())
-
 
44
    using_options(shortnames=True)
-
 
45
    using_table_options(mysql_engine="InnoDB")
-
 
46
    
35
def initialize(dbname='helper'):
47
def initialize(dbname='helper'):
36
    #metadata.bind = "sqlite:///message.sqlite" #need to read it from configserver.
48
    #metadata.bind = "sqlite:///message.sqlite" #need to read it from configserver.
37
    engine = create_engine('mysql://root:shop2020@localhost/' + dbname, pool_recycle=7200)
49
    engine = create_engine('mysql://root:shop2020@localhost/' + dbname, pool_recycle=7200)
38
    metadata.bind = engine
50
    metadata.bind = engine
39
    metadata.bind.echo = True
51
    metadata.bind.echo = True