obspy.clients.filesystem.tsindex.TSIndexDatabaseHandler

class TSIndexDatabaseHandler(database=None, tsindex_table='tsindex', tsindex_summary_table='tsindex_summary', session=None, loglevel='WARNING')[source]

Bases: builtins.object

Supports direct tsindex database data access and manipulation.

Attributes

__dict__
__doc__ str(object=’‘) -> str
__module__ str(object=’‘) -> str
__weakref__ list of weak references to the object (if defined)

Public Methods

build_tsindex_summary Builds a tsindex_summary table using the table name supplied to the
get_tsindex_summary_cte
rtype:sqlalchemy.sql.expression.CTE
has_tsindex Returns True if there is a tsindex table in the database.
has_tsindex_summary Returns True if there is a tsindex_summary table in the database.

Private Methods

Warning

Private methods are mainly for internal/developer use and their API might change without notice.

_clean_query_rows Reformats query rows to match what is stored in the database.
_create_query_row Returns a tuple (network, station, location, channel, starttime, endtime) with elements that have been formatted to match database entries.
_fetch_index_rows Fetch index rows matching specified request.
_fetch_summary_rows Fetch summary rows matching specified request.
_format_date
_set_sqlite_pragma Setup a sqlite3 database for indexing.

Special Methods

__dir__ default dir() implementation
__format__ default object formatter
__init__ Main query interface to timeseries index database.
__new__ Create and return a new object.
__reduce__ helper for pickle
__reduce_ex__ helper for pickle
__sizeof__ size of object in memory, in bytes
__subclasshook__ Abstract classes can override this to customize issubclass().