def upload(): """ Route for url: server/new/upload/ """ if 'username' in session: form = UploadForm() if request.method == 'GET': session['data_parsed'] = '' if 'project_name' in session and 'project_type' in session: return render_template('ubuildit.html', form = form, username = session['username']) if request.method == 'POST': if form.validate(): file = request.files['file'] if upload_file(file): if check_file(file): session['data_parsed'] = parse_file(file) flash('Your file has been successfully uploaded!') return redirect(url_for('preview')) else: flash('This file is invalid.') else: flash('Could not upload your excel file.') else: flash('There were problems with your file.') return render_template('ubuildit.html', form = form, username = session['username']) return abort(404)
def upload_image(): if not 'signed_user' in session: return json.dumps({ 'answer': False, 'details': 'You are not signed in' }) form = UploadForm() if not form.validate(): return json.dumps({'answer': False, 'details': 'File is invalid'}) file = form.file.data coordinates = json.loads(request.form.get('coordinates')) filename = secure_filename(session['signed_user'] + str(datetime.datetime.now()) + file.filename) filepath = os.path.join(os.path.abspath('images'), filename) file.save(filepath) img = Image.open(filepath) coordinates_to_crop = (coordinates['left'], coordinates['top'], coordinates['left'] + coordinates['width'], coordinates['top'] + coordinates['height']) cropped = img.crop(coordinates_to_crop) cropped.save(filepath) res = User().upload_image(filename, session['signed_user']) User().set_online(session['signed_user']) if not res: return json.dumps({ 'answer': False, 'details': "You can upload not more than 5 images" }) return json.dumps({'answer': True})
def upload(): if not session.get('logged_in'): abort(401) # Instantiate your form class form = UploadForm() if request.method == 'GET': return render_template('upload.html', form = form) # Validate file upload on submit if request.method == 'POST' and form.validate(): uploaded_file = request.files['file'] filename = secure_filename(uploaded_file.filename) if filename != '': file_ext = os.path.splitext(filename)[1] if file_ext not in app.config['UPLOAD_EXTENSIONS']: flash('Invalid Format', 'error') abort(400) # Get file data and save to your uploads folder uploaded_file.save(os.path.join( app.config['UPLOAD_FOLDER'], filename)) flash('File Saved', 'success') return redirect(url_for('home')) return render_template('upload.html')
def uploadLog(): "Upload log file" form = UploadForm() app.logger.debug("uploadLog: %s" % form.errors) app.logger.debug('------ {0}'.format(request.form)) if form.is_submitted(): app.logger.debug(form.errors) if form.validate(): app.logger.debug(form.errors) app.logger.debug(form.errors) if form.validate_on_submit(): db_folder = app.config['UPLOAD_FOLDER'] filename = secure_filename(form.uploadFile.data.filename) file_path = os.path.join(db_folder, filename) form.uploadFile.data.save(file_path) os.chdir(db_folder) optionsSQL = MyOptions([file_path], sql=True, outlog='log.out') log2sql = Log2sql(optionsSQL) log2sql.processLogs() return redirect(url_for('analyzeLog')) return render_template('uploadLog.html', title='Upload Log', form=form)
def basexlsx(): basexlsx_form = UploadForm(request.form) if g.user: if request.method == "POST" and basexlsx_form.validate(): # image_data = request.FILES[form.image.name].read() if basexlsx_form.basexlsx.name not in request.files: flash("No se ha seleccionado ningun archivo", "alert-danger") return redirect(request.url) file = request.files[basexlsx_form.basexlsx.name] print(file) if file.filename == "": flash("No selected file.", "alert-warning") return redirect(request.url) if file: # and allowed_file(file.filename): filename = secure_filename(file.filename) file.save(os.path.join(app.config["UPLOAD_FOLDER"], filename)) import openpyxl documento = openpyxl.load_workbook( os.path.abspath(app.config["UPLOAD_FOLDER"] + '\\' + filename)) ws = documento.active smq = (ws.rows) registros_nuevos = 0 registros_repetidos = 0 registros_total = 0 for campo in smq: registros_total += 1 if Recuperos.query.filter_by (rama = campo[0].value).first() and \ Recuperos.query.filter_by (siniestro = campo[1].value).first(): registros_repetidos += 1 continue rama = campo[0].value siniestro = campo[1].value desc_siniestro = campo[2].value fe_ocurrencia = campo[3].value importe_pagado = campo[4].value estado = 1 registro_recupero = Recuperos(rama = rama,\ siniestro = siniestro,\ desc_siniestro = desc_siniestro,\ fe_ocurrencia = fe_ocurrencia,\ importe_pagado =importe_pagado,\ estado = estado) db.session.add(registro_recupero) registros_nuevos += 1 db.session.commit() flash("Se han ingresado: " + str(registros_nuevos) + " nuevos registros. Se rechazaron: " + \ str(registros_repetidos) + " registros ya existentes. El archivo contenia: " + str(registros_total) \ + " registros.", "alert-primary" ) return render_template("subirbases.html", form=basexlsx_form) flash("You must be logged in.", "alert-warning") return redirect(url_for("login"))
def upload(): if not session.get('logged_in'): abort(401) # Instantiate your form class upload = UploadForm() # Validate file upload on submit if request.method == 'POST' and upload.validate(): # Get file data and save to your uploads folder file = request.files['photo'] filename = secure_filename(file.filename) file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename)) flash('File Saved', 'success') return redirect(url_for('home')) return render_template('upload.html')
def change_icon(): form = UploadForm() if form.validate(): suffix = os.path.splitext(form.icon.data.filename)[1] filename = random_string()+suffix photos.save(form.icon.data,name=filename) pathname = os.path.join(current_app.config['UPLOADED_PHOTOS_DEST'],filename) img = Image.open(pathname) img.thumbnail((128,128)) img.save(pathname) if current_user.icon != 'default.jpg': os.remove(os.path.join(current_app.config['UPLOADED_PHOTOS_DEST'],current_user.icon)) current_user.icon = filename db.session.add(current_user) db.session.commit() flash('图片已经保存') img_url = photos.url(current_user.icon) return render_template('users/change_icon.html',form=form,img_url=img_url)
def earnings_and_expenses(): form = UploadForm() form.origin.choices = [('Credit Card', 'Credit Card'), ('Checking Account', 'Checking Account')] if form.submit1.data and form.validate(): df = pd.read_csv(request.files.get('file_upload')) items = create_items(df, form.origin.data) for item in items: db.session.add(item) db.session.commit() flash('{} items registered!'.format(len(items))) return redirect(url_for('earnings_and_expenses')) #Using session to store the dates used from the last if "init_date_ee" not in session: session["init_date_ee"] = date.today().replace(day=1, month=1).strftime("%d%m%Y") session["end_date_ee"] = date.today().strftime("%d%m%Y") form_date = DatesForm(session["init_date_ee"], session["end_date_ee"]) if form_date.submit2.data and form_date.validate(): form_date.initial_date.data = form_date.initial_date.data form_date.end_date.data = form_date.end_date.data session["init_date_ee"] = form_date.initial_date.data.strftime("%d%m%Y") session["end_date_ee"] = form_date.end_date.data.strftime("%d%m%Y") elif request.method == 'GET': form_date.initial_date.data = datetime.strptime(session["init_date_ee"], "%d%m%Y").date() form_date.end_date.data = datetime.strptime(session["end_date_ee"], "%d%m%Y").date() try: items_df = pd.read_sql(Item.query.filter((Item.date >= datetime.strptime(session["init_date_ee"], "%d%m%Y")) & (Item.date <= datetime.strptime(session["end_date_ee"], "%d%m%Y"))).statement, db.session.bind) views = get_views_earnings_and_expenses(items_df) except: views = None return render_template('earnings_and_expenses.html', form=form, form_date=form_date, active_page = 'earnings_and_expenses', views = views)