def get_sites_by_topic(topic):
connection = sqlite3.connect("Sites.db")
courser = connection.cursor()
courser.execute("SELECT * FROM Websites WHERE Topic = '" + topic + "'")
raw_sites = courser.fetchall()
articles = []
for raw_site in raw_sites:
site = Class.Article(raw_site[0], raw_site[1], raw_sites[2])
articles.append(site)
connection.commit()
return articles
