1.5.9.3 The Row Object

You don't need to create Row objects directly. Instead they should be created by using the appropriate methods of the Table class.

Row objects support the standard comparison operators <,<=,>,>=,==,<> as well as the len() function.

class Row( )

form( [action=''][, method='post'][, stickyData={}][, enctype='multipart/form-data'][, submit='Submit'][, modeDict={'mode':'mode', 'table':'table', 'submode':'submode'}][, submode='add']): Return a web.form Form object populated with the information from the Row

relate( row): Relate this Row to another Row object specified by row. Both Rows must be from tables related with addRelated() columns and must not alread be related.

unrelate( row): Unrelate this Row from another Row object specified by row. Both Rows must be from tables related with addRelated() columns and must already be related.

isRelated( row): Returns True if the Rows are already related, otherwise returns False.

update( [all=None],[**params]): Set multiple values of this row in one go. This currently not optimised so it makes an SQL call for each column set. Set either all as a dictionary of column:values pairs or set **params by using column=value pairs.

keys( ): Return a tuple containing the column names of the fields.

values( ): Return a tuple containing values of each field for the current row.

items( ): Return a tuple containing 2-tuples of (key, value) pairs where the key is the column name and the value is the value of each field for the current row.

has_key( column): Returns True if the row has a column named column, False otherwise

dict( ): Return the row as a dictionary of column name : value pairs, except for single, multiple and related joins columns, since this could result in circular references.

rowid: The rowid of the row

Each column from the Row can be accessed through a dictionary-like interface. For example to print the value of the column named 'firstName' from the Row with rowid 1 from the 'Person' table in the database database you would use:

>>> print database['Person'][1]['firstName']
John