Project

General

Profile

« Previous | Next » 

Revision 10742

Added by Aaron Marcuse-Kubitza over 11 years ago

bin/tnrs_db: add entry to new batch table

View differences:

tnrs_db
31 31 
import tnrs
32 32 

  		




  33
  33
  
    
tnrs_input = sql_gen.Table('tnrs_input_name')


  		




  
  34
  
    
tnrs_batch = sql_gen.Table('batch')


  		




  34
  35
  
    
tnrs_data = sql_gen.Table('tnrs')


  		




  35
  36
  
    

  		




  36
  37
  
    
def main():


  		




  ......




  68
  69
  
    
                cumulative_profiler=cumulative_tnrs_profiler)


  		




  69
  70
  
    
            


  		




  70
  71
  
    
            log('Storing TNRS response data')


  		




  
  72
  
    
            sql.insert(db, tnrs_batch, []) # time_submitted is autopopulated


  		




  71
  73
  
    
            sql_io.append_csv(db, tnrs_data, *csvs.reader_and_header(stream))


  		




  72
  74
  
    
        # start transaction *before* submitting data, so Time_submitted is


  		




  73
  75
  
    
        # correctly set to the submission time rather than the insertion time.


  		












Also available in:  Unified diff