select.py 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417
  1. # -*- coding: utf-8 -*-
  2. # MinIO Python Library for Amazon S3 Compatible Cloud Storage, (C)
  3. # 2020 MinIO, Inc.
  4. #
  5. # Licensed under the Apache License, Version 2.0 (the "License");
  6. # you may not use this file except in compliance with the License.
  7. # You may obtain a copy of the License at
  8. #
  9. # http://www.apache.org/licenses/LICENSE-2.0
  10. #
  11. # Unless required by applicable law or agreed to in writing, software
  12. # distributed under the License is distributed on an "AS IS" BASIS,
  13. # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  14. # See the License for the specific language governing permissions and
  15. # limitations under the License.
  16. """Request/response of SelectObjectContent API."""
  17. from __future__ import absolute_import
  18. from abc import ABC, abstractmethod
  19. from binascii import crc32
  20. from dataclasses import dataclass
  21. from io import BytesIO
  22. from typing import Optional
  23. from xml.etree import ElementTree as ET
  24. from .error import MinioException
  25. from .xml import Element, SubElement, findtext
  26. COMPRESSION_TYPE_NONE = "NONE"
  27. COMPRESSION_TYPE_GZIP = "GZIP"
  28. COMPRESSION_TYPE_BZIP2 = "BZIP2"
  29. FILE_HEADER_INFO_USE = "USE"
  30. FILE_HEADER_INFO_IGNORE = "IGNORE"
  31. FILE_HEADER_INFO_NONE = "NONE"
  32. JSON_TYPE_DOCUMENT = "DOCUMENT"
  33. JSON_TYPE_LINES = "LINES"
  34. QUOTE_FIELDS_ALWAYS = "ALWAYS"
  35. QUOTE_FIELDS_ASNEEDED = "ASNEEDED"
  36. @dataclass(frozen=True)
  37. class InputSerialization(ABC):
  38. """Input serialization."""
  39. compression_type: Optional[str] = None
  40. def __post_init__(self):
  41. if (
  42. self.compression_type is not None and
  43. self.compression_type not in [
  44. COMPRESSION_TYPE_NONE,
  45. COMPRESSION_TYPE_GZIP,
  46. COMPRESSION_TYPE_BZIP2,
  47. ]
  48. ):
  49. raise ValueError(
  50. f"compression type must be {COMPRESSION_TYPE_NONE}, "
  51. f"{COMPRESSION_TYPE_GZIP} or {COMPRESSION_TYPE_BZIP2}"
  52. )
  53. def toxml(self, element):
  54. """Convert to XML."""
  55. if self.compression_type is not None:
  56. SubElement(element, "CompressionType", self.compression_type)
  57. return element
  58. @dataclass(frozen=True)
  59. class CSVInputSerialization(InputSerialization):
  60. """CSV input serialization."""
  61. allow_quoted_record_delimiter: Optional[str] = None
  62. comments: Optional[str] = None
  63. field_delimiter: Optional[str] = None
  64. file_header_info: Optional[str] = None
  65. quote_character: Optional[str] = None
  66. quote_escape_character: Optional[str] = None
  67. record_delimiter: Optional[str] = None
  68. def __post_init__(self):
  69. if (
  70. self.file_header_info is not None and
  71. self.file_header_info not in [
  72. FILE_HEADER_INFO_USE,
  73. FILE_HEADER_INFO_IGNORE,
  74. FILE_HEADER_INFO_NONE,
  75. ]
  76. ):
  77. raise ValueError(
  78. f"file header info must be {FILE_HEADER_INFO_USE}, "
  79. f"{FILE_HEADER_INFO_IGNORE} or {FILE_HEADER_INFO_NONE}"
  80. )
  81. def toxml(self, element):
  82. """Convert to XML."""
  83. super().toxml(element)
  84. element = SubElement(element, "CSV")
  85. if self.allow_quoted_record_delimiter is not None:
  86. SubElement(
  87. element,
  88. "AllowQuotedRecordDelimiter",
  89. self.allow_quoted_record_delimiter,
  90. )
  91. if self.comments is not None:
  92. SubElement(element, "Comments", self.comments)
  93. if self.field_delimiter is not None:
  94. SubElement(element, "FieldDelimiter", self.field_delimiter)
  95. if self.file_header_info is not None:
  96. SubElement(element, "FileHeaderInfo", self.file_header_info)
  97. if self.quote_character is not None:
  98. SubElement(element, "QuoteCharacter", self.quote_character)
  99. if self.quote_escape_character is not None:
  100. SubElement(
  101. element,
  102. "QuoteEscapeCharacter",
  103. self.quote_escape_character,
  104. )
  105. if self.record_delimiter is not None:
  106. SubElement(element, "RecordDelimiter", self.record_delimiter)
  107. @dataclass(frozen=True)
  108. class JSONInputSerialization(InputSerialization):
  109. """JSON input serialization."""
  110. json_type: Optional[str] = None
  111. def __post_init__(self):
  112. if (
  113. self.json_type is not None and
  114. self.json_type not in [JSON_TYPE_DOCUMENT, JSON_TYPE_LINES]
  115. ):
  116. raise ValueError(
  117. f"json type must be {JSON_TYPE_DOCUMENT} or {JSON_TYPE_LINES}"
  118. )
  119. def toxml(self, element):
  120. """Convert to XML."""
  121. super().toxml(element)
  122. element = SubElement(element, "JSON")
  123. if self.json_type is not None:
  124. SubElement(element, "Type", self.json_type)
  125. @dataclass(frozen=True)
  126. class ParquetInputSerialization(InputSerialization):
  127. """Parquet input serialization."""
  128. def toxml(self, element):
  129. """Convert to XML."""
  130. super().toxml(element)
  131. return SubElement(element, "Parquet")
  132. @dataclass(frozen=True)
  133. class OutputSerialization(ABC):
  134. """Output serialization."""
  135. @abstractmethod
  136. def toxml(self, element):
  137. """Convert to XML."""
  138. @dataclass(frozen=True)
  139. class CSVOutputSerialization(OutputSerialization):
  140. """CSV output serialization."""
  141. field_delimiter: Optional[str] = None
  142. quote_character: Optional[str] = None
  143. quote_escape_character: Optional[str] = None
  144. quote_fields: Optional[str] = None
  145. record_delimiter: Optional[str] = None
  146. def __post_init__(self):
  147. if (
  148. self.quote_fields is not None and
  149. self.quote_fields not in [
  150. QUOTE_FIELDS_ALWAYS, QUOTE_FIELDS_ASNEEDED,
  151. ]
  152. ):
  153. raise ValueError(
  154. f"quote fields must be {QUOTE_FIELDS_ALWAYS} or "
  155. f"{QUOTE_FIELDS_ASNEEDED}"
  156. )
  157. def toxml(self, element):
  158. """Convert to XML."""
  159. element = SubElement(element, "CSV")
  160. if self.field_delimiter is not None:
  161. SubElement(element, "FieldDelimiter", self.field_delimiter)
  162. if self.quote_character is not None:
  163. SubElement(element, "QuoteCharacter", self.quote_character)
  164. if self.quote_escape_character is not None:
  165. SubElement(
  166. element,
  167. "QuoteEscapeCharacter",
  168. self.quote_escape_character,
  169. )
  170. if self.quote_fields is not None:
  171. SubElement(element, "QuoteFields", self.quote_fields)
  172. if self.record_delimiter is not None:
  173. SubElement(element, "RecordDelimiter", self.record_delimiter)
  174. @dataclass(frozen=True)
  175. class JSONOutputSerialization(OutputSerialization):
  176. """JSON output serialization."""
  177. record_delimiter: Optional[str] = None
  178. def toxml(self, element):
  179. """Convert to XML."""
  180. element = SubElement(element, "JSON")
  181. if self.record_delimiter is not None:
  182. SubElement(element, "RecordDelimiter", self.record_delimiter)
  183. @dataclass(frozen=True)
  184. class SelectRequest:
  185. """Select object content request."""
  186. expression: str
  187. input_serialization: InputSerialization
  188. output_serialization: OutputSerialization
  189. request_progress: bool = False
  190. scan_start_range: Optional[int] = None
  191. scan_end_range: Optional[int] = None
  192. def toxml(self, element):
  193. """Convert to XML."""
  194. element = Element("SelectObjectContentRequest")
  195. SubElement(element, "Expression", self.expression)
  196. SubElement(element, "ExpressionType", "SQL")
  197. self.input_serialization.toxml(
  198. SubElement(element, "InputSerialization"),
  199. )
  200. self.output_serialization.toxml(
  201. SubElement(element, "OutputSerialization"),
  202. )
  203. if self.request_progress:
  204. SubElement(
  205. SubElement(element, "RequestProgress"), "Enabled", "true",
  206. )
  207. if self.scan_start_range or self.scan_end_range:
  208. tag = SubElement(element, "ScanRange")
  209. if self.scan_start_range:
  210. SubElement(tag, "Start", self.scan_start_range)
  211. if self.scan_end_range:
  212. SubElement(tag, "End", self.scan_end_range)
  213. return element
  214. def _read(reader, size):
  215. """Wrapper to RawIOBase.read() to error out on short reads."""
  216. data = reader.read(size)
  217. if len(data) != size:
  218. raise IOError("insufficient data")
  219. return data
  220. def _int(data):
  221. """Convert byte data to big-endian int."""
  222. return int.from_bytes(data, byteorder="big")
  223. def _crc32(data):
  224. """Wrapper to binascii.crc32()."""
  225. return crc32(data) & 0xffffffff
  226. def _decode_header(data):
  227. """Decode header data."""
  228. reader = BytesIO(data)
  229. headers = {}
  230. while True:
  231. length = reader.read(1)
  232. if not length:
  233. break
  234. name = _read(reader, _int(length))
  235. if _int(_read(reader, 1)) != 7:
  236. raise IOError("header value type is not 7")
  237. value = _read(reader, _int(_read(reader, 2)))
  238. headers[name.decode()] = value.decode()
  239. return headers
  240. @dataclass(frozen=True)
  241. class Stats:
  242. """Progress/Stats information."""
  243. bytes_scanned: Optional[str] = None
  244. bytes_processed: Optional[str] = None
  245. bytes_returned: Optional[str] = None
  246. def __init__(self, data):
  247. element = ET.fromstring(data.decode())
  248. object.__setattr__(
  249. self,
  250. "bytes_scanned",
  251. findtext(element, "BytesScanned"),
  252. )
  253. object.__setattr__(
  254. self,
  255. "bytes_processed",
  256. findtext(element, "BytesProcessed"),
  257. )
  258. object.__setattr__(
  259. self,
  260. "bytes_returned",
  261. findtext(element, "BytesReturned"),
  262. )
  263. class SelectObjectReader:
  264. """
  265. BufferedIOBase compatible reader represents response data of
  266. Minio.select_object_content() API.
  267. """
  268. def __init__(self, response):
  269. self._response = response
  270. self._stats = None
  271. self._payload = None
  272. def __enter__(self):
  273. return self
  274. def __exit__(self, exc_type, exc_value, exc_traceback):
  275. return self.close()
  276. def readable(self): # pylint: disable=no-self-use
  277. """Return this is readable."""
  278. return True
  279. def writeable(self): # pylint: disable=no-self-use
  280. """Return this is not writeable."""
  281. return False
  282. def close(self):
  283. """Close response and release network resources."""
  284. self._response.close()
  285. self._response.release_conn()
  286. def stats(self):
  287. """Get stats information."""
  288. return self._stats
  289. def _read(self):
  290. """Read and decode response."""
  291. if self._response.isclosed():
  292. return 0
  293. prelude = _read(self._response, 8)
  294. prelude_crc = _read(self._response, 4)
  295. if _crc32(prelude) != _int(prelude_crc):
  296. raise IOError(
  297. f"prelude CRC mismatch; expected: {_crc32(prelude)}, "
  298. f"got: {_int(prelude_crc)}"
  299. )
  300. total_length = _int(prelude[:4])
  301. data = _read(self._response, total_length - 8 - 4 - 4)
  302. message_crc = _int(_read(self._response, 4))
  303. if _crc32(prelude + prelude_crc + data) != message_crc:
  304. raise IOError(
  305. f"message CRC mismatch; "
  306. f"expected: {_crc32(prelude + prelude_crc + data)}, "
  307. f"got: {message_crc}"
  308. )
  309. header_length = _int(prelude[4:])
  310. headers = _decode_header(data[:header_length])
  311. if headers.get(":message-type") == "error":
  312. raise MinioException(
  313. f"{headers.get(':error-code')}: "
  314. f"{headers.get(':error-message')}"
  315. )
  316. if headers.get(":event-type") == "End":
  317. return 0
  318. payload_length = total_length - header_length - 16
  319. if headers.get(":event-type") == "Cont" or payload_length < 1:
  320. return self._read()
  321. payload = data[header_length:header_length+payload_length]
  322. if headers.get(":event-type") in ["Progress", "Stats"]:
  323. self._stats = Stats(payload)
  324. return self._read()
  325. if headers.get(":event-type") == "Records":
  326. self._payload = payload
  327. return len(payload)
  328. raise MinioException(
  329. f"unknown event-type {headers.get(':event-type')}",
  330. )
  331. def stream(self, num_bytes=32*1024):
  332. """
  333. Stream extracted payload from response data. Upon completion, caller
  334. should call self.close() to release network resources.
  335. """
  336. while self._read() > 0:
  337. while self._payload:
  338. result = self._payload
  339. if num_bytes < len(self._payload):
  340. result = self._payload[:num_bytes]
  341. self._payload = self._payload[len(result):]
  342. yield result