1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
|
import atexit
import http
import logging
import multiprocessing
import os
import sys
import socket
import time
from collections import deque
from typing import Dict, Any, Optional, Tuple, Callable
import certifi
import lz4.frame
import urllib3
import zstandard
from urllib3.poolmanager import PoolManager, ProxyManager
from urllib3.response import HTTPResponse
from clickhouse_connect.driver.exceptions import ProgrammingError
from clickhouse_connect import common
logger = logging.getLogger(__name__)
# We disable this warning. Verify must be explicitly set to false, so we assume the user knows what they're doing
urllib3.disable_warnings(urllib3.exceptions.InsecureRequestWarning)
# Increase this number just to be safe when ClickHouse is returning progress headers
http.client._MAXHEADERS = 10000 # pylint: disable=protected-access
DEFAULT_KEEP_INTERVAL = 30
DEFAULT_KEEP_COUNT = 3
DEFAULT_KEEP_IDLE = 30
SOCKET_TCP = socket.IPPROTO_TCP
core_socket_options = [
(socket.SOL_SOCKET, socket.SO_KEEPALIVE, 1),
(SOCKET_TCP, socket.TCP_NODELAY, 1),
(socket.SOL_SOCKET, socket.SO_SNDBUF, 1024 * 256),
(socket.SOL_SOCKET, socket.SO_SNDBUF, 1024 * 256)
]
logging.getLogger('urllib3').setLevel(logging.WARNING)
_proxy_managers = {}
all_managers = {}
@atexit.register
def close_managers():
for manager in all_managers:
manager.clear()
# pylint: disable=no-member,too-many-arguments,too-many-branches
def get_pool_manager_options(keep_interval: int = DEFAULT_KEEP_INTERVAL,
keep_count: int = DEFAULT_KEEP_COUNT,
keep_idle: int = DEFAULT_KEEP_IDLE,
ca_cert: str = None,
verify: bool = True,
client_cert: str = None,
client_cert_key: str = None,
**options) -> Dict[str, Any]:
socket_options = core_socket_options.copy()
if getattr(socket, 'TCP_KEEPINTVL', None) is not None:
socket_options.append((SOCKET_TCP, socket.TCP_KEEPINTVL, keep_interval))
if getattr(socket, 'TCP_KEEPCNT', None) is not None:
socket_options.append((SOCKET_TCP, socket.TCP_KEEPCNT, keep_count))
if getattr(socket, 'TCP_KEEPIDLE', None) is not None:
socket_options.append((SOCKET_TCP, socket.TCP_KEEPIDLE, keep_idle))
if sys.platform == 'darwin':
socket_options.append((SOCKET_TCP, getattr(socket, 'TCP_KEEPALIVE', 0x10), keep_interval))
options['maxsize'] = options.get('maxsize', 8)
options['retries'] = options.get('retries', 1)
if ca_cert == 'certifi':
ca_cert = certifi.where()
options['cert_reqs'] = 'CERT_REQUIRED' if verify else 'CERT_NONE'
if ca_cert:
options['ca_certs'] = ca_cert
if client_cert:
options['cert_file'] = client_cert
if client_cert_key:
options['key_file'] = client_cert_key
options['socket_options'] = socket_options
options['block'] = options.get('block', False)
return options
def get_pool_manager(keep_interval: int = DEFAULT_KEEP_INTERVAL,
keep_count: int = DEFAULT_KEEP_COUNT,
keep_idle: int = DEFAULT_KEEP_IDLE,
ca_cert: str = None,
verify: bool = True,
client_cert: str = None,
client_cert_key: str = None,
http_proxy: str = None,
https_proxy: str = None,
**options):
options = get_pool_manager_options(keep_interval,
keep_count,
keep_idle,
ca_cert,
verify,
client_cert,
client_cert_key,
**options)
if http_proxy:
if https_proxy:
raise ProgrammingError('Only one of http_proxy or https_proxy should be specified')
if not http_proxy.startswith('http'):
http_proxy = f'http://{http_proxy}'
manager = ProxyManager(http_proxy, **options)
elif https_proxy:
if not https_proxy.startswith('http'):
https_proxy = f'https://{https_proxy}'
manager = ProxyManager(https_proxy, **options)
else:
manager = PoolManager(**options)
all_managers[manager] = int(time.time())
return manager
def check_conn_expiration(manager: PoolManager):
reset_seconds = common.get_setting('max_connection_age')
if reset_seconds:
last_reset = all_managers.get(manager, 0)
now = int(time.time())
if last_reset < now - reset_seconds:
logger.debug('connection expiration')
manager.clear()
all_managers[manager] = now
def get_proxy_manager(host: str, http_proxy):
key = f'{host}__{http_proxy}'
if key in _proxy_managers:
return _proxy_managers[key]
proxy_manager = get_pool_manager(http_proxy=http_proxy)
_proxy_managers[key] = proxy_manager
return proxy_manager
def get_response_data(response: HTTPResponse) -> bytes:
encoding = response.headers.get('content-encoding', None)
if encoding == 'zstd':
try:
zstd_decom = zstandard.ZstdDecompressor()
return zstd_decom.stream_reader(response.data).read()
except zstandard.ZstdError:
pass
if encoding == 'lz4':
lz4_decom = lz4.frame.LZ4FrameDecompressor()
return lz4_decom.decompress(response.data, len(response.data))
return response.data
def check_env_proxy(scheme: str, host: str, port: int) -> Optional[str]:
env_var = f'{scheme}_proxy'.lower()
proxy = os.environ.get(env_var)
if not proxy:
proxy = os.environ.get(env_var.upper())
if not proxy:
return None
no_proxy = os.environ.get('no_proxy')
if not no_proxy:
no_proxy = os.environ.get('NO_PROXY')
if not no_proxy:
return proxy
if no_proxy == '*':
return None # Wildcard no proxy means don't actually proxy anything
host = host.lower()
for name in no_proxy.split(','):
name = name.strip()
if name:
name = name.lstrip('.').lower()
if name in (host, f'{host}:{port}'):
return None # Host or host/port matches
if host.endswith('.' + name):
return None # Domain matches
return proxy
_default_pool_manager = get_pool_manager()
def default_pool_manager():
if multiprocessing.current_process().name == 'MainProcess':
return _default_pool_manager
# PoolManagers don't seem to be safe for some multiprocessing environments, always return a new one
return get_pool_manager()
class ResponseSource:
def __init__(self, response: HTTPResponse, chunk_size: int = 1024 * 1024):
self.response = response
compression = response.headers.get('content-encoding')
decompress:Optional[Callable] = None
if compression == 'zstd':
zstd_decom = zstandard.ZstdDecompressor().decompressobj()
def zstd_decompress(c: deque) -> Tuple[bytes, int]:
chunk = c.popleft()
return zstd_decom.decompress(chunk), len(chunk)
decompress = zstd_decompress
elif compression == 'lz4':
lz4_decom = lz4.frame.LZ4FrameDecompressor()
def lz_decompress(c: deque) -> Tuple[Optional[bytes], int]:
read_amt = 0
data = c.popleft()
read_amt += len(data)
if lz4_decom.unused_data:
read_amt += len(lz4_decom.unused_data)
data = lz4_decom.unused_data + data
block = lz4_decom.decompress(data)
if lz4_decom.unused_data:
read_amt -= len(lz4_decom.unused_data)
return block, read_amt
decompress = lz_decompress
buffer_size = common.get_setting('http_buffer_size')
def buffered():
chunks = deque()
done = False
current_size = 0
read_gen = response.read_chunked(chunk_size, decompress is None)
while True:
while not done:
chunk = next(read_gen, None) # Always try to read at least one chunk if there are any left
if not chunk:
done = True
break
chunks.append(chunk)
current_size += len(chunk)
if current_size > buffer_size:
break
if len(chunks) == 0:
return
if decompress:
chunk, used = decompress(chunks)
current_size -= used
else:
chunk = chunks.popleft()
current_size -= len(chunk)
if chunk:
yield chunk
self.gen = buffered()
def close(self):
self.response.drain_conn()
self.response.close()
|
