Elixir Elixir is a declarative layer on top of SQLAlchemy.
Download

Elixir Ranking & Summary

Elixir Tags

SQLAlchemy declarative Elixir declarative layer SQLAlchemy layer define model objects

Elixir Description

Elixir is a declarative layer on top of SQLAlchemy. Elixir is a declarative layer on top of SQLAlchemy. The project is a fairly thin wrapper, which provides the ability to define model objects following the Active Record design pattern, and using a DSL syntax similar to that of the Ruby on Rails ActiveRecord system.Elixir does not intend to replace SQLAlchemy's core features, but instead focuses on providing a simpler syntax for defining model objects when you do not need the full expressiveness of SQLAlchemy's manual mapper definitions.Examples:The Elixir source distribution includes a sample web application that uses the TurboGears web application framework. The application builds upon the tutorial's Movie model to create a simple store for buying movies.The Video Store sample application also includes an example of how to use Elixir with the TurboGears "identity" framework for security and authorization. If you are planning to use Elixir with your TurboGears application, and need to support authorization using identity, you can use this model as a basis:from turbogears.database import metadata, sessionfrom elixir import Unicode, DateTime, String, Integerfrom elixir import Entity, has_field, using_optionsfrom elixir import has_many, belongs_to, has_and_belongs_to_manyfrom sqlalchemy import ForeignKeyfrom datetime import datetimeclass Visit(Entity): has_field('visit_key', String(40), primary_key=True) has_field('created', DateTime, nullable=False, default=datetime.now) has_field('expiry', DateTime) using_options(tablename='visit') @classmethod def lookup_visit(cls, visit_key): return Visit.get(visit_key)class VisitIdentity(Entity): has_field('visit_key', String(40), primary_key=True) has_field('user_id', Integer, ForeignKey('tg_user.user_id', name='user_id_fk', use_alter=True), index=True) using_options(tablename='visit_identity')class Group(Entity): has_field('group_id', Integer, primary_key=True) has_field('group_name', Unicode(16), unique=True) has_field('display_name', Unicode(255)), has_field('created', DateTime, default=datetime.now) has_and_belongs_to_many('users', of_kind='User', inverse='groups') has_and_belongs_to_many('permissions', of_kind='Permission', inverse='groups') using_options(tablename='tg_group')class User(Entity): has_field('user_id', Integer, primary_key=True) has_field('user_name', Unicode(16), unique=True) has_field('email_address', Unicode(255), unique=True) has_field('display_name', Unicode(255)) has_field('password', Unicode(40)) has_field('created', DateTime, default=datetime.now) has_and_belongs_to_many('groups', of_kind='Group', inverse='users') using_options(tablename='tg_user') @property def permissions(self): perms = set() for g in self.groups: perms = perms | set(g.permissions) return permsclass Permission(Entity): has_field('permission_id', Integer, primary_key=True) has_field('permission_name', Unicode(16), unique=True) has_field('description', Unicode(255)) has_and_belongs_to_many('groups', of_kind='Group', inverse='permissions') using_options(tablename='permission')More Elixir examples are coming soon, and we would appreciate any additional sample applications that you could provide to illustrate more complex mappings. Requirements: · SQLAlchemy · Python

Elixir Related Software