Project

General

Profile

« Previous | Next » 

Revision 972

Added by Jing Tao over 22 years ago

In order to test query performance. We need add lots of documents to database. This script file can add couple documents to database by for loop.

View differences:

test/senddoctodb.sh
1 
#!/bin/sh
2 

  		




  
  3
  
    
# this script file will send 5 xml documents to db.


  		




  
  4
  
    

  		




  
  5
  
    
for ((i=1000;i<1500;i+=5))


  		




  
  6
  
    
do


  		




  
  7
  
    
  echo $i


  		




  
  8
  
    
  let j=i


  		




  
  9
  
    
  java -cp ../build/metacat.jar:../lib/xerces.jar:/oracle01/app/oracle/product/8.1.6/jdbc/lib/classes111.zip edu.ucsb.nceas.metacat.DocumentImpl -a INSERT -d jin.$j.1 -f 532.2


  		




  
  10
  
    
  let j=i+1


  		




  
  11
  
    
#  java -cp ../build/metacat.jar:../lib/xerces.jar:/oracle01/app/oracle/product/8.1.6/jdbc/lib/classes111.zip edu.ucsb.nceas.metacat.DocumentImpl -a INSERT -d jin.$j.1 -f 530.18


  		




  
  12
  
    
  let j=i+2


  		




  
  13
  
    
  java -cp ../build/metacat.jar:../lib/xerces.jar:/oracle01/app/oracle/product/8.1.6/jdbc/lib/classes111.zip edu.ucsb.nceas.metacat.DocumentImpl -a INSERT -d jin.$j.1 -f 533.4


  		




  
  14
  
    
  let j=i+3


  		




  
  15
  
    
  java -cp ../build/metacat.jar:../lib/xerces.jar:/oracle01/app/oracle/product/8.1.6/jdbc/lib/classes111.zip edu.ucsb.nceas.metacat.DocumentImpl -a INSERT -d jin.$j.1 -f 529.1


  		




  
  16
  
    
  let j=i+4


  		




  
  17
  
    
  java -cp ../build/metacat.jar:../lib/xerces.jar:/oracle01/app/oracle/product/8.1.6/jdbc/lib/classes111.zip edu.ucsb.nceas.metacat.DocumentImpl -a INSERT -d jin.$j.1 -f 534.1


  		




  
  18
  
    

  		




  
  19
  
    
done


  		




  0
  20
  
    

  		












Also available in:  Unified diff