On 11/17/2016 01:02 AM, Andrew Wansley wrote:
Hey sqlalchemy,
It's common in our code to have encrypted columns:
class Patient(Base):
first_name = Column(LargeBinary, ..)
In order to figure out what key we use to decrypt the first_name column,
we may need to do a lookup using the whole row.
def get_encryption_key(self):
session.query(HealthcareProviderDataKey).filter(..)
Currently, we have, on our base class, a Base.get(key) method that may
call self.get_encryption_key() and do some decryption, so to read a
patient's first name, I might call patient.get('first_name').
Instead, the docs suggest we could use the @hybrid_propery decorator and
alias the column property:
class Patient(Base):
_first_name = Column("first_name", LargeBinary, ..)
@property
def first_name(self):
self.decrypt(self._first_name)
That's great, but is a bit tedious/verbose to do for each of our
encrypted columns. Ideally I'd be able to declare the column as a custom
type, or set a key in the column "info" dict..
Is there a recommended way to override the getattr behavior for columns
like this?
I don't think I can just use TypeDecorator because I need access to the
whole row, and I haven't quite been able to get overriding __getattr__
on the declarative metaclass to work..
You could likely most easily use __getattribute__, which in Python is a
different kind of hook than __getattr__. __getattribute__ should be
called unconditionally for all attributes, so you can intercept at that
level.
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and
Verifiable Example. See http://stackoverflow.com/help/mcve for a full
description.
---
You received this message because you are subscribed to the Google
Groups "sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
