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,
})
