Skip to main content

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

Project description

HTables is a database library for storing mapping objects in a relational database. Two backends are supported so far: ~htables.PostgresqlDB (using the hstore extension; requires psycopg2) and ~htables.SQLiteDB.

>>> import htables
>>> db = htables.SqliteDB(':memory:')
>>> session = db.get_session()
>>> session['tweet'].create_table()
>>> session.commit()

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

>>> tweet_table = session['tweet']
>>> tweet = tweet_table.new(message="Hello world!")
>>> tweet['author'] = '1337 h4x0r'
>>> tweet.save()
>>> session.commit()

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

>>> [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)

Project details


Release history Release notifications

History Node

0.5.1

History Node

0.5

History Node

0.4

History Node

0.4b5

This version
History Node

0.4b4

Download files

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

Filename, size & hash SHA256 hash help File type Python version Upload date
htables-0.4b4.zip (7.7 kB) Copy SHA256 hash SHA256 Source None Aug 8, 2012

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page