1<?php
2
3include_once __DIR__ . '/../include.php';
4
5$config = include_once __DIR__ . '/00_config_connect.php';
6
7
8$db = new ClickHouseDB\Client($config);
9
10$input_params = [
11    'select_date' => ['2000-10-10', '2000-10-11', '2000-10-12'],
12    'limit'       => 5,
13    'from_table'  => 'table'
14];
15
16
17$db->enableQueryConditions();
18
19
20$select = '
21SELECT * FROM {from_table}
22WHERE
23{if select_date}
24event_date IN (:select_date)
25{else}
26event_date=today()
27{/if}
28{if limit}
29LIMIT {limit}
30{/if}
31';
32
33$statement = $db->selectAsync($select, $input_params);
34echo $statement->sql();
35echo "\n";
36
37/*
38SELECT * FROM table
39WHERE
40event_date IN ('2000-10-10','2000-10-11','2000-10-12')
41LIMIT 5
42FORMAT JSON
43*/
44
45$input_params['select_date'] = false;
46
47
48$statement = $db->selectAsync($select, $input_params);
49echo $statement->sql();
50echo "\n";
51
52/*
53SELECT * FROM table
54WHERE
55event_date=today()
56LIMIT 5
57FORMAT JSON
58*/