Enable record delete option using SQLFORM()

By setting deletable attribute to True, user will have an option to delete existing record during record update process.

Model db.py

Specify category table using define_table.


Field('is_enabled', 'boolean', default=True, label=T('Enabled')),
Field('name', 'string', length=256, label=T('Name')),
Field('description', 'text', readable=True, writable=True, label=T('Description')),

Controller default.py

Using request.args update specific record using SQLFORM(). By specifying deletable to True a form option will be given to a user.

def edit_category():

if not len(request.args):
response.flash = 'Something happended that shouln\'t happened, lets start from the start'
record_id = request.args(0)
form = SQLFORM(db.category,record_, showid = False,deletable=True, fields = ['is_enabled','name'])
return dict(form=form)

View default/edit_category.html

Show update form by entering {{=form}}

{{extend 'layout.html'}}







Tag Cloud

accepted Acces Control access rights actions_disabled admin album allowed_attributes allowed_schemes App apps args auth authentication B bar chart BEAUTIFY begin BODY BR carousel CAT CENTER chart check CLEANUP client request client_side CMS CODE COL COLGROUP comment compute contact form crud.create crud.delete crud.read crud.select crud.tables CRUD custom attributes custom form DAL data define_table deletable depriciated DIV doctype dot dspval EM embed64 enable_record_version end error_message example extension Field types Field FIELDSET file filename form.accepted form.accepts form.process form.validate FORM format Forms gallery Grid H1 H2 H3 H4 H5 H6 hash_vars Hello helper helpers highchart hmac_key host hosting HTML image images inpval ip address ip IS_DATETIME IS_DATETIME_IN_RANGE IS_DECIMAL_IN_RANGE 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_LIST_OF IS_NOT_EMPTY IS_NOT_IN_DB IS_NULL_OR is_slug IS_STRONG IS_TIME IS_UPLOAD_FILENAME IS_UPPER IS_URL lable lambda lang lastdot linkto li_class li_first li_last login_methods maximum maxip maxlen MENU min minimum minip mobile mode module multiple permitted_tags pie chart placeholder plugin prepend_scheme pythonanywhere query rating reCaptcha redirect request.now routes.py salt sanitize scheme services settings slug sortable special SQLFORM() SQLFORM.grid SQLFORM SSL submit table constructor TAG test text TinyWebsite ul_class update upper URL rewrite URL validator value vars Views widget XML xmlescape _class _common_fields

Powered by

Hosted on
(affiliated link)