This is a bit of an odd request, but here goes:
A table in postgresql has some columns with sensitive data which should be
secured against visibility by one of our applications (we use a central
SqlAlchemy model for multiple applications)
Currently we use an environment var to determine if the column is in the
class definition for the table (nesting the column in an "if" statement).
A new feature I'd like to implement is allowing one of the applications to
search on that column, but ensuring that it doesn't appear in the result.
currently we have this:
class Foo(Base):
__tablename__ = 'foo'
id = sa_Column(sa_Integer, primary_key=True)
if allow_bar:
bar = sa_Column(sa_Text)
and it would be ideal to allow `bar` to be used in filter() queries, but
never retrieved and exceptions raised if accessed.
has anyone tried to do something like this before?
--
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.
