If I intercept strings that are empty and replace with None, is there
potential problems because the database record and the python object are
"out of sync"? Thereafter, will sqla believe the column value has
changed and try to write again on next flush()?
On 11/4/2010 11:42 AM, Michael Bayer wrote:
On Nov 4, 2010, at 11:16 AM, Kent wrote:
We are writing an application that can run on PostgreSQL or Oracle.
Since postgres treats NULL and '' (empty string) differently, while
Oracle treats '' as NULL, this can cause subtle behavior differences
based on the underlying database.
Can you think of a way I could easily intercept all UPDATE and INSERT
column values, and, if the value is the empty string, replace with
None/null?
Thanks in advance if you can point me in the right direction.
the current method on this is the ConnectionProxy:
http://www.sqlalchemy.org/docs/core/interfaces.html#sqlalchemy.interfaces.ConnectionProxy
Kent
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
