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)