python data attributes in sqlalchemy model [duplicate]

Question

I'm getting myself into issues with python class attributes vs data attributes in my sqlalchemy model. This is a small example to demonstrate what's happening:

# -*- coding: utf-8 -*-
import cherrypy
import sqlalchemy
from sqlalchemy import create_engine
from sqlalchemy import Table, Column, Integer, String, MetaData, ForeignKey
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

engine = create_engine('mysql://USER:PASS@localhost/SCHEMA?charset=utf8', echo=True)
Session = sessionmaker(bind=engine)
session = Session()
Base = declarative_base()

class User(Base):
    __tablename__ = 'user'

    id = Column(Integer, primary_key=True)
    username = Column(String, nullable=False)
    name = Column(String, nullable=False)
    email = Column(String, nullable=False)

    def __init__(self, username, name, email):
        self.username = username
        self.name = name
        self.email = email
        self.data_attribute = "my data attribute"
        print "__init__"

    def __repr__(self):
        print "__repr__"
        return "<User('%s','%s', '%s')>" % (self.username, self.name, self.email)

class Root(object):

    @cherrypy.expose
    def test(self):        
        our_user = session.query(User).one()        
        return our_user.data_attribute #error

if __name__ == '__main__':

    cherrypy.tree.mount(Root())
    cherrypy.server.quickstart()
    cherrypy.engine.start()

That code errors because when the objects are taken from the DB __init__ doesn't run so data_attribute doesn't exist. If I put data_attribute in with the Column objects is becomes a class attribute (I think) and therefore carries the same value for all instances of User. This is not what I want.

What do I need to do to have a data attribute on my User object that doesn't come from the DB but also is unique for each instance of User?

Edit: I should probably point out that data_attribute will not always just be a simple string set in __init__ - this is just to demonstrate the problem.

modulitos · Accepted Answer · 2016-10-22 02:01:53Z

3

SQLAlchemy provides special syntax for such cases, http://docs.sqlalchemy.org/en/latest/orm/constructors.html?highlight=object%20initialization

edited Oct 22, 2016 at 2:01

modulitos

16.1k17 gold badges82 silver badges122 bronze badges

answered Aug 7, 2010 at 23:42

Daniel Kluev

11.4k2 gold badges38 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

modulitos Over a year ago

@AlexLordThorsen The post has been edited with the fixed link

AlexLordThorsen Over a year ago

Cool, I removed my down vote. Potentially this post should include an example so it's resistant to link decay.

robert · Accepted Answer · 2010-08-06 09:21:28Z

0

You should be using super() to call the base class constructor:

def __init__(self, username, name, email, *args, **kwargs ):
    super( User, self ).__init__( *args, **kwargs ) # Python 2.x or 3.x
    #super().__init__( *args, **kwargs ) # Python 3.x only
    self.username = username
    ...

answered Aug 6, 2010 at 9:21

robert

34.6k8 gold badges55 silver badges74 bronze badges

2 Comments

OrganicPanda Over a year ago

according to my print statement User.__init__ never runs so how can I make a call to the base? is there some python magic I'm missing here??

robert Over a year ago

I misread part of the question, so I guess this doesn't directly apply.

Collectives™ on Stack Overflow

python data attributes in sqlalchemy model [duplicate]

2 Answers 2

2 Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Linked

Related