CRUD() reference: Create Read Update Delete

8357 views
1 comments
loading...

CRUD incorporates the creation of the form, the processing of the form, the notification, and the redirection

CRUD creates an SQLFORM, but it simplifies the coding because it incorporates the creation of the form, the processing of the form, the notification, and the redirection, all in one single function.

CRUD is not exposed and it must be imported, also it also must be linked to a specific database.

from gluon.tools import Crud
crud = Crud(db)

def data(): return dict(form=crud())



# Expose the following URLs:



http://.../[app]/[controller]/data/tables

http://.../[app]/[controller]/data/create/[tablename]

http://.../[app]/[controller]/data/read/[tablename]/[id]

http://.../[app]/[controller]/data/update/[tablename]/[id]

http://.../[app]/[controller]/data/delete/[tablename]/[id]

http://.../[app]/[controller]/data/select/[tablename]

http://.../[app]/[controller]/data/search/[tablename]

Attributes / Arguments

auth crud.settings.auth = auth

Enforce authentication on all crud forms

crud.settings.auth = auth

controller crud.settings.controller = 'default'

Specify the controller that defines the data function which returns the crud object

crud.settings.controller = 'default'

create_next crud.settings.create_next = URL('index')

Specify the URL to redirect to after a successful "create" record.

crud.settings.create_next = URL('index')

update_next crud.settings.update_next = URL('index')

Specify the URL to redirect to after a successful "update" record:

crud.settings.update_next = URL('index')

delete_next crud.settings.delete_next = URL('index')

Specify the URL to redirect to after a successful "delete" record.

crud.settings.delete_next = URL('index')

download_url crud.settings.download_url = URL('download')

To specify the URL to be used for linking uploaded files.

crud.settings.download_url = URL('download')

create_onvalidation crud.settings.create_onvalidation = StorageList()

To specify extra functions to be executed after standard validation procedures for crud.create forms

crud.settings.create_onvalidation = StorageList() #StorageList is the same as a Storage object, they are both defined in the file "gluon/storage.py", but it defaults to [] as opposed to None. It allows the following syntax:

crud.settings.create_onvalidation.mytablename.append(lambda form:....)

update_onvalidation crud.settings.update_onvalidation = StorageList()

To specify extra functions to be executed after standard validation procedures for crud.update forms.

crud.settings.update_onvalidation = StorageList()

create_onaccept crud.settings.create_onaccept = StorageList()

To specify extra functions to be executed after completion of crud.create forms: .

crud.settings.create_onaccept = StorageList()

update_onaccept crud.settings.update_onaccept = StorageList()

To specify extra functions to be executed after completion of crud.update forms.

crud.settings.update_onaccept = StorageList()

update_ondelete crud.settings.update_ondelete = StorageList()

To specify extra functions to be executed after completion of crud.update i. record is deleted:

crud.settings.update_ondelete = StorageList()

delete_onaccept crud.settings.delete_onaccept = StorageList()

To specify extra functions to be executed after completion of crud.delete:

crud.settings.delete_onaccept = StorageList()

update_deletable crud.settings.update_deletable = True

To determine whether the "update" forms should have a "delete" button.

crud.settings.update_deletable = True

showid crud.settings.showid = False

To determine whether the "update" forms should show the id of the edited record.

crud.settings.showid = False

keepvalues crud.settings.keepvalues = False

To determine whether forms should keep the previously inserted values or reset to default after successful submission.

crud.settings.keepvalues = False

detect_record_change crud.settings.detect_record_change = True

Crud always detects whether a record being edited has been modified by a third party in the time between the time when the form is displayed and the time when it is submitted. This behavior is equivalent to form.process(detect_record_change=True)

crud.settings.detect_record_change = True

formstyle crud.settings.formstyle = 'table3cols' or 'table2cols' or 'divs' or 'ul'

Change form style: 'table3cols' or 'table2cols' or 'divs' or 'ul'

crud.settings.formstyle = 'table3cols' or 'table2cols' or 'divs' or 'ul'

label_separator crud.settings.label_separator = ':'

You can set the separator in all crud forms.

crud.settings.label_separator = ':'

captcha crud.settings.captcha = None

crud.settings.captcha = None

create_captcha crud.settings.create_captcha = None

crud.settings.create_captcha = None

update_captcha crud.settings.update_captcha = None

crud.settings.update_captcha = None

Related References

crud.create() CRUD Method

Create record

3178

crud.delete() CRUD Method

Deletes the record

3052

crud.read() CRUD Method

Read-only form

2890

crud.search() CRUD Method

Search records

3268

crud.select CRUD Method

Returns a list of records

3463

crud.tables() CRUD Methods

2552

crud.update() CRUD Method

Update record

3082

Examples

Contact form with reCaptcha and gmail SMTP service

Add contact form to your app

App
18630

Enable record delete option using SQLFORM()

Snippet
7751

Append the same fields to all the tables

Common fields shared by different tables

Snippet
6198

LDAP auth configuration using login_methods

How to configure LDAP auth with login_methods

Snippet
7445

Sources / Reference

" web2py Book Chapter 7: Forms and Validatators" is licensed under Creative Common License BY-NC-ND 3.0

Comments

Access Control
- auth
  - enable_record_version
  - settings
- Authentication
  - Actions
Apps
- Charts
  - Highcharts
- CMS
  - TinyWebsite
- Images
  - Gallery
custom attributes
Database Abstraction Layer
Forms
- CRUD()
- Custom forms
  - begin
  - comment
  - deletable
  - dspval
  - end
  - inpval
  - label
  - linkto
  - submit
  - widget
- FORM()
- SQLFORM()
- SQLFORM.factory
Grids
- grid
- smartgrid
Hosting
- Pythonanywhere
  - SSL Setup
Modules
- images module
Payment Systems
Plugins
Services
URL
Validators
- CLEANUP
- CRYPT
- IS_ALPHANUMERIC
- IS_DATE
- IS_DATETIME
- IS_DATETIME_IN_RANGE
- IS_DATE_IN_RANGE
- IS_DECIMAL_IN_RANGE
- IS_EMAIL
- IS_EMPTY_OR
- IS_EQUAL_TO
- IS_EXPR
- IS_FLOAT_IN_RANGE
- IS_IMAGE
- IS_INT_IN_RANGE
- IS_IN_DB
- IS_IN_SET
- IS_IPV4
- IS_LENGTH
- IS_LIST_OF
- IS_LOWER
- IS_MATCH
- IS_NOT_EMPTY
- IS_NOT_IN_DB
- IS_NULL_OR
- IS_SLUG
- IS_STRONG
- IS_TIME
- IS_UPLOAD_FILENAME
- IS_UPPER
- IS_URL
Views
- Helpers
  - A
  - B
  - BEAUTIFY
  - BODY
  - BR
  - CAT
  - CENTER
  - CODE
  - COL
  - COLGROUP
  - DIV
  - EM
  - embed64
  - FIELDSET
  - FORM
  - H1
  - HTML
  - INPUT
  - MENU
  - TAG
  - XHTML
  - XML
  - xmlescape
Widgets

CRUD() Create Read Update Delete