def stats_csv_to_mongo(): path = os.path.join(os.getcwd(), 'data/stats') print(path) for file, collection in files.items(): Database.delete(collection) data = pd.read_csv(os.path.join(path, file)) data_dict = data.to_dict('records') Database.insert(collection, data_dict)
def delete(email,blogtitle,blog_id): loginform = LoginForm() if session['user'] == email and blog_id.__len__() == 32: ids = Users.id_one(blog_id)["_id"] if blog_id == ids: Database.delete("blogs",{"_id":blog_id}) flash("blog deleted") return redirect(url_for('login')) else: flash("not right") return redirect(url_for('login')) return redirect(url_for('login'))
def insert_csv_to_mongo(): file_path = os.path.join(os.getcwd(), 'data/covid') for file, collection in files.items(): # delete all documents in the collection Database.delete(collection) # read csv files saved locally and convert to dict using 'records' parameter data = pd.read_csv(os.path.join(file_path, file)) data_dict = data.to_dict('records') # insert models dict into collection Database.insert(collection, data_dict)