MCPcopy
hub / github.com/coleifer/sqlite-web / drop_index

Function drop_index

sqlite_web/sqlite_web.py:724–749  ·  view source on GitHub ↗
(table)

Source from the content-addressed store, hash-verified

722@app.route('/<table>/drop-index/', methods=['GET', 'POST'])
723@require_table
724def drop_index(table):
725 dataset = get_dataset()
726 request_data = get_request_data()
727 name = request_data.get('name', '')
728 indexes = dataset.get_indexes(table)
729 index_names = [index.name for index in indexes]
730
731 if request.method == 'POST':
732 if name in index_names:
733 try:
734 migrate(dataset._migrator.drop_index(table, name))
735 except Exception as exc:
736 flash('Error attempting to drop index: %s' % exc, 'danger')
737 app.logger.exception('Error attempting to drop index.')
738 else:
739 flash('Index "%s" was dropped successfully!' % name, 'success')
740 return redirect(url_for('table_structure', table=table))
741 else:
742 flash('Index name is required.', 'danger')
743
744 return render_template(
745 'drop_index.html',
746 indexes=indexes,
747 index_names=index_names,
748 name=name,
749 table=table)
750
751@app.route('/<table>/drop-trigger/', methods=['GET', 'POST'])
752@require_table

Callers

nothing calls this directly

Calls 3

get_datasetFunction · 0.85
get_request_dataFunction · 0.85
get_indexesMethod · 0.80

Tested by

no test coverage detected