gluon :: sql :: SQLTable :: Class SQLTable
[hide private]
[frames] | no frames]

Class SQLTable

source code

object --+        
         |        
      dict --+    
             |    
    SQLStorage --+
                 |
                SQLTable

an instance of this class represents a database table Example:

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

Instance Methods [hide private]
new empty dictionary

__init__(self, db, tablename, *fields)
x.__init__(...) initializes x; see x.__class__.__doc__ for signature
source code
 
__str__(self)
str(x)
source code
 
_create(self, migrate=True) source code
 
_migrate(self, sql_fields, sql_fields_old, logfile) source code
 
create(self) source code
 
_drop(self) source code
 
drop(self) source code
 
_insert(self, **fields) source code
 
insert(self, **fields) source code
 
import_from_csv_file(self, file)
import records from csv file.
source code

Inherited from SQLStorage: __getattr__, __repr__, __setattr__

Inherited from dict: __cmp__, __contains__, __delitem__, __eq__, __ge__, __getattribute__, __getitem__, __gt__, __hash__, __iter__, __le__, __len__, __lt__, __ne__, __new__, __setitem__, clear, copy, fromkeys, get, has_key, items, iteritems, iterkeys, itervalues, keys, pop, popitem, setdefault, update, values

Inherited from object: __delattr__, __reduce__, __reduce_ex__

Properties [hide private]

Inherited from object: __class__

Method Details [hide private]

__init__(self, db, tablename, *fields)
(Constructor)

source code 

x.__init__(...) initializes x; see x.__class__.__doc__ for signature

Returns:
new empty dictionary

Overrides: dict.__init__
(inherited documentation)

__str__(self)
(Informal representation operator)

source code 

str(x)

Overrides: object.__str__
(inherited documentation)

import_from_csv_file(self, file)

source code 

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.