Esempi in Python per Sqlite_Helper

Esempio n. 1

File: article_getter.py Progetto: hdoupe/news_agglomerator

	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)

Esempio n. 2

File: article_getter.py Progetto: hdoupe/news_agglomerator

	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)