'Populates the showList with shows from the database'

@staticmethod
def load_from_db():

    test_main_db_con = test.db.DBConnection()
    sql_results = test_main_db_con.select(u'SELECT    *    FROM    tv_shows')
    for sql_show in sql_results:
        try:
            cur_show = TVShow(int(sql_show['indexer']), int(sql_show['indexer_id']))
            sickbeard.showList.append(cur_show)
        except Exception as error:
            print(u'There    was    an    error    creating    the    show    {0}'.format(error))
