A database-respecting object-relational mapper for PostgreSQL.
Project description
Overview
What Simpycity Is
Simpycity is an object-relational mapper. It seamlessly maps PostgreSQL query and function result sets to Python classes and class attributes.
It allows for the easy and rapid development of query- and stored procedure-based data representations. Simpycity leverages PostgreSQL’s powerful composite type system, and the advanced type handling of the psycopg2 database access library.
What Simpycity is Not
Simpycity is not a SQL generator and does not attempt to abstract or hide SQL. Simpycity is designed for developers who deeply understand SQL and desire to write the best possible SQL representations for their database. Simpycity also rejects the Active Record paradigm, whose simplistic patterns fail in even moderately complex systems.
Core Philosophy
The core philosophy behind Simpycity is that the Database and the Application are separate entities, each with distinct abilities and design representations; this echoe the classic Object versus Relation argument. It provides a mechanism where a single business Object can easily represent several Relations, and allow the base Relational layer to follow normal forms without compromising or complicating application design.
Usage
At its simplest, object-relation mapping looks like:
--SQL create table foo (id int, name text); insert into foo (id, name) values (1, 'one'), (2, 'two'); #Python class Foo(simpycity.model.SimpleModel): pg_type = ('public', 'foo') __load__ = simpycity.core.QuerySingle('foo',['id']) my_foo = Foo(1) print(my_foo.name) >>>one
Read the tutorial for more narrative help.
License
Simpycity is licensed under the LGPL license, and a copy of your rights and permissions is available in the LICENSE file included in your distribution.
Contact
The official source repository is https://github.com/commandprompt/Simpycity
For support, questions, and additional help with Simpycity, please feel free to contact us on github.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for Simpycity-2.0.0-py2-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d9198f347470a0200353bcd5c36a7c713960b39ef87f7661968f759749b9d627 |
|
MD5 | 0f5c857cb7e4db5f252baa1a02a25d5a |
|
BLAKE2b-256 | 62e1c727679be70c2c29fb93e1664a2a1ba9bbdaac947376b23544a70bd83fea |