Update with "where" about php-crud-api

[focussing]

Topper!

[mevdschee]

Hi Raymond, Thank you for your great question.

If not do you have a suggestion how to deal with this?

Every record should have a synthetic primary key (auto increment or uuid). You can find the primary key using filters. Updates should go on primary keys not on filters.

SELECT id FROM posts WHERE ...
UPDATE posts SET ... WHERE id = ?

I hope you understand this very minimal explanation. Kind regards, Maurits

[mevdschee]

Hi Raymond,

To answer your specific questions:

Is this possible using the php-crud-api?

No, it is not.

If not do you have a suggestion how to deal with this?

Do multiple http requests.

Kind regards, Maurits

[focussing]

Hi Maurits,

Thank you for your suggestions. During the last 2 weeks I have implemented the whole system, and soon it will arrive online.

Reading is easy of course.
The update function needs already to be done via separate api calls one at a time using the already known record id.

Creating and deleting records I did via an "await-loop" which worked fine.
Just this morning I came across the Batch operations, and I already implemented the delete colums-rows-pages already using that very efficient functionality!

One question remains, about creating records in batch. How should I provice the IDs in the url? The IDs are normally not given when creating a record as these are generated in the database itself.
Maybe you can put an example in the docs?

Kind regards,
Raymond

[mevdschee]

Hi Raymond,

I hope you are aware of the "Batch Operations" section in the manual. You can find various useful examples there including batch creation of records.

see: https://github.com/mevdschee/php-crud-api?tab=readme-ov-file#batch-operations

Batch insert is shown in the tests:

see: https://github.com/mevdschee/php-crud-api/blob/main/tests/functional/001_records/086_add_and_update_posts_in_large_batch.log

Kind regards,

Maurits

[focussing]

I am aware, this morning I came across that part in the docs. However I don't see a CREATE batch example...

[focussing]

The solution is simple, just post the objects and do not use a key :)
Thanks @mevdschee for this beautiful single file api 👍

[mevdschee]

Thank you for your kind words. I updated the README to include this information, see: c38083f