Subversion Repositories SmartDukaan

Rev

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

Rev 16136 Rev 16216
Line 35... Line 35...
35 
INSERT_QUERY= """
 35 
INSERT_QUERY= """
36 
INSERT INTO dial2verifyStatus (session_id, api_key, mobile_number, verification_status, transaction_time, verification_time) VALUES ('%s', '%s', '%s', '%s', '%s', '%s');"""
 36 
INSERT INTO dial2verifyStatus (session_id, api_key, mobile_number, verification_status, transaction_time, verification_time) VALUES ('%s', '%s', '%s', '%s', '%s', '%s');"""
37 
 
 37 
 
38 
def getDbConnection():
 38 
def getDbConnection():
39 
    return MySQLdb.connect(options.dbHost, DB_USER, DB_PASSWORD, DB_NAME)
 39 
    return MySQLdb.connect(options.dbHost, DB_USER, DB_PASSWORD, DB_NAME)
40 
 
 - 
 
41 
def insertFOSAddressData():
 - 
 
42 
    numbers=[]
 - 
 
43 
    session_id=''
 - 
 
44 
    api_key=''
 - 
 
45 
    mobile_number=''
 - 
 
46 
    verifcation_status=''
 - 
 
47 
    transaction_time=None
 - 
 
48 
    verification_time=None
 - 
 
49 
    ttime=None
 - 
 
50 
    vtime=None
 - 
 
51 
    wb = open_workbook('/home/kshitij/Downloads/Dial2Verify_UI_Data.xlsx')
- 
 
52 
    for s in wb.sheets():
 - 
 
53 
        for row in range(s.nrows):
 - 
 
54 
            for col in range(s.ncols):
 - 
 
55 
                if col==0:
 - 
 
56 
                    session_id=s.cell(row,col).value
- 
 
57 
                elif col==1:
 - 
 
58 
                    api_key=s.cell(row,col).value
- 
 
59 
                elif col==2:
 - 
 
60 
                    mobile_number=s.cell(row,col).value
- 
 
61 
                elif col==3:
- 
 
62 
                    verifcation_status=s.cell(row,col).value
 - 
 
63 
                elif col==4:
- 
 
64 
                    transaction_time=s.cell(row,col).value
 - 
 
65 
                    print transaction_time
 - 
 
66 
                    ttime=datetime.strptime(transaction_time,'%m/%d/%Y %H:%M:%S %p')
 - 
 
67 
                elif col==5:
 - 
 
68 
                    verification_time=s.cell(row,col).value
 - 
 
69 
                    if verification_time is not None and len(verification_time)>0:
 - 
 
70 
                        vtime=datetime.strptime(verification_time,'%m/%d/%Y %H:%M:%S %p')
 - 
 
71 
                    #if col==2:
 - 
 
72 
                    #    numbers.append(s.cell(row,col).value)
 - 
 
73 
            if vtime is not None:
- 
 
74 
                strw=INSERT_QUERY % (session_id,api_key,mobile_number,verifcation_status,ttime.strftime('%Y-%m-%d %H:%M:%S'),vtime.strftime('%Y-%m-%d %H:%M:%S'))
 - 
 
75 
                print strw
 - 
 
76 
            else:
 - 
 
77 
                strw1=INSERT_QUERY % (session_id,api_key,mobile_number,verifcation_status,ttime.strftime('%Y-%m-%d %H:%M:%S'),vtime)
 - 
 
78 
                print strw1
- 
 
79 
    #print numbers
 - 
 
80 
    #cleanlist = []
 - 
 
81 
    #[cleanlist.append(x) for x in numbers if x not in cleanlist]
 - 
 
82 
    #print cleanlist
 - 
 
83
40
84 
def insertVerificationData(filePath):
 41 
def insertVerificationData(filePath):
85 
    session_id=''
 42 
    session_id=''
86 
    api_key=''
 43 
    api_key=''
87 
    mobile_number_new=''
 44 
    mobile_number_new=''
Line 108... Line 65...
108 
                mobile_number_new =str(mobile_number)
65 
                mobile_number_new =str(mobile_number)
109 
            elif col==3:
66 
            elif col==3:
110 
                verifcation_status=s.cell(row,col).value
 67 
                verifcation_status=s.cell(row,col).value
111 
            elif col==4:
68 
            elif col==4:
112 
                transaction_time=s.cell(row,col).value
 69 
                transaction_time=s.cell(row,col).value
113 
                ttime=datetime.strptime(transaction_time,'%m/%d/%Y %H:%M:%S %p')
 70 
                ttime=datetime.strptime(transaction_time,'%m/%d/%Y %I:%M:%S %p')
114 
            elif col==5:
 71 
            elif col==5:
115 
                verification_time=s.cell(row,col).value
 72 
                verification_time=s.cell(row,col).value
116 
                if verification_time is not None and len(verification_time)>0:
 73 
                if verification_time is not None and len(verification_time)>0:
117 
                    vtime=datetime.strptime(verification_time,'%m/%d/%Y %H:%M:%S %p')
 74 
                    vtime=datetime.strptime(verification_time,'%m/%d/%Y %I:%M:%S %p')
118 
                else:
 75 
                else:
119 
                    vtime=None
76 
                    vtime=None
120 
        if row>0:
77 
        if row>0:
121 
            if vtime is not None:
78 
            if vtime is not None:
122 
                squery=INSERT_QUERY % (session_id,api_key,mobile_number_new[0:10],verifcation_status,ttime.strftime('%Y-%m-%d %H:%M:%S'),vtime.strftime('%Y-%m-%d %H:%M:%S'))
 79 
                squery=INSERT_QUERY % (session_id,api_key,mobile_number_new[0:10],verifcation_status,ttime.strftime('%Y-%m-%d %H:%M:%S'),vtime.strftime('%Y-%m-%d %H:%M:%S'))
Line 124... Line 81...
124 
                conn.commit()
 81 
                conn.commit()
125 
            else:
 82 
            else:
126 
                squery=INSERT_QUERY % (session_id,api_key,mobile_number_new[0:10],verifcation_status,ttime.strftime('%Y-%m-%d %H:%M:%S'),vtime)
 83 
                squery=INSERT_QUERY % (session_id,api_key,mobile_number_new[0:10],verifcation_status,ttime.strftime('%Y-%m-%d %H:%M:%S'),vtime)
127 
                cur.execute(squery)
 84 
                cur.execute(squery)
128 
                conn.commit()
85 
                conn.commit()
- 
 
 86 
 
- 
 
 87 
def deleteDial2VerifyRecords():
- 
 
 88 
    conn = getDbConnection()
- 
 
 89 
    datesql="delete from dial2verifyStatus"
- 
 
 90 
    cursor = conn.cursor()
- 
 
 91 
    cursor.execute(datesql)
- 
 
 92 
    conn.commit()
129
93
130 
def main():
 94 
def main():
131 
    #insertFOSAddressData()
 - 
 
132 
    filePath = Dial2VerifyFile.main()
 95 
    filePath = Dial2VerifyFile.main()
- 
 
 96 
    deleteDial2VerifyRecords()
133 
    insertVerificationData(filePath)
 97 
    insertVerificationData(filePath)
- 
 
 98 
 
134 
if __name__ == '__main__':
 99 
if __name__ == '__main__':
135 
    main()
 100 
    main()
136 

            101