def main(): #get stuff stuff from configs DB_NAME, DB_USER = cfg.database_name, cfg.database_user try: connection = psycopg2.connect("dbname=%s user=%s" %(DB_NAME, DB_USER)) except Exception as e: print(e) utils.init_tables() cursor = connection.cursor() #cursor.execute("SELECT * FROM subgroups;") available_groups = list(i['subgroup'] for i in d.available_subgroups) if not available_groups: print("No Subgroups configured") return False print("Subgroups available: ") utils.selection(available_groups) eval('subgroups.%s(cursor)' %available_groups[utils.selector('Select Subgroup: ', len(available_groups))]) #subgroups.HorribleSubs(cursor) connection.commit() connection.close()
nyaa_url = 'http://nyaa.se/' download_queue = [] torrent_list = [] #loging setup logging.getLogger(__name__) logging.basicConfig(filename=cfg.log_dir, level=logging.DEBUG, format='%(asctime)s - %(name)s - %(levelname)s - %(message)s') try: tc = transmissionrpc.Client(cfg.transmission_location, port=cfg.transmission_port) except Exception as e: logging.error(e) #Database connection DB_NAME, DB_USER = cfg.database_name, cfg.database_user utils.init_tables() try: connection = psycopg2.connect("dbname=%s user=%s" %(DB_NAME, DB_USER)) except Exception as e: logging.error(e) cursor = connection.cursor() def main(): #TODO: add support for mysql for subgroup in d.available_subgroups: try: cursor.execute("SELECT * FROM %s;" %(subgroup['db_name'])) anime_list = cursor.fetchall() except Exception as e: logging.error(e)