Project

General

Profile

« Previous | Next » 

Revision 4405

Added by Aaron Marcuse-Kubitza about 12 years ago

sql_io.py: cleanup_table(): Add table to each column so its type can later be determined from the DB

View differences:

sql_io.py
22 22 

  		




  23
  23
  
    
def cleanup_table(db, table, cols):


  		




  24
  24
  
    
    table = sql_gen.as_Table(table)


  		




  25
  
  
    
    cols = map(sql_gen.as_Col, cols)


  		




  
  25
  
    
    cols = [sql_gen.as_Col(c, table) for c in cols]


  		




  26
  26
  
    
    


  		




  27
  27
  
    
    expr = 'trim(both from %s)'


  		




  28
  28
  
    
    for null in null_strs: expr = 'nullif('+expr+', '+db.esc_value(null)+')'


  		












Also available in:  Unified diff