# Mireo SpaceTime MSQL connector
**msql-driver** is a Python module for querying [Mireo SpaceTime database](https://www.mireo.com/spacetime) using [MSQL query language](https://spacetime.mireo.com/msql/).
## 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 --upgrade`\
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](https://choosealicense.com/licenses/bsd-3-clause/).
## Credits
Authored and maintained by [Mireo](https://www.mireo.com).
Raw data
{
"_id": null,
"home_page": null,
"name": "msql-driver",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.8",
"maintainer_email": "Hrvoje Stojanovi\u0107 <hrvoje.stojanovic@mireo.com>, Zvonimir Jurelinac <zvonimir.jurelinac@mireo.com>",
"keywords": "mireo, spacetime, msql, connector, sql, query, spatiotemporal, database",
"author": "Mireo",
"author_email": null,
"download_url": null,
"platform": null,
"description": "# Mireo SpaceTime MSQL connector\r\n**msql-driver** is a Python module for querying [Mireo SpaceTime database](https://www.mireo.com/spacetime) using [MSQL query language](https://spacetime.mireo.com/msql/).\r\n\r\n## Features\r\n- Both **blocking** and **asynchronous** modes of operation are available.\r\n- Query results are convertible to **Python lists**, **NumPy arrays** and **Pandas dataframes**.\r\n\r\n## Installation\r\n`pip install msql-driver --upgrade`\\\r\nConversions to NumPy and Pandas data types require those packages that can be installed as optional dependencies.\r\n\r\n## Example\r\n```\r\nimport msql_driver\r\n\r\n# Connect\r\nsession = msql_driver.SessionBuilder().host(<address>).user(<org>, <user>, <password>).build()\r\nprint(session.status()) # SessionStatus.Connected\r\n\r\n# Run query\r\nres, = session.run_query(\"select * from st.segment limit 10\")\r\n\r\n# Print column names and their MSQL data types\r\nprint(res.fields)\r\n\r\n# Iterating over rows converts each lazily to a Python list of appropriate Python data types\r\nfor row in res:\r\n\tprint(row)\r\n\r\n# Query result can be converted to:\r\nrows = res.to_list() # Python list of lists of appropriate Python data types\r\narr = res.to_numpy() # NumPy array of appropriate NumPy data types (requires numpy)\r\ndf = res.to_pandas() # Pandas dataframe of appropriate NumPy/Pandas data types (requires pandas)\r\n\r\n# Disconnect\r\nsession.stop()\r\nprint(session.status()) # SessionStatus.Stopped\r\n```\r\n\r\n## License\r\nLicensed under [BSD 3-Clause \u201cNew\u201d or \u201cRevised\u201d License](https://choosealicense.com/licenses/bsd-3-clause/).\r\n\r\n## Credits\r\nAuthored and maintained by [Mireo](https://www.mireo.com).\r\n\n",
"bugtrack_url": null,
"license": null,
"summary": "Mireo SpaceTime MSQL connector",
"version": "0.5.0",
"project_urls": {
"Homepage": "https://www.mireo.com/spacetime",
"MSQL Reference": "https://spacetime.mireo.com/msql/",
"SpaceTime Live Demo": "https://spacetime.mireo.com/"
},
"split_keywords": [
"mireo",
" spacetime",
" msql",
" connector",
" sql",
" query",
" spatiotemporal",
" database"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "36ffd283e04c58a3612207d3af824c6da97b61cfd57a73ab262cf8e98dc1e046",
"md5": "94b4083273a2a2c81ed99e1e64fd103c",
"sha256": "18bc79cb90e01194c4cac3a481e44ac39c82dcaea794157e0aac7cb35571b365"
},
"downloads": -1,
"filename": "msql_driver-0.5.0-cp38-abi3-macosx_10_12_x86_64.whl",
"has_sig": false,
"md5_digest": "94b4083273a2a2c81ed99e1e64fd103c",
"packagetype": "bdist_wheel",
"python_version": "cp38",
"requires_python": ">=3.8",
"size": 473967,
"upload_time": "2024-09-23T13:37:22",
"upload_time_iso_8601": "2024-09-23T13:37:22.417846Z",
"url": "https://files.pythonhosted.org/packages/36/ff/d283e04c58a3612207d3af824c6da97b61cfd57a73ab262cf8e98dc1e046/msql_driver-0.5.0-cp38-abi3-macosx_10_12_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "8a5832d625a86aa84ad56a4ae4627cfd5bbc0c37d7114a4679c0ed47fbad6f90",
"md5": "e9b814b11d35813200e02809f13379b5",
"sha256": "1edc91c172d96aed02c06086d5c059c00773e6e4d1329c78d4249fb156c75987"
},
"downloads": -1,
"filename": "msql_driver-0.5.0-cp38-abi3-macosx_11_0_arm64.whl",
"has_sig": false,
"md5_digest": "e9b814b11d35813200e02809f13379b5",
"packagetype": "bdist_wheel",
"python_version": "cp38",
"requires_python": ">=3.8",
"size": 451616,
"upload_time": "2024-09-23T13:37:44",
"upload_time_iso_8601": "2024-09-23T13:37:44.184319Z",
"url": "https://files.pythonhosted.org/packages/8a/58/32d625a86aa84ad56a4ae4627cfd5bbc0c37d7114a4679c0ed47fbad6f90/msql_driver-0.5.0-cp38-abi3-macosx_11_0_arm64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "8650ac6262b8907ec732059a70f060bfa926581fed813f2ddcd1a445d4876a67",
"md5": "6ce22a7dd32ab8a19a2153e6484c7530",
"sha256": "de5a17b9de82375f286e71043855f4ae5bbdfbe5b2105579a6d4c973604d559f"
},
"downloads": -1,
"filename": "msql_driver-0.5.0-cp38-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl",
"has_sig": false,
"md5_digest": "6ce22a7dd32ab8a19a2153e6484c7530",
"packagetype": "bdist_wheel",
"python_version": "cp38",
"requires_python": ">=3.8",
"size": 488318,
"upload_time": "2024-09-23T13:36:17",
"upload_time_iso_8601": "2024-09-23T13:36:17.207660Z",
"url": "https://files.pythonhosted.org/packages/86/50/ac6262b8907ec732059a70f060bfa926581fed813f2ddcd1a445d4876a67/msql_driver-0.5.0-cp38-abi3-manylinux_2_17_aarch64.manylinux2014_aarch64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "aa6e3327f3517d3e6b4ed89f86681733ecd10403102c21ec9239e67ab0528170",
"md5": "857d1dc13a40bb35ac509e889f754faf",
"sha256": "748fedeea928fe8ab43490dde7c0a3945f0cb443066843a25a3c7aff71ac3c91"
},
"downloads": -1,
"filename": "msql_driver-0.5.0-cp38-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"has_sig": false,
"md5_digest": "857d1dc13a40bb35ac509e889f754faf",
"packagetype": "bdist_wheel",
"python_version": "cp38",
"requires_python": ">=3.8",
"size": 510978,
"upload_time": "2024-09-23T13:35:55",
"upload_time_iso_8601": "2024-09-23T13:35:55.783521Z",
"url": "https://files.pythonhosted.org/packages/aa/6e/3327f3517d3e6b4ed89f86681733ecd10403102c21ec9239e67ab0528170/msql_driver-0.5.0-cp38-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "5c1d435378eadf856898ed0e4ae26fd0b8b82a1d3f0a5427e3d383688eb1c504",
"md5": "414581cd96e68e7de82579d9f536a0de",
"sha256": "f5742402bff88752cdbeaf38eb46c102649c6f1892e004e216afd2b7b6b57b3e"
},
"downloads": -1,
"filename": "msql_driver-0.5.0-cp38-abi3-musllinux_1_2_aarch64.whl",
"has_sig": false,
"md5_digest": "414581cd96e68e7de82579d9f536a0de",
"packagetype": "bdist_wheel",
"python_version": "cp38",
"requires_python": ">=3.8",
"size": 482183,
"upload_time": "2024-09-23T13:37:01",
"upload_time_iso_8601": "2024-09-23T13:37:01.143582Z",
"url": "https://files.pythonhosted.org/packages/5c/1d/435378eadf856898ed0e4ae26fd0b8b82a1d3f0a5427e3d383688eb1c504/msql_driver-0.5.0-cp38-abi3-musllinux_1_2_aarch64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "5597ed6354d6ee224e272c55f548b0fa45f82c45a6719cdb35c488867eaed489",
"md5": "5245ee90fc2469a4796b52434901bcb2",
"sha256": "448e1a8ea991b8418f02dd38af4a2fb2869c8068c571d3c4915044241cbe8778"
},
"downloads": -1,
"filename": "msql_driver-0.5.0-cp38-abi3-musllinux_1_2_x86_64.whl",
"has_sig": false,
"md5_digest": "5245ee90fc2469a4796b52434901bcb2",
"packagetype": "bdist_wheel",
"python_version": "cp38",
"requires_python": ">=3.8",
"size": 508470,
"upload_time": "2024-09-23T13:36:39",
"upload_time_iso_8601": "2024-09-23T13:36:39.509521Z",
"url": "https://files.pythonhosted.org/packages/55/97/ed6354d6ee224e272c55f548b0fa45f82c45a6719cdb35c488867eaed489/msql_driver-0.5.0-cp38-abi3-musllinux_1_2_x86_64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "36f5ae82aa8a43187d4c9118e29ee94ac0b020aa4d965722f2da6ea4d460ec32",
"md5": "1c8f6247f46ed29b834fb148c84f8865",
"sha256": "077e03e9a1a407c2586b9339ebd3a1b086640865e519ef3ddd76d0e9f40480ba"
},
"downloads": -1,
"filename": "msql_driver-0.5.0-cp38-abi3-win_amd64.whl",
"has_sig": false,
"md5_digest": "1c8f6247f46ed29b834fb148c84f8865",
"packagetype": "bdist_wheel",
"python_version": "cp38",
"requires_python": ">=3.8",
"size": 438970,
"upload_time": "2024-09-23T13:35:11",
"upload_time_iso_8601": "2024-09-23T13:35:11.121357Z",
"url": "https://files.pythonhosted.org/packages/36/f5/ae82aa8a43187d4c9118e29ee94ac0b020aa4d965722f2da6ea4d460ec32/msql_driver-0.5.0-cp38-abi3-win_amd64.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "a5a2d4d5d2a4feb6367fe328b48adc1aae5d0c6ee5f48881172e6b7673d13670",
"md5": "ab325f3b884737cb8f701a100657eb15",
"sha256": "829893624277186607abe3704cfccc962faf7f69f3b6a85ad24fef87a17ef61f"
},
"downloads": -1,
"filename": "msql_driver-0.5.0-cp38-abi3-win_arm64.whl",
"has_sig": false,
"md5_digest": "ab325f3b884737cb8f701a100657eb15",
"packagetype": "bdist_wheel",
"python_version": "cp38",
"requires_python": ">=3.8",
"size": 416980,
"upload_time": "2024-09-23T13:35:31",
"upload_time_iso_8601": "2024-09-23T13:35:31.179117Z",
"url": "https://files.pythonhosted.org/packages/a5/a2/d4d5d2a4feb6367fe328b48adc1aae5d0c6ee5f48881172e6b7673d13670/msql_driver-0.5.0-cp38-abi3-win_arm64.whl",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-09-23 13:37:22",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "msql-driver"
}
JSON