{ "info": { "author": "SliceUp, Inc", "author_email": "info@sliceup.com", "bugtrack_url": null, "classifiers": [ "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python :: 3" ], "description": "# Sliceup\n\n![PyPI](https://img.shields.io/pypi/v/sliceup) ![PyPI - Downloads](https://img.shields.io/pypi/dm/sliceup) ![GitHub](https://img.shields.io/github/license/sliceup/sliceup-python)\n\nPython client of the SliceUp API\n\nInstalling\n---\n```bash\n$ pip install sliceup\n```\n\nExamples\n---\n\n### Importing\n\n```python\nfrom sliceup import *\n```\n\n### Database summary\n\n```python\nfrom sliceup import *\n\nsliceup = Sliceup('demo.sliceup.co')\n\nresponse = sliceup.summary()\n\nif response:\n print(response.content)\nelse:\n print('An error has occurred.')\n```\n\n### Create a table\n\n```python\nfrom sliceup import *\n\nsliceup = Sliceup('demo.sliceup.co')\n\nresponse = sliceup.create({\n 'name': 'orders',\n 'columns': [\n {'name': 'time', 'type': 'time'},\n {'name': 'qty', 'type': 'int'},\n {'name': 'price', 'type': 'float'}\n ],\n 'recreate': True\n})\n\nif response:\n print(response.content)\nelse:\n print('An error has occurred.')\n```\n\n### Insert data\n\n```python\nfrom sliceup import *\n\nsliceup = Sliceup('demo.sliceup.co')\n\nresponse = sliceup.insert({\n 'name': 'orders', \n 'rows': [\n {'time': '00:00:00', 'qty': 2, 'price': 9.0},\n {'time': '00:30:09', 'qty': 2, 'price': 2.0},\n {'time': '01:45:01', 'qty': 4, 'price': 1.0},\n {'time': '12:10:33', 'qty': 10, 'price': 16.0},\n {'time': '16:00:09', 'qty': 4, 'price': 8.0},\n {'time': '22:00:00', 'qty': 4, 'price': 23.0},\n {'time': '22:31:49', 'qty': 4, 'price': 45.0},\n {'time': '22:59:19', 'qty': 4, 'price': 17.0},\n ]\n})\n\nif response:\n print(response.content)\nelse:\n print('An error has occurred.')\n```\n\n### Query data\n*Check out in [RunKit](https://runkit.com/sliceup/5d7c162cea9933001c32a424)*\n\n#### Select from table\n\n```python\nfrom sliceup import *\n\nsliceup = Sliceup('demo.sliceup.co')\n\nresponse = sliceup.query({\n 'select': ['time', 'qty', 'price'],\n 'from': 'orders'\n})\n\nif response:\n print(response.content)\nelse:\n print('An error has occurred.')\n```\n\n#### Visualize data\n\n```python\nfrom sliceup import *\n\nsliceup = Sliceup('demo.sliceup.co')\n\nresponse = sliceup.query({\n 'select': ['time', 'qty', 'price'],\n 'from': 'orders'\n})\n\nif response:\n print(response.content)\nelse:\n print('An error has occurred.')\n```\n\n#### Query table statistics\n\n```python\nfrom sliceup import *\n\nsliceup = Sliceup('demo.sliceup.co')\n\nresponse = sliceup.query({\n 'select': [max('time'), min('time'), min('qty'), max('qty'), min('price'), max('price')],\n 'from': 'orders'\n})\n\nif response:\n print(response.content)\nelse:\n print('An error has occurred.')\n```\n\n#### Slice the data into hour buckets\n\n```python\nfrom sliceup import *\n\nsliceup = Sliceup('demo.sliceup.co')\n\nresponse = sliceup.query({\n 'select': count('price'),\n 'by': bar('time', time(1,0,0)),\n 'from': 'orders'\n})\n\nif response:\n print(response.content)\nelse:\n print('An error has occurred.')\n```\n\n#### Slice and group the quantity by bars of 2\n\n```python\nfrom sliceup import *\n\nsliceup = Sliceup('demo.sliceup.co')\n\nresponse = sliceup.query({\n 'select': count('price'),\n 'by': bar('qty', 2),\n 'from': 'orders'\n})\n\nif response:\n print(response.content)\nelse:\n print('An error has occurred.')\n```\n\nLicense\n---\n\nSliceup is copyright (c) 2019-present SliceUp, Inc.\n\nSliceup is free software, licensed under the MIT. See the LICENSE file for more details.\n\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/sliceup/sliceup-python", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "sliceup", "package_url": "https://pypi.org/project/sliceup/", "platform": "", "project_url": "https://pypi.org/project/sliceup/", "project_urls": { "Homepage": "https://github.com/sliceup/sliceup-python" }, "release_url": "https://pypi.org/project/sliceup/0.2.0/", "requires_dist": null, "requires_python": ">=3.6", "summary": "Python client for SliceUp", "version": "0.2.0" }, "last_serial": 5881989, "releases": { "0.0.4": [ { "comment_text": "", "digests": { "md5": "81115bc80b751107247808283ff547fc", "sha256": "8afbde3d740557ae82a13ce4677256743f5300fcc6e58b322886f111d33599f7" }, "downloads": -1, "filename": "sliceup-0.0.4-py3-none-any.whl", "has_sig": false, "md5_digest": "81115bc80b751107247808283ff547fc", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.6", "size": 3210, "upload_time": "2019-09-04T21:24:38", "url": "https://files.pythonhosted.org/packages/e4/b6/32af599d2f304b8db682443314d010c7f98b3c6d444188b064dc6936c7bb/sliceup-0.0.4-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "b2a021c21af8223a78cc61eed95ce9cb", "sha256": "abe6d13540dce88e957f9bfa61419ddad17a78aa2bddf70a964638afd94d025d" }, "downloads": -1, "filename": "sliceup-0.0.4.tar.gz", "has_sig": false, "md5_digest": "b2a021c21af8223a78cc61eed95ce9cb", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 1719, "upload_time": "2019-09-04T21:24:40", "url": "https://files.pythonhosted.org/packages/c4/6f/1cc692585a797bb634557cde4ff499e9956d9e9ddcede4e96969c31fc02c/sliceup-0.0.4.tar.gz" } ], "0.1.0": [ { "comment_text": "", "digests": { "md5": "4844b2d387e699e844658c2053e17ac9", "sha256": "0aa3f038a1ece4a0fd4ca75de5fece4a6e85a4f34a5afbc7feff64b0b59b41da" }, "downloads": -1, "filename": "sliceup-0.1.0-py3-none-any.whl", "has_sig": false, "md5_digest": "4844b2d387e699e844658c2053e17ac9", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.6", "size": 4751, "upload_time": "2019-09-17T22:01:54", "url": "https://files.pythonhosted.org/packages/c7/9b/71a443c84952ea75ed2a7167941fb7501e99eca950af8701ef60ff05a8dc/sliceup-0.1.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "3bc64d0ea232a970cc189b2891632fcd", "sha256": "9276a3e263f6fa06b5a7b64d10513473e102d93692628ba5bfc6bdabfa9a9ca5" }, "downloads": -1, "filename": "sliceup-0.1.0.tar.gz", "has_sig": false, "md5_digest": "3bc64d0ea232a970cc189b2891632fcd", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 3267, "upload_time": "2019-09-17T22:01:55", "url": "https://files.pythonhosted.org/packages/e1/f8/bf0e20ba00eb72508b8e1f2cbf6d2ce342d0314841ffc6db669f16206670/sliceup-0.1.0.tar.gz" } ], "0.2.0": [ { "comment_text": "", "digests": { "md5": "6d332554f67d739d406971994dc31090", "sha256": "faab207aef070d914382c90aac61e6baeb3cb5c96401690f2e9bc1c1cbdfb62c" }, "downloads": -1, "filename": "sliceup-0.2.0-py3-none-any.whl", "has_sig": false, "md5_digest": "6d332554f67d739d406971994dc31090", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.6", "size": 5682, "upload_time": "2019-09-24T21:37:26", "url": "https://files.pythonhosted.org/packages/69/a9/3b562650dc893b1eec081308cd4d2bb2c0813d75715f16cbdde38da44c10/sliceup-0.2.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "6bedfef7829206fee6c54f5f8f65e1d0", "sha256": "cf116a8f3b6bce123032d65d9bf73d398c24e269e714c51c6a9458a6d77bb4b8" }, "downloads": -1, "filename": "sliceup-0.2.0.tar.gz", "has_sig": false, "md5_digest": "6bedfef7829206fee6c54f5f8f65e1d0", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 4506, "upload_time": "2019-09-24T21:37:29", "url": "https://files.pythonhosted.org/packages/54/c3/821c565d8f6d59ae94b48c62726f75de832f0f86cf3c1878990f10a17479/sliceup-0.2.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "6d332554f67d739d406971994dc31090", "sha256": "faab207aef070d914382c90aac61e6baeb3cb5c96401690f2e9bc1c1cbdfb62c" }, "downloads": -1, "filename": "sliceup-0.2.0-py3-none-any.whl", "has_sig": false, "md5_digest": "6d332554f67d739d406971994dc31090", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.6", "size": 5682, "upload_time": "2019-09-24T21:37:26", "url": "https://files.pythonhosted.org/packages/69/a9/3b562650dc893b1eec081308cd4d2bb2c0813d75715f16cbdde38da44c10/sliceup-0.2.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "6bedfef7829206fee6c54f5f8f65e1d0", "sha256": "cf116a8f3b6bce123032d65d9bf73d398c24e269e714c51c6a9458a6d77bb4b8" }, "downloads": -1, "filename": "sliceup-0.2.0.tar.gz", "has_sig": false, "md5_digest": "6bedfef7829206fee6c54f5f8f65e1d0", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 4506, "upload_time": "2019-09-24T21:37:29", "url": "https://files.pythonhosted.org/packages/54/c3/821c565d8f6d59ae94b48c62726f75de832f0f86cf3c1878990f10a17479/sliceup-0.2.0.tar.gz" } ] }