Revision 14826
Added by Aaron Marcuse-Kubitza over 9 years ago
| sql_io.py | ||
|---|---|---|
| 57 | 57 |
db.log_debug('Cleaning up table', level=1.5)
|
| 58 | 58 |
|
| 59 | 59 |
db.log_debug('null_strs = '+repr(null_strs), level=1.5)
|
| 60 |
expr = 'trim(both from %s)' |
|
| 60 |
expr = 'trim(both from %s)' # also converts character varying fields to text
|
|
| 61 | 61 |
for null in null_strs: expr = 'nullif('+expr+', '+db.esc_value(null)+')'
|
| 62 | 62 |
changes = [(v, sql_gen.CustomCode(expr % v.to_str(db))) for v in cols] |
| 63 | 63 |
|
Also available in: Unified diff
lib/sql_io.py: cleanup_table(): trim(): documented that this also converts character varying fields to text