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

Function rename_column

sqlite_web/sqlite_web.py:654–686  ·  view source on GitHub ↗
(table)

Source from the content-addressed store, hash-verified

652@app.route('/<table>/rename-column/', methods=['GET', 'POST'])
653@require_table
654def rename_column(table):
655 dataset = get_dataset()
656 request_data = get_request_data()
657 rename = request_data.get('rename', '')
658 rename_to = request_data.get('rename_to', '')
659
660 columns = dataset.get_columns(table)
661 column_names = [column.name for column in columns]
662
663 if request.method == 'POST':
664 rename_to = re.sub(r'[^\w]+', '_', rename_to.strip())
665 if (rename in column_names) and (rename_to not in column_names):
666 try:
667 migrate(dataset._migrator.rename_column(table, rename, rename_to))
668 except Exception as exc:
669 flash('Error attempting to rename column "%s": %s' % (name, exc),
670 'danger')
671 app.logger.exception('Error attempting to rename column.')
672 else:
673 flash('Column "%s" was renamed successfully!' % rename, 'success')
674 dataset.update_cache(table)
675 return redirect(url_for('table_structure', table=table))
676 else:
677 flash('Column name is required and cannot conflict with an '
678 'existing column\'s name.', 'danger&#x27;)
679
680 return render_template(
681 'rename_column.html',
682 columns=columns,
683 column_names=column_names,
684 rename=rename,
685 rename_to=rename_to,
686 table=table)
687
688@app.route('/<table>/add-index/', methods=['GET', 'POST'])
689@require_table

Callers

nothing calls this directly

Calls 3

get_datasetFunction · 0.85
get_request_dataFunction · 0.85
get_columnsMethod · 0.80

Tested by

no test coverage detected