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 0x7f992817fc60>, <_sre.SRE_Pattern object at 0x7f992817fc60>, 'children'), (<_sre.SRE_Pattern object at 0x7f9924de9030>, <_sre.SRE_Pattern object at 0x7f9924de9030>, 'eet'), (<_sre.SRE_Pattern object at 0x7f9928146270>, <_sre.SRE_Pattern object at 0x7f9928146270>, 'eeth'), (<_sre.SRE_Pattern object at 0x7f9928146330>, <_sre.SRE_Pattern object at 0x7f992817fd30>, 'l\\1aves'), (<_sre.SRE_Pattern object at 0x7f9924de90e0>, <_sre.SRE_Pattern object at 0x7f9924de90e0>, 'ses'), (<_sre.SRE_Pattern object at 0x7f9924de9190>, <_sre.SRE_Pattern object at 0x7f9924de9190>, 'men'), (<_sre.SRE_Pattern object at 0x7f9924de9240>, <_sre.SRE_Pattern object at 0x7f9924de9240>, 'ives'), (<_sre.SRE_Pattern object at 0x7f9924de92f0>, <_sre.SRE_Pattern object at 0x7f9924de92f0>, 'eaux'), (<_sre.SRE_Pattern object at 0x7f992813af30>, <_sre.SRE_Pattern object at 0x7f992813af30>, 'lves'), (<_sre.SRE_Pattern object at 0x7f992817fe00>, <_sre.SRE_Pattern object at 0x7f9925621718>, 'es'), (<_sre.SRE_Pattern object at 0x7f99281929d0>, <_sre.SRE_Pattern object at 0x7f9925621718>, 'es'), (<_sre.SRE_Pattern object at 0x7f9928139bd0>, <_sre.SRE_Pattern object at 0x7f9924dd1030>, 'ies'), (<_sre.SRE_Pattern object at 0x7f9925621718>, <_sre.SRE_Pattern object at 0x7f9925621718>, 's')])[source]¶