Source code for pytablewriter.writer._elasticsearch

# encoding: utf-8

.. codeauthor:: Tsuyoshi Hombashi <>

from __future__ import absolute_import, unicode_literals

import copy

import dataproperty
import msgfy
from six.moves import zip
from typepy import Typecode

from ._table_writer import AbstractTableWriter

[docs]class ElasticsearchWriter(AbstractTableWriter): """ A table writer class for Elasticsearch. :Dependency Packages: - `elasticsearch-py <>`__ .. py:attribute:: index_name Alias attribute for |table_name|. .. py:attribute:: document_type Specify document type for indices. Defaults to ``"table"``. .. py:method:: write_table() Create an index and put documents for each row to Elasticsearch. You need to pass an `elasticsearch.Elasticsearch <>`__ instance to |stream| before calling this method. |table_name|/:py:attr:`~pytablewriter.ElasticsearchWriter.index_name` used as the creating index name, invalid characters in the name are replaced with underscore (``'_'``). Document data types for documents are automatically detected from the data. :raises ValueError: If the |stream| has not elasticsearch.Elasticsearch instance. :Example: :ref:`example-elasticsearch-table-writer` """ FORMAT_NAME = "elasticsearch" @property def format_name(self): return self.FORMAT_NAME @property def support_split_write(self): return True @property def table_name(self): return super(ElasticsearchWriter, self).table_name @table_name.setter def table_name(self, value): from ..sanitizer import ElasticsearchIndexNameSanitizer from pathvalidate import ValidationError, ErrorReason try: self._table_name = ElasticsearchIndexNameSanitizer(value).sanitize(replacement_text="_") except ValidationError as e: if e.reason is ErrorReason.NULL_NAME: self._table_name = None else: raise @property def index_name(self): return self.table_name @index_name.setter def index_name(self, value): self.table_name = value def __init__(self): super(ElasticsearchWriter, self).__init__() = None self.is_padding = False self.is_formatting_float = False self._is_require_table_name = True self._quoting_flags = copy.deepcopy(dataproperty.NOT_QUOTING_FLAGS) self._dp_extractor.type_value_map = copy.deepcopy(dataproperty.DefaultValue.TYPE_VALUE_MAP) self.document_type = "table" def write_null_line(self): pass @staticmethod def __get_es_datatype(column_dp): if column_dp.typecode in ( Typecode.NONE, Typecode.NULL_STRING, Typecode.INFINITY, Typecode.NAN, ): return {"type": "keyword"} if column_dp.typecode == Typecode.STRING: return {"type": "text"} if column_dp.typecode == Typecode.DATETIME: return {"type": "date", "format": "date_optional_time"} if column_dp.typecode == Typecode.REAL_NUMBER: return {"type": "double"} if column_dp.typecode == Typecode.BOOL: return {"type": "boolean"} if column_dp.typecode == Typecode.IP_ADDRESS: return {"type": "ip"} if column_dp.typecode == Typecode.INTEGER: if column_dp.bit_length <= 8: return {"type": "byte"} elif column_dp.bit_length <= 16: return {"type": "short"} elif column_dp.bit_length <= 32: return {"type": "integer"} elif column_dp.bit_length <= 64: return {"type": "long"} raise ValueError( "too large integer bits: expected<=64bits, actual={:d}bits".format( column_dp.bit_length ) ) raise ValueError("unknown typecode: {}".format(column_dp.typecode)) def _get_mappings(self): properties = {} for header, column_dp in zip(self.header_list, self._column_dp_list): properties[header] = self.__get_es_datatype(column_dp) return {"mappings": {self.document_type: {"properties": properties}}} def _get_body(self): str_datatype = (Typecode.DATETIME, Typecode.IP_ADDRESS, Typecode.INFINITY, Typecode.NAN) for value_dp_list in self._table_value_dp_matrix: value_list = [ if value_dp.typecode not in str_datatype else value_dp.to_str() for value_dp in value_dp_list ] yield dict(zip(self.header_list, value_list)) def _write_table(self): import elasticsearch as es if not isinstance(, es.Elasticsearch): raise ValueError("stream must be an elasticsearch.Elasticsearch instance") self._verify_value_matrix() self._preprocess() mappings = self._get_mappings() try: result =, body=mappings) self._logger.logger.debug(result) except es.TransportError as e: if e.error == "index_already_exists_exception": # ignore already existing index self._logger.logger.debug(msgfy.to_error_message(e)) else: raise for body in self._get_body(): try:, body=body, doc_type=self.document_type) except es.exceptions.RequestError as e: self._logger.logger.error("{}, body={}".format(msgfy.to_error_message(e), body)) def _write_value_row_separator(self): pass