[phpmyadmin/phpmyadmin] 85ee72: feat: Add option to import empty CSV values as NULL
Branch: refs/heads/master Home: https://github.com/phpmyadmin/phpmyadmin Commit: 85ee729df85d8af672fc625faaab3282c8b7481c https://github.com/phpmyadmin/phpmyadmin/commit/85ee729df85d8af672fc625faaab... Author: Darsh Bhavnani <darshbhavnani@gmail.com> Date: 2025-08-08 (Fri, 08 August 2025) +05:30 Changed paths: M src/Plugins/Import/ImportCsv.php Log Message: ----------- feat: Add option to import empty CSV values as NULL - Adds a new "Import empty values as NULL" checkbox to the CSV import options. When enabled, this setting will convert any empty string values in the imported data to the SQL `NULL` value. - This enhancement ensures that empty fields are not stored as empty strings, which is crucial for columns where a true `NULL` value is required or expected. The logic is applied to both the table analysis and data insertion phases, providing consistent behavior when creating new tables or appending to existing ones. Signed-off-by: Darsh Bhavnani <darshbhavnani@gmail.com> Commit: 1149ae93126badb9e28baa3ace9427ba336851bd https://github.com/phpmyadmin/phpmyadmin/commit/1149ae93126badb9e28baa3ace94... Author: Darsh Bhavnani <darshbhavnani@gmail.com> Date: 2025-08-08 (Fri, 08 August 2025) +05:30 Changed paths: M src/Plugins/Import/ImportCsv.php Log Message: ----------- feat: sets empty value to null string Signed-off-by: Darsh Bhavnani <darshbhavnani@gmail.com> Commit: c9906ba607522b6c74e4201ca0dbd21f5c531319 https://github.com/phpmyadmin/phpmyadmin/commit/c9906ba607522b6c74e4201ca0db... Author: Darsh Bhavnani <darshbhavnani@gmail.com> Date: 2025-08-08 (Fri, 08 August 2025) +05:30 Changed paths: M src/Plugins/Import/ImportCsv.php Log Message: ----------- fix: treat null string as nul By removing this, import automatically treats null string as null value Signed-off-by: Darsh Bhavnani <darshbhavnani@gmail.com> Commit: acf5579be0b98f47958a7b4489a011fa7ca6be89 https://github.com/phpmyadmin/phpmyadmin/commit/acf5579be0b98f47958a7b4489a0... Author: Darsh Bhavnani <darshbhavnani@gmail.com> Date: 2025-08-09 (Sat, 08 August 2025) +05:30 Changed paths: M src/Plugins/Import/ImportCsv.php Log Message: ----------- fix: lint error Signed-off-by: Darsh Bhavnani <darshbhavnani@gmail.com> Commit: 2c03905eeafdd096c85b89aad863aaca18637ff5 https://github.com/phpmyadmin/phpmyadmin/commit/2c03905eeafdd096c85b89aad863... Author: William Desportes <williamdes@wdes.fr> Date: 2026-04-09 (Thu, 04 April 2026) +02:00 Changed paths: M src/Config/Descriptions.php M src/Config/Forms/User/ImportForm.php M src/Config/Settings.php M src/Config/Settings/Import.php M src/Plugins/Import/ImportCsv.php M tests/unit/Config/Forms/User/ImportFormTest.php M tests/unit/Config/Settings/ImportTest.php M tests/unit/Controllers/Database/Fixtures/Import-testController.html M tests/unit/Plugins/Import/ImportCsvTest.php M tests/unit/PluginsTest.php Log Message: ----------- Merge #19802 - Fix #19381 - Implement csv empty to null Pull-request: #19802 Fixes: #19381 Co-Authored-By: William Desportes <williamdes@wdes.fr> Signed-off-by: William Desportes <williamdes@wdes.fr> Commit: 43fd19b79ea63798a5dfc10f8cd5c97fff54edbb https://github.com/phpmyadmin/phpmyadmin/commit/43fd19b79ea63798a5dfc10f8cd5... Author: William Desportes <williamdes@wdes.fr> Date: 2026-04-09 (Thu, 04 April 2026) +02:00 Changed paths: M src/Plugins/Export/ExportToon.php Log Message: ----------- Fix #20275 - TOON export should use the normal user Pull-request: #20175 Signed-off-by: William Desportes <williamdes@wdes.fr>
participants (1)
-
Darsh Bhavnani