pydal.helpers package

Submodules

pydal.helpers.classes module

class pydal.helpers.classes.BasicStorage(*args, **kwargs)

Bases: object

clear(*args, **kwargs)

copy(*args, **kwargs)

get(key, default=None)

has_key(key)

items()

iteritems()

iterkeys()

itervalues()

keys()

pop(*args, **kwargs)

update(*args, **kwargs)

values()

class pydal.helpers.classes.DatabaseStoredFile(db, filename, mode)

close()

close_connection()

escape(obj)

static exists(db, filename)

read(bytes)

readline()

static try_create_web2py_filesystem(db)

web2py_filesystems = set([])

write(data)

class pydal.helpers.classes.FakeCursor

Bases: object

The Python Database API Specification has a cursor() method, which NoSql drivers generally don’t support. If the exception in this function is taken then it likely means that some piece of functionality has not yet been implemented in the driver. And something is using the cursor.

https://www.python.org/dev/peps/pep-0249/

warn_bad_usage(attr)

class pydal.helpers.classes.FakeDriver(*args, **kwargs)

Bases: pydal.helpers.classes.BasicStorage

close()

commit()

cursor()

class pydal.helpers.classes.MethodAdder(table)

Bases: object

register(method_name=None)

class pydal.helpers.classes.NullCursor

Bases: pydal.helpers.classes.FakeCursor

lastrowid = 1

class pydal.helpers.classes.NullDriver(*args, **kwargs)

Bases: pydal.helpers.classes.FakeDriver

class pydal.helpers.classes.RecordDeleter(table, id)

Bases: object

class pydal.helpers.classes.RecordUpdater(colset, table, id)

Bases: object

class pydal.helpers.classes.Reference

Bases: long

get(key, default=None)

pydal.helpers.classes.Reference_pickler(data)

pydal.helpers.classes.Reference_unpickler(data)

class pydal.helpers.classes.SQLALL(table)

Bases: object

Helper class providing a comma-separated string having all the field names (prefixed by table name and ‘.’)

normally only called from within gluon.dal

class pydal.helpers.classes.SQLCallableList

Bases: list

class pydal.helpers.classes.SQLCustomType(type='string', native=None, encoder=None, decoder=None, validator=None, _class=None, widget=None, represent=None)

Bases: object

Allows defining of custom SQL types

Parameters:

• type – the web2py type (default = ‘string’)
• native – the backend type
• encoder – how to encode the value to store it in the backend
• decoder – how to decode the value retrieved from the backend
• validator – what validators to use ( default = None, will use the default validator for type)

Example::

Define as:

decimal = SQLCustomType(

type =’double’, native =’integer’, encoder =(lambda x: int(float(x) * 100)), decoder = (lambda x: Decimal(“0.00”) + Decimal(str(float(x)/100)) ) )

db.define_table(

‘example’, Field(‘value’, type=decimal) )

endswith(text=None)

startswith(text=None)

class pydal.helpers.classes.Serializable

Bases: object

as_dict(flat=False, sanitize=True)

as_json(sanitize=True)

as_xml(sanitize=True)

as_yaml(sanitize=True)

class pydal.helpers.classes.UseDatabaseStoredFile

file_close(fileobj)

file_delete(filename)

file_exists(filename)

file_open(filename, mode='rb', lock=True)

pydal.helpers.classes.pickle_basicstorage(s)

pydal.helpers.methods module

pydal.helpers.methods.archive_record(qset, fs, archive_table, current_record)

pydal.helpers.methods.auto_represent(field)

pydal.helpers.methods.auto_validators(field)

pydal.helpers.methods.bar_decode_integer(value)

pydal.helpers.methods.bar_decode_string(value)

pydal.helpers.methods.bar_encode(items)

pydal.helpers.methods.bar_escape(item)

pydal.helpers.methods.cleanup(text)

Validates that the given text is clean: only contains [0-9a-zA-Z_]

pydal.helpers.methods.geoLine(*line)

pydal.helpers.methods.geoPoint(x, y)

pydal.helpers.methods.geoPolygon(*line)

pydal.helpers.methods.hide_password(uri)

pydal.helpers.methods.int2uuid(n)

pydal.helpers.methods.list_represent(values, row=None)

pydal.helpers.methods.pluralize(singular, rules=[(<_sre.SRE_Pattern object at 0x7fda3c4dcac0>, <_sre.SRE_Pattern object at 0x7fda3c4dcac0>, 'children'), (<_sre.SRE_Pattern object at 0x7fda3c496b30>, <_sre.SRE_Pattern object at 0x7fda3c496b30>, 'eet'), (<_sre.SRE_Pattern object at 0x7fda3c54eb70>, <_sre.SRE_Pattern object at 0x7fda3c54eb70>, 'eeth'), (<_sre.SRE_Pattern object at 0x7fda3c54ec30>, <_sre.SRE_Pattern object at 0x7fda3c4dcb90>, 'l\\1aves'), (<_sre.SRE_Pattern object at 0x7fda3c496be0>, <_sre.SRE_Pattern object at 0x7fda3c496be0>, 'ses'), (<_sre.SRE_Pattern object at 0x7fda3c496c90>, <_sre.SRE_Pattern object at 0x7fda3c496c90>, 'men'), (<_sre.SRE_Pattern object at 0x7fda3c496d40>, <_sre.SRE_Pattern object at 0x7fda3c496d40>, 'ives'), (<_sre.SRE_Pattern object at 0x7fda3c496df0>, <_sre.SRE_Pattern object at 0x7fda3c496df0>, 'eaux'), (<_sre.SRE_Pattern object at 0x7fda3c4a8df0>, <_sre.SRE_Pattern object at 0x7fda3c4a8df0>, 'lves'), (<_sre.SRE_Pattern object at 0x7fda3c4dcc60>, <_sre.SRE_Pattern object at 0x7fda3997e920>, 'es'), (<_sre.SRE_Pattern object at 0x7fda3c4ed8f0>, <_sre.SRE_Pattern object at 0x7fda3997e920>, 'es'), (<_sre.SRE_Pattern object at 0x7fda3c4958e8>, <_sre.SRE_Pattern object at 0x7fda39160c00>, 'ies'), (<_sre.SRE_Pattern object at 0x7fda3997e920>, <_sre.SRE_Pattern object at 0x7fda3997e920>, 's')])

pydal.helpers.methods.smart_query(fields, text)

pydal.helpers.methods.use_common_filters(query)

pydal.helpers.methods.uuid2int(uuidv)

pydal.helpers.methods.varquote_aux(name, quotestr='%s')

pydal.helpers.methods.xorify(orderby)

pydal.helpers.regex module

Module contents