utopia-php/database

๐Ÿš€ Feature: updateDocumentBy

Opened this issue ยท 0 comments

zdanl commented

๐Ÿ”– Feature description

$resp = $DB::updateDocumentBy('db', 'collection', [
    Query.select(['foo', 'bar'])
], {
    'bar': 'bla',
    'splash': 'hash'
});

๐ŸŽค Pitch

Alternate way for SELECT statement when Document ID isn't available. Might be slower in terms of a INNER JOIN not looking for _uid as a PRIMARY KEY.

Allows for more natural thinking in programming, and for example, updateDocumentBy APIKey or any other UNIQUE Column, in our case, in a MariaDB Table.

I thought something like this

Screenshot 2023-12-05 at 13 46 58

Thoughts?

๐Ÿ‘€ Have you spent some time to check if this issue has been raised before?

  • I checked and didn't find similar issue

๐Ÿข Have you read the Code of Conduct?