Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
442 rajveer 1 
'''
2 
Created on 13-Sep-2010
3 
 
4 
@author: rajveer
5 
'''
1131 chandransh 6 
 
7 
from sqlalchemy import create_engine
442 rajveer 8 
from elixir import *
9 
import datetime
746 rajveer 10 
import elixir
442 rajveer 11 
 
12 
class Provider(Entity):
13 
    id = Field(Integer, primary_key=True, autoincrement=True)
14 
    name = Field(String(100))
5527 anupam.sin 15 
    pickup = Field(Integer)
5387 rajveer 16 
    isActive = Field(Boolean)
3044 chandransh 17 
    details = OneToMany("ProviderDetails")
18 
    using_options(shortnames=True)
19 
    using_table_options(mysql_engine="InnoDB")
20 
 
21 
class ProviderDetails(Entity):
22 
    provider = ManyToOne("Provider", primary_key=True)
23 
    type = Field(Integer, primary_key=True, autoincrement=False)
669 chandransh 24 
    accountNo = Field(String(10))
644 chandransh 25 
    email = Field(String(100))
3044 chandransh 26 
    phone = Field(String(15))
644 chandransh 27 
    using_options(shortnames=True)
746 rajveer 28 
    using_table_options(mysql_engine="InnoDB")
3044 chandransh 29 
 
644 chandransh 30 
class Awb(Entity):
31 
    id = Field(Integer, primary_key=True, autoincrement=True)
442 rajveer 32 
    awb_number = Field(String(100))
644 chandransh 33 
    provider = ManyToOne("Provider")
442 rajveer 34 
    is_available = Field(Boolean)
644 chandransh 35 
    type = Field(String(50))
36 
    updates = OneToMany("AwbUpdate")
37 
    using_options(shortnames=True)
746 rajveer 38 
    using_table_options(mysql_engine="InnoDB")
442 rajveer 39 
 
644 chandransh 40 
class AwbUpdate(Entity):
442 rajveer 41 
    id = Field(Integer, primary_key=True, autoincrement=True)
644 chandransh 42 
    awb = ManyToOne("Awb")
43 
    location = Field(String(50))
44 
    entry_date = Field(DateTime)
442 rajveer 45 
    description = Field(String(100))
644 chandransh 46 
    comments = Field(String(100))
47 
    using_options(shortnames=True)
746 rajveer 48 
    using_table_options(mysql_engine="InnoDB")
442 rajveer 49 
 
644 chandransh 50 
class WarehouseAllocation(Entity):
51 
    pincode = Field(String(6), primary_key=True)
52 
    primary_warehouse_location = Field(Integer)
53 
    using_options(shortnames=True)
746 rajveer 54 
    using_table_options(mysql_engine="InnoDB")
55 
 
644 chandransh 56 
class ServiceableLocationDetails(Entity):
57 
    provider = ManyToOne("Provider", primary_key=True)
58 
    dest_pincode = Field(String(6), primary_key=True)
731 chandransh 59 
    dest_code = Field(String(10))
644 chandransh 60 
    exp = Field(Boolean)
61 
    cod = Field(Boolean)
62 
    station_type = Field(Integer)
6537 rajveer 63 
    otgAvailable = Field(Boolean, default=0, server_default="0")
644 chandransh 64 
    using_options(shortnames=True)
746 rajveer 65 
    using_table_options(mysql_engine="InnoDB")
477 rajveer 66 
 
472 rajveer 67 
class DeliveryEstimate(Entity):
644 chandransh 68 
    destination_pin = Field(String(6), primary_key=True)
477 rajveer 69 
    provider = ManyToOne("Provider", primary_key=True)
746 rajveer 70 
    warehouse_location = Field(Integer, primary_key=True, autoincrement=False)
472 rajveer 71 
    delivery_time = Field(Integer)
6537 rajveer 72 
    delivery_delay = Field(Integer, default=0, server_default="0")
644 chandransh 73 
    using_options(shortnames=True)
746 rajveer 74 
    using_table_options(mysql_engine="InnoDB")
1504 ankur.sing 75 
 
1730 ankur.sing 76 
class PublicHolidays(Entity):
77 
    date = Field(Date, primary_key=True)
78 
    occasion = Field(String(100))
79 
    using_options(shortnames=True)
80 
    using_table_options(mysql_engine="InnoDB")
5555 rajveer 81 
 
82 
class PickupStore(Entity):
83 
    id = Field(Integer, primary_key=True)
5719 rajveer 84 
    hotspotId = Field(String(3))
5555 rajveer 85 
    name = Field(String(100))
86 
    line_1 = Field(String(100))
87 
    line_2 = Field(String(100))
88 
    city = Field(String(100))
89 
    state = Field(String(100))
90 
    pin = Field(String(10))
91 
    phone = Field(String(20))
5863 rajveer 92 
    email = Field(String(100))
5739 rajveer 93 
    zone = Field(String(30))
5813 rajveer 94 
    bdm = Field(String(100))
95 
    bdmEmail = Field(String(100))
5555 rajveer 96 
    using_options(shortnames=True)
97 
    using_table_options(mysql_engine="InnoDB")
6524 rajveer 98 
 
3187 rajveer 99 
def initialize(dbname="logistics",db_hostname="localhost"):
746 rajveer 100 
    #metadata.bind = "sqlite:///logistics.sqlite" #need to read it from configserver.
3187 rajveer 101 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
1131 chandransh 102 
    metadata.bind = engine
442 rajveer 103 
    metadata.bind.echo = True
104 
    setup_all(True)
105 
 
106 
if __name__=="__main__":
107 
    initialize()
108