)]}'
{"manila/db/migrations/alembic/versions/fbdfabcba377_change_the_mysql_datetime_precision.py":[{"author":{"_account_id":16643,"name":"Goutham Pacha Ravi","email":"gouthampravi@gmail.com","username":"gouthamr"},"change_message_id":"e81103c5d2169d179dd6602cbb095a1b5bdd0d53","unresolved":false,"context_lines":[{"line_number":26,"context_line":"from sqlalchemy import DateTime, dialects"},{"line_number":27,"context_line":""},{"line_number":28,"context_line":""},{"line_number":29,"context_line":"# DB Columns that can be affected by low precision timestamps in MySQL:"},{"line_number":30,"context_line":"COLUMNS \u003d (\u0027shares\u0027, \u0027messages\u0027, \u0027security_services\u0027, \u0027share_groups\u0027,"},{"line_number":31,"context_line":"           \u0027share_networks\u0027, \u0027share_groups\u0027, \u0027share_snapshots\u0027,"},{"line_number":32,"context_line":"           \u0027share_group_snapshots\u0027, \u0027share_snapshot_instances\u0027)"}],"source_content_type":"text/x-python","patch_set":2,"id":"1f493fa4_f0a5f3b6","line":29,"range":{"start_line":29,"start_character":5,"end_line":29,"end_character":12},"updated":"2020-04-22 22:01:47.000000000","message":"nit: tables","commit_id":"84f49486b954b51008872c430ed7439f02b69237"},{"author":{"_account_id":16643,"name":"Goutham Pacha Ravi","email":"gouthampravi@gmail.com","username":"gouthamr"},"change_message_id":"e81103c5d2169d179dd6602cbb095a1b5bdd0d53","unresolved":false,"context_lines":[{"line_number":27,"context_line":""},{"line_number":28,"context_line":""},{"line_number":29,"context_line":"# DB Columns that can be affected by low precision timestamps in MySQL:"},{"line_number":30,"context_line":"COLUMNS \u003d (\u0027shares\u0027, \u0027messages\u0027, \u0027security_services\u0027, \u0027share_groups\u0027,"},{"line_number":31,"context_line":"           \u0027share_networks\u0027, \u0027share_groups\u0027, \u0027share_snapshots\u0027,"},{"line_number":32,"context_line":"           \u0027share_group_snapshots\u0027, \u0027share_snapshot_instances\u0027)"},{"line_number":33,"context_line":""}],"source_content_type":"text/x-python","patch_set":2,"id":"1f493fa4_50ab0788","line":30,"range":{"start_line":30,"start_character":0,"end_line":30,"end_character":7},"updated":"2020-04-22 22:01:47.000000000","message":"nit: tables","commit_id":"84f49486b954b51008872c430ed7439f02b69237"},{"author":{"_account_id":16643,"name":"Goutham Pacha Ravi","email":"gouthampravi@gmail.com","username":"gouthamr"},"change_message_id":"e81103c5d2169d179dd6602cbb095a1b5bdd0d53","unresolved":false,"context_lines":[{"line_number":30,"context_line":"COLUMNS \u003d (\u0027shares\u0027, \u0027messages\u0027, \u0027security_services\u0027, \u0027share_groups\u0027,"},{"line_number":31,"context_line":"           \u0027share_networks\u0027, \u0027share_groups\u0027, \u0027share_snapshots\u0027,"},{"line_number":32,"context_line":"           \u0027share_group_snapshots\u0027, \u0027share_snapshot_instances\u0027)"},{"line_number":33,"context_line":""},{"line_number":34,"context_line":""},{"line_number":35,"context_line":"def upgrade():"},{"line_number":36,"context_line":"    context \u003d op.get_context()"}],"source_content_type":"text/x-python","patch_set":2,"id":"1f493fa4_905f4f40","line":33,"range":{"start_line":33,"start_character":0,"end_line":33,"end_character":0},"updated":"2020-04-22 22:01:47.000000000","message":"All models that derive from ManilaBase have these columns, and as of this migration these tables are:\n\n\u0027services\u0027\n\u0027manila_nodes\u0027\n\u0027quotas\u0027\n\u0027project_user_quotas\u0027\n\u0027project_share_type_quotas\u0027\n\u0027quota_classes\u0027\n\u0027quota_usages\u0027\n\u0027reservations\u0027\n\u0027shares\u0027\n\u0027share_instances\u0027\n\u0027share_instance_export_locations\u0027\n\"share_instance_export_locations_metadata\"\n\"share_types\"\n\"share_type_projects\"\n\u0027share_type_extra_specs\u0027\n\u0027share_metadata\u0027\n\u0027share_access_map\u0027\n\u0027share_access_rules_metadata\u0027\n\u0027share_instance_access_map\u0027\n\u0027share_snapshots\u0027\n\u0027share_snapshot_instances\u0027\n\u0027share_snapshot_access_map\u0027\n\u0027share_snapshot_instance_access_map\u0027\n\u0027share_snapshot_instance_export_locations\u0027\n\u0027security_services\u0027\n\u0027share_networks\u0027\n\u0027share_network_subnets\u0027\n\u0027share_servers\u0027\n\u0027share_server_backend_details\u0027\n\u0027share_network_security_service_association\u0027\n\u0027network_allocations\u0027\n\u0027drivers_private_data\u0027\n\u0027availability_zones\u0027\n\"share_group_types\"\n\u0027share_groups\u0027\n\"share_group_type_projects\"\n\u0027share_group_type_specs\u0027\n\u0027share_group_snapshots\u0027\n\u0027share_group_type_share_type_mappings\u0027\n\u0027share_group_share_type_mappings\u0027\n\u0027messages\u0027\n\"backend_info\"","commit_id":"84f49486b954b51008872c430ed7439f02b69237"},{"author":{"_account_id":29632,"name":"Carlos Eduardo","email":"ces.eduardo98@gmail.com","username":"silvacarlos"},"change_message_id":"8c2867a88f750f27cf1fae34d316b015c522a00e","unresolved":true,"context_lines":[{"line_number":43,"context_line":"          \u0027share_group_type_projects\u0027, \u0027share_group_type_specs\u0027, \u0027messages\u0027,"},{"line_number":44,"context_line":"          \u0027share_group_snapshots\u0027, \u0027share_group_type_share_type_mappings\u0027,"},{"line_number":45,"context_line":"          \u0027share_group_share_type_mappings\u0027)"},{"line_number":46,"context_line":""},{"line_number":47,"context_line":""},{"line_number":48,"context_line":"def upgrade():"},{"line_number":49,"context_line":"    context \u003d op.get_context()"}],"source_content_type":"text/x-python","patch_set":8,"id":"f6d5eb49_ca854b67","line":46,"range":{"start_line":46,"start_character":0,"end_line":46,"end_character":0},"updated":"2021-01-27 13:50:57.000000000","message":"Is there a way this change could be somehow tested in the walk_versions db test?","commit_id":"ee00a12a8934950ce248f5cdc7ee9413c524510f"}]}
