Subversion Repositories SmartDukaan

'''

Created on 13-Sep-2010

@author: rajveer

'''

from sqlalchemy import create_engine

from elixir import *

import datetime

import elixir

class Provider(Entity):

    id = Field(Integer, primary_key=True, autoincrement=True)

    name = Field(String(100))

    pickup = Field(Integer)

    isActive = Field(Boolean)

    details = OneToMany("ProviderDetails")

    bundleWeightLimit = Field(Float)

    groupShipmentAllowed = Field(Boolean)

    maxCodLimit = Field(Float)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class ProviderDetails(Entity):

    provider = ManyToOne("Provider", primary_key=True)

    type = Field(Integer, primary_key=True, autoincrement=False)

    logisticLocation = Field(Integer, primary_key=True, autoincrement=False)

    accountNo = Field(String(10))

    email = Field(String(100))

    phone = Field(String(15))

    active = Field(Boolean)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class Awb(Entity):

    id = Field(Integer, primary_key=True, autoincrement=True)

    awb_number = Field(String(100))

    provider = ManyToOne("Provider")

    is_available = Field(Boolean)

    type = Field(String(50))

    awbUsedFor = Field(Integer)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class AwbUpdate(Entity):

    providerId = Field(Integer, primary_key=True, autoincrement=False)

    awbNumber = Field(String(50), primary_key=True, autoincrement=False)

    location = Field(String(50), primary_key=True, autoincrement=False)

    date = Field(DateTime, primary_key=True, autoincrement=False)

    status = Field(String(100), primary_key=True, autoincrement=False)

    description = Field(String(100), primary_key=True, autoincrement=False)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class WarehouseAllocation(Entity):

    pincode = Field(String(6), primary_key=True)

    primary_warehouse_location = Field(Integer)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class ServiceableLocationDetails(Entity):

    provider = ManyToOne("Provider", primary_key=True)

    dest_pincode = Field(String(6), primary_key=True)

    dest_code = Field(String(10))

    exp = Field(Boolean)

    cod = Field(Boolean)

    station_type = Field(Integer)

    otgAvailable = Field(Boolean, default=0, server_default="0")

    providerCodLimit = Field(Integer)

    websiteCodLimit = Field(Integer)

    storeCodLimit = Field(Integer)

    providerPrepaidLimit = Field(Integer)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class DeliveryEstimate(Entity):

    destination_pin = Field(String(6), primary_key=True)

    provider = ManyToOne("Provider", primary_key=True)

    warehouse_location = Field(Integer, primary_key=True, autoincrement=False)

    delivery_time = Field(Integer)

    delivery_delay = Field(Integer, default=0, server_default="0")

    providerZoneCode = Field(String(20))

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class PublicHolidays(Entity):

    date = Field(Date, primary_key=True)

    occasion = Field(String(100))

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class Locations(Entity):

    id = Field(Integer, primary_key=True)

    state_id = Field(Integer)

    label = Field(String(50))

    description = Field(String(100))

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class PickupStore(Entity):

    id = Field(Integer, primary_key=True)

    hotspotId = Field(String(3))

    name = Field(String(100))

    line_1 = Field(String(100))

    line_2 = Field(String(100))

    city = Field(String(100))

    state = Field(String(100))

    pin = Field(String(10))

    phone = Field(String(20))

    email = Field(String(100))

    zone = Field(String(30))

    bdm = Field(String(100))

    bdmEmail = Field(String(100))

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class ProviderCosting(Entity):

    provider = ManyToOne("Provider", primary_key=True)

    zoneCode = Field(String(20), primary_key=True)

    zoneCodeDescription = Field(String(256))

    initialWeightUpperLimit = Field(Float) 

    initialLogisticsCost = Field(Float)

    additionalUnitWeight = Field(Float)

    additionalUnitLogisticsCost = Field(Float)

    minimumCodCollectionCharges = Field(Float)

    codCollectionFactor = Field(Float, default=0)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class BluedartAttribute(Entity):

    logisticsTransactionId = Field(String(100))

    name = Field(String(100))

    value = Field(String(100))

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class PincodeStates(Entity):

    pin = Field(Integer(6), primary_key=True)

    statename = Field(String(64))

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

def initialize(dbname="logistics",db_hostname="localhost", echoOn=True, setup=True):

    #metadata.bind = "sqlite:///logistics.sqlite" #need to read it from configserver.

    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)

    metadata.bind = engine

    metadata.bind.echo = echoOn

    setup_all(setup)

if __name__=="__main__":

    initialize()