ZEXP‡9((U OFS.FolderqUFolderqtqNt.}q(U sqlDropTableq(UÅq(UProducts.ZSQLMethods.SQLqUSQLqttQU__ac_local_roles__q }q Uadminq ]q UOwnerq asU kysimusedq(U‹q(UProducts.ZGadflyDA.DAqU ConnectionqttQU_objectsq(}q(U meta_typeqUZ Gadfly Database ConnectionqUidqU kysimusedqu}q(U meta_typeqU Z SQL MethodqUidqUsqlCreateTablequ}q(hhhU sqlInsertqu}q(hhhU sqlSelectq u}q!(U meta_typeq"U Z SQL Methodq#Uidq$hu}q%(U meta_typeq&U Z SQL Methodq'Uidq(U sqlInsert2q)u}q*(h&U DTML Methodq+h(U K6ikKysimusedq,u}q-(U meta_typeq.U DTML Methodq/Uidq0UValitudKysimusedq1u}q2(U meta_typeq3U Z SQL Methodq4Uidq5UsqlCountq6u}q7(h3U DTML Methodq8h5U index_htmlq9u}q:(h3h4h5U sqlSelect2q;u}q<(U meta_typeq=U DTML Methodq>Uidq?UValitudKysimusq@u}qA(h=U Z SQL MethodqBh?U sqlNimTabqCu}qD(U meta_typeqEUScript (Python)qFUidqGUprooviksqHu}qI(U meta_typeqJUScript (Python)qKUidqLU loosimineqMu}qN(U meta_typeqOUScript (Python)qPUidqQU loosimine2qRu}qS(U meta_typeqTU Z SQL MethodqUUidqVU sqlVastusqWu}qX(hTU DTML MethodqYhVU K6ikVastusedqZu}q[(hThUhVUsqlSelectVastusq\u}q](hThYhVUVastuseLisamineq^uthH(UIq_(U#Products.PythonScripts.PythonScriptq`U PythonScriptqattQU_ownerqb(]qcU acl_usersqdah th)(UĘqe(hUSQLqfttQU index_htmlqg(UĖqh(UOFS.DTMLMethodqiU DTMLMethodqjttQUtitleqkU andmebaasqlhZ(Uaqm(hiU DTMLMethodqnttQUidqoU andmebaasqph;(UĢqq(hUSQLqrttQh,(UĒqs(hiU DTMLMethodqtttQh(UĀqu(hUSQLqvttQh@(UĶqw(hiU DTMLMethodqxttQhW(U`qy(hUSQLqzttQhR(U_q{(h`U PythonScriptq|ttQhC(UĪq}(hUSQLq~ttQh\(Ubq(hUSQLq€ttQh(UĆq(hUSQLq‚ttQh6(UŹqƒ(hUSQLq„ttQh^(Ucq…(hiU DTMLMethodq†ttQh (UÄq‡(hUSQLqˆttQhM(U^q‰(h`U PythonScriptqŠttQh1(UÉq‹(hiU DTMLMethodqŒttQu.Å”((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU sqlDropTableqU__ac_local_roles__q}qUadminq ]q UOwnerq asU connection_idq U kysimusedq UsrcqUDROP TABLE kysimusqU_colq)UtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawqhU_varsq}qubUtitleqUDrop Table kysimusqU arguments_srcqUU_argq(cShared.DC.ZRDB.Aqueduct Args q oq!}q"(U_keysq#]q$U_dataq%}q&ubu.‹±((UProducts.ZGadflyDA.DAqU ConnectionqtqNt.}q(UtitleqU kysimusedqUidqU kysimusedqU__ac_local_roles__q }q Uadminq ]q UOwnerq asUconnection_stringqU kysimustikqu.I”((U#Products.PythonScripts.PythonScriptqU PythonScriptqtqNt.}q(U func_codeq(cShared.DC.Scripts.Signature FuncCode qoq}q(U co_varnamesq (U_print_q U_printq UProducts.PythonScripts.standardq U html_quoteq U _getattr_qU containerqUrequestqURESPONSEqUscriptqtqU co_argcountqKubUidqUprooviksqU__ac_local_roles__q}qUadminq]qUOwnerqasU _bind_namesq(cShared.DC.Scripts.Bindings NameAssignments qoq}qU_asgnsq }q!(Uname_containerq"hU name_subpathq#Utraverse_subpathq$U name_contextq%Ucontextq&U name_m_selfq'husbU func_defaultsq(NU_codeq)TPcsd„ZdS(Nc sÖtƒ}dkl}ttdƒ}t|dƒ} |dIttdƒIdttdƒƒIt tdƒo$ |d |ttdƒƒIn |d Ittd ƒƒIJ |ƒSdS( N(s html_quotesREQUESTsRESPONSEs This is thes meta_types"%s"sgetIdstitles(%s)sins absolute_url( s_print_s_printsProducts.PythonScripts.standards html_quotes _getattr_s containersrequestsRESPONSEsscript( s_print_s_printsProducts.PythonScripts.standards html_quotes _getattr_s containersrequestsRESPONSEsscript((sScript (Python)sproovikss 5$(sprooviks(sprooviks((sScript (Python)ssq*U_bodyq+T¬# Example code: # Import a standard function, and get the HTML request and response objects. from Products.PythonScripts.standard import html_quote request = container.REQUEST RESPONSE = request.RESPONSE # Return a string identifying this script. print "This is the", script.meta_type, '"%s"' % script.getId(), if script.title: print "(%s)" % html_quote(script.title), print "in", container.absolute_url() return printed q,U Script_magicq-KUwarningsq.)Uerrorsq/)U Python_magicq0U*ė q1u.ĘŅ((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU sqlInsert2qU__ac_local_roles__q}qUadminq ]q UOwnerq asU connection_idq U kysimusedq UsrcqUBinsert into kysimus (k_id, k_sisu) values (1, 'Kysimus 1 sisu' ) qU_colq)UtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawqhU_varsq}qubUtitleqUSisesta Tabelisse FixqU arguments_srcqUU_argq(cShared.DC.ZRDB.Aqueduct Args q oq!}q"(U_keysq#]q$U_dataq%}q&ubu.ˬ((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUadminq]qUOwnerq asU__name__q U index_htmlq Utitleq UEksamiküsimusedq Uglobalsq}qUrawqTš Eksamiküsimused

Eksamiküsimused andmebaasist


Kõikide andmebaasis olevate küsimuste vaatamine kokku on neid

Eksamiküsimused ja neile vastamine

Üksik Eksamiküsimus ja sellele vastamine

Kõikide vastuste vaatamine

qU_varsq}qu.a((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUadminq]qUOwnerq asU__name__q U K6ikVastusedq Utitleq UKõikide vastuste vaatamineq Uglobalsq}qUrawqTø

Kõikide küsimuste näitamine

VastajaÕppegrupp Küsimuse IDVastuse sisu
qU_varsq}qu.Ģ((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU sqlSelect2qU__ac_local_roles__q}qUadminq ]q UOwnerq asU connection_idq U kysimusedq UsrcqU8SELECT * FROM kysimus WHERE qU_colq]q}q(UnameqUK_SISUqUtypeqUsUnullqNUwidthqNuaUtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawq hU_varsq!}q"ubUtitleq#UTeatava rea küsimineq$U arguments_srcq%Uk_idq&U_argq'(cShared.DC.ZRDB.Aqueduct Args q(oq)}q*(U_keysq+]q,h&aU_dataq-}q.h&}q/subu.Ēē((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUadminq]qUOwnerq asU__name__q U K6ikKysimusedq Utitleq UK6ikide kysimuste v2ljastamineq Uglobalsq}qUrawqT

Kõikide küsimuste näitamine

qU_varsq}qu.ĀŹ((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUsqlCreateTableqU__ac_local_roles__q}qUadminq ]q UOwnerq asU_argq (cShared.DC.ZRDB.Aqueduct Args q oq}q(U_keysq]qU_dataq}qubU connection_idqU kysimusedqU_colq)UtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawqU8CREATE TABLE kysimus( k_id integer, k_sisu VARCHAR )q U_varsq!}q"ubUtitleq#UTabelKysimusLoomineq$U arguments_srcq%UUsrcq&h u.ĶĻ((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUadminq]qUOwnerq asU__name__q UValitudKysimusq Utitleq U Üksik küsimusq U _proxy_rolesq(UManagerqtqUglobalsq}qUrawqTņ

Üksiku küsimuse näitamine

GruppNimi
qU_varsq}qu.`·((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU sqlVastusqU__ac_local_roles__q}qUadminq ]q UOwnerq asU connection_idq U kysimusedq UsrcqUĻINSERT INTO vastused (vastaja, ryhm, k_id, k_vastus) values( , , , )qU_colq)UtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawqhU_varsq}qubUtitleqUVastuse sisestamineqU arguments_srcqUvastaja ryhm k_id k_vastusqU_argq (cShared.DC.ZRDB.Aqueduct Args q!oq"}q#(U_keysq$]q%(Uvastajaq&Uryhmq'Uk_idq(Uk_vastusq)eU_dataq*}q+(h'}q,h)}q-h&}q.h(}q/uubu._*((U#Products.PythonScripts.PythonScriptqU PythonScriptqtqNt.}q(U func_codeq(cShared.DC.Scripts.Signature FuncCode qoq}q(U co_varnamesq (Urandomq U kysimusedq U _getattr_q Uloositudq tqU co_argcountqKubU_paramsqUUidqU loosimine2qU__ac_local_roles__q}qUadminq]qUOwnerqasU _bind_namesq(cShared.DC.Scripts.Bindings NameAssignments qoq}qU_asgnsq}q(Uname_containerqU containerqU name_subpathq Utraverse_subpathq!U name_m_selfq"Uscriptq#U name_contextq$Ucontextq%usbU func_defaultsq&NU_codeq'Tcsd„ZdS(Ncshdk}ddddddddd d d d d ddg}t|dƒddƒ}|SdS(Niiiiiiiii i i i i iisrandinti(srandoms kysimuseds _getattr_sloositud(srandoms kysimuseds _getattr_sloositud((sScript (Python)s loosimine2s 6(s loosimine2(s loosimine2((sScript (Python)ssq(U _proxy_rolesq)(UManagerq*tq+U_bodyq,Uimport random kysimused =[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] loositud = random.randint(1, 16) return loositud q-U Script_magicq.KUwarningsq/)Utitleq0UÜhe numbri loosimineq1Uerrorsq2)U Python_magicq3U*ė q4u.Īö((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU sqlNimTabqU__ac_local_roles__q}qUadminq ]q UOwnerq asU_argq (cShared.DC.ZRDB.Aqueduct Args q oq}q(U_keysq]qU_dataq}qubU connection_idqU kysimusedqU_colq)UtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawqUeCREATE TABLE vastused( vastaja varchar, ryhm varchar, k_id integer, k_vastus varchar )q U_varsq!}q"ubUtitleq#UVastuste tabeli loomineq$U arguments_srcq%UUsrcq&h u.b ((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUsqlSelectVastusqU__ac_local_roles__q}qUadminq ]q UOwnerq asU connection_idq U kysimusedq UsrcqUselect * from vastusedqU_colq]q(}q(UnameqURYHMqUtypeqUsUnullqNUwidthqNu}q(hUK_VASTUSqhUshNhNu}q(hUVASTAJAqhUshNhNu}q(hUK_IDqhUshNhNueUtemplateqcShared.DC.ZRDB.DA SQL qNRq }q!(U__name__q"Uq#Uglobalsq$}q%Urawq&hU_varsq'}q(ubUtitleq)UU arguments_srcq*UU_argq+(cShared.DC.ZRDB.Aqueduct Args q,oq-}q.(U_keysq/]q0U_dataq1}q2ubu.Ć*((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU sqlInsertqU__ac_local_roles__q}qUadminq ]q UOwnerq asU connection_idq U kysimusedq UsrcqUrINSERT INTO kysimus (k_id, k_sisu) values( , )qU_colq)UtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawqhU_varsq}qubUtitleqUSisesta TabelisseqU arguments_srcqU k_id k_sisuqU_argq (cShared.DC.ZRDB.Aqueduct Args q!oq"}q#(U_keysq$]q%(Uk_idq&Uk_sisuq'eU_dataq(}q)(h&}q*h'}q+uubu.Ź÷((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqUsqlCountqU__ac_local_roles__q}qUadminq ]q UOwnerq asU connection_idq U kysimusedq UsrcqU$SELECT COUNT(*) AS hulk FROM kysimusqU_colq]q}q(UnameqUHULKqUtypeqUsUnullqNUwidthqNuaUtemplateqcShared.DC.ZRDB.DA SQL qNRq}q(U__name__qUqUglobalsq}qUrawq hU_varsq!}q"ubUtitleq#UKüsimuste arvu päringq$U arguments_srcq%Uhulkq&U_argq'(cShared.DC.ZRDB.Aqueduct Args q(oq)}q*(U_keysq+]q,h&aU_dataq-}q.h&}q/subu.c((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUadminq]qUOwnerq asU__name__q UVastuseLisamineq Utitleq UUglobalsq }qUrawqUŅ Vastus lisatud qU_varsq}qu.Äł((UProducts.ZSQLMethods.SQLqUSQLqtqNt.}q(UidqU sqlSelectqU__ac_local_roles__q}qUadminq ]q UOwnerq asU_argq (cShared.DC.ZRDB.Aqueduct Args q oq}q(U_keysq]qU_dataq}qubU connection_idqU kysimusedqU_colq]q(}q(UnameqUK_IDqUtypeqUsUnullqNUwidthqNu}q(hUK_SISUqhUshNhNueUtemplateq cShared.DC.ZRDB.DA SQL q!NRq"}q#(U__name__q$Uq%Uglobalsq&}q'Urawq(Uselect * from kysimusq)U_varsq*}q+ubUtitleq,UK6ikide ridade kysimineq-U arguments_srcq.UUsrcq/h)u.^ł((U#Products.PythonScripts.PythonScriptqU PythonScriptqtqNt.}q(U func_codeq(cShared.DC.Scripts.Signature FuncCode qoq}q(U co_varnamesq (U_print_q U_printq Urandomq U kysimusedq U _getattr_qUloositudqU _getiter_qUitqU co_argcountqKubU_paramsqUUidqU loosimineqU__ac_local_roles__q}qUadminq]qUOwnerqasU _bind_namesq(cShared.DC.Scripts.Bindings NameAssignments qoq}qU_asgnsq}q (Uname_containerq!U containerq"U name_subpathq#Utraverse_subpathq$U name_m_selfq%Uscriptq&U name_contextq'Ucontextq(usbU func_defaultsq)NU_codeq*T¢csd„ZdS(Ncs­tƒ}dk}ddddddddd d d d d ddg}t|dƒ|dƒ}||IJx&t|ƒdr}||IJq…W|ƒSdS(Niiiiiiiii i i i i iissamplei(s_print_s_printsrandoms kysimuseds _getattr_sloosituds _getiter_si(s_print_s_printsrandoms kysimuseds _getattr_sloosituds _getiter_si((sScript (Python)s loosimines 6 (s loosimine(s loosimine((sScript (Python)ssq+U_bodyq,U±import random kysimused =[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] loositud = random.sample(kysimused, 5) print loositud for i in loositud: print i return printed q-U Script_magicq.KUwarningsq/)Utitleq0ULoosimisskritptq1Uerrorsq2)U Python_magicq3U*ė q4u.ÉŽ((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUadminq]qUOwnerq asU__name__q UValitudKysimusedq Utitleq UKüsimuste Valikq Uglobalsq}qUrawqTĢ

Eksamiküsimused

qU_varsq}qu.’’’’’’’’’’’’’’’’