'Populates the showList with shows from the database'

@staticmethod
def load_shows_from_db():

    logger.log(u'Loading    initial    show    list', logger.DEBUG)
    main_db_con = db.DBConnection()
    sql_results = main_db_con.select(u'SELECT    indexer,    indexer_id,    location    FROM    tv_shows;')
    sickbeard.showList = []
    for sql_show in sql_results:
        try:
            cur_show = TVShow(sql_show['indexer'], sql_show['indexer_id'])
            cur_show.nextEpisode()
            sickbeard.showList.append(cur_show)
        except Exception as error:
            logger.log(u'There    was    an    error    creating    the    show    in    {0}:    Error    {1}'.format(sql_show['location'], error), logger.ERROR)
            logger.log(traceback.format_exc(), logger.DEBUG)
