title: How can I do a batch insert into an Oracle database using Python?
body: <p>I have some monthly weather data that I want to insert into an Oracle database table but I want to insert the corresponding records in a batch in order to be more efficient.  Can anyone advise as to how I'd go about doing this in Python?</p>
  
  <p>For example let's say my table has four fields: a station ID, a date, and two value fields.  The records are uniquely identified by the station ID and date fields (composite key).  The values I'll have to insert for each station will be kept in a list with X number of full years worth of data, so for example if there are two years of values then the value lists will contain 24 values.</p>
  
  <p>I assume that below is the way I'd do this if I wanted to insert the records one at a time: </p>
  
  <pre><code>connection_string = "scott/tiger@testdb"
  connection = cx_Oracle.Connection(connection_string)
  cursor = cx_Oracle.Cursor(connection)
  station_id = 'STATION_1'
  start_year = 2000
  
  temps = [ 1, 3, 5, 7, 9, 1, 3, 5, 7, 9, 1, 3 ]
  precips = [ 2, 4, 6, 8, 2, 4, 6, 8, 2, 4, 6, 8 ]
  number_of_years = len(temps) / 12
  for i in range(number_of_years):
      for j in range(12):
          # make a date for the first day of the month
          date_value = datetime.date(start_year + i, j + 1, 1)
          index = (i * 12) + j
          sql_insert = 'insert into my_table (id, date_column, temp, precip) values (%s, %s, %s, %s)', (station_id, date_value, temps[index], precips[index]))
          cursor.execute(sql_insert)
  connection.commit()
  </code></pre>
  
  <p>Is there a way to do what I'm doing above but in a way that performs a batch insert in order to increase efficiency?  BTW my experience is with Java/JDBC/Hibernate so if someone can give an explanation/example which compares to the Java approach then it'd be especially helpful.  </p>
  
  <p>EDIT: Perhaps I need to use cursor.executemany() as described <a href="http://www.oracle.com/technetwork/articles/dsl/python-091105.html">here</a>?</p>
  
  <p>Thanks in advance for any suggestions, comments, etc.</p>