)]}'
{"ceilometer/storage/sqlalchemy/migrate_repo/versions/005_change_counter_volume_type.py":[{"author":{"_account_id":882,"name":"shengjie min","email":"minshengjie@chinacloud.com.cn","username":"shengjie-min"},"change_message_id":"92f30c372cdf8db26160c6b52a98169ed33536ce","unresolved":false,"context_lines":[{"line_number":27,"context_line":""},{"line_number":28,"context_line":""},{"line_number":29,"context_line":"def downgrade(migrate_engine):"},{"line_number":30,"context_line":"    meta.bind \u003d migrate_engine"},{"line_number":31,"context_line":"    meter \u003d Table(\u0027meter\u0027, meta, autoload\u003dTrue)"},{"line_number":32,"context_line":"    meter.c.counter_volume.alter(type\u003dInteger)"}],"source_content_type":"text/x-python","patch_set":3,"id":"AAAAOH%2F%2F5wo%3D","line":30,"updated":"2013-03-21 16:15:03.000000000","message":"not an expert on sqlalchemy, so it\u0027s more like a question here: if your table already has BigInteger values in the table, the downgrade might potentially fail or it will just truncate the value to Integer regardless.","commit_id":"53fc4e2e65ad5937ddcd3a5b81a81821f085b09d"},{"author":{"_account_id":6537,"name":"gordon chung","email":"gord@live.ca","username":"chungg"},"change_message_id":"76150af7953a56e0d9cd67a8ae14c2d5d9c8d5cb","unresolved":false,"context_lines":[{"line_number":27,"context_line":""},{"line_number":28,"context_line":""},{"line_number":29,"context_line":"def downgrade(migrate_engine):"},{"line_number":30,"context_line":"    meta.bind \u003d migrate_engine"},{"line_number":31,"context_line":"    meter \u003d Table(\u0027meter\u0027, meta, autoload\u003dTrue)"},{"line_number":32,"context_line":"    meter.c.counter_volume.alter(type\u003dInteger)"}],"source_content_type":"text/x-python","patch_set":3,"id":"AAAAOH%2F%2F5E4%3D","line":30,"in_reply_to":"AAAAOH%2F%2F5wo%3D","updated":"2013-03-21 21:59:02.000000000","message":"i\u0027ve seen this done by first altering BIGINT to VARCHAR to INT.\n\nFWIW, a similar action is made in glance: https://github.com/openstack/glance/blob/master/glance/db/sqlalchemy/migrate_repo/versions/005_size_big_integer.py","commit_id":"53fc4e2e65ad5937ddcd3a5b81a81821f085b09d"}]}