<?php
namespace Microservices\Config\Queries\ClientDB\GET;
use Microservices\App\Constants;
use Microservices\App\DatabaseCacheKey;
use Microservices\App\DatabaseDataTypes;
use Microservices\App\Env;
return [
'query' => "SELECT * FROM `category` WHERE __WHERE__",
'__WHERE__' => [
'is_deleted' => ['custom', 'No'],
'parent_id' => ['custom', 0]
],
'mode' => 'multipleRowFormat',
'subQuery' => [
'sub' => [
'query' => "SELECT * FROM `category` WHERE __WHERE__",
'__WHERE__' => [
'is_deleted' => ['custom', 'No'],
],
'mode' => 'multipleRowFormat',
]
],
'fetchFrom' => 'Master',
'cacheKey' => DatabaseCacheKey::$Category1
];
|