def initFromDB(self, mysql, sql, family, id_name, val_name): cursor = mysql.cursor(MySQLdb.cursors.DictCursor) cursor.execute(sql) inserting = defaultdict(dict) for row in cursor.fetchall(): val = row[val_name] id = pack(row[id_name]) inserting[id][val] = val fam = ColumnFamily(self.connection, family) fam.truncate() logging.info('Initializing %s' % family) fam.batch_insert(inserting)