| Line 6... |
Line 6... |
| 6 |
@author: Chandranshu
|
6 |
@author: Chandranshu
|
| 7 |
'''
|
7 |
'''
|
| 8 |
import sys
|
8 |
import sys
|
| 9 |
import os
|
9 |
import os
|
| 10 |
import csv
|
10 |
import csv
|
| - |
|
11 |
import optparse
|
| 11 |
|
12 |
|
| 12 |
if __name__ == '__main__' and __package__ is None:
|
13 |
if __name__ == '__main__' and __package__ is None:
|
| 13 |
sys.path.insert(0, os.getcwd())
|
14 |
sys.path.insert(0, os.getcwd())
|
| 14 |
|
15 |
|
| 15 |
from shop2020.model.v1.order.impl import DataAccessors, DataService
|
16 |
from shop2020.model.v1.order.impl import DataAccessors, DataService
|
| 16 |
|
17 |
|
| 17 |
def main():
|
18 |
def main():
|
| - |
|
19 |
parser = optparse.OptionParser()
|
| - |
|
20 |
parser.add_option("-H", "--host", dest="hostname",
|
| - |
|
21 |
default="localhost",
|
| - |
|
22 |
type="string", help="The HOST where the DB server is running",
|
| - |
|
23 |
metavar="HOST")
|
| - |
|
24 |
(options, args) = parser.parse_args()
|
| - |
|
25 |
if len(args) != 0:
|
| - |
|
26 |
parser.error("You've supplied extra arguments. Are you sure you want to run this program?")
|
| - |
|
27 |
DataService.initialize(db_hostname=options.hostname, echoOn=False)
|
| 18 |
filename = os.getenv("HOME") + os.sep + "ExpectedAndActualDeliveryReport.csv"
|
28 |
filename = os.getenv("HOME") + os.sep + "ExpectedAndActualDeliveryReport.csv"
|
| 19 |
writer = csv.writer(open(filename, "wb"), delimiter=',', quoting=csv.QUOTE_NONE)
|
29 |
writer = csv.writer(open(filename, "wb"), delimiter=',', quoting=csv.QUOTE_NONE)
|
| 20 |
writer.writerow(["Order ID", "Customer Name", "Pin Code", "State", "AWB No", "Order Date", "Expected Date of Delivery", "Delivery Date"])
|
30 |
writer.writerow(["Order ID", "Customer Name", "Pin Code", "State", "AWB No", "Order Date", "Expected Date of Delivery", "Delivery Date"])
|
| 21 |
DataService.initialize(echoOn=True)
|
- |
|
| 22 |
orders = DataAccessors.get_valid_orders(0)
|
31 |
orders = DataAccessors.get_valid_orders(0)
|
| 23 |
orders.reverse()
|
32 |
orders.reverse()
|
| 24 |
for order in orders:
|
33 |
for order in orders:
|
| 25 |
writer.writerow([order.id, order.customer_name, order.customer_pincode, order.customer_state, order.airwaybill_no, order.created_timestamp, order.expected_delivery_time, order.delivery_timestamp])
|
34 |
writer.writerow([order.id, order.customer_name, order.customer_pincode, order.customer_state, order.airwaybill_no, order.created_timestamp, order.expected_delivery_time, order.delivery_timestamp])
|
| 26 |
|
35 |
|