Docs for DAL.Table

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

Description

<type 'type'> extends (<type 'dict'>,)


    an instance of this class represents a database table

    Example::

        db = DAL(...)
        db.define_table('users', Field('name'))
        db.users.insert(name='me') # print db.users._insert(...) to see SQL
        db.users.drop()

Attributes


DAL.Table.__call__	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table.__class__	<type 'type'> extends (<type 'object'>,) belongs to class <type 'type'> type(object) -> the object's type type(name, bases, dict) -> a new type

DAL.Table.__cmp__	<type 'wrapper_descriptor'> belongs to class <type 'wrapper_descriptor'> x.__cmp__(y) <==> cmp(x,y)

DAL.Table.__contains__	<type 'method_descriptor'> belongs to class <type 'method_descriptor'> D.__contains__(k) -> True if D has a key k, else False

DAL.Table.__delattr__	<type 'wrapper_descriptor'> belongs to class <type 'wrapper_descriptor'> x.__delattr__('name') <==> del x.name

DAL.Table.__delitem__	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table.__dict__	<type 'dictproxy'> belongs to class <type 'dictproxy'>

DAL.Table.__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.

DAL.Table.__eq__	<type 'wrapper_descriptor'> belongs to class <type 'wrapper_descriptor'> x.__eq__(y) <==> x==y

DAL.Table.__ge__	<type 'wrapper_descriptor'> belongs to class <type 'wrapper_descriptor'> x.__ge__(y) <==> x>=y

DAL.Table.__getattr__	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table.__getattribute__	<type 'wrapper_descriptor'> belongs to class <type 'wrapper_descriptor'> x.__getattribute__('name') <==> x.name

DAL.Table.__getitem__	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table.__gt__	<type 'wrapper_descriptor'> belongs to class <type 'wrapper_descriptor'> x.__gt__(y) <==> x>y

DAL.Table.__hash__	<type 'wrapper_descriptor'> belongs to class <type 'wrapper_descriptor'> x.__hash__() <==> hash(x)

DAL.Table.__init__	<type 'instancemethod'> belongs to class <type 'instancemethod'> Initializes the table and performs checking on the provided fields. Each table will have automatically an 'id'. If a field is of type Table, the fields (excluding 'id') from that table will be used instead. :raises SyntaxError: when a supplied field is of incorrect type.

DAL.Table.__iter__	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table.__le__	<type 'wrapper_descriptor'> belongs to class <type 'wrapper_descriptor'> x.__le__(y) <==> x<=y

DAL.Table.__len__	<type 'wrapper_descriptor'> belongs to class <type 'wrapper_descriptor'> x.__len__() <==> len(x)

DAL.Table.__lt__	<type 'wrapper_descriptor'> belongs to class <type 'wrapper_descriptor'> x.__lt__(y) <==> x<y

DAL.Table.__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.

DAL.Table.__ne__	<type 'wrapper_descriptor'> belongs to class <type 'wrapper_descriptor'> x.__ne__(y) <==> x!=y

DAL.Table.__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

DAL.Table.__reduce__	<type 'method_descriptor'> belongs to class <type 'method_descriptor'> helper for pickle

DAL.Table.__reduce_ex__	<type 'method_descriptor'> belongs to class <type 'method_descriptor'> helper for pickle

DAL.Table.__repr__	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table.__setattr__	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table.__setitem__	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table.__str__	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table.__weakref__	<type 'getset_descriptor'> belongs to class <type 'getset_descriptor'> list of weak references to the object (if defined)

DAL.Table._build_query	<type 'instancemethod'> belongs to class <type 'instancemethod'> for keyed table only

DAL.Table._create_references	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table._drop	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table._filter_fields	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table._insert	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table._listify	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table._truncate	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table._validate	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table.bulk_insert	<type 'instancemethod'> belongs to class <type 'instancemethod'> here items is a list of dictionaries

DAL.Table.clear	<type 'method_descriptor'> belongs to class <type 'method_descriptor'> D.clear() -> None. Remove all items from D.

DAL.Table.copy	<type 'method_descriptor'> belongs to class <type 'method_descriptor'> D.copy() -> a shallow copy of D

DAL.Table.drop	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table.fields	<type 'property'> belongs to class <type 'property'>

DAL.Table.fromkeys	<type 'builtin_function_or_method'> belongs to class <type 'builtin_function_or_method'> dict.fromkeys(S[,v]) -> New dict with keys from S and values equal to v. v defaults to None.

DAL.Table.get	<type 'method_descriptor'> belongs to class <type 'method_descriptor'> D.get(k[,d]) -> D[k] if k in D, else d. d defaults to None.

DAL.Table.has_key	<type 'method_descriptor'> belongs to class <type 'method_descriptor'> D.has_key(k) -> True if D has a key k, else False

DAL.Table.import_from_csv_file	<type 'instancemethod'> belongs to class <type 'instancemethod'> import records from csv file. Column headers must have same names as table fields. field 'id' is ignored. If column names read 'table.file' the 'table.' prefix is ignored. 'unique' argument is a field which must be unique (typically a uuid field)

DAL.Table.insert	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table.items	<type 'method_descriptor'> belongs to class <type 'method_descriptor'> D.items() -> list of D's (key, value) pairs, as 2-tuples

DAL.Table.iteritems	<type 'method_descriptor'> belongs to class <type 'method_descriptor'> D.iteritems() -> an iterator over the (key, value) items of D

DAL.Table.iterkeys	<type 'method_descriptor'> belongs to class <type 'method_descriptor'> D.iterkeys() -> an iterator over the keys of D

DAL.Table.itervalues	<type 'method_descriptor'> belongs to class <type 'method_descriptor'> D.itervalues() -> an iterator over the values of D

DAL.Table.keys	<type 'method_descriptor'> belongs to class <type 'method_descriptor'> D.keys() -> list of D's keys

DAL.Table.on	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table.pop	<type 'method_descriptor'> belongs to class <type 'method_descriptor'> D.pop(k[,d]) -> v, remove specified key and return the corresponding value If key is not found, d is returned if given, otherwise KeyError is raised

DAL.Table.popitem	<type 'method_descriptor'> belongs to class <type 'method_descriptor'> D.popitem() -> (k, v), remove and return some (key, value) pair as a 2-tuple; but raise KeyError if D is empty

DAL.Table.setdefault	<type 'method_descriptor'> belongs to class <type 'method_descriptor'> D.setdefault(k[,d]) -> D.get(k,d), also set D[k]=d if k not in D

DAL.Table.truncate	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table.update	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table.update_or_insert	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table.validate_and_insert	<type 'instancemethod'> belongs to class <type 'instancemethod'>

DAL.Table.values	<type 'method_descriptor'> belongs to class <type 'method_descriptor'> D.values() -> list of D's values

DAL.Table.with_alias	<type 'instancemethod'> belongs to class <type 'instancemethod'>

Download Latest Stable (1, 99, 7, datetime.datetime(2012, 3, 4, 22, 12, 8), 'stable')

User groups

User Voice

Twitter

Live Chat (IRC)

F.A.Q.

Quick Examples

Videos

web2py Slices

Interactive demo

Free appliances

Plugins