tarsislima / arangodb-php-aql-generator Goto Github PK

FOR u IN users
  FILTER u.status == 'not active'
  UPDATE u WITH { status: 'inactive' } IN users

// expected 
// FOR l IN locations
//   LET users = FIRST( (FOR u IN users) )

 $mainQuery = AqlGen::query('l', 'locations');  
 $users = AqlGen::query('u', 'users');

// next  produces    
//LET users = (FOR u IN users) 
$mainQuery->let('users', $users);

//but for functions only work with string 
$mainQuery->let('users', 'FIRST((' .  $users->get() .'))');

//insert
FOR u IN users
  INSERT u IN backup
//Remove
FOR u IN users
  FILTER u.status == 'deleted'
  REMOVE u._key IN backup