Project

General

Profile

« Previous | Next » 

Revision 4992

Added by Aaron Marcuse-Kubitza about 12 years ago

sql_io.py: cleanup_table(): Also vacuum and reanalyze table

View differences:

lib/sql_io.py
39 39 
            db.log_debug('Caught exception: '+exc.str_(e))
40 40 
            col, = e.cols
41 41 
            sql.drop_not_null(db, col)
42
43 
    db.log_debug('Vacuuming and reanalyzing table', level=1.5)
44 
    sql.vacuum(db, table)
42 45 

  		




  43
  46
  
    
##### Error tracking


  		




  44
  47
  
    

  		












  

    
      bin/csv2db
    
  





  122
  122
  
    
    


  		




  123
  123
  
    
    log('Cleaning up table')


  		




  124
  124
  
    
    sql_io.cleanup_table(db, table)


  		




  125
  
  
    
    


  		




  126
  
  
    
    log('Vacuuming and reanalyzing table')


  		




  127
  
  
    
    sql.vacuum(db, table)


  		




  128
  125
  
    

  		




  129
  126
  
    
main()


  		












Also available in:  Unified diff