skip to navigation
skip to content

sqla_declarative 0.2

Extended SQLAlchemy declarative_base class


This package provides an extended Base class for your SQLAlchemy classes.
What this class proposes:
* the __tablename__ to create/use for the class is automatically defined by class.__name__.lower().
* it adds a property pk_id which returns the value of the primary key for the object.
* it attaches a query object to the class which is a shortcut to session.query(class).
* Function which returns all the DB entry in a HTML table
* Function to edit/add new entry as a HTML form

Example of usage::

import sqlalchemy as sa
from sqlalchemy.orm import (
from zope.sqlalchemy import ZopeTransactionExtension
from sqla_declarative import extended_declarative_base

session = scoped_session(sessionmaker(extension=ZopeTransactionExtension()))
Base = extended_declarative_base(

class Test1(Base):
id = sa.Column(sa.Integer, primary_key=True)
name = sa.Column(sa.String(50))

bob = Test1(name='Bob')

# pk_id detects automatically the primary key and returns it value
bob.pk_id == 1
# Easy querying. For example: == bob

# To see all the existing entry as HTML

# To add/update a new entry as HTML
widget = Test1.edit_form()
File Type Py Version Uploaded on Size
sqla_declarative-0.2.tar.gz (md5) Source 2013-01-10 3KB