Subversion Repositories SmartDukaan

Rev

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

Rev 20837 Rev 21093
Line 132... Line 132...
132 
    name = Field(String(100))
 132 
    name = Field(String(100))
133 
    value = Field(String(100))
 133 
    value = Field(String(100))
134 
    using_options(shortnames=True)
 134 
    using_options(shortnames=True)
135 
    using_table_options(mysql_engine="InnoDB")
 135 
    using_table_options(mysql_engine="InnoDB")
136 
 
 136 
 
- 
 
 137 
class PincodeStates(Entity):
- 
 
 138 
    pin = Field(Integer(6), primary_key=True)
- 
 
 139 
    state = Field(String(64))
- 
 
 140 
    using_options(shortnames=True)
- 
 
 141 
    using_table_options(mysql_engine="InnoDB")
- 
 
 142 
 
137 
def initialize(dbname="logistics",db_hostname="localhost", echoOn=True, setup=True):
 143 
def initialize(dbname="logistics",db_hostname="localhost", echoOn=True, setup=True):
138 
    #metadata.bind = "sqlite:///logistics.sqlite" #need to read it from configserver.
 144 
    #metadata.bind = "sqlite:///logistics.sqlite" #need to read it from configserver.
139 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
 145 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
140 
    metadata.bind = engine
 146 
    metadata.bind = engine
141 
    metadata.bind.echo = echoOn
 147 
    metadata.bind.echo = echoOn