Sub-Documents / new value fields PHP SDK

nadnapz · August 29, 2018, 8:55pm

I am trying to add a new piece of information to an existing document and I am not sure how to do so, I am not understanding the documentation for it.

Example:
SELECT META(bucketname) As Meta FROM bucketname WHERE Meta().id = “’.$key.’”’)
I pull a document and it shows the meta data:
ID:
FLAGS:
CAS:
etc…

I want to add to this list of meta data with my own field and put, for example, EXP DATE: some value

Im trying to use mutatein and upsert but im not figuring out the path it desires.

Can someone show me a good example of how i could do this and have access to values in couchbase on application side ?

avsej · August 30, 2018, 6:37am

You can find subdocument documentation here:
https://developer.couchbase.com/documentation/server/5.5/sdk/subdocument-operations.html
http://docs.couchbase.com/sdk-api/couchbase-php-client-2.5.1/classes/Couchbase.MutateInBuilder.html

Here is an example on how to modify meta attributes (XATTRs). Regular attributes are exactly the same but without 'xattr' => true option.

github.com

couchbase/php-couchbase/blob/master/examples/subdoc/xattrs.php

<?php

$cluster = new \Couchbase\Cluster('couchbase://192.168.1.194');
$cluster->authenticateAs('Administrator', 'password');

$bucket = $cluster->openBucket('travel-sample');

// Add key-value pairs to hotel_10138, representing traveller-Ids and associated discount percentages
$bucket->mutateIn('hotel_10138')
    ->upsert('discounts.jsmith123', '20', ['xattr' => true, 'createPath' => true])
    ->upsert('discounts.pjones356', '30', ['xattr' => true, 'createPath' => true])
    // The following lines, "insert" and "remove", simply demonstrate insertion and
    // removal of the same path and value
    ->insert('discounts.jbrown789', '25', ['xattr' => true, 'createPath' => true])
    ->remove('discounts.jbrown789', ['xattr' => true])
    ->execute();

// Add key - value pairs to hotel_10142, again representing traveller - Ids and associated discount percentages
$bucket->mutateIn('hotel_10142')
    ->upsert('discounts.jsmith123', '15', ['xattr' => true, 'createPath' => true])

This file has been truncated. show original

I can help more if you will provide your code example, logs or failure messages.