Type casting in PostgreSQL with updateBatch()

I sent a PR: https://github.com/codeigniter4/CodeIgniter4/pull/8426

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

I sent a PR: https://github.com/codeigniter4/CodeIgniter4/pull/8426

Man I couldn't be any more happier. Thank you so-much. You made my day.
You are the best. Love you ma man. (y)

Tests and reviews are welcome.

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

I hope individuals with strong technical skills can offer assistance. I wish I possessed such skills to contribute. I attempted to rectify this after a few hours of struggling, but unfortunately, I failed. Every value is gets enclosed in quotes. I spent several days trying to comprehend how things interconnect, but I couldn't figure it out.

I want to convey that I genuinely desire to actively contribute to CI4, but I'm not at that level yet. I highly appreciate what you all are doing here. I eat, live, and take care of my family because of you guys. Thank you so much

I have this issue. i dunno what to do.

my whole project is now stuck at this point. cant go forward without having a solution to this. i nerver had this type of issue in ci3.

i suggest this kind of way casting types, $builder->updateBatch($data, ['title', 'author', 'data:jsonb']);

Tests and reviews are welcome.

I reviewed its fine but it has to be documented. I will give it a try on its test

Added the docs: https://github.com/codeigniter4/CodeIgniter4/pull/8426

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

The quick and easy fix for this is to use RawSql as well as casting your php values:

Code:

$data = [
                [
                    'name'                  => 'Derek Jones',
                    'savings'               => (float) '28389.48',
                    'updated_at' => new RawSql("'2023-12-02 18:47:52'::TIMESTAMP"),
                ],
            ];

https://codeigniter.com/user_guide/datab...tml#rawsql

Another things to have a look at is:

https://www.postgresql.org/docs/current/...ecast.html

Added the docs: https://github.com/codeigniter4/CodeIgniter4/pull/8426

Big thanks  

The quick and easy fix for this is to use RawSql as well as casting your php values:

Code:

            $data = [
                [
                    'name'                  => 'Derek Jones',
                    'savings'              => (float) '28389.48',
                    'updated_at' => new RawSql("'2023-12-02 18:47:52'::TIMESTAMP"),
                ],
            ];

https://codeigniter.com/user_guide/datab...tml#rawsql

Another things to have a look at is:

https://www.postgresql.org/docs/current/...ecast.html

Yeah! nice trick.

There are four options now. Any opinion? or another solution?
See https://github.com/codeigniter4/CodeIgni...1901901019

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

I sent another PR. This seems better.

fix: [Postgre] QueryBuilder::updateBatch() does not work (No API change) by kenjis · Pull Request #8439 · codeigniter4/CodeIgniter4
https://github.com/codeigniter4/CodeIgniter4/pull/8439

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper