clickhouse_pool_connection_pool_quickstart_with_context_manager.py

1from clickhouse_pool import Pool
2
3# Initialize the pool
4pool = Pool(
5    host='localhost',
6    port=9000,
7    user='default',
8    password='',
9    database='default',
10    connections_min=5,
11    connections_max=20
12)
13
14# Use the pool to get a client
15with pool.pull() as client:
16    result = client.execute('SELECT 1')
17    print(result)
18
19# The client is automatically returned to the pool after the 'with' block