)]}'
{"octavia/db/migration/alembic_migrations/versions/8583b13a1dad_properly_increase_length_of_fields.py":[{"author":{"_account_id":7249,"name":"Ann Taraday","email":"akamyshnikova@mirantis.com","username":"AKamyshnikova"},"change_message_id":"fdde4ac20a9ca52107bf6b4eb8d3fd7694587f7c","unresolved":false,"context_lines":[{"line_number":40,"context_line":"                    type_\u003dsa.String(255), nullable\u003dTrue)"},{"line_number":41,"context_line":""},{"line_number":42,"context_line":"    # in revision 13500e2e978d, wrong on MySQL and PostgreSQL"},{"line_number":43,"context_line":"    op.drop_constraint(u\u0027fk_amphora_provisioning_status_name\u0027,"},{"line_number":44,"context_line":"                       u\u0027amphora\u0027,"},{"line_number":45,"context_line":"                       type_\u003du\u0027foreignkey\u0027)"},{"line_number":46,"context_line":"    op.drop_constraint(u\u0027fk_health_monitor_provisioning_status_name\u0027,"},{"line_number":47,"context_line":"                       u\u0027health_monitor\u0027,"},{"line_number":48,"context_line":"                       type_\u003du\u0027foreignkey\u0027)"},{"line_number":49,"context_line":"    op.drop_constraint(\u0027fk_l7policy_provisioning_status_name\u0027,"},{"line_number":50,"context_line":"                       \u0027l7policy\u0027,"},{"line_number":51,"context_line":"                       type_\u003d\u0027foreignkey\u0027)"},{"line_number":52,"context_line":"    op.drop_constraint(\u0027fk_l7rule_provisioning_status_name\u0027,"},{"line_number":53,"context_line":"                       \u0027l7rule\u0027,"},{"line_number":54,"context_line":"                       type_\u003d\u0027foreignkey\u0027)"},{"line_number":55,"context_line":"    op.drop_constraint(\u0027fk_listener_provisioning_status_name\u0027,"},{"line_number":56,"context_line":"                       \u0027listener\u0027,"},{"line_number":57,"context_line":"                       type_\u003d\u0027foreignkey\u0027)"},{"line_number":58,"context_line":"    op.drop_constraint(\u0027fk_load_balancer_provisioning_status_name\u0027,"},{"line_number":59,"context_line":"                       \u0027load_balancer\u0027,"},{"line_number":60,"context_line":"                       type_\u003d\u0027foreignkey\u0027)"},{"line_number":61,"context_line":"    op.drop_constraint(\u0027fk_member_provisioning_status_name\u0027,"},{"line_number":62,"context_line":"                       \u0027member\u0027,"},{"line_number":63,"context_line":"                       type_\u003d\u0027foreignkey\u0027)"},{"line_number":64,"context_line":"    op.drop_constraint(\u0027fk_pool_provisioning_status_name\u0027,"},{"line_number":65,"context_line":"                       \u0027pool\u0027,"},{"line_number":66,"context_line":"                       type_\u003d\u0027foreignkey\u0027)"},{"line_number":67,"context_line":""},{"line_number":68,"context_line":"    op.alter_column(u\u0027provisioning_status\u0027, u\u0027name\u0027,"},{"line_number":69,"context_line":"                    type_\u003dsa.String(255), nullable\u003dFalse)"}],"source_content_type":"text/x-python","patch_set":4,"id":"5fc1f717_eace9080","line":66,"range":{"start_line":43,"start_character":4,"end_line":66,"end_character":42},"updated":"2019-03-13 08:46:20.000000000","message":"How about something like:\n\n   table_names \u003d [\u0027load_balancer\u0027, \u0027health_monitor\u0027, \u0027l7policy\u0027, ..]\n   for t_name in table_names:    \n      op.drop_constraint(u\u0027fk_%s_provisioning_status_name\u0027 % t_name, t_name, type_\u003du\u0027foreignkey\u0027)\n      op.alter_column(t_name, u\u0027provisioning_status\u0027,\n                    type_\u003dsa.String(255), nullable\u003dFalse)\n      op.create_foreign_key(\n        u\u0027fk_%s_provisioning_status_name\u0027 % t_name, t_name,\n        u\u0027provisioning_status\u0027, [u\u0027provisioning_status\u0027], [u\u0027name\u0027]\n    )\n\nAt least for those tables that have the same column name \u0027provisioning_status\u0027, \u0027operating_status\u0027","commit_id":"4b0443d2f0b22edcb73097796a5b9187ee588cbf"}]}