Joe Williams 759356288b Add transactions to missing config keys migration. (#4318) ...

* `execute_script()` now returns a boolean for error handling.

* Added transaction to `Migration_MissingConfigKeys.up()`.

* Added `executeScriptWithTransaction()` to migration helpers.

* Many changes for testing; also minor formatting fixes.

* Removed test code and pointed the `NullableTaxCategoryId` migration at the right SQL file.

* Fixed header.php

* Code cleanup from code review:
- Added IGNORE to SQL scripts.
- Added try-catch to executeScriptWithTransaction().
- Various comment changes.

* Fixed naming issue

Nullable tax category ID migration now runs the correct script.

* Updated SQL

Replaced INSERT WHERE NOT EXISTS in missing config keys sql script to use a single INSERT IGNORE.

* Updated migration helper

Updated executeScriptWithTransaction to use transRollback

---------

Co-authored-by: Joe Williams <hey-there-joe@outlook.com>

2025-10-15 22:53:14 -07:00

..

pre-3.0.2

Improve code style and PSR-12 compliance (#4204)

2025-05-02 19:37:06 +02:00

3.0.2_to_3.1.1.sql

Upgrade to CodeIgniter 4.1.3

2024-06-15 17:19:15 +02:00

3.1.1_to_3.2.0.sql

Improve code style and PSR-12 compliance (#4204)

2025-05-02 19:37:06 +02:00

3.2.0_to_3.2.1.sql

Improve code style and PSR-12 compliance (#4204)

2025-05-02 19:37:06 +02:00

3.2.1_to_3.3.0.sql

Replace tabs with spaces (#4196)

2025-03-28 21:24:21 +04:00

3.3.0_add_iso_4217.sql

Improve code style and PSR-12 compliance (#4204)

2025-05-02 19:37:06 +02:00

3.3.0_attributes.sql

Improve code style and PSR-12 compliance (#4204)

2025-05-02 19:37:06 +02:00

3.3.0_dbfix.sql

Upgrade to CodeIgniter 4.1.3

2024-06-15 17:19:15 +02:00

3.3.0_decimal_attribute_type.sql

Improve code style and PSR-12 compliance (#4204)

2025-05-02 19:37:06 +02:00

3.3.0_fix_attribute_datetime.sql

Improve code style and PSR-12 compliance (#4204)

2025-05-02 19:37:06 +02:00

3.3.0_indiagst1.sql

Upgrade to CodeIgniter 4.1.3

2024-06-15 17:19:15 +02:00

3.3.0_indiagst2.sql

Improve code style and PSR-12 compliance (#4204)

2025-05-02 19:37:06 +02:00

3.3.0_indiagst.sql

Replace tabs with spaces (#4196)

2025-03-28 21:24:21 +04:00

3.3.0_paymenttracking.sql

Upgrade to CodeIgniter 4.1.3

2024-06-15 17:19:15 +02:00

3.3.0_refundtracking.sql

Replace tabs with spaces (#4196)

2025-03-28 21:24:21 +04:00

3.3.2_modify_attr_links_constraint.sql

Improve code style and PSR-12 compliance (#4204)

2025-05-02 19:37:06 +02:00

3.3.2_paymentdatefix.sql

Upgrade to CodeIgniter 4.1.3

2024-06-15 17:19:15 +02:00

3.3.2_saleschangeprice.sql

Upgrade to CodeIgniter 4.1.3

2024-06-15 17:19:15 +02:00

3.3.3_add_kits_item_number.sql

Improve code style and PSR-12 compliance (#4204)

2025-05-02 19:37:06 +02:00

3.3.4_modify_session_datatype.sql

Upgrade to CodeIgniter 4.1.3

2024-06-15 17:19:15 +02:00

3.4.0_attribute_links_unique_constraint.sql

Replace tabs with spaces (#4196)

2025-03-28 21:24:21 +04:00

3.4.0_ci4_conversion.sql

Replace tabs with spaces (#4196)

2025-03-28 21:24:21 +04:00

3.4.0_database_optimizations.sql

Bugfix Attributes not saving (#4080)

2024-11-05 22:37:47 +01:00

3.4.1_attribute_links_unique_constraint.sql

Fix migration 20250522000000 (#4284)

2025-07-16 23:28:24 +02:00

3.4.1_migrate_sessions_table.sql

Bugfix: constraint migration fixes (#4230)

2025-05-29 15:24:08 +04:00

3.4.2_missing_config_keys.sql

Add transactions to missing config keys migration. (#4318)

2025-10-15 22:53:14 -07:00

3.4.2_nullable_tax_category_id.sql

Allow empty tax category id (#4285) (#4288)

2025-07-29 23:59:23 +02:00