pydal.helpers package¶
Submodules¶
pydal.helpers.classes module¶
- class pydal.helpers.classes.DatabaseStoredFile(db, filename, mode)[source]¶
-
- web2py_filesystems = set([])¶
- class pydal.helpers.classes.SQLALL(table)[source]¶
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.SQLCustomType(type='string', native=None, encoder=None, decoder=None, validator=None, _class=None)[source]¶
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) )
pydal.helpers.methods module¶
- pydal.helpers.methods.cleanup(text)[source]¶
Validates that the given text is clean: only contains [0-9a-zA-Z_]
- 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')])[source]¶