skip to navigation
skip to content

Not Logged In

htables 0.4b4

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

Package Documentation

Latest Version: 0.5.1

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)
 
File Type Py Version Uploaded on Size
htables-0.4b4.zip (md5) Source 2012-08-08 7KB
  • Downloads (All Versions):
  • 17 downloads in the last day
  • 121 downloads in the last week
  • 437 downloads in the last month