Subversion Repositories SmartDukaan

Rev

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

Rev 5527 Rev 5555
Line 75... Line 75...
75 
class PublicHolidays(Entity):
 75 
class PublicHolidays(Entity):
76 
    date = Field(Date, primary_key=True)
 76 
    date = Field(Date, primary_key=True)
77 
    occasion = Field(String(100))
 77 
    occasion = Field(String(100))
78 
    using_options(shortnames=True)
 78 
    using_options(shortnames=True)
79 
    using_table_options(mysql_engine="InnoDB")
 79 
    using_table_options(mysql_engine="InnoDB")
- 
 
 80
- 
 
 81 
class PickupStore(Entity):
- 
 
 82 
    id = Field(Integer, primary_key=True)
- 
 
 83 
    name = Field(String(100))
- 
 
 84 
    line_1 = Field(String(100))
- 
 
 85 
    line_2 = Field(String(100))
- 
 
 86 
    city = Field(String(100))
- 
 
 87 
    state = Field(String(100))
- 
 
 88 
    pin = Field(String(10))
- 
 
 89 
    phone = Field(String(20))
- 
 
 90 
    using_options(shortnames=True)
- 
 
 91 
    using_table_options(mysql_engine="InnoDB")
80
92
81 
def initialize(dbname="logistics",db_hostname="localhost"):
 93 
def initialize(dbname="logistics",db_hostname="localhost"):
82 
    #metadata.bind = "sqlite:///logistics.sqlite" #need to read it from configserver.
 94 
    #metadata.bind = "sqlite:///logistics.sqlite" #need to read it from configserver.
83 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
 95 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
84 
    metadata.bind = engine
 96 
    metadata.bind = engine
85 
    metadata.bind.echo = True
 97 
    metadata.bind.echo = True