)]}'
{"nova/db/sqlalchemy/migrate_repo/versions/379_add_live_resize_migration_type.py":[{"author":{"_account_id":7,"name":"Jay Pipes","email":"jaypipes@gmail.com","username":"jaypipes"},"change_message_id":"a25c272b9198c6b2302132847d6ffaa454d6488a","unresolved":false,"context_lines":[{"line_number":22,"context_line":"    migrations \u003d Table(\u0027migrations\u0027, meta, autoload\u003dTrue)"},{"line_number":23,"context_line":"    shadow_migrations \u003d Table(\u0027shadow_migrations\u0027, meta, autoload\u003dTrue)"},{"line_number":24,"context_line":""},{"line_number":25,"context_line":"    old_enum \u003d Enum(\u0027migration\u0027, \u0027resize\u0027, \u0027live-migration\u0027, \u0027evacuation\u0027,"},{"line_number":26,"context_line":"                    metadata\u003dmeta, name\u003d\u0027migration_type\u0027)"},{"line_number":27,"context_line":"    new_enum \u003d Enum(\u0027migration\u0027, \u0027resize\u0027, \u0027live-migration\u0027, \u0027live-resize\u0027,"},{"line_number":28,"context_line":"                    \u0027evacuation\u0027, metadata\u003dmeta, name\u003d\u0027migration_type\u0027)"},{"line_number":29,"context_line":""},{"line_number":30,"context_line":"    migrations_col \u003d migrations.c[\u0027migration_type\u0027]"},{"line_number":31,"context_line":"    migrations_col.alter(existing_type\u003dold_enum,"},{"line_number":32,"context_line":"                         type\u003dnew_enum).update()"},{"line_number":33,"context_line":""},{"line_number":34,"context_line":"    shadow_migrations_col \u003d shadow_migrations.c[\u0027migration_type\u0027]"},{"line_number":35,"context_line":"    shadow_migrations_col.alter(existing_type\u003dold_enum,"},{"line_number":36,"context_line":"                                type\u003dnew_enum).update()"},{"line_number":37,"context_line":""},{"line_number":38,"context_line":"    old_enum.drop(checkfirst\u003dFalse)"},{"line_number":39,"context_line":"    new_enum.create()"}],"source_content_type":"text/x-python","patch_set":4,"id":"df7087c5_329dab65","line":39,"range":{"start_line":25,"start_character":0,"end_line":39,"end_character":21},"updated":"2018-03-15 17:28:00.000000000","message":"This will work for MySQL and SQLite, but for PostgreSQL, I think you will need to execute SQL directly:\n\n ALTER TYPE $type_name ADD VALUE \u0027live-resize\u0027 AFTER \u0027live-migration\u0027;","commit_id":"e1c807c19ee9b3f372e41b541f0be42f3e87a674"}]}