Subversion Repositories SmartDukaan

Rev

Rev 1422 | Rev 1891 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
353 ashish 1 
'''
2 
Created on 14-Jul-2010
3 
 
4 
@author: ashish
5 
'''
1131 chandransh 6 
from sqlalchemy import create_engine
353 ashish 7 
from elixir import *
746 rajveer 8 
import elixir
353 ashish 9 
 
10 
class Message(Entity):
11 
    id = Field(Integer, primary_key=True, autoincrement=True)
12 
    message_id = Field(Integer)
13 
    message = Field(String(200))
746 rajveer 14 
    using_options(shortnames=True)
15 
    using_table_options(mysql_engine="InnoDB")
353 ashish 16 
 
494 rajveer 17 
class DashboardUser(Entity):
18 
    username = Field(String(30), primary_key=True)
19 
    password =  Field(String(30))
20 
    warehouseId = Field(Integer)
21 
    addedOn = Field(DateTime)
22 
    loggedOn = Field(DateTime)
23 
    status = Field(Integer)
24 
    otherInfo = Field(String(200))
746 rajveer 25 
    using_options(shortnames=True)
26 
    using_table_options(mysql_engine="InnoDB")
353 ashish 27 
 
759 chandransh 28 
class LogisticsUser(Entity):
29 
    username = Field(String(30), primary_key=True)
30 
    password = Field(String(30))
31 
    providerId = Field(Integer)
32 
    using_options(shortnames=True)
33 
    using_table_options(mysql_engine="InnoDB")
34 
 
1610 ankur.sing 35 
class StatisticsUser(Entity):
36 
    username = Field(String(30), primary_key=True)
37 
    password = Field(String(30))
38 
    using_options(shortnames=True)
39 
    using_table_options(mysql_engine="InnoDB")
40 
 
1395 varun.gupt 41 
class UserEmail(Entity):
1422 varun.gupt 42 
    id = Field(Integer, primary_key=True, autoincrement=True)
1395 varun.gupt 43 
    emailTo = Field(String(100))
44 
    emailFrom = Field(String(60))
45 
    subject = Field(String(120))
46 
    body = Field(Text())
47 
    source = Field(String(20))
48 
    emailType = Field(String(40))
49 
    status = Field(Boolean())
50 
    timestamp = Field(DateTime())
51 
    using_options(shortnames=True)
52 
    using_table_options(mysql_engine="InnoDB")
53 
 
1248 chandransh 54 
def initialize(dbname='helper'):
746 rajveer 55 
    #metadata.bind = "sqlite:///message.sqlite" #need to read it from configserver.
1248 chandransh 56 
    engine = create_engine('mysql://root:shop2020@localhost/' + dbname, pool_recycle=7200)
1131 chandransh 57 
    metadata.bind = engine
353 ashish 58 
    metadata.bind.echo = True
59 
    setup_all(True)
60 
 
61 
if __name__=="__main__":
62 
    initialize()
759 chandransh 63