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()