search

rubenv / sql-migrate

SQL schema migration tool for Go.
MIT License
3.18k stars 273 forks source link

Migrations are Executed in the Wrong Order #138

Closed mauleyzaola closed 5 years ago

mauleyzaola commented 5 years ago

Apparently the execution order doesn't match the right one. I have the latest master version.

select * from migrations order by 2

Result

id  applied_at
20190313114328-InsuranceTypo.sql    2019-04-08 12:56:59
20190305211544-trigger-service_types-insert.sql 2019-04-08 12:56:59
20190305211543-trigger-sales_reps-update.sql    2019-04-08 12:56:59
20190305211542-trigger-sales_reps-insert.sql    2019-04-08 12:56:59
20190305211541-trigger-sales_regions-update.sql 2019-04-08 12:56:59
20190305211540-trigger-sales_regions-insert.sql 2019-04-08 12:56:59
20190305211539-trigger-logos-update.sql 2019-04-08 12:56:59
20190305211538-trigger-logos-insert.sql 2019-04-08 12:56:59
20190305211537-trigger-locations-update.sql 2019-04-08 12:56:59
20190305211536-trigger-locations-insert.sql 2019-04-08 12:56:59
20190305211545-trigger-service_types-update.sql 2019-04-08 12:56:59
20190305211546-trigger-super_carriers-insert.sql    2019-04-08 12:56:59
20190308181014-EnrollmentsView.sql  2019-04-08 12:56:59
20190308095556-set_workstation_defualt_to_dedicated.sql 2019-04-08 12:56:59
20190305211554-trigger-workstations-update.sql  2019-04-08 12:56:59
20190305211553-trigger-workstations-insert.sql  2019-04-08 12:56:59
20190305211552-trigger-workstation_uploads-update.sql   2019-04-08 12:56:59
20190305211550-trigger-workstation_uploads-insert.sql   2019-04-08 12:56:59
20190305211549-trigger-users-update.sql 2019-04-08 12:56:59
20190305211548-trigger-users-insert.sql 2019-04-08 12:56:59
20190305211547-trigger-super_carriers-update.sql    2019-04-08 12:56:59
20190305211535-trigger-internal_users-update.sql    2019-04-08 12:56:59
20190305211534-trigger-internal_users-insert.sql    2019-04-08 12:56:59
20190305211533-trigger-insurances-update.sql    2019-04-08 12:56:59
20190305211520-trigger-device_types-insert.sql  2019-04-08 12:56:59
20190305211519-trigger-carriers-update.sql  2019-04-08 12:56:59
20190305211518-trigger-carriers-insert.sql  2019-04-08 12:56:59
20190226153139-AuditTable.sql   2019-04-08 12:56:59
20190226133819-AddUsernameFieldAllTables.sql    2019-04-08 12:56:59
20190221103021-columns_order.sql    2019-04-08 12:56:59
20190218221735-add-is_dedicated-field-workstation-tbl.sql   2019-04-08 12:56:59
20190211080013-RemoveUploadLogsTable.sql    2019-04-08 12:56:59
20190210160726-WorkstationUploadsRemoveStateField.sql   2019-04-08 12:56:59
20190305211521-trigger-device_types-update.sql  2019-04-08 12:56:59
20190305211522-trigger-devices-insert.sql   2019-04-08 12:56:59
20190305211523-trigger-devices-update.sql   2019-04-08 12:56:59
20190305211532-trigger-insurances-insert.sql    2019-04-08 12:56:59
20190305211531-trigger-insurance_types-update.sql   2019-04-08 12:56:59
20190305211530-trigger-insurance_types-insert.sql   2019-04-08 12:56:59
20190305211529-trigger-icd10-update.sql 2019-04-08 12:56:59
20190305211528-trigger-icd10-insert.sql 2019-04-08 12:56:59
20190305211527-trigger-groups-update.sql    2019-04-08 12:56:59
20190305211526-trigger-groups-insert.sql    2019-04-08 12:56:59
20190305211525-trigger-enrollments-update.sql   2019-04-08 12:56:59
20190305211524-trigger-enrollments-insert.sql   2019-04-08 12:56:59
20190319165117-trigger-report-update.sql    2019-04-08 12:57:00
20190321135032-ReportsAddName.sql   2019-04-08 12:57:00
20190321135522-trigger-report-insert.sql    2019-04-08 12:57:00
20190321135527-trigger-report-update.sql    2019-04-08 12:57:00
20190321152250-replace_icd-10_codes.sql 2019-04-08 12:57:00
20190325110413-LocationGroupNotNull.sql 2019-04-08 12:57:00
20190325110801-trigger-locations-insert.sql 2019-04-08 12:57:00
20190325110804-trigger-locations-update.sql 2019-04-08 12:57:00
20190327093820-remove_enrollment_prior_auth_needed_bit.sql  2019-04-08 12:57:00
20190327101311-ViewEnrollmentsFix.sql   2019-04-08 12:57:00
20190329145733-create_config_table_if_does_not_exist.sql    2019-04-08 12:57:00
20190319165114-trigger-report-insert.sql    2019-04-08 12:57:00
20190319151702-ReportsTable.sql 2019-04-08 12:57:00
20190313130323-trigger-insurances-insert.sql    2019-04-08 12:57:00
20190313130328-trigger-insurances-update.sql    2019-04-08 12:57:00
20190314100244-add_carrier_types.sql    2019-04-08 12:57:00
20190314141946-add_carriers_seed_data.sql   2019-04-08 12:57:00
20190314155355-add_carriers_triggers.sql    2019-04-08 12:57:00
20190314163758-enrollments_icd10-remove-createdat-field.sql 2019-04-08 12:57:00
20190318175700-trg_insert_audits_insurances.sql 2019-04-08 12:57:00
20190318175707-trg_update_audits_insurances.sql 2019-04-08 12:57:00
20190319094635-ReportType.sql   2019-04-08 12:57:00
20190319095254-trigger-report-types-insert.sql  2019-04-08 12:57:00
20190319095258-trigger-report-types-update.sql  2019-04-08 12:57:00
20190404174014-enrollments-trigger-insert.sql   2019-04-08 12:57:05
20190404173208-EnrollmentSubmitS3Identifier.sql 2019-04-08 12:57:05
20190403230146-add_self_pay_to_carriers.sql 2019-04-08 12:57:05
20190402212719-ViewDoctorsForLocation.sql   2019-04-08 12:57:05
20190402154828-add_service_types.sql    2019-04-08 12:57:05
20190402105505-BI_Reporting_View_Holter_Uploads.sql 2019-04-08 12:57:05
20190401085944-cleanup_generated_data_null_submitted_on_draft_enrollements.sql  2019-04-08 12:57:05
20190329150604-demo_sample_data.sql 2019-04-08 12:57:05
20190404174042-enrollments-trigger-update.sql   2019-04-08 12:57:05

To test this, I checked out this commit: https://github.com/rubenv/sql-migrate/commit/1007f53448d75fe14190968f5de4d95ed63ebb83

Then did a go install, executed the migration tool again and this is the result, which looks like correct to me.

id  applied_at
20190210160726-WorkstationUploadsRemoveStateField.sql   2019-04-08 13:06:43
20190211080013-RemoveUploadLogsTable.sql    2019-04-08 13:06:43
20190218221735-add-is_dedicated-field-workstation-tbl.sql   2019-04-08 13:06:43
20190221103021-columns_order.sql    2019-04-08 13:06:43
20190313130328-trigger-insurances-update.sql    2019-04-08 13:06:44
20190314100244-add_carrier_types.sql    2019-04-08 13:06:44
20190314141946-add_carriers_seed_data.sql   2019-04-08 13:06:44
20190314155355-add_carriers_triggers.sql    2019-04-08 13:06:44
20190314163758-enrollments_icd10-remove-createdat-field.sql 2019-04-08 13:06:44
20190318175700-trg_insert_audits_insurances.sql 2019-04-08 13:06:44
20190313130323-trigger-insurances-insert.sql    2019-04-08 13:06:44
20190313114328-InsuranceTypo.sql    2019-04-08 13:06:44
20190308181014-EnrollmentsView.sql  2019-04-08 13:06:44
20190308095556-set_workstation_defualt_to_dedicated.sql 2019-04-08 13:06:44
20190305211554-trigger-workstations-update.sql  2019-04-08 13:06:44
20190305211553-trigger-workstations-insert.sql  2019-04-08 13:06:44
20190305211552-trigger-workstation_uploads-update.sql   2019-04-08 13:06:44
20190305211550-trigger-workstation_uploads-insert.sql   2019-04-08 13:06:44
20190318175707-trg_update_audits_insurances.sql 2019-04-08 13:06:44
20190319094635-ReportType.sql   2019-04-08 13:06:44
20190319095254-trigger-report-types-insert.sql  2019-04-08 13:06:44
20190329145733-create_config_table_if_does_not_exist.sql    2019-04-08 13:06:44
20190327101311-ViewEnrollmentsFix.sql   2019-04-08 13:06:44
20190327093820-remove_enrollment_prior_auth_needed_bit.sql  2019-04-08 13:06:44
20190325110804-trigger-locations-update.sql 2019-04-08 13:06:44
20190325110801-trigger-locations-insert.sql 2019-04-08 13:06:44
20190325110413-LocationGroupNotNull.sql 2019-04-08 13:06:44
20190321152250-replace_icd-10_codes.sql 2019-04-08 13:06:44
20190321135527-trigger-report-update.sql    2019-04-08 13:06:44
20190321135522-trigger-report-insert.sql    2019-04-08 13:06:44
20190321135032-ReportsAddName.sql   2019-04-08 13:06:44
20190319165117-trigger-report-update.sql    2019-04-08 13:06:44
20190319165114-trigger-report-insert.sql    2019-04-08 13:06:44
20190319151702-ReportsTable.sql 2019-04-08 13:06:44
20190319095258-trigger-report-types-update.sql  2019-04-08 13:06:44
20190305211549-trigger-users-update.sql 2019-04-08 13:06:44
20190305211548-trigger-users-insert.sql 2019-04-08 13:06:44
20190226133819-AddUsernameFieldAllTables.sql    2019-04-08 13:06:44
20190305211530-trigger-insurance_types-insert.sql   2019-04-08 13:06:44
20190305211529-trigger-icd10-update.sql 2019-04-08 13:06:44
20190305211528-trigger-icd10-insert.sql 2019-04-08 13:06:44
20190305211527-trigger-groups-update.sql    2019-04-08 13:06:44
20190305211526-trigger-groups-insert.sql    2019-04-08 13:06:44
20190305211525-trigger-enrollments-update.sql   2019-04-08 13:06:44
20190305211524-trigger-enrollments-insert.sql   2019-04-08 13:06:44
20190305211523-trigger-devices-update.sql   2019-04-08 13:06:44
20190305211522-trigger-devices-insert.sql   2019-04-08 13:06:44
20190305211521-trigger-device_types-update.sql  2019-04-08 13:06:44
20190305211520-trigger-device_types-insert.sql  2019-04-08 13:06:44
20190305211519-trigger-carriers-update.sql  2019-04-08 13:06:44
20190305211518-trigger-carriers-insert.sql  2019-04-08 13:06:44
20190226153139-AuditTable.sql   2019-04-08 13:06:44
20190305211531-trigger-insurance_types-update.sql   2019-04-08 13:06:44
20190305211532-trigger-insurances-insert.sql    2019-04-08 13:06:44
20190305211547-trigger-super_carriers-update.sql    2019-04-08 13:06:44
20190305211546-trigger-super_carriers-insert.sql    2019-04-08 13:06:44
20190305211545-trigger-service_types-update.sql 2019-04-08 13:06:44
20190305211544-trigger-service_types-insert.sql 2019-04-08 13:06:44
20190305211543-trigger-sales_reps-update.sql    2019-04-08 13:06:44
20190305211542-trigger-sales_reps-insert.sql    2019-04-08 13:06:44
20190305211541-trigger-sales_regions-update.sql 2019-04-08 13:06:44
20190305211540-trigger-sales_regions-insert.sql 2019-04-08 13:06:44
20190305211539-trigger-logos-update.sql 2019-04-08 13:06:44
20190305211533-trigger-insurances-update.sql    2019-04-08 13:06:44
20190305211534-trigger-internal_users-insert.sql    2019-04-08 13:06:44
20190305211535-trigger-internal_users-update.sql    2019-04-08 13:06:44
20190305211536-trigger-locations-insert.sql 2019-04-08 13:06:44
20190305211537-trigger-locations-update.sql 2019-04-08 13:06:44
20190305211538-trigger-logos-insert.sql 2019-04-08 13:06:44
20190329150604-demo_sample_data.sql 2019-04-08 13:06:49
20190404174014-enrollments-trigger-insert.sql   2019-04-08 13:06:50
20190404173208-EnrollmentSubmitS3Identifier.sql 2019-04-08 13:06:50
20190403230146-add_self_pay_to_carriers.sql 2019-04-08 13:06:50
20190402212719-ViewDoctorsForLocation.sql   2019-04-08 13:06:50
20190402154828-add_service_types.sql    2019-04-08 13:06:50
20190402105505-BI_Reporting_View_Holter_Uploads.sql 2019-04-08 13:06:50
20190401085944-cleanup_generated_data_null_submitted_on_draft_enrollements.sql  2019-04-08 13:06:50
20190404174042-enrollments-trigger-update.sql   2019-04-08 13:06:50
mauleyzaola commented 5 years ago

Cannot reproduce this one now. Will close.