def select_url():
arrList = []
try:
connect = get_connect()
cursor = connect.cursor()
print("connection")
sql = "SELECT id,source_url FROM news_api"
cursor.execute(sql)
result = cursor.fetchall()
for row in result:
# print(row[0])
news = News()
news.id = row[0]
news.source_url = row[1]
arrList.append(news)
except Exception as e:
print(e)
finally:
return arrList
def getDB():
news_list = []
for i in mydb.list_collection_names():
mycol = mydb.get_collection(i)
nested_news_list = []
for item in mycol.find():
newNewsObject = News()
newNewsObject.author = itemgetter("author")(item)
newNewsObject.title = itemgetter("title")(item)
newNewsObject.description = itemgetter("description")(item)
newNewsObject.url = itemgetter("url")(item)
newNewsObject.url_to_image = itemgetter("url_to_image")(item)
newNewsObject.date_time_of_publishing = itemgetter(
"date_time_of_publishing")(item)
newNewsObject.id = itemgetter("id")(item)
newNewsObject.name = itemgetter("name")(item)
nested_news_list.append(newNewsObject)
news_list.append(nested_news_list)
return news_list
