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()
