Hi,

I've got a db object with a string property that may grow larger than its 
column specifies (because it's being appended to). I tried:

    old_string = obj.string
    try:                                                                    
                        
        obj.string = "abc" * 10000                                          
                               
        dbsession.flush()                                                  
                 
    except Exception as e:                                                  
                        
        obj.string = old_string                                            
                             

but the expected warning wasn't caught here:

/…/pymysql/cursors.py:166: Warning: (1265, "Data truncated for column 
'chat' at row 1")
  result = self._query(query)

What is the proper way of handling this situation, other than comparing the 
string length against the column size explicitly?

Thanks!
Jens

-- 
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 sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Reply via email to