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

1.4.7

Mar 6, 2023

1.4.6

Dec 26, 2022

1.4.5

Mar 4, 2022

1.4.4

Nov 17, 2021

1.4.3

Nov 16, 2021

1.4.2

Nov 16, 2021

1.4.1

Nov 16, 2021

1.4.0

Nov 15, 2021

1.3.9

Jul 10, 2021

1.3.8

Jul 10, 2021

1.3.7

May 27, 2021

1.3.6

May 8, 2021

1.3.5

Mar 21, 2021

1.3.4

Mar 14, 2021

1.3.3

Mar 10, 2021

1.3.2

Mar 9, 2021

1.3.1

Mar 9, 2021

1.3.0

Mar 8, 2021

1.2.6

Jan 31, 2021

1.2.5

Jan 31, 2021

1.2.4

Jan 31, 2021

1.2.3

Dec 14, 2020

1.2.2

Dec 14, 2020

1.2.1

Dec 13, 2020

1.2.0

Dec 13, 2020

1.1.8

Nov 6, 2020

1.1.8a0 pre-release

Nov 6, 2020

1.1.7

Nov 5, 2020

1.1.6

Nov 5, 2020

1.1.5

Nov 2, 2020

1.1.4

Oct 29, 2020

1.1.3

Oct 29, 2020

1.1.2

Oct 29, 2020

1.1.1

Oct 27, 2020

1.1.0

Oct 23, 2020

1.0.6

Oct 23, 2020

1.0.5

Oct 20, 2020

1.0.4

Oct 20, 2020

This version

1.0.3

Oct 20, 2020

1.0.2

Oct 20, 2020

1.0.1

Oct 19, 2020

1.0.0

Oct 13, 2020

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.3.tar.gz (10.0 kB view details)

Uploaded Oct 20, 2020 Source

Built Distribution

tablecrow-1.0.3-py3-none-any.whl (11.1 kB view details)

Uploaded Oct 20, 2020 Python 3

File details

Details for the file tablecrow-1.0.3.tar.gz.

File metadata

Download URL: tablecrow-1.0.3.tar.gz
Upload date: Oct 20, 2020
Size: 10.0 kB
Tags: Source
Uploaded using Trusted Publishing? No
Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/49.2.1 requests-toolbelt/0.9.1 tqdm/4.50.2 CPython/3.9.0

File hashes

Hashes for tablecrow-1.0.3.tar.gz
Algorithm	Hash digest
SHA256	`87f86d495783934ac5f34df51a007f807d275fa796de30c52a58c539d8259827`
MD5	`17a8755173a36db434a52b628bc9cfde`
BLAKE2b-256	`dd1e5101f162974626eb6801a3c46d8b9e376e36f017d439477e6f7d01667cc9`

See more details on using hashes here.

Provenance

File details

Details for the file tablecrow-1.0.3-py3-none-any.whl.

File metadata

Download URL: tablecrow-1.0.3-py3-none-any.whl
Upload date: Oct 20, 2020
Size: 11.1 kB
Tags: Python 3
Uploaded using Trusted Publishing? No
Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/49.2.1 requests-toolbelt/0.9.1 tqdm/4.50.2 CPython/3.9.0

File hashes

Hashes for tablecrow-1.0.3-py3-none-any.whl
Algorithm	Hash digest
SHA256	`af6da0ca6c8ca0fa7e2b3df970b9adfa05d4f76b5447f318524c3c78153a1a55`
MD5	`eb72ac04b9c4a1171d8bde6f25ff82e1`
BLAKE2b-256	`cf84a1f89fa0cd961179da1ca0fae613a29b51190f6f6ee2af529d62288e4f20`