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