This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (pypi.python.org).
Help us improve Python packaging - Donate today!

htables is a database library for storing mapping objects in a relational database.

Project Description

HTables is a library for storing string-to-string mapping objects in a database. Two backends are supported so far: ~htables.PostgresqlDB and ~htables.SqliteDB.

>>> import htables
>>> db = htables.SqliteDB(':memory:')
>>> with db.session() as dbs:
...     dbs['tweet'].create_table()
...     dbs['tweet'].new(text="Hello world!")
...     dbs.commit()

Tables are collections of Rows. A row is basically a dictionary with an extra id property. Its keys and values must be strings.

>>> with db.session() as dbs:
...     tweet = dbs['tweet'].find_first()
...     tweet['author'] = '1337 h4x0r'
...     tweet.save()
...     dbs.commit()

There are many ways of retrieving rows. The following all fetch the same record:

>>> with db.session() as dbs:
...     tweet_table = dbs['tweet']
...     [tweet] = list(tweet_table.find())
...     [tweet] = list(tweet_table.find(author='1337 h4x0r'))
...     tweet = tweet_table.find_first()
...     tweet = tweet_table.find_single()
...     tweet = tweet_table.get(1)
Release History

Release History

This version
History Node

0.5.1

History Node

0.5

History Node

0.4

History Node

0.4b5

History Node

0.4b4

Download Files

Download Files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
htables-0.5.1.zip (8.9 kB) Copy SHA256 Checksum SHA256 Source Sep 10, 2012

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting