ZEXPts(cOFS.Folder Folder q)tq.}q(UtitleqUUmesswerte_search_resultqUt|qQUmesswerte_searchqUtyqQUinitialize_tableq Ut}q QU add_valuesq Utvq QUgadfly_connecitonq UttqQU drop_tableqUt{qQUget_messreihenqUtwqQU_objectsq(}q(U meta_typeqUZ Gadfly Database ConnectionqUidqh u}q(hU Z SQL MethodqhU create_tablequ}q(hhhh u}q(hhhhu}q(hU Page TemplateqhUmesswerte_search_formqu}q (U meta_typeq!UScript (Python)q"Uidq#hu}q$(h!U Z SQL Methodq%h#U get_messwerteq&u}q'(h!h%h#hu}q((U meta_typeq)U Page Templateq*Uidq+hu}q,(h)UScript (Python)q-h+h utq.h&Utzq/QU__ac_local_roles__q0}q1Ugeroldq2]q3UOwnerq4asUidq5Udbtestq6hUtxq7QhUtuq8Qu.t|(cProducts.PageTemplates.ZopePageTemplate ZopePageTemplate q)tq.}q(UtitleqUU content_typeqU text/htmlqU_textqTn Ergebnis der Messwertsuche

Ergebnis der Messwertsuche

Messreihe "unbekannt".

[messwert1] [messwert2]

Kein Ergebnis...

qU _bind_namesq (cShared.DC.Scripts.Bindings NameAssignments q oq }q U_asgnsq }qU name_subpathqUtraverse_subpathqssbU__ac_local_roles__q}qUgeroldq]qUOwnerqasUidqUmesswerte_search_resultqUexpandqKu.ty(cProducts.PythonScripts.PythonScript PythonScript q)tq.}q(U Python_magicqUm qUerrorsq)Uwarningsq)U Script_magicqKU_bodyq T# request request = container.REQUEST # SQL-Datenbank abfragen result = container.get_messwerte(messreihe = messreihe) # Ergebnisseite aufrufen und dabei Daten übergeben return container.messwerte_search_result( messreihe = messreihe, result = result ) q Uidq Umesswerte_searchq U_codeq Tc@s dZdS(NcCsGttd}ttdd|}ttdd|d|SdS(NtREQUESTt get_messwertet messreihetmesswerte_search_resulttresult(t _getattr_t containertrequestRR(RRRRR((sScript (Python)tmesswerte_searchs (R(R((sScript (Python)stqU func_defaultsqNU _bind_namesq(cShared.DC.Scripts.Bindings NameAssignments qoq}qU_asgnsq}q(U name_contextqUcontextqU name_subpathqUtraverse_subpathqU name_m_selfqUscriptqUname_containerqU containerqusbU__ac_local_roles__q}qUgeroldq ]q!UOwnerq"asU _filepathq#U3Script (Python):/TESTORDNER/dbtest/messwerte_searchq$U_paramsq%U messreiheq&U func_codeq'(cShared.DC.Scripts.Signature FuncCode q(oq)}q*(U co_argcountq+KU co_varnamesq,(U messreiheq-U _getattr_q.U containerq/Urequestq0Uresultq1tq2ubu.t}(cProducts.PythonScripts.PythonScript PythonScript q)tq.}q(U Python_magicqUm qUerrorsq)Uwarningsq)U Script_magicqKU_bodyq TDtry: # Tabelle erstellen container.create_table() # Tabelle fuellen container.add_values(messreihe = 'a', messwert1 = 22, messwert2 = 33) container.add_values(messreihe = 'a', messwert1 = 33, messwert2 = 44) container.add_values(messreihe = 'b', messwert1 = 66, messwert2 = 55) except: pass q Uidq Uinitialize_tableq U_codeq Tc@s dZdS(Nc Csyzttdttdddddddttddddddd ttddd dd dd WnnXdS( Nt create_tablet add_valuest messreihetat messwert1it messwert2i!i,tbiBi7(t _getattr_t container(RR((sScript (Python)tinitialize_tables "")(R (R ((sScript (Python)stqU func_defaultsqNU _bind_namesq(cShared.DC.Scripts.Bindings NameAssignments qoq}qU_asgnsq}q(U name_contextqUcontextqU name_subpathqUtraverse_subpathqU name_m_selfqUscriptqUname_containerqU containerqusbU__ac_local_roles__q}qUgeroldq ]q!UOwnerq"asU _filepathq#U3Script (Python):/TESTORDNER/dbtest/initialize_tableq$U_paramsq%UU func_codeq&(cShared.DC.Scripts.Signature FuncCode q'oq(}q)(U co_argcountq*KU co_varnamesq+(U _getattr_q,htq-ubu.tv(cProducts.ZSQLMethods.SQL SQL q)tq.}q(UsrcqUINSERT INTO messwerte ( messreihe, messwert1, messwert2 ) VALUES ( , , ) qU arguments_srcqUmessreihe messwert1 messwert2qUtitleqUU connection_idq Ugadfly_connecitonq U_argq (cShared.DC.ZRDB.Aqueduct Args q oq }q(U_dataq}q(U messreiheq}qU messwert2q}qU messwert1q}quU_keysq]q(hhheubUtemplateqccopy_reg __newobj__ q(cShared.DC.ZRDB.DA SQL qtRq}q(U_varsq}qUrawq hUglobalsq!}q"U__name__q#Uq$ubU_colq%)U__ac_local_roles__q&}q'Ugeroldq(]q)UOwnerq*asUidq+U add_valuesq,u.tt(cProducts.ZGadflyDA.DA Connection q)tq.}q(Uconnection_stringqUdemoqU__ac_local_roles__q}qUgeroldq]q UOwnerq asUidq Ugadfly_connecitonq Utitleq Uu.t{(cProducts.ZSQLMethods.SQL SQL q)tq.}q(UsrcqUDROP TABLE messwerteqU arguments_srcqUUtitleqUU connection_idqUgadfly_connecitonq U_argq (cShared.DC.ZRDB.Aqueduct Args q oq }q (U_dataq}qU_keysq]qubUtemplateqccopy_reg __newobj__ q(cShared.DC.ZRDB.DA SQL qtRq}q(U_varsq}qUrawqhUglobalsq}qU__name__qUqubU_colq)U__ac_local_roles__q}q Ugeroldq!]q"UOwnerq#asUidq$U drop_tableq%u.tw(cProducts.ZSQLMethods.SQL SQL q)tq.}q(UsrcqUASELECT DISTINCT messreihe FROM messwerte ORDER BY messreiheqU arguments_srcqUUtitleqUU connection_idqUgadfly_connecitonq U_argq (cShared.DC.ZRDB.Aqueduct Args q oq }q (U_dataq}qU_keysq]qubUtemplateqccopy_reg __newobj__ q(cShared.DC.ZRDB.DA SQL qtRq}q(U_varsq}qUrawqhUglobalsq}qU__name__qUqubU_colq]q}q (Uwidthq!NUnullq"NUtypeq#UsUnameq$U MESSREIHEq%uaU__ac_local_roles__q&}q'Ugeroldq(]q)UOwnerq*asUidq+Uget_messreihenq,u.tzr(cProducts.ZSQLMethods.SQL SQL q)tq.}q(UsrcqUkSELECT messwert1, messwert2 FROM messwerte WHERE (messreihe = ) qU arguments_srcqU messreiheqUtitleqUU connection_idq Ugadfly_connecitonq U_argq (cShared.DC.ZRDB.Aqueduct Args q oq }q(U_dataq}qh}qsU_keysq]qhaubUtemplateqccopy_reg __newobj__ q(cShared.DC.ZRDB.DA SQL qtRq}q(U_varsq}qUrawqhUglobalsq}qU__name__qUqubU_colq ]q!(}q"(Uwidthq#NUnullq$NUtypeq%UsUnameq&U MESSWERT1q'u}q((h#Nh$Nh%Ush&U MESSWERT2q)ueU__ac_local_roles__q*}q+Ugeroldq,]q-UOwnerq.asUidq/U get_messwerteq0u.tx(cProducts.PageTemplates.ZopePageTemplate ZopePageTemplate q)tq.}q(UtitleqUU content_typeqU text/htmlqU_textqT Messwerte suchen

Messwerte suchen

Wählen Sie eine Messreihe aus:

qU _bind_namesq (cShared.DC.Scripts.Bindings NameAssignments q oq }q U_asgnsq }qU name_subpathqUtraverse_subpathqssbU__ac_local_roles__q}qUgeroldq]qUOwnerqasUidqUmesswerte_search_formqUexpandqKu.tu(cProducts.ZSQLMethods.SQL SQL q)tq.}q(UsrcqUXCREATE TABLE messwerte ( messreihe VARCHAR, messwert1 INTEGER, messwert2 INTEGER )qU arguments_srcqUUtitleqUU connection_idqUgadfly_connecitonq U_argq (cShared.DC.ZRDB.Aqueduct Args q oq }q (U_dataq}qU_keysq]qubUtemplateqccopy_reg __newobj__ q(cShared.DC.ZRDB.DA SQL qtRq}q(U_varsq}qUrawqhUglobalsq}qU__name__qUqubU_colq)U__ac_local_roles__q}q Ugeroldq!]q"UOwnerq#asUidq$U create_tableq%u.