<?php
namespace Microservices\Config\Queries\ClientDB\POST;
use Microservices\App\Constants;
use Microservices\App\DatabaseCacheKey;
use Microservices\App\DatabaseDataTypes;
use Microservices\App\Env;
return [
'query' => "INSERT INTO `category` SET __SET__",
'__SET__' => [
'name' => ['payload', 'name'],
'parent_id' => ['custom', 0],
],
'insertId' => 'category:id',
'subQuery' => [
'sub' => [
'query' => "INSERT INTO `category` SET __SET__",
'__SET__' => [
'name' => ['payload', 'subname'],
'parent_id' => ['insertIdParams', 'category:id'],
],
'insertId' => 'sub:id',
'subQuery' => [
'subsub' => [
'query' => "INSERT INTO `category` SET __SET__",
'__SET__' => [
'name' => ['payload', 'subsubname'],
// 'name' => ['useResultSet', 'return:sub:subname'],
'parent_id' => ['insertIdParams', 'sub:id'],
],
'insertId' => 'subsub:id',
]
]
]
],
'useHierarchy' => true,
'affectedCacheKeys' => [
DatabaseCacheKey::$Category,
DatabaseCacheKey::$Category1
]
];
|
Download
