def save_changes(album, form, new=False): if new: # Add the new album to the database form_data = dict((key, request.form.get(key)) for key in request.form.keys()) a = object_as_dict(album) form_data["name"] = configuration_type(form_data) for key in set(form_data) & set(a): a[key] = form_data[key] for key, value in a.items(): setattr(album, key, value) db_session.add(album) else: form_data = dict((key, request.form.get(key)) for key in request.form.keys()) a = object_as_dict(album) form_data["name"] = configuration_type(form_data) for key in set(form_data) & set(a): a[key] = form_data[key] qry3 = db_session.query(Album).get(a["id"]) for key, value in a.items(): setattr(qry3, key, value) # commit the data to the database db_session.commit()
def plano_new(): if request.method == 'GET': return render_template('plano_new.html') if request.method == 'POST': form = plano_form(request.form) db_session.add(plano_convert(plano(), form)) db_session.commit() return redirect('/plano_list')
def delete(id): qry = db_session.query(Album).filter(Album.id==id) album = qry.first() if album: form = AlbumForm(formdata=request.form, obj=album) if request.method == 'DELETE' and form.validate(): db_session.delete(album) db_session.commit()
def delete(): courseNum = request.form.get('course') assignmentName = request.form.get('assignmentName') deleteAssignment = db_session.query(Assignment).filter_by( name=assignmentName, class_id=courseNum).first() db_session.delete(deleteAssignment) db_session.commit() return redirect(url_for('search', courseNum=courseNum))
def sheetnew(): form = SheetsForm(request.form) if request.method == 'POST' and form.validate(): sheet = SheetsConvert(Sheets(), form) db_session.add(sheet) db_session.commit() flash('created successfully!') return redirect('/sheetlist') return render_template('sheetform.html', form=form)
def projectnew(): form = ProjectsForm(request.form) if request.method == 'POST' and form.validate(): project = ProjectsConvert(Projects(), form) db_session.add(project) db_session.commit() flash('created successfully!') return redirect('/projectlist') return render_template('projectform.html', form=form)
def foldernew(): form = FoldersForm(request.form) if request.method == 'POST' and form.validate(): folder = FoldersConvert(Folders(), form) db_session.add(folder) db_session.commit() flash('created successfully!') return redirect('/folderlist') return render_template('folderform.html', form=form)
def floorplannew(): form = FloorplansForm(request.form) if request.method == 'POST' and form.validate(): floorplan = FloorplansConvert(Floorplans(), form) db_session.add(floorplan) db_session.commit() flash('created successfully!') return redirect('/floorplanlist') return render_template('floorplanform.html', form=form)
def attachmentnew(): form = AttachmentsForm(request.form) if request.method == 'POST' and form.validate(): attachment = AttachmentsConvert(Attachments(), form) db_session.add(attachment) db_session.commit() flash('created successfully!') return redirect('/attachmentlist') return render_template('attachmentform.html', form=form)
def del_spe(id): qry = db_session.query(Spend).filter(Spend.id==id) spend = qry.first() db_session.delete(spend) db_session.commit() flash('Spend deleted successfully!') return redirect('/spe')
def save_entry(raw_grid, move_str, time): m_moves = MarioMoves() m_moves.id = datetime.datetime.now() m_moves.grid = raw_grid m_moves.moves = move_str m_moves.time = time db_session.add(m_moves) db_session.commit()
def del_res(id): qry = db_session.query(Reservation).filter(Reservation.id==id) reservation = qry.first() db_session.delete(reservation) db_session.commit() flash('Reservation deleted successfully!') return redirect('/res')
def holiday_del(del_date): print('holiday del') qry = db_session.query(Holiday).filter(Holiday.c_acdcode == '0202').filter( Holiday.c_date == del_date) hday = qry.first() db_session.delete(hday) db_session.commit() print('Holiday delete successfully!') return redirect('/holiday')
def save_spe(spend, form, new=False): spend.date = form.date.data spend.value = form.value.data spend.item = form.item.data if new: db_session.add(spend) db_session.commit()
def funcrandom(): fake = Faker() for i in range(300): datedata = fake.date_between(start_date='-1y', end_date='today') nodata = random.randint(1,500) codebaseobject = Codebase() codebaseobject.date = datedata codebaseobject.code_count = nodata db_session.add(codebaseobject) db_session.commit()
def get_stored_password(self): qry = db_session.query(User).filter(User.username == self.username) qry = qry.first() if qry is None: return None stored_password = qry.password db_session.commit() return stored_password
def save_changes(userdata, form, new=False): userdata.username = form.username.data userdata.password = form.password.data if new: db_session.add(userdata) db_session.commit()
def save_item(item, form, new=True): item.product = form.product.data item.seller = form.seller.data item.price = form.price.data item.quantity = True if new: db_session.add(item) db_session.commit()
def save_changes(produto, form, new=False): #gravar os dados do formulario na base de dados criada #utilizar os dados do formulario e atribuilos aos cmapos correspondentes da base de dados produto.nome = form.nome.data produto.preco = form.preco.data produto.quantidade = form.quantidade.data if new: #adiciona o novo produto a base de dados db_session.add(produto) db_session.commit()
def detect_barcode(f): jpgname = 'temp/temp.jpg' jpgbar = 'temp/tempbar.jpg' f.save(jpgname) # images_from_path = convert_from_path(pdfname, dpi=300, last_page=1, first_page =1) # for page in images_from_path: # page.save(jpgname) image = cv2.imread(jpgname) gray = cv2.cvtColor(image, cv2.COLOR_BGR2GRAY) ddepth = cv2.cv.CV_32F if imutils.is_cv2() else cv2.CV_32F gradX = cv2.Sobel(gray, ddepth=ddepth, dx=1, dy=0, ksize=-1) gradY = cv2.Sobel(gray, ddepth=ddepth, dx=0, dy=1, ksize=-1) gradient = cv2.subtract(gradX, gradY) gradient = cv2.convertScaleAbs(gradient) blurred = cv2.blur(gradient, (9, 9)) (_, thresh) = cv2.threshold(blurred, 225, 255, cv2.THRESH_BINARY) kernel = cv2.getStructuringElement(cv2.MORPH_RECT, (80, 3)) closed = cv2.morphologyEx(thresh, cv2.MORPH_CLOSE, kernel) closed = cv2.erode(closed, None, iterations=25) closed = cv2.dilate(closed, None, iterations=25) cnts = cv2.findContours(closed.copy(), cv2.RETR_EXTERNAL, cv2.CHAIN_APPROX_SIMPLE) cnts = imutils.grab_contours(cnts) c = sorted(cnts, key=cv2.contourArea, reverse=True)[0] rect = cv2.minAreaRect(c) box = cv2.cv.BoxPoints(rect) if imutils.is_cv2() else cv2.boxPoints(rect) box = np.int0(box) x1, x2, x3, x4, y1, y2, y3, y4 = box[0][0], box[1][0], box[2][0], box[3][ 0], box[0][1], box[1][1], box[2][1], box[3][1] top_left_x = min([x1, x2, x3, x4]) top_left_y = min([y1, y2, y3, y4]) bot_right_x = max([x1, x2, x3, x4]) bot_right_y = max([y1, y2, y3, y4]) img = image[top_left_y + 6:bot_right_y + 6, top_left_x - 10:bot_right_x + 10] image_gray = cv2.cvtColor(img, cv2.COLOR_BGR2GRAY) cv2.imwrite(jpgbar, image_gray) code = decode(cv2.imread(jpgbar))[0][0] c1 = code.decode('ascii') nom_form = c1[0:4] reg = int(c1[4:7]) tablas = 'f' + nom_form exec("qry = db_session.query(" + tablas + ").filter(" + tablas + ".id==" + str(reg) + ").first()") qry1 = locals()['qry'] qry1.fscan = str(date.today()) flag_modified(qry1, 'fscan') db_session.merge(qry1) db_session.flush() db_session.commit() name = nom_form[1:4] + str(reg).zfill(4) + ".jpg" filename = "temp/" + name # os.rename(jpgname, filename) return jpgname, name
def save_changes(stats, form, new=False): company = Company() company.name = form.company.data stats.company = company stats.board = form.board.data stats.ticker = form.ticker.data #Name if new: db_session.add(stats) db_session.commit()
def save_product(product, form, new=True): product.name = form.name.data.lower() product.category = form.category.data.lower() product.width = form.width.data product.height = form.height.data product.length = form.length.data product.weight = form.weight.data if new: db_session.add(product) db_session.commit()
def save_res(reservation, form, new=False): reservation.room = form.room.data reservation.checkin = form.checkin.data reservation.checkout = form.checkout.data reservation.value = form.value.data reservation.client = form.client.data if new: db_session.add(reservation) db_session.commit()
def save_user(user, form, new=True): user.name = form.name.data user.street = form.street.data user.city = form.city.data user.state = form.state.data user.country = form.country.data user.user_type = form.user_type.data if new: db_session.add(user) db_session.commit()
def save_changes(hotel, form): """ Save the changes to the database """ hotel.pname = form.pname.data hotel.hsr_layout = form.hsr_layout.data hotel.location = form.location.data hotel.cordinates = form.cordinates.data hotel.s_room = form.s_room.data hotel.p_room = form.p_room.data db_session.add(hotel) db_session.commit()
def add(): if request.method == "GET": course_num = request.args['courseNum'] return render_template("addAssignment.html", course_num=course_num) name = request.form.get('assignment') course_num = request.form.get('courseNum') newAssignment = Assignment(name=name, class_id=course_num) db_session.add(newAssignment) db_session.commit() db_session.add(Grade(grade=0, assignment_id=newAssignment.id)) db_session.commit() return redirect(url_for('search', courseNum=course_num))
def index(): all_classes = db_session.query(Class).all() options = [] db_session.commit() for row in all_classes: options.append((row.id, row.name)) if request.method == "GET": return render_template("index.html", options=options) if request.form.get("class"): course = request.form.get('class') return redirect(url_for('search', courseNum=course))
def plano_edit(): if request.method == 'GET': id = request.args.get('id', None) qry = db_session.query(plano).filter(plano.id == id).first() return render_template('plano_edit.html', val=qry) if request.method == 'POST': form = plano_form(request.form) fo = plano_convert(plano(), form) flag_modified(fo, 'plano') db_session.merge(fo) db_session.flush() db_session.commit() return redirect('/plano_list')
def edit_protocolo(): if request.method == 'GET': global fname name = request.args.get('format', None) fname = 'f' + name.split('.')[0].split('-')[-1] return render_template('forms/' + fname + '.html') if request.method == 'POST': print(request.form) exec("form =" + fname + "_form(request.form)") exec("formats = " + fname + "_convert(" + fname + "(),form)") exec("db_session.add(formats)") db_session.commit() return redirect('/')
def save_changes(article_info, form, new=False): article = Article() article.name = form.article.data article_info.article = article article_info.url = form.url.data article_info.release_date = form.release_date.data article_info.publisher = form.publisher.data if new: db_session.add(article_info) db_session.commit()