m &{BIc@sdklZdklZdkZdkZdkZdkZdkZdk Z dk Z dk Z dk Z defdYZ dS((sBasic(sDataNtSystemcBsVtZdZdZdZdZdZdZdddd Zd Z d Z d Z d Z dZ dZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZddZdd Z d!Z!d"Z"d#Z#d$Z$d%Z%d&Z&d'Z'd(d)d*Z(d+Z)d,Z*dd-dd.Z+dd-dd/Z,d0Z-d1Z.d2Z/d3Z0d4Z1d5Z2d6e3i4fd7YZ5d8Z6d9Z7d:Z8d;fd<YZ9d(d=Z:d>Z;d?Z<d@Z=dAZ>RS(BNcCsti|y|iddd|iddd|iddd|iddd|iddd|iddd|idd d|idd d|idd d|idd d|idd d|iddd|iddd|iddd|iddd|iddd|iddd|iddd|iddd|iddd|iddd|iddd|iddd|iddd|idddWntj onXdS(Ntttables table::idt0s table::names table::fieldstable::field::idstable::field::namestable::field::typestable::field::defaultstable::field::indextusersuser::ids user::namesuser::passwords user::rolessuser::preferencestfunctions function::idsfunction::namesfunction::rolessfunction::titlesfunction::attributestlanguages language::idslanguage::nameslanguage::title(tDatatinittselftaddentryt Exception(R ((tH/data/zmath/mirror/zope/Products/zauthors/zsite/zsystem/system/system.pyRs< cCsi|i|d|tdgtt|iddd}|i|d||i|d|dS(NRis.*s table::idis table::name(R R tnametmaxtmaptintt listvaluestid(R R R((R taddtable)s ,cCs(|i|d|id|ddS(NRs^%s$s^table::(R tdelentryR t delentries(R R ((R tdeltable1scCsChd|i|d<d|i|d<d|i|d %d ORDER BY id LIMIT 1 tprevioussSELECT id FROM %s_%s WHERE id > 0 AND id < %d ORDER BY id DESC LIMIT 1 tfirstsSELECT id FROM %s_%s WHERE id > 0 ORDER BY id LIMIT 1 tlastsSELECT id FROM %s_%s ORDER BY id DESC LIMIT 1 iR( R RPRQtactionRRR RRRSt dictfetchallR(R RRReRRQ((R tnavigatecs  ! !     cCsV|ii}|id|i|f|i}|i|o |dSndS(NstSELECT id FROM %s_%s ORDER BY id LIMIT 1 Ri( R RPRQRRR Rt dictfetchoneRRS(R RRQR((R tminids   cCsV|ii}|id|i|f|i}|i|o |dSndS(NsySELECT id FROM %s_%s ORDER BY id DESC LIMIT 1 Ri( R RPRQRRR RRhRRS(R RRQR((R tmaxids   Rc CsAti|d}d|d}x<tt|D](}d|i||||f||R?R@RARBRCRDR|RFRGRTRYRZR[R\R^R`RgRiRjRyRzRRRRRRRt TransportRRRRRRRRR R (((R Rst !                   #       ' !  (tbasicR]RRR.RHRRlRRrRRRR( RRRlR.RRRRRHR]RRr((R Rs  Q