Project

General

Profile

« Previous | Next » 

Revision 14822

Added by Aaron Marcuse-Kubitza about 10 years ago

bugfix: lib/sql_io.py: null_strs_str_default: removed "NA" because this is the abbr for a Spanish province (Navarra). this fixes the 2nd bug of #955, geovalidation duplicated rows.

View differences:

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

  		




  36
  
  
    
null_strs_str_default = r',-,\N,NULL,N/A,NA,UNKNOWN,nulo'


  		




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


  		




  38
  
  
    
    # continent, so this is OK


  		




  
  36
  
    
null_strs_str_default = r',-,\N,NULL,N/A,UNKNOWN,nulo'


  		




  39
  37
  
    

  		




  40
  38
  
    
null_strs_str = os.getenv('null_strs', null_strs_str_default)


  		




  41
  39
  
    
null_strs = null_strs_str.split(',')


  		












Also available in:  Unified diff