def show_entries(): #cur = g.db.execute('select district, story, measure_type, measurement from entries order by id desc') form = DatabaseForm(request.form) #checks if user is posting data in the form entries = [] if request.method == 'POST' and form.validate(): cur = g.db.execute('select measurement from entries where district = ? and story = ? and measure_type = ?', [form.district.data, form.story.data, form.measure_type.data]) entries = [dict(measurement = row[0]) for row in cur.fetchall()] return render_template('show_entries.html', entries=entries, form=form)
def edit(self, _id): # TODO: Validations for fields obj = Database.query.filter_by(id=_id).first() database_form = DatabaseForm(obj=obj) if database_form.validate_on_submit(): database_form.populate_obj(obj) db_session.commit() flash("New database modify!", "alert-success") return redirect('/admin/databases') return self.render('databases/edit.html', database_form=database_form)
def add(self): # TODO: Validations for fields database_form = DatabaseForm() if database_form.validate_on_submit(): db_session.add( Database( name=database_form.name.data, user=database_form.user.data, host=database_form.host.data, password=database_form.password.data ) ) db_session.commit() flash("New database added!", "alert-success") return redirect('/admin/databases') return self.render('databases/add.html', database_form=database_form)
def create_databases(request): if request.method == 'POST': form = DatabaseForm(request.POST) if form.is_valid(): database = mm.Database( name=form.cleaned_data['name'], vendor=form.cleaned_data['vendor'], rubrics=form.cleaned_data['rubrics'], start_date=form.cleaned_data['start_date'], end_date=form.cleaned_data['end_date'] ) insert_record(database.to_rusmarc(), appsettings.ZBASES['databases']) return redirect(reverse('erm_admin_databases')) else: form = DatabaseForm() return render(request, 'admin_erm_databases_create.html', { 'form': form, })
def database_edit(request, id): records = search( appsettings.ZBASES['databases'], u'@attr 1=12 "%s"' % id ) if not records: raise Http404(_(u'Database not founded')) database_record = records[0] database = mm.Database.from_rusmarc(database_record) print database_record print database.end_date form = DatabaseForm(request.POST) if form.is_valid(): database.name = form.cleaned_data['name'] database.vendor = form.cleaned_data['vendor'] database.rubrics = form.cleaned_data['rubrics'] database.start_date = form.cleaned_data['start_date'] database.end_date = form.cleaned_data['end_date'] update_record(database.to_rusmarc(), appsettings.ZBASES['databases']) return redirect(reverse('erm_admin_databases')) else: form = DatabaseForm(data={ 'name':database.name, 'vendor':database.vendor, 'rubrics':database.rubrics, 'start_date':database.start_date, 'end_date':database.end_date, }) return render(request, 'admin_erm_databases_edit.html', { 'form': form, })