Method CDbCommandBuilder:: createMultipleInsertCommandWithIgnore added

[apphp]

Added method CDbCommandBuilder:: createMultipleInsertCommandWithIgnore and implemented for MySQL and Postgres

[what-the-diff[bot]]

PR Summary

• Addition of the new method in CDbCommandBuilder.php A new function, createMultipleInsertCommandWithIgnore, has been introduced into the CDbCommandBuilder.php file. This function lays down the steps to create a Multiple INSERT command - a key database operation that can add several entries at once - while simultaneously ignoring any conflicts that arise.

• Enhancement of CMysqlCommandBuilder.php Similarly, the createMultipleInsertCommandWithIgnore function has also been incorporated into the CMysqlCommandBuilder.php file. This version not only creates a Multiple INSERT command but adds some database-specific handling to avoid conflicts. This change is designed to improve how the software communicates with MySQL databases, a popular database management system.

• Update to CPgsqlCommandBuilder.php Lastly, the same function has made its way into the CPgsqlCommandBuilder.php file, where it is again used to generate a Multiple INSERT command while handling conflicts. This database-specific improvement is aimed at better interfacing with PostgreSQL, another widely-used database system.

[marcovtwout]

Sorry, but Yii 1 Yii is in maintainace mode, only receiving security and compatibility fixes. This PR looks like optional functionality, which is not something we are taking into account right now.

[apphp]

Get it, thanks!