Docs for SQLFORM

[ Python Tutorial ] [ Python Libraries ] [ web2py epydoc ]

Description


<type 'type'> extends (<class 'gluon.html.FORM'>,) 


1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.

    SQLFORM is used to map a table (and a current record) into an HTML form
   
    given a SQLTable stored in db.table

    SQLFORM(db.table) generates an insert form
    record=db(db.table.id==some_id).select()[0]
    SQLFORM(db.table,record) generates an update form
    SQLFORM(db.table,record,deletable=True) generates an update 
                                            with a delete button
    
    optional arguments:
    
    fields: a list of fields that should be placed in the form, default is all.
    labels: a dictionary with labels for each field. keys are field names.
    col3  : a dictionary with content for an optional third column (right of each field). keys are field names.
    linkto: the URL of a controller/function to access referencedby records
            see controller appadmin.py for examples
    upload: the URL of a controller/function to download an uploaded file
            see controller appadmin.py for examples
    any named optional attribute is passed to the <form> tag
            for example _class, _id, _style, _action,_method, etc.


Attributes

SQLFORM.__class__ <type 'type'> extends (<type 'object'>,) belongs to class <type 'type'>
type(object) -> the object's type type(name, bases, dict) -> a new type
SQLFORM.__delattr__ <type 'wrapper_descriptor'> belongs to class <type 'wrapper_descriptor'>
x.__delattr__('name') <==> del x.name
SQLFORM.__delitem__ <type 'instancemethod'> belongs to class <type 'instancemethod'>
SQLFORM.__dict__ <type 'dictproxy'> belongs to class <type 'dictproxy'>
SQLFORM.__doc__ <type 'str'> belongs to class <type 'str'>
str(object) -> string Return a nice string representation of the object. If the argument is a string, the return value is the same object.
SQLFORM.__getattribute__ <type 'wrapper_descriptor'> belongs to class <type 'wrapper_descriptor'>
x.__getattribute__('name') <==> x.name
SQLFORM.__getitem__ <type 'instancemethod'> belongs to class <type 'instancemethod'>
SQLFORM.__hash__ <type 'wrapper_descriptor'> belongs to class <type 'wrapper_descriptor'>
x.__hash__() <==> hash(x)
SQLFORM.__init__ <type 'instancemethod'> belongs to class <type 'instancemethod'>
SQLFORM(db.table, record=None, fields=['name'], labels={'name':'Your name'}, linkto=ULR(r=request,f='table/db/')
SQLFORM.__len__ <type 'instancemethod'> belongs to class <type 'instancemethod'>
SQLFORM.__module__ <type 'str'> belongs to class <type 'str'>
str(object) -> string Return a nice string representation of the object. If the argument is a string, the return value is the same object.
SQLFORM.__new__ <type 'builtin_function_or_method'> belongs to class <type 'builtin_function_or_method'>
T.__new__(S, ...) -> a new object with type S, a subtype of T
SQLFORM.__reduce__ <type 'method_descriptor'> belongs to class <type 'method_descriptor'>
helper for pickle
SQLFORM.__reduce_ex__ <type 'method_descriptor'> belongs to class <type 'method_descriptor'>
helper for pickle
SQLFORM.__repr__ <type 'wrapper_descriptor'> belongs to class <type 'wrapper_descriptor'>
x.__repr__() <==> repr(x)
SQLFORM.__setattr__ <type 'wrapper_descriptor'> belongs to class <type 'wrapper_descriptor'>
x.__setattr__('name', value) <==> x.name = value
SQLFORM.__setitem__ <type 'instancemethod'> belongs to class <type 'instancemethod'>
SQLFORM.__str__ <type 'instancemethod'> belongs to class <type 'instancemethod'>
SQLFORM.__weakref__ <type 'getset_descriptor'> belongs to class <type 'getset_descriptor'>
list of weak references to the object (if defined)
SQLFORM._fixut <type 'instancemethod'> belongs to class <type 'instancemethod'>
SQLFORM._postprocessing <type 'instancemethod'> belongs to class <type 'instancemethod'>
SQLFORM._traverse <type 'instancemethod'> belongs to class <type 'instancemethod'>
SQLFORM._validate <type 'instancemethod'> belongs to class <type 'instancemethod'>
SQLFORM._xml <type 'instancemethod'> belongs to class <type 'instancemethod'>
SQLFORM.accepts <type 'instancemethod'> belongs to class <type 'instancemethod'>
same as FORM.accepts but also does insert, update or delete in SQLDB
SQLFORM.append <type 'instancemethod'> belongs to class <type 'instancemethod'>
SQLFORM.hidden_fields <type 'instancemethod'> belongs to class <type 'instancemethod'>
SQLFORM.insert <type 'instancemethod'> belongs to class <type 'instancemethod'>
SQLFORM.tag <type 'str'> belongs to class <type 'str'>
str(object) -> string Return a nice string representation of the object. If the argument is a string, the return value is the same object.
SQLFORM.xml <type 'instancemethod'> belongs to class <type 'instancemethod'>