Skip to content

Instantly share code, notes, and snippets.

@suzaku

suzaku/test.md

Created April 20, 2013 14:05
Show Gist options
  • Save suzaku/5426099 to your computer and use it in GitHub Desktop.
Save suzaku/5426099 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
test.md

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment