Пример #1
0
 def testMethod(self):
     for data,expected in self.TEST_DATA.items():
         self.assertEqual(removeDuplicate(data),expected)
Пример #2
0
cur.execute("SELECT fdiccert, bankaba, bankaccount, minamount, max_savings_rate FROM `bankaccounts` ORDER BY max_savings_rate ")
db.commit()
bankData = cur.fetchall()[0:]

cur.execute("SELECT clientid, subacctid FROM clients WHERE statement <> \'FICA\'")
db.commit()
ICAClient = cur.fetchall()[0:]

cur.execute("SELECT clientid, subacctid, bankaba, bankaccount, SUM(Amount) AS Amount FROM fisagl WHERE account=\'1001\' GROUP BY clientid, subacctid, bankaba, bankaccount ORDER BY clientid DESC")
db.commit()
curAlloc = cur.fetchall()[0:]
ClientBank = {}


for row in curAlloc:
    if (bool(row[0])):
        ClientBank.update({row[0] + row[1] + row[2] + row[3]:(float(row[4]))})

for bk in bankData:  
    for ica in ICAClient:
        if bool(ClientBank.get(ica[0] + ica[1] + bk[1] + bk[2])):
            if (ClientBank.get(ica[0] + ica[1] + bk[1] + bk[2]) > 0.0):
                ICABank.append(bk[1] + "|" + bk[2])

ICABank = removeDuplicate(ICABank)

print("There are " + str(len(ICABank)) + " banks with ICA clients:\n")

for i in range(len(ICABank)):
    print(ICABank[i])