/pony

Pony Object Relational Mapper

Primary LanguagePythonGNU Affero General Public License v3.0AGPL-3.0

Pony Object-Relational Mapper
-----------------------------
Pony is an object-relational mapper. The most interesting feature of Pony is its ability to write queries to the database using generator expressions. Pony works with entities which are mapped to a SQL database. Using generator syntax for writing queries allows the user to formulate very eloquent queries. It increases the level of abstraction and allows a programmer to concentrate on the business logic of the application. For this purpose Pony analyzes the abstract syntax tree of a generator and translates it to its SQL equivalent.

Following is an example of a query in Pony:

    select(p for p in Product if p.name.startswith('A') and p.cost <= 1000)

Pony translates queries to SQL using a specific database dialect. Currently Pony works with SQLite, MySQL, PostgreSQL and Oracle databases.

The package pony.orm.examples contains several examples.
Documenation is available at http://ponyorm.com

License
---------
Pony ORM is released under the GNU Affero General Public License version 3. 
http://www.gnu.org/licenses/agpl

Copyright (c) 2006-2013 Alexander Kozlovsky, Alexey Malashkevich. All rights reserved. 
team (at) ponyorm.com