Huge News!Announcing our $40M Series B led by Abstract Ventures.Learn More
Socket
Sign inDemoInstall
Socket

ascetic

Package Overview
Dependencies
Maintainers
1
Alerts
File Explorer

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

ascetic

Lightweight python datamapper ORM (Object-relational mapper).

  • 0.7.2.40
  • PyPI
  • Socket score

Maintainers
1

============================================ Ascetic, a lightweight Python datamapper ORM

Ascetic exists as a super-lightweight datamapper ORM (Object-Relational Mapper) for Python.

  • Home Page: https://bitbucket.org/emacsway/ascetic
  • Docs: https://ascetic.readthedocs.io/
  • Browse source code (canonical repo): https://bitbucket.org/emacsway/ascetic/src
  • GitHub mirror: https://github.com/emacsway/ascetic
  • Get source code (canonical repo): git clone https://bitbucket.org/emacsway/ascetic.git
  • Get source code (mirror): git clone https://github.com/emacsway/ascetic.git
  • PyPI: https://pypi.python.org/pypi/ascetic

Ascetic ORM based on "Data Mapper <http://martinfowler.com/eaaCatalog/dataMapper.html>" pattern. It also supports "Active Record <http://www.martinfowler.com/eaaCatalog/activeRecord.html>" pattern, but only as a wrapper, the model class is fully free from any service logic. Ascetic ORM follows the KISS principle <http://en.wikipedia.org/wiki/KISS_principle>. Has automatic population of fields from database (see the example below) and minimal size. You do not have to specify the columns in the class. This follows the DRY <http://en.wikipedia.org/wiki/DRY_code> principle. Ascetic ORM as small as possible.

Inside ascetic.contrib (currently under development) you can find the next solutions:

  • multilingual
  • polymorphic relations
  • polymorphic models (supports for "Single Table Inheritance <http://martinfowler.com/eaaCatalog/singleTableInheritance.html>", "Concrete Table Inheritance <http://martinfowler.com/eaaCatalog/concreteTableInheritance.html>" and "Class Table Inheritance <http://martinfowler.com/eaaCatalog/classTableInheritance.html>" aka Django "Multi-table inheritance <https://docs.djangoproject.com/en/1.8/topics/db/models/#multi-table-inheritance>")
  • "Materialized Path" implementation to handle tree structures
  • versioning (which stores only diff, not content copy)

All extensions support composite primary/foreign keys.

"Identity Map <http://martinfowler.com/eaaCatalog/identityMap.html>__" has SERIALIZABLE isolation level by default.

What Ascetic ORM does not? Ascetic ORM does not make any data type conversions (use connection features like this <http://initd.org/psycopg/docs/advanced.html#adapting-new-python-types-to-sql-syntax>), and does not has "Unit of Work <http://martinfowler.com/eaaCatalog/unitOfWork.html>". I recommend using a Storm ORM <https://storm.canonical.com/>__, if you need these features.

Ascetic ORM is released under the MIT License (see LICENSE file for details).

This project is currently under development, and not stable. If you are looking for stable KISS-style ORM, pay attention to Storm ORM <https://storm.canonical.com/>__.

PostgreSQL Example

Using these tables:

::

CREATE TABLE ascetic_tests_models_author (
    id serial NOT NULL PRIMARY KEY,
    first_name VARCHAR(40) NOT NULL,
    last_name VARCHAR(40) NOT NULL,
    bio TEXT
);
CREATE TABLE books (
    id serial NOT NULL PRIMARY KEY,
    title VARCHAR(255),
    author_id integer REFERENCES ascetic_tests_models_author(id) ON DELETE CASCADE
);

You can configure in one the following ways:

\1. Put in your PYTHONPATH file ascetic_settings.py with your settings. See file ascetic/settings.py for more details.

\2. Define settings module in evironment variable ASCETIC_SETTINGS.

\3. Call ascetic.settings.configure(), for example::

import ascetic.settings.configure
ascetic.settings.configure({
    'DATABASES': {
        'default': {
            'engine': "postgresql",
            'user': "devel",
            'database': "devel_ascetic",
            'password': "devel",
            'debug': True,
            'initial_sql': "SET NAMES 'UTF8';",
        }
    }
})

We setup our objects like so:

::

from ascetic.model import Model
from ascetic.mappers import get_mapper
from ascetic.relations import ForeignKey, OneToMany

class Author(Model):
    class Mapper(object):
        defaults = {'bio': 'No bio available'}
        validations = {'first_name': (
            lambda v: len(v) > 1 or "Too short first name",
            lambda self, key, value: value != self.last_name or "Please, enter another first name",
        )}

class Book(Model):
    author = ForeignKey(Author, related_name='books')

    class Mapper(object):
        db_table = 'books'

Now we can create, retrieve, update and delete entries in our database. Creation

::

james = Author(first_name='James', last_name='Joyce')
get_mapper(Author).save(james)  # Datamapper way

u = Book(title='Ulysses', author_id=james.id)
u.save()  # Use ActiveRecord wrapper

Retrieval

::

a = Author.get(1)
a.first_name # James
a.books      # Returns list of author's books

# Returns a list, using LIMIT based on slice
a = Author.q[:10]   # LIMIT 0, 10
a = Author.q[20:30] # LIMIT 20, 10

Updating

::

a = Author.get(1)
a.bio = 'What a crazy guy! Hard to read but... wow!'
a.save()

Deleting

::

a.delete()

SQLBuilder <https://bitbucket.org/emacsway/sqlbuilder/overview>_ integration

::

object_list = Book.q.tables(
    (Book.s & Author.s).on(Book.s.author_id == Author.s.id)
).where(
    (Author.s.first_name != 'James') & (Author.s.last_name != 'Joyce')
)[:10]

Query object based on sqlbuilder.smartsql <https://bitbucket.org/emacsway/sqlbuilder/src/tip/sqlbuilder/smartsql>, see more info <https://bitbucket.org/emacsway/sqlbuilder/overview>.

Signals support

  • pre_init
  • post_init
  • pre_save
  • post_save
  • pre_delete
  • post_delete
  • class_prepared

More info

See more info in docs: https://ascetic.readthedocs.io/

Web

You can use Ascetic ORM with lightweight web-frameworks, like wheezy.web <https://bitbucket.org/akorn/wheezy.web>, Bottle <http://bottlepy.org/>, Tornado <http://www.tornadoweb.org/>, pysi <https://bitbucket.org/imbolc/pysi>, etc.

Gratitude

| Forked from https://github.com/lucky/autumn <https://github.com/lucky/autumn>_ | Thanks to Jared Kuolt (lucky) <https://github.com/lucky>_

Other projects

See also:

  • Storm <https://storm.canonical.com/>_ (properties from class) - excellent and simple ORM!
  • Article (in English) "Why I prefer Storm ORM for Python <https://emacsway.github.io/en/storm-orm/>_"
  • Article (in Russian) "Почему я выбираю Storm ORM для Python <https://emacsway.github.io/ru/storm-orm/>_"
  • Article (in English) "Implementation of Repository pattern for browser’s JavaScript <https://emacsway.github.io/en/javascript-and-repository-pattern/>_"
  • Article (in Russian) "Реализация паттерна Repository в браузерном JavaScript <https://emacsway.github.io/ru/javascript-and-repository-pattern/>_"
  • SQLAlchemy <http://www.sqlalchemy.org/>_ (scheme from class or database, see "autoload <http://docs.sqlalchemy.org/en/rel_1_1/core/reflection.html>__" option)
  • Openorm <http://code.google.com/p/openorm/source/browse/python/>_ (lightweight datamapper), miror <https://bitbucket.org/emacsway/openorm/src/default/python/>__
  • SQLObject <http://www.sqlobject.org/>_ (scheme from class or database, see "fromDatabase" option)
  • Peewee <https://peewee.readthedocs.io/>_ (scheme from class)
  • Bazaar ORM <http://www.nongnu.org/bazaar/>_
  • Twistar <http://findingscience.com/twistar/>_ (scheme from database), provides asynchronous DB interaction
  • Activemodel <http://code.google.com/p/activemodel/>_ (scheme from database)
  • ActiveRecord <http://code.activestate.com/recipes/496905-an-activerecord-like-orm-object-relation-mapper-un/>_ like ORM under 200 lines (scheme from database)
  • A Query Language extension for Python <https://github.com/pythonql/pythonql>_: Query files, objects, SQL and NoSQL databases with a built-in query language
  • simpleql <https://bitbucket.org/robertodealmeida/simpleql/>_ SQL table using nothing but Python to build the query
  • Generator expressions <http://code.activestate.com/recipes/442447/>__ for database requests (Python recipe)
  • Object Relational Mappers (ORMs) <https://wiki.python.org/moin/HigherLevelDatabaseProgramming>_

Keywords

FAQs


Did you know?

Socket

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap
  • Changelog

Packages

npm

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc