Python client for SliceUp
Project description
Sliceup
Python client of the SliceUp API
Installing
$ pip install sliceup
Examples
Importing
from sliceup import *
Database summary
from sliceup import * sliceup = Sliceup('demo.sliceup.co') response = sliceup.summary() if response: print(response.content) else: print('An error has occurred.')
Create a table
from sliceup import * sliceup = Sliceup('demo.sliceup.co') response = sliceup.create({ 'name': 'orders', 'columns': [ {'name': 'time', 'type': 'time'}, {'name': 'qty', 'type': 'int'}, {'name': 'price', 'type': 'float'} ], 'recreate': True }) if response: print(response.content) else: print('An error has occurred.')
Insert data
from sliceup import * sliceup = Sliceup('demo.sliceup.co') response = sliceup.insert({ 'name': 'orders', 'rows': [ {'time': '00:00:00', 'qty': 2, 'price': 9.0}, {'time': '00:30:09', 'qty': 2, 'price': 2.0}, {'time': '01:45:01', 'qty': 4, 'price': 1.0}, {'time': '12:10:33', 'qty': 10, 'price': 16.0}, {'time': '16:00:09', 'qty': 4, 'price': 8.0}, {'time': '22:00:00', 'qty': 4, 'price': 23.0}, {'time': '22:31:49', 'qty': 4, 'price': 45.0}, {'time': '22:59:19', 'qty': 4, 'price': 17.0}, ] }) if response: print(response.content) else: print('An error has occurred.')
Query data
Check out in RunKit
Select from table
from sliceup import * sliceup = Sliceup('demo.sliceup.co') response = sliceup.query({ 'select': ['time', 'qty', 'price'], 'from': 'orders' }) if response: print(response.content) else: print('An error has occurred.')
Visualize data
from sliceup import * sliceup = Sliceup('demo.sliceup.co') response = sliceup.query({ 'select': ['time', 'qty', 'price'], 'from': 'orders' }) if response: print(response.content) else: print('An error has occurred.')
Query table statistics
from sliceup import * sliceup = Sliceup('demo.sliceup.co') response = sliceup.query({ 'select': [max('time'), min('time'), min('qty'), max('qty'), min('price'), max('price')], 'from': 'orders' }) if response: print(response.content) else: print('An error has occurred.')
Slice the data into hour buckets
from sliceup import * sliceup = Sliceup('demo.sliceup.co') response = sliceup.query({ 'select': count('price'), 'by': bar('time', time(1,0,0)), 'from': 'orders' }) if response: print(response.content) else: print('An error has occurred.')
Slice and group the quantity by bars of 2
from sliceup import * sliceup = Sliceup('demo.sliceup.co') response = sliceup.query({ 'select': count('price'), 'by': bar('qty', 2), 'from': 'orders' }) if response: print(response.content) else: print('An error has occurred.')
License
Sliceup is copyright (c) 2019-present SliceUp, Inc.
Sliceup is free software, licensed under the MIT. See the LICENSE file for more details.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sliceup-0.2.0.tar.gz
(4.5 kB
view hashes)