)]}'
{"designate/storage/impl_sqlalchemy/migrate_repo/versions/041_add_indices.py":[{"author":{"_account_id":8174,"name":"Tim Simmons","email":"tim.r.simmons@gmail.com","username":"TimSimmons"},"change_message_id":"80b75f3c79068acd184ff1c305eb33d5e1b9f44c","unresolved":false,"context_lines":[{"line_number":30,"context_line":"        [\u0027id_tenant\u0027, zones_table.c.id, zones_table.c.tenant_id],"},{"line_number":31,"context_line":"        [\u0027id_tenant_deleted\u0027, zones_table.c.id, zones_table.c.tenant_id,"},{"line_number":32,"context_line":"         zones_table.c.deleted],"},{"line_number":33,"context_line":"        # [\u0027parent_deleted\u0027, zones_table.c.parent_domain_id, zones_table.c.deleted],"},{"line_number":34,"context_line":"        [\u0027name_deleted\u0027, zones_table.c.name, zones_table.c.deleted],"},{"line_number":35,"context_line":"        [\u0027tenant\u0027, recordsets_table.c.tenant_id],"},{"line_number":36,"context_line":"        [\u0027type_domainid\u0027, recordsets_table.c.type, recordsets_table.c.domain_id],"}],"source_content_type":"text/x-python","patch_set":1,"id":"9aa7fdbe_b4318a0d","line":33,"updated":"2014-10-20 17:12:06.000000000","message":"These can be added but not removed because they interfere with columns that are needed for foreign keys. When you add them it seems to override the foreign key index that\u0027s already there.","commit_id":"b81168338115c7653d52d16a3a555e4581ae2f67"},{"author":{"_account_id":8174,"name":"Tim Simmons","email":"tim.r.simmons@gmail.com","username":"TimSimmons"},"change_message_id":"43e90eb45a376030085ad30a3bd04d5e572af5d2","unresolved":false,"context_lines":[{"line_number":20,"context_line":""},{"line_number":21,"context_line":"def index_exists(index):"},{"line_number":22,"context_line":"    table \u003d index[1]._get_table()"},{"line_number":23,"context_line":"    cols \u003d sorted([str(x).split(\u0027.\u0027)[1] for x in index[1:]])"},{"line_number":24,"context_line":""},{"line_number":25,"context_line":"    for idx in table.indexes:"},{"line_number":26,"context_line":"        if sorted(idx.columns.keys()) \u003d\u003d cols:"}],"source_content_type":"text/x-python","patch_set":2,"id":"9aa7fdbe_00421010","line":23,"updated":"2014-10-20 19:11:22.000000000","message":"*barf*","commit_id":"9d78934e562f8a4ff127a1044aaf50d604fa7096"},{"author":{"_account_id":8174,"name":"Tim Simmons","email":"tim.r.simmons@gmail.com","username":"TimSimmons"},"change_message_id":"43e90eb45a376030085ad30a3bd04d5e572af5d2","unresolved":false,"context_lines":[{"line_number":41,"context_line":"        [\u0027zone_id_tenant\u0027, zones_table.c.id, zones_table.c.tenant_id],"},{"line_number":42,"context_line":"        [\u0027zone_id_tenant_deleted\u0027, zones_table.c.id, zones_table.c.tenant_id,"},{"line_number":43,"context_line":"         zones_table.c.deleted],"},{"line_number":44,"context_line":"        # [\u0027zone_parent_deleted\u0027, zones_table.c.parent_domain_id, zones_table.c.deleted],"},{"line_number":45,"context_line":"        [\u0027zone_name_deleted\u0027, zones_table.c.name, zones_table.c.deleted],"},{"line_number":46,"context_line":"        [\u0027recordset_tenant\u0027, recordsets_table.c.tenant_id],"},{"line_number":47,"context_line":"        [\u0027recordset_type_domainid\u0027, recordsets_table.c.type, recordsets_table.c.domain_id],"}],"source_content_type":"text/x-python","patch_set":2,"id":"9aa7fdbe_a05224db","line":44,"updated":"2014-10-20 19:11:22.000000000","message":"These can be created, but not deleted because they interfere with the columns involved in foreign key constraints?","commit_id":"9d78934e562f8a4ff127a1044aaf50d604fa7096"},{"author":{"_account_id":9533,"name":"Eiichi Aikawa","email":"aikawa@mxk.nes.nec.co.jp","username":"EiichiAikawa"},"change_message_id":"9b6bced35ad359631c312d6a43a140d248911f31","unresolved":false,"context_lines":[{"line_number":40,"context_line":"        [\u0027zone_deleted\u0027, zones_table.c.deleted],"},{"line_number":41,"context_line":"        [\u0027zone_id_tenant_deleted\u0027, zones_table.c.id, zones_table.c.tenant_id,"},{"line_number":42,"context_line":"         zones_table.c.deleted],"},{"line_number":43,"context_line":"        # [\u0027zone_parent_deleted\u0027, zones_table.c.parent_domain_id, zones_table.c.deleted],"},{"line_number":44,"context_line":"        # [\u0027zone_name_deleted\u0027, zones_table.c.name, zones_table.c.deleted],"},{"line_number":45,"context_line":"        [\u0027recordset_id_tenant\u0027, recordsets_table.c.id, recordsets_table.c.tenant_id],"},{"line_number":46,"context_line":"        [\u0027recordset_type_name\u0027, recordsets_table.c.type, recordsets_table.c.name],"}],"source_content_type":"text/x-python","patch_set":4,"id":"9aa7fdbe_86d91cf5","line":43,"updated":"2014-10-27 08:56:56.000000000","message":"too long.\nsome other lines are the same.","commit_id":"67e01677942bb381cd2cf23397d2e2b14178d457"}],"designate/storage/impl_sqlalchemy/migrate_repo/versions/046_add_indices.py":[{"author":{"_account_id":8099,"name":"Graham Hayes","email":"gr@ham.ie","username":"graham"},"change_message_id":"e61e09d83d67298553b1a72d029d9c48e712cc42","unresolved":false,"context_lines":[{"line_number":37,"context_line":""},{"line_number":38,"context_line":"    indices \u003d ["},{"line_number":39,"context_line":"        [\u0027zone_deleted\u0027, zones_table.c.deleted],"},{"line_number":40,"context_line":"        [\u0027zone_id_tenant_deleted\u0027, zones_table.c.tenant_id,"},{"line_number":41,"context_line":"         zones_table.c.deleted],"},{"line_number":42,"context_line":"        [\u0027rrset_type_domainid\u0027, recordsets_table.c.type,"},{"line_number":43,"context_line":"         recordsets_table.c.domain_id],"}],"source_content_type":"text/x-python","patch_set":7,"id":"5a890539_d70bc67a","line":40,"updated":"2014-11-17 16:15:12.000000000","message":"should this be zone_tenant_deleted ?","commit_id":"0fcfde00ea9954611b144e85c1129542267ea170"},{"author":{"_account_id":8099,"name":"Graham Hayes","email":"gr@ham.ie","username":"graham"},"change_message_id":"e61e09d83d67298553b1a72d029d9c48e712cc42","unresolved":false,"context_lines":[{"line_number":43,"context_line":"         recordsets_table.c.domain_id],"},{"line_number":44,"context_line":"        [\u0027recordset_type_name\u0027, recordsets_table.c.type,"},{"line_number":45,"context_line":"        recordsets_table.c.name],"},{"line_number":46,"context_line":"        [\u0027recordset_tenant\u0027, records_table.c.tenant_id]"},{"line_number":47,"context_line":"    ]"},{"line_number":48,"context_line":""},{"line_number":49,"context_line":"    for ind in indices:"}],"source_content_type":"text/x-python","patch_set":7,"id":"5a890539_17fb8e79","line":46,"updated":"2014-11-17 16:15:12.000000000","message":"is that the right name? seems it should be records_tenant","commit_id":"0fcfde00ea9954611b144e85c1129542267ea170"},{"author":{"_account_id":8099,"name":"Graham Hayes","email":"gr@ham.ie","username":"graham"},"change_message_id":"e61e09d83d67298553b1a72d029d9c48e712cc42","unresolved":false,"context_lines":[{"line_number":67,"context_line":"        recordsets_table.c.domain_id],"},{"line_number":68,"context_line":"        [\u0027recordset_type_name\u0027, recordsets_table.c.type,"},{"line_number":69,"context_line":"        recordsets_table.c.name],"},{"line_number":70,"context_line":"        [\u0027recordset_tenant\u0027, records_table.c.tenant_id]"},{"line_number":71,"context_line":"    ]"},{"line_number":72,"context_line":""},{"line_number":73,"context_line":"    for ind in indices:"}],"source_content_type":"text/x-python","patch_set":7,"id":"5a890539_f75c427f","line":70,"updated":"2014-11-17 16:15:12.000000000","message":"naming as above ^","commit_id":"0fcfde00ea9954611b144e85c1129542267ea170"}]}