Subversion Repositories SmartDukaan

#!/usr/bin/python

'''
Created on 23-Jun-2011

@author: Chandranshu
'''
import sys
import os
import csv
import optparse

if __name__ == '__main__' and __package__ is None:
    sys.path.insert(0, os.getcwd())

from shop2020.model.v1.order.impl import DataAccessors, DataService

def main():
    parser = optparse.OptionParser()
    parser.add_option("-H", "--host", dest="hostname",
                      default="localhost",
                      type="string", help="The HOST where the DB server is running",
                      metavar="HOST")
    (options, args) = parser.parse_args()
    if len(args) != 0:
        parser.error("You've supplied extra arguments. Are you sure you want to run this program?")
    DataService.initialize(db_hostname=options.hostname, echoOn=False)
    filename = os.getenv("HOME") + os.sep + "ExpectedAndActualDeliveryReport.csv"
    writer = csv.writer(open(filename, "wb"), delimiter=',', quoting=csv.QUOTE_NONE)
    writer.writerow(["Order ID", "Customer Name", "Pin Code", "State", "AWB No", "Order Date", "Expected Date of Delivery", "Delivery Date"])
    orders = DataAccessors.get_valid_orders(0)
    orders.reverse()
    for order in orders:
        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])

if __name__ == '__main__':
    main()