Project

General

Profile

« Previous | Next » 

Revision 14785

Added by Aaron Marcuse-Kubitza over 9 years ago

lib/sql_io.py: null_strs: added N/A and NA (this will remove a common abbr for North America, but we don't use the continent, so this is OK)

View differences:

sql_io.py
32 32 
    return sql.value(sql.run_query(db, 'SELECT util.table_nulls_mapped__get('
33 33 
        +sql_gen.table2regclass_text(db, table)+')'))
34 34 

  		




  35
  
  
    
null_strs = ['', '-', r'\N', 'NULL', 'UNKNOWN', 'nulo']


  		




  
  35
  
    
null_strs = ['', '-', r'\N', 'NULL', 'N/A', 'NA', 'UNKNOWN', 'nulo']


  		




  
  36
  
    
    # NA: this will remove a common abbr for North America, but we don't use the


  		




  
  37
  
    
    # continent, so this is OK


  		




  36
  38
  
    

  		




  37
  39
  
    
def cleanup_table(db, table):


  		




  38
  40
  
    
    '''idempotent'''


  		












Also available in:  Unified diff