hammant     01/11/30 02:46:52

  Modified:    apps/db  build.xml
  Added:       apps/db/src/scripts/sql Test1.script
  Log:
  first SQL scripts
  
  Revision  Changes    Path
  1.24      +9 -0      jakarta-avalon-cornerstone/apps/db/build.xml
  
  Index: build.xml
  ===================================================================
  RCS file: /home/cvs/jakarta-avalon-cornerstone/apps/db/build.xml,v
  retrieving revision 1.23
  retrieving revision 1.24
  diff -u -r1.23 -r1.24
  --- build.xml 2001/11/29 23:08:59     1.23
  +++ build.xml 2001/11/30 10:46:52     1.24
  @@ -343,5 +343,14 @@
         <classpath refid="test.path"/>
       </java>  
     </target>
  +
  +  <target name="tests1" depends="main">
  +    <property name="script" location="src/scripts/sql/Test1.script"/>
  +    <java classname="org.apache.avalon.db.test.Tester" fork="true">          
  +      <arg value="sql"/>    
  +      <arg value="${script}"/>
  +      <classpath refid="test.path"/>
  +    </java>  
  +  </target>
   
   </project>
  
  
  
  1.1                  
jakarta-avalon-cornerstone/apps/db/src/scripts/sql/Test1.script
  
  Index: Test1.script
  ===================================================================
  ### CREATE ##!
  
  CREATE TABLE Primes
    ( prime INT NOT NULL,
      sequence INT NOT NULL,
      words VARCHAR(50) NOT NULL )
  
  ### INSERT ##!
  
  INSERT INTO PRIMES (prime, sequence, words) VALUES (
    2,1,"two",
    3,2,"three",
    5,3,"five",
    7,4,"seven",
    11,5,"eight",
    13,6,"nine",
    17,7,"ten",
    19,8,"eleven")
    
  ###
    
      
  
  

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to