couchdb-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Couchdb Wiki] Update of "DumpOracleDbToCouchDbPython" by DougShawhan
Date Fri, 25 Feb 2011 15:58:23 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Couchdb Wiki" for change notification.

The "DumpOracleDbToCouchDbPython" page has been changed by DougShawhan.
http://wiki.apache.org/couchdb/DumpOracleDbToCouchDbPython?action=diff&rev1=9&rev2=10

--------------------------------------------------

+ = Dump an Oracle Table to CouchDB using Python =
+ Since CouchDB requires unique keys to access documents, importing data from an SQL database
is an incitement to deep thought. 
+ 
+ If you went to the trouble of creating a single unique key in your SQL database, you may
be inclined to use it as your couchdb _id. Hard to go wrong there. However, for certain groups
of documents (say a collection of blog posts), simply using a iso format date as your _id
is pretty handy and can greatly simplify writing views in both Javascript and Python.
+ 
+ The first two examples expect a unique key to be extracted from the SQL database, the third
example lets CouchDB create the unique key. Of the three, the first and last are the most
useful. The second example is for static or "throwaway tables" that have very few values,
but might be a pain to just hand-copy (ex. config data).
+ 
+ You'll need the python couchdb module from http://code.google.com/p/couchdb-python/ , plus
whatever DBAPI2.0 compliant module you use to connect to your favorite SQL database. These
examples use Oracle, but it should be trivial to convert.
+ 
- = Unique Values in SQL Table Converted to Individual Documents =
+ == Unique Values in SQL Table Converted to Individual Documents ==
  Cro-Magnon simple python script which will take the contents of an SQL table and place it
into CouchDB.
  
  This particular example depends on the SQL table having one unique field. The values in
the unique field become individual documents in the CouchDB database.
- 
- You'll need the python couchdb module from http://code.google.com/p/couchdb-python/ , plus
whatever DBAPI2.0 compliant module you use to connect to your favorite SQL database.This example
uses Oracle, but it should be trivial to convert.
  
  This is probably not what you want. :-)
  
@@ -104, +111 @@

      for table_name in table_names:
          gm.updateCouch( table_name )
  }}}
- = Unique Values in SQL Table Converted to a Single Document =
+ == Unique Values in SQL Table Converted to a Single Document ==
  Differs from above in that it places all table data into a single document.
  
  {{{#!sql
@@ -162, +169 @@

          cursor.close()
  }}}
  
- = All Values from SQL Table Imported, Let CouchDB Assign Keys =
+ == All Values from SQL Table Imported, Let CouchDB Assign Keys ==
  
  This is most likely what you want!
  

Mime
View raw message