Example #1
0
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)