def getBankList(whereDict, city="all"):
conn = getConnection();
c = conn.cursor();
where = buildWhereClause(whereDict);
if city and city != "all":
where += " and ct_name = '%s'" % city;
c.execute("SELECT * FROM " + BankTable.TABLE_NAME
+ " LEFT OUTER JOIN "
+ " (SELECT _id AS ct_id, name AS ct_name FROM city) "
+ " ON ct_id == " + BankTable.COL_CITY_ID + " "
+ where + "ORDER BY _id DESC", list(whereDict.viewvalues()))
conn.commit();
banks = [];
for row in c.fetchall():
bank = Bank();
bank.name = row[BankTable.COL_NAME];
bank.title = row[BankTable.COL_TITLE];
bank.fetchTime = row[BankTable.COL_FETCH_TIME];
bank.accepted = row[BankTable.COL_ACCEPTED];
bank.url = row[BankTable.COL_URL];
bank.id = row[BankTable.COL_ID];
city = row["ct_name"];
if city:
bank.city = city;
banks.append(bank);
return banks;
def getBankList(whereDict, city="all"):
conn = getConnection()
c = conn.cursor()
where = buildWhereClause(whereDict)
if city and city != "all":
where += " and ct_name = '%s'" % city
c.execute(
"SELECT * FROM " + BankTable.TABLE_NAME + " LEFT OUTER JOIN " +
" (SELECT _id AS ct_id, name AS ct_name FROM city) " +
" ON ct_id == " + BankTable.COL_CITY_ID + " " + where +
"ORDER BY _id DESC", list(whereDict.viewvalues()))
conn.commit()
banks = []
for row in c.fetchall():
bank = Bank()
bank.name = row[BankTable.COL_NAME]
bank.title = row[BankTable.COL_TITLE]
bank.fetchTime = row[BankTable.COL_FETCH_TIME]
bank.accepted = row[BankTable.COL_ACCEPTED]
bank.url = row[BankTable.COL_URL]
bank.id = row[BankTable.COL_ID]
city = row["ct_name"]
if city:
bank.city = city
banks.append(bank)
return banks
