abstract interface with remote database table
Project description
TableCrow
tablecrow
is an abstraction library over a generalized database table.
Currently, tablecrow
offers an abstraction for PostGreSQL tables with simple PostGIS operations.
pip install tablecrow
Python API:
from datetime import datetime
from tablecrow import PostGresTable
hostname = 'localhost:5432'
database = 'postgres'
table = 'test'
username = 'postgres'
password = '<password>'
# parameters for an SSH tunnel
ssh_hostname = None
ssh_username = None
ssh_password = None
fields = {
'id' : int,
'time' : datetime,
'length': float,
'name' : str
}
table = PostGresTable(hostname, database, table, fields, username=username, password=password,
ssh_hostname=ssh_hostname, ssh_username=ssh_username, ssh_password=ssh_password)
table.insert([
{'id': 1, 'time': datetime(2020, 1, 1), 'length': 4.4, 'name': 'long boi'},
{'id': 3, 'time': datetime(2020, 1, 3), 'length': 2, 'name': 'short boi'},
{'id': 2, 'time': datetime(2020, 1, 2)}
])
table[4] = {'time': datetime(2020, 1, 4), 'length': 5, 'name': 'long'}
record_with_id_3 = table[3]
short_records = table.records_where({'name': 'short boi'})
long_records = table.records_where({'name': '%long%'})
early_records = table.records_where("time <= '20200102'::date")
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
tablecrow-1.0.4.tar.gz
(10.0 kB
view hashes)
Built Distribution
tablecrow-1.0.4-py3-none-any.whl
(11.1 kB
view hashes)
Close
Hashes for tablecrow-1.0.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a847b02cb6c803f1e9ad5b1826a622acd6a8220cd9ca30437b5be6c95385ebf5 |
|
MD5 | 8b575859725187d114ea623cd5e2d790 |
|
BLAKE2b-256 | 1e8d7075cf89c649d9f57c691e5ac9d221c7d5dfadf87bc18529e65363207613 |