def save_user_clan_relationship(): init_db_cmd = "create table if not exists clans (clan_id int(8) unique, user_id int(10));" curs_users.execute(init_db_cmd) for clan_id in get_all_clans_ids(): members = wg_api.get_clans_members_list_by_id(clan_id) for user_id in members: curs_users.execute("insert into clans values (?,?)", (clan_id, user_id)) conn_users.commit()
def save_all_users_data(): dt = datetime.datetime.now() for clan_id in get_all_clans_ids(): try: save_all_users_data_from_clan(clan_id, dt) except Exception as e: print e print "clan " + str(clan_id) + " done" if clan_id % 50 == 0: conn_users.commit() conn_users.commit()