mò T¬ Gc@sŒdZddd!ZdklZlZlZdklZdkl Z dk l Z dk l Z d k Zd kZd kZd kZd kZd kZd kZd kZd kZed eƒƒZd d ed „Zd ZdZdZdZdZ dZ!hed<ed<ed<ed <e d<e!d Iterates through all rows of the TinyTablePlus. Within the region contained by 'in' tag, the column names will be available as variables and so can be insterted. For example on the first iteration, '' will be replaced with 'john'. Index Query:: The passed argument will be looked up in the table's index of the first column. Because the index is unique, either zero (if no matching rows) or one (if any matching rows) rows will be iterated through. In this case, any *one* of the three rows with a last name of 'jones' could be returned. The choice of which row is returned when multiple rows have the same index value is unspecified. Filter Query:: When one or more named arguments is given, a filter query is performed. Each argument name must be the name of a column, and the corresponding value is compared against that column in each row. Only matching rows are returned. The first example above, in contrast with the index query example, returns *all three* rows where the last name is 'jones'. While an Index Query operates only on the first column, a filter query can operate on any column. In the second exmple above, all three rows with the first name 'john' are returned. Finally, multiple filters may be specified. In this case only rows matching all contraints are iterated through. In the third example above, only the two rows where the last name is 'jones' and the middle initial is 'y' will be returned. Shane's mods: There are four new methods, a change in the specification of column names, and minor mods throughout. These changes make it possible to use TinyTablePlus as a small database table, which can be very useful in a variety of situations. It is recommended, however, that TinyTablePlus only be used this way when accessed through a DatabaseConnector, so that a better implementation can be swapped in easily. 1. setRow(columnName=value, ...) setRows allows you to set the data in the table. If there are any 'key' columns, it will try to match the key columns and update a row. If there are no key columns or the values in the key are not matched by any row, a new row will be added. See the explanation for key columns below. 2. delRows(columnName=value, ...) Deletes all rows that match the filter. 3. delAllRows() Deletes all rows. 4. getRows(columnName=value, ...) A synonym for the query interface. Using the getRows() method is sometimes easier to read in DTML or Python code. Key columns: In a real database, key columns let you specify columns that can uniquely identify a record. If you try to add a row with values in the key column that are the same as the corresponding values in a row that already exists, the database will reject the new row. TinyTablePlus takes a less formal approach and only pays attention to key columns in the setRow() method. setRow() is a combination of both 'insert' and 'update' operations. It tries to find a row with the specified values in the key columns, and if found will update that row. It will ignore any other rows that happen to match. To specify which columns in the table are key columns, add an asterisk after the column name. For example: login* name email birthdate A table that uses those column names might have the following data: "joe", "Joe Brown", "jbrown@xyz.com", "10/12/66" "eliza", "Eliza Weizenbaum", "eliza@univ.edu", "1/1/70" Because the login column is a key column, the following call: setRow(login='eliza', birthdate='unknown') ...would change the table data to: "joe", "Joe Brown", "jbrown@xyz.com", "10/12/66" "eliza", "Eliza Weizenbaum", "eliza@univ.edu", "unknown" setRow() found a row that matched all specified key columns and changed that row rather than add a new row. More than one key column is possible. The following call: setRow(login='harry', name='Harry Chaste', birthdate='1/1/00', email='unknown') ...would add to the table a new row since there is no row with the value of 'harry' in the login column. The table would look like this: "joe", "Joe Brown", "jbrown@xyz.com", "10/12/66" "eliza", "Eliza Weizenbaum", "eliza@univ.edu", "unknown" "harry", "Harry Chaste", "unknown", "1/1/00" Please keep in mind that TinyTablePlus does *not* scale well. It is very useful for reference implementations of a database, but don't use it in the final version your new e-commerce product. I (Shane) have no intention of improving its scaleability because that is the need that DatabaseAPI / DatabaseConnector (a product which I wrote myself) is intended to address. Rsmisc_/TinyTablePlus/icontlabelt PropertiestactionR tAdvancedtmanage_advancedFormtViewt manage_viewtSecurityt manage_accesstAboutt manage_aboutsView management screenst manage_tabssChange permissionssChange TinyTablet manage_edittmanage_editDatatmanage_advancedtdelRowst delAllRowstsetRowsQuery TinyTable DataRt index_htmltgetRowscCsT||_d|_|i||ƒg|_tƒ|_d|_ |_ d|_ dS(NiR( RRt_datavert _SetStateRRt_rowstPersistentMappingt_indext class_name_t class_file_R t_v_brain(RRRR((R t__init__€s    tEditcCs?|i||ƒt|i|iƒ|_|iƒ|i|ƒS(sqChange item properties Note that we return people to our own interface, not to the folder we were in before. N( RR?RRtmapt_FixRowR@t_GenerateIndextmanage_editedDialogR(RRRR((R R6”s  cCsA||_|idjo|id=n|i|ƒd|_dS(Nit delim_char_(RRR>t__dict__t_DigestColumnsR(RRR((R R?¤s   cCs;|||_|_t|i|idƒ|_|i|ƒS(sChange Advanced SettingsiN( t class_namet class_fileRRCRDtgetBrainRERKR(RRORPR((R R8®scCs;ti|ƒ}t|i|ƒ|_|iƒ|i |ƒS(sChange item dataN( t ImportExportt ImportDatatdatatnewRowsRHRRIR@RJRKR(RRTRRU((R R7´s  c Csìtƒ|_g|_g|_g|_ti|ƒ}g|_ xS|D]K}tƒ}ti|dƒ}|d}|ddjo!|dd!}|i i|ƒn|ii|ƒ||d s s s s s sN( RRRuRR^R@RnRHR(RRRn((R R< s +cCsXt|dƒo |i}nt|i|iƒ}|_t|i|fd|ddƒS(NREtbrainstparent( RtRREtbrainRQRDRCtResultsR`trowsR (RR}R{((R t_resultss cOsît|ƒdjoE|ii|dƒo&|i|i|i|dgƒSqêdSn“t|ƒout ||ƒ}g}xLt dt|iƒƒD]2}||i|ƒo|i|i|ƒq“q“W|i|ƒSn|i|iƒSdS(Nii(RjtargsRRBthas_keyR~R@R tkargst RowFiltertrfRRpR Rh(RRRR RRƒ((R t__call__s& cOst|ƒdjo]|ii|dƒo>|i|d}|djo|i|=|iƒdSqlqdSn“t|ƒot ||ƒ}d}d}xQ|t|iƒjo:||i|ƒo|i|=|d}q›|d}q›W|iƒ|SndSdS(s,Returns the number of rows deleted. iiN( RjRRRBR€R R@RJRR‚Rƒtcount(RRRR…R Rƒ((R R94s,       cCst|iƒ}|i2|S(sDeletes all rows. N(RjRR@R…(RR…((R R:Psc Osæd} d} t|dƒoþ|i}t|ƒdjoÞh}xl|D]d} |i | }|i | ƒo|| ||