return dbillingInvoice = float(e1['billingInvoice']) - float(e2['billingInvoice']) if (abs(dbillingInvoice) > epson): fl.write("+billingInvoice:" + str(dbillingInvoice) + ',' + e1['billingInvoice'] + ',' + e2['billingInvoice'] + ':' + str(e1) + ',' + str(e2) + '\n') return c.write(str(e1) + '\n') servers = ['pb036:9160', 'pb037:9160', 'pb038:9160'] pool = ConnectionPool('RSS', server_list = servers, timeout = 1, pool_size=20) meta = ColumnFamily(pool, 'MetaData') counter = ColumnFamily(pool, 'Counter') oid_count = meta.get_count('rss.All') print 'Total oids => ', oid_count oids_gen = meta.xget('rss.All', column_reversed=True, include_timestamp=True) oids = dict(oids_gen) #oids = meta.get('rss.All', column_reversed=True) #print oids home = os.path.expanduser("~") fi = open(home + "/rss/diff_cas.txt", "w") fj = open(home + "/rss/diff_rss.txt", "w") difi = open(home + "/rss/difi.txt", "w") difl = open(home + "/rss/difl.txt", "w") f = open(home + "/rss/good.txt", "w") fo = open(home + "/rss/negative_rss.txt", "w") fp = open(home + "/rss/negative_cas.txt", "w")
from pycassa.pool import ConnectionPool from pycassa.columnfamily import ColumnFamily import urllib2 import simplejson import datetime import time pool = ConnectionPool('RSS', ['pb036:9160', 'pb037:9160'], pool_size=20) meta = ColumnFamily(pool, 'MetaData') countercf = ColumnFamily(pool, 'Counter') oid_count = meta.get_count('rss.All') print 'Total oids => ', oid_count oids_generator = meta.xget('rss.All', column_reversed=True, include_timestamp=True) oids = dict(oids_generator) #oids = meta.get('rss.All', column_reversed=True) #print oids # 3 days ago then = (datetime.date.today() - datetime.timedelta(3)) tt = time.mktime(then.timetuple()) * 1000 * 1000 #then.microsecond/1000 # {oid: tz, ...} delete = {} save = {} tzid = 'TimeZoneCodeId'