Subversion Repositories SmartDukaan

Rev

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

Rev 5863 Rev 6524
Line 58... Line 58...
58 
    dest_pincode = Field(String(6), primary_key=True)
 58 
    dest_pincode = Field(String(6), primary_key=True)
59 
    dest_code = Field(String(10))
 59 
    dest_code = Field(String(10))
60 
    exp = Field(Boolean)
 60 
    exp = Field(Boolean)
61 
    cod = Field(Boolean)
 61 
    cod = Field(Boolean)
62 
    station_type = Field(Integer)
 62 
    station_type = Field(Integer)
- 
 
 63 
    otgAvailable = Field(Boolean)
63 
    using_options(shortnames=True)
 64 
    using_options(shortnames=True)
64 
    using_table_options(mysql_engine="InnoDB")
 65 
    using_table_options(mysql_engine="InnoDB")
65 
 
 66 
 
66 
class DeliveryEstimate(Entity):
 67 
class DeliveryEstimate(Entity):
67 
    destination_pin = Field(String(6), primary_key=True)
 68 
    destination_pin = Field(String(6), primary_key=True)
Line 92... Line 93...
92 
    zone = Field(String(30))
 93 
    zone = Field(String(30))
93 
    bdm = Field(String(100))
 94 
    bdm = Field(String(100))
94 
    bdmEmail = Field(String(100))
 95 
    bdmEmail = Field(String(100))
95 
    using_options(shortnames=True)
 96 
    using_options(shortnames=True)
96 
    using_table_options(mysql_engine="InnoDB")
 97 
    using_table_options(mysql_engine="InnoDB")
97
98 
 
98 
def initialize(dbname="logistics",db_hostname="localhost"):
 99 
def initialize(dbname="logistics",db_hostname="localhost"):
99 
    #metadata.bind = "sqlite:///logistics.sqlite" #need to read it from configserver.
 100 
    #metadata.bind = "sqlite:///logistics.sqlite" #need to read it from configserver.
100 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
 101 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
101 
    metadata.bind = engine
 102 
    metadata.bind = engine
102 
    metadata.bind.echo = True
 103 
    metadata.bind.echo = True