Subversion Repositories SmartDukaan

Rev

Rev 14451 | Rev 14468 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 14451 Rev 14460
Line 87... Line 87...
87 
        traceback.print_exc()
 87 
        traceback.print_exc()
88 
    finally:
 88 
    finally:
89 
        conn.close()
 89 
        conn.close()
90 
 
 90 
 
91 
def getOrdersAfterDate(afterDate, storeId):
 91 
def getOrdersAfterDate(afterDate, storeId):
- 
 
 92 
    try:
92 
    conn = getDbConnection()
 93 
        conn = getDbConnection()
93 
    cursor = conn.cursor()
 94 
        cursor = conn.cursor()
94 
    afterDate = datetime.strftime(afterDate,"\'%Y-%m-%d\'")
 95 
        afterDate = datetime.strftime(afterDate,"\'%Y-%m-%d\'")
95 
    cursor.execute(ORDERS_DATE_QUERY%(afterDate, storeId))
 96 
        cursor.execute(ORDERS_DATE_QUERY%(afterDate, storeId))
96 
    result = cursor.fetchall()
 97 
        result = cursor.fetchall()
97 
    return result
98 
        return result
- 
 
 99 
    finally:
- 
 
 100 
        conn.close()
98 
 
 101 
 
99 
def main():
 102 
def main():
100 
    getOrdersAfterDate(datetime.now() - timedelta(days=10), 3)
 103 
    print getOrdersAfterDate(datetime.now() - timedelta(days=10), 3)
101 
 
 104 
 
102 
 
 105 
 
103 
if __name__ == '__main__':
 106 
if __name__ == '__main__':
104 
    main()
 107 
    main()
105 

            108