msql-driver 0.3.0

Mireo SpaceTime MSQL connector

Mireo SpaceTime MSQL connector

msql-driver is a Python module for querying Mireo SpaceTime database using MSQL query language.

Features

• Both blocking and asynchronous modes of operation are available.
• Query results are convertible to Python lists, NumPy arrays and Pandas dataframes.

Installation

pip install msql-driver
Conversions to NumPy and Pandas data types require those packages that can be installed as optional dependencies.

Example

import msql_driver

# Connect
session = msql_driver.SessionBuilder().host(<address>).user(<org>, <user>, <password>).build()
print(session.status())  # SessionStatus.Connected

# Run query
res, = session.run_query("select * from st.segment limit 10")

# Print column names and their MSQL data types
print(res.fields)

# Iterating over rows converts each lazily to a Python list of appropriate Python data types
for row in res:
	print(row)

# Query result can be converted to:
rows = res.to_list()  # Python list of lists of appropriate Python data types
arr = res.to_numpy()  # NumPy array of appropriate NumPy data types (requires numpy)
df = res.to_pandas()  # Pandas dataframe of appropriate NumPy/Pandas data types (requires pandas)

# Disconnect
session.stop()
print(session.status())  # SessionStatus.Stopped

License

Licensed under BSD 3-Clause “New” or “Revised” License.

Credits

Authored and maintained by Mireo.