pydal.helpers package

Submodules

pydal.helpers.classes module

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.MethodAdder(table)

Bases: object

register(method_name=None)

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)

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.UseDatabaseStoredFile

file_close(fileobj)

file_delete(filename)

file_exists(filename)

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

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 0x7fccd1d1a370>, <_sre.SRE_Pattern object at 0x7fccd1d1a370>, 'children'), (<_sre.SRE_Pattern object at 0x7fccd1d39030>, <_sre.SRE_Pattern object at 0x7fccd1d39030>, 'eet'), (<_sre.SRE_Pattern object at 0x7fccd2008ab0>, <_sre.SRE_Pattern object at 0x7fccd2008ab0>, 'eeth'), (<_sre.SRE_Pattern object at 0x7fccd2008b70>, <_sre.SRE_Pattern object at 0x7fccd1d1a440>, 'l\\1aves'), (<_sre.SRE_Pattern object at 0x7fccd1d390e0>, <_sre.SRE_Pattern object at 0x7fccd1d390e0>, 'ses'), (<_sre.SRE_Pattern object at 0x7fccd1d39190>, <_sre.SRE_Pattern object at 0x7fccd1d39190>, 'men'), (<_sre.SRE_Pattern object at 0x7fccd1d39240>, <_sre.SRE_Pattern object at 0x7fccd1d39240>, 'ives'), (<_sre.SRE_Pattern object at 0x7fccd1d392f0>, <_sre.SRE_Pattern object at 0x7fccd1d392f0>, 'eaux'), (<_sre.SRE_Pattern object at 0x7fccd1fab8f0>, <_sre.SRE_Pattern object at 0x7fccd1fab8f0>, 'lves'), (<_sre.SRE_Pattern object at 0x7fccd1d1a510>, <_sre.SRE_Pattern object at 0x7fccd1d1b9f0>, 'es'), (<_sre.SRE_Pattern object at 0x7fccd20759d0>, <_sre.SRE_Pattern object at 0x7fccd1d1ba58>, 'es'), (<_sre.SRE_Pattern object at 0x7fccd1fb68e8>, <_sre.SRE_Pattern object at 0x7fccd1f664b0>, 'ies'), (<_sre.SRE_Pattern object at 0x7fccd1d1ba58>, <_sre.SRE_Pattern object at 0x7fccd1d1ba58>, '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