| Line 76... |
Line 76... |
| 76 |
destination_pin = Field(String(6), primary_key=True)
|
76 |
destination_pin = Field(String(6), primary_key=True)
|
| 77 |
provider = ManyToOne("Provider", primary_key=True)
|
77 |
provider = ManyToOne("Provider", primary_key=True)
|
| 78 |
warehouse_location = Field(Integer, primary_key=True, autoincrement=False)
|
78 |
warehouse_location = Field(Integer, primary_key=True, autoincrement=False)
|
| 79 |
delivery_time = Field(Integer)
|
79 |
delivery_time = Field(Integer)
|
| 80 |
delivery_delay = Field(Integer, default=0, server_default="0")
|
80 |
delivery_delay = Field(Integer, default=0, server_default="0")
|
| - |
|
81 |
providerZoneCode = Field(String(20))
|
| 81 |
using_options(shortnames=True)
|
82 |
using_options(shortnames=True)
|
| 82 |
using_table_options(mysql_engine="InnoDB")
|
83 |
using_table_options(mysql_engine="InnoDB")
|
| 83 |
|
84 |
|
| 84 |
class PublicHolidays(Entity):
|
85 |
class PublicHolidays(Entity):
|
| 85 |
date = Field(Date, primary_key=True)
|
86 |
date = Field(Date, primary_key=True)
|
| Line 109... |
Line 110... |
| 109 |
zone = Field(String(30))
|
110 |
zone = Field(String(30))
|
| 110 |
bdm = Field(String(100))
|
111 |
bdm = Field(String(100))
|
| 111 |
bdmEmail = Field(String(100))
|
112 |
bdmEmail = Field(String(100))
|
| 112 |
using_options(shortnames=True)
|
113 |
using_options(shortnames=True)
|
| 113 |
using_table_options(mysql_engine="InnoDB")
|
114 |
using_table_options(mysql_engine="InnoDB")
|
| - |
|
115 |
|
| - |
|
116 |
class ProviderCosting(Entity):
|
| - |
|
117 |
provider = ManyToOne("Provider", primary_key=True)
|
| - |
|
118 |
zoneCode = Field(String(20), primary_key=True)
|
| - |
|
119 |
zoneCodeDescription = Field(String(256))
|
| - |
|
120 |
initialWeightUpperLimit = Field(Float)
|
| - |
|
121 |
initialLogisticsCost = Field(Float)
|
| - |
|
122 |
additionalUnitWeight = Field(Float)
|
| - |
|
123 |
additionalUnitLogisticsCost = Field(Float)
|
| - |
|
124 |
minimumCodCollectionCharges = Field(Float)
|
| - |
|
125 |
codCollectionFactor = Field(Float, default=0)
|
| - |
|
126 |
using_options(shortnames=True)
|
| - |
|
127 |
using_table_options(mysql_engine="InnoDB")
|
| 114 |
|
128 |
|
| 115 |
def initialize(dbname="logistics",db_hostname="localhost"):
|
129 |
def initialize(dbname="logistics",db_hostname="localhost"):
|
| 116 |
#metadata.bind = "sqlite:///logistics.sqlite" #need to read it from configserver.
|
130 |
#metadata.bind = "sqlite:///logistics.sqlite" #need to read it from configserver.
|
| 117 |
engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|
131 |
engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
|
| 118 |
metadata.bind = engine
|
132 |
metadata.bind = engine
|