(table)
| 751 | @app.route('/<table>/drop-trigger/', methods=['GET', 'POST']) |
| 752 | @require_table |
| 753 | def drop_trigger(table): |
| 754 | dataset = get_dataset() |
| 755 | request_data = get_request_data() |
| 756 | name = request_data.get('name', '') |
| 757 | triggers = dataset.get_triggers(table) |
| 758 | trigger_names = [trigger.name for trigger in triggers] |
| 759 | |
| 760 | if request.method == 'POST': |
| 761 | if name in trigger_names: |
| 762 | try: |
| 763 | dataset.query('DROP TRIGGER "%s";' % name) |
| 764 | except Exception as exc: |
| 765 | flash('Error attempting to drop trigger: %s' % exc, 'danger') |
| 766 | app.logger.exception('Error attempting to drop trigger.') |
| 767 | else: |
| 768 | flash('Trigger "%s" was dropped successfully!' % name, 'success') |
| 769 | return redirect(url_for('table_structure', table=table)) |
| 770 | else: |
| 771 | flash('Trigger name is required.', 'danger') |
| 772 | |
| 773 | return render_template( |
| 774 | 'drop_trigger.html', |
| 775 | triggers=triggers, |
| 776 | trigger_names=trigger_names, |
| 777 | name=name, |
| 778 | table=table) |
| 779 | |
| 780 | |
| 781 | @app.route('/<table>/content/', methods=['GET', 'POST']) |
nothing calls this directly
no test coverage detected