Subversion Repositories SmartDukaan

Rev

Rev 4439 | Rev 5387 | 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))
3044 chandransh 15 
    details = OneToMany("ProviderDetails")
16 
    using_options(shortnames=True)
17 
    using_table_options(mysql_engine="InnoDB")
18 
 
19 
class ProviderDetails(Entity):
20 
    provider = ManyToOne("Provider", primary_key=True)
21 
    type = Field(Integer, primary_key=True, autoincrement=False)
669 chandransh 22 
    accountNo = Field(String(10))
644 chandransh 23 
    email = Field(String(100))
3044 chandransh 24 
    phone = Field(String(15))
644 chandransh 25 
    using_options(shortnames=True)
746 rajveer 26 
    using_table_options(mysql_engine="InnoDB")
3044 chandransh 27 
 
644 chandransh 28 
class Awb(Entity):
29 
    id = Field(Integer, primary_key=True, autoincrement=True)
442 rajveer 30 
    awb_number = Field(String(100))
644 chandransh 31 
    provider = ManyToOne("Provider")
442 rajveer 32 
    is_available = Field(Boolean)
644 chandransh 33 
    type = Field(String(50))
34 
    updates = OneToMany("AwbUpdate")
35 
    using_options(shortnames=True)
746 rajveer 36 
    using_table_options(mysql_engine="InnoDB")
442 rajveer 37 
 
644 chandransh 38 
class AwbUpdate(Entity):
442 rajveer 39 
    id = Field(Integer, primary_key=True, autoincrement=True)
644 chandransh 40 
    awb = ManyToOne("Awb")
41 
    location = Field(String(50))
42 
    entry_date = Field(DateTime)
442 rajveer 43 
    description = Field(String(100))
644 chandransh 44 
    comments = Field(String(100))
45 
    using_options(shortnames=True)
746 rajveer 46 
    using_table_options(mysql_engine="InnoDB")
442 rajveer 47 
 
644 chandransh 48 
class WarehouseAllocation(Entity):
49 
    pincode = Field(String(6), primary_key=True)
50 
    primary_warehouse_location = Field(Integer)
51 
    using_options(shortnames=True)
746 rajveer 52 
    using_table_options(mysql_engine="InnoDB")
53 
 
644 chandransh 54 
class ServiceableLocationDetails(Entity):
55 
    provider = ManyToOne("Provider", primary_key=True)
56 
    dest_pincode = Field(String(6), primary_key=True)
731 chandransh 57 
    dest_code = Field(String(10))
644 chandransh 58 
    exp = Field(Boolean)
59 
    cod = Field(Boolean)
60 
    station_type = Field(Integer)
61 
    using_options(shortnames=True)
746 rajveer 62 
    using_table_options(mysql_engine="InnoDB")
477 rajveer 63 
 
472 rajveer 64 
class DeliveryEstimate(Entity):
644 chandransh 65 
    destination_pin = Field(String(6), primary_key=True)
477 rajveer 66 
    provider = ManyToOne("Provider", primary_key=True)
746 rajveer 67 
    warehouse_location = Field(Integer, primary_key=True, autoincrement=False)
472 rajveer 68 
    delivery_time = Field(Integer)
644 chandransh 69 
    reliability = Field(Integer)
70 
    using_options(shortnames=True)
746 rajveer 71 
    using_table_options(mysql_engine="InnoDB")
1504 ankur.sing 72 
 
1730 ankur.sing 73 
class PublicHolidays(Entity):
74 
    date = Field(Date, primary_key=True)
75 
    occasion = Field(String(100))
76 
    using_options(shortnames=True)
77 
    using_table_options(mysql_engine="InnoDB")
442 rajveer 78 
 
3187 rajveer 79 
def initialize(dbname="logistics",db_hostname="localhost"):
746 rajveer 80 
    #metadata.bind = "sqlite:///logistics.sqlite" #need to read it from configserver.
3187 rajveer 81 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
1131 chandransh 82 
    metadata.bind = engine
442 rajveer 83 
    metadata.bind.echo = True
84 
    setup_all(True)
85 
 
86 
if __name__=="__main__":
87 
    initialize()
88