def insert_data(self,articles): self.cursor.execute("SELECT date('now')") todays_date = self.cursor.fetchall()[0][0] rows = [] for article in articles: rows.append([article,'fivethirtyeight',str(articles[article]),todays_date]) Sqlite_Helper.insert_rows(self,4,rows)
def __init__(self,url,tag,table,table_name): super(Article_Getter_sql,self).__init__(table,table_name) source = self.html_source(url) self.articles = self.parse(source,tag) if os.path.exists(table): self.connection,self.cursor = Sqlite_Helper.set_db(self) else: header = "NAME TEXT PRIMARY KEY,PUBLISHER TEXT,LINK TEXT,DATE TEXT" Sqlite_Helper.create(self,header) self.connection,self.cursor = Sqlite_Helper.set_db(self)