Skip to main content

Normalize SQLAlchemy Object to Plain dict and list

Project description

Build Status Version Status

Working in Progress. Normalize SQLAlchemy Object to Plain dict and list. Convert SQLAlchemy to Dict without pain!

pip install sqlalchemy-norm

An example of a simple code:

from yourapp.database import Base, session
from sqlalchemy_norm import Normalizable

class User(Base, Normalizable):
    # ...

me = User('Edward')
norm = me.vars() # {"name": "Edward"}

users = session.query(User).all()
norms = [user.vars() for user in users]
    {"name": "Edward"},
    {"name": "Koala"},
    {"name": "Kangaroo"}

If you like,

python test


When I tried to convert from SQLAlchemy object to JSON, it’s not an easy job than I expected. If SQLAlchemy objects could convert to plain objects, it will be better to handle it for most of converting situations, jsonify in Flask, especially.


I’m not good at python and I don’t know pythonic code that much. If you have any idea or opinion about the code, please leave an issue on the issue tracker. Contributing the code is always welcome.


This software is licensed under the New BSD License. See the LICENSE file in the top distribution directory for the full license text.


Simple Model

In model,

from datetime import datetime

from sqlalchemy import Column, Integer, String, DateTime
from sqlalchemy_norm import Normalizable

from yourapp.database import Base

class User(Base, Normalizable):
    __tablename__ = 'users'

    id = Column(Integer, primary_key=True)
    name = Column(String)
    nickname = Column(String)
    password = Column(String) # do not save password as plain string
    point = Column(Integer)
    created_at = Column(DateTime)

    # specify your dict strcutrue inside the model
    __excludes__ = ['password']
    __includes__ = ['display_name']

    def display_name(self):
        return "%s (%s)" % (self.nickname,

    def __init__(self, name, nickname=None, = name
        self.nickname = nickname
        self.created_at = created_at

Now we can use it like below:

from models import User

me = User("Edward", "haruair")
me.password = "strong password"
me.point = 42

  'id': 1,
  'point': 42,
  'name': 'Edward',
  'nickname': 'haruair',
  'created_at': '2016-01-01T00:00:00.123456',
  'display_name': 'haruair (Edward)'

print(me.vars(includes=["password"], excludes=["display_name", "name", "created_at"]))
# {'nickname': 'haruair', 'password': 'strong password', 'point': 100}

# {'display_name': 'haruair (Edward)'}

Complex Model

Relationship between models,

from sqlalchemy import ForeignKey
from sqlalchemy.orm import relationship, backref

class Address(Base, Normalizable):
    __tablename__ = 'addresses'
    id = Column(Integer, primary_key=True)
    email = Column(String, nullable=False)

    user_id = Column(Integer, ForeignKey(''))
    user = relationship("User", backref=backref('addresses', order_by=id))

    def __init__(self, email): = email
from models import User, Addresses
from yourapp.database import session

me = User("Edward", "haruair")

me.addresses = [


  'id': 1,
  'addresses': [
    {'email': '', 'id': 1, 'user_id': 1},
    {'email': '', 'id': 2, 'user_id': 1}
  'display_name': 'haruair (Edward)',
  'point': None,
  'nickname': 'haruair',
  'created_at': '2016-09-16T14:16:37.359005',
  'name': 'Edward'

Dot Notation

Simple dot notation support. Not much fancy but it’s worth than nothing.

norm1 = me.vars(

norm2 = me.vars(

If you need more examples, please check test cases in tests directory.

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for SQLAlchemy-Norm, version 0.0.5
Filename, size File type Python version Upload date Hashes
Filename, size SQLAlchemy-Norm-0.0.5.tar.gz (7.5 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page