def all():
session_init(session, db)
spectra = []
dbspectra = db.get_spectra()
for s in dbspectra:
edge = db.get_edge(s.edge_id)
elem_sym = db.get_element(s.element_z).symbol
elem = s.element_z
person = db.get_person(s.person_id)
bl_id, bl_desc = beamline_for_spectrum(db, s)
spectra.append({
'id': s.id,
'name': s.name,
'element': elem,
'edge': edge.name,
'person_email': person.email,
'person_name': person.name,
'elem_sym': elem_sym,
'rating': get_rating(s),
'beamline_desc': bl_desc,
'beamline_id': bl_id,
})
return render_template('ptable.html',
nspectra=len(dbspectra),
elem='All Elements',
spectra=spectra)
def all():
session_init(session, db)
spectra = []
dbspectra = db.get_spectra()
for s in dbspectra:
edge = db.get_edge(s.edge_id)
elem_sym = db.get_element(s.element_z).symbol
elem = s.element_z
person = db.get_person(s.person_id)
bl_id, bl_desc = beamline_for_spectrum(db, s)
spectra.append({'id': s.id,
'name': s.name,
'element': elem,
'edge': edge.name,
'person_email': person.email,
'person_name': person.name,
'elem_sym': elem_sym,
'rating': get_rating(s),
'beamline_desc': bl_desc,
'beamline_id': bl_id,
})
return render_template('ptable.html', nspectra=len(dbspectra),
elem='All Elements', spectra=spectra)
def search(elem=None, orderby=None, reverse=0):
session_init(session, db)
dbspectra = []
if orderby is None: orderby = 'id'
if elem is not None:
try:
dbspectra = db.get_spectra(element=elem, orderby=orderby)
except:
pass
reverse = int(reverse)
if reverse:
dbspectra.reverse()
reverse = 0
else:
reverse = 1
spectra = []
for s in dbspectra:
edge = db.get_edge(s.edge_id)
elem_sym = db.get_element(s.element_z).symbol
person = db.get_person(s.person_id)
bl_id, bl_desc = beamline_for_spectrum(db, s)
spectra.append({
'id': s.id,
'name': s.name,
'element': elem,
'edge': edge.name,
'person_email': person.email,
'person_name': person.name,
'elem_sym': elem_sym,
'rating': get_rating(s),
'beamline_desc': bl_desc,
'beamline_id': bl_id,
})
return render_template('ptable.html',
nspectra=len(dbspectra),
elem=elem,
spectra=spectra,
reverse=reverse)
def search(elem=None, orderby=None, reverse=0):
session_init(session, db)
dbspectra = []
if orderby is None: orderby = 'id'
if elem is not None:
try:
dbspectra = db.get_spectra(element=elem, orderby=orderby)
except:
pass
reverse = int(reverse)
if reverse:
dbspectra.reverse()
reverse = 0
else:
reverse = 1
spectra = []
for s in dbspectra:
edge = db.get_edge(s.edge_id)
elem_sym = db.get_element(s.element_z).symbol
person = db.get_person(s.person_id)
bl_id, bl_desc = beamline_for_spectrum(db, s)
spectra.append({'id': s.id,
'name': s.name,
'element': elem,
'edge': edge.name,
'person_email': person.email,
'person_name': person.name,
'elem_sym': elem_sym,
'rating': get_rating(s),
'beamline_desc': bl_desc,
'beamline_id': bl_id,
})
return render_template('ptable.html', nspectra=len(dbspectra),
elem=elem, spectra=spectra,
reverse=reverse)
