def testExportCsv(self): from_addr = "/Users/superCat/Desktop/PycharmProjectPortable/sync/Sum.db" to_addr = "/Users/superCat/Desktop/PycharmProjectPortable/sync/2015_OLD.csv" table_name = "2015 Old" from_db = FilteredResultDB(table_name, db_addr=from_addr) data = [x for x in from_db.get_all_sites() if x[1] > 0] CsvLogger.log_to_file_path(to_addr, [FilteredResultDB.get_fields_names(),]) CsvLogger.log_to_file_path(to_addr, data)
def testFilterExportDB(self): from_addr = "/Users/superCat/Desktop/PycharmProjectPortable/sync/FilteredSitesList_oLD" to_addr = "/Users/superCat/Desktop/PycharmProjectPortable/sync/FilteredSitesList" table_name = "20/11/2015" from_db = FilteredResultDB(table_name, db_addr=from_addr) to_db = FilteredResultDB(table_name, db_addr=to_addr) results = [x for x in from_db.get_all_sites() if x[1] > 0] count = 0 for item in results: print("count:", count, "item:", item) count += 1
def testFilterExportDB2(self): from_addr = "/Users/superCat/Desktop/PycharmProjectPortable/sync/FilteredSitesList.db" to_addr = "/Users/superCat/Desktop/PycharmProjectPortable/sync/Sum.db" table_name = "20/11/2015" from_db = FilteredResultDB(table_name, db_addr=from_addr) from_db.cur.execute("SELECT name FROM sqlite_master WHERE type = 'table';") table_names = [x[0] for x in from_db.cur.fetchall()] to_db = FilteredResultDB("2015 Old", db_addr=to_addr) for table_name in table_names: print(table_name) temp = FilteredResultDB(table_name, db_addr=from_addr) results = [x for x in temp.get_all_sites() if x[1] > 0] temp.close() count = 0 for item in results: print("count:", count, "item:", item) count += 1 to_db.add_sites(results, skip_check=True) from_db.close() to_db.close()