Skip to content

Instantly share code, notes, and snippets.

@kevgathuku
Forked from luhn/getter_and_setter.py
Created August 3, 2016 15:27
Show Gist options
  • Save kevgathuku/1964eb21ba5dad11b65f7496978f948b to your computer and use it in GitHub Desktop.
Save kevgathuku/1964eb21ba5dad11b65f7496978f948b to your computer and use it in GitHub Desktop.
Using getters and setters with SQLAlchemy
class Table(Base):
id = Column(Integer, primary_key=True)
_name = Column('name', String(24))
@property
def name(self):
return self._name;
@name.setter
def name(self, value):
self._name = value.title()
#A query you might perform on the table.
#It won't work anymore :'(
query = db_session.query(Table)\
.filter(Table.name == 'Theron')
#You could do this, but it doesn't look as nice, is inconsistent with the "id"
#column, and you'd have to update all your existing code.
query = db_session.query(Table)\
.filter(Table._name == 'Theron')
from sqlalchemy.orm import synonym
class Table(Base):
id = Column(Integer, primary_key=True)
_name = Column('name', String(24))
@property
def name(self):
return self._name;
@name.setter
def name(self, value):
self._name = value.title()
name = synonym('_name', descriptor=name)
#A query you might perform on the table.
#Now it works again! :)
query = db_session.query(Table)\
.filter(Table.name == 'Theron')
class Table(Base):
id = Column(Integer, primary_key=True)
name = Column(String(24))
#A query you might perform on the table.
query = db_session.query(Table)\
.filter(Table.name == 'Theron')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment