[Csvtosql-cvs] csvtosql_jdk50/examples/test.jdbcbatchwriter create_db.sql, NONE, 1.1 build.xml, NON
Brought to you by:
davideconsonni
Update of /cvsroot/csvtosql/csvtosql_jdk50/examples/test.jdbcbatchwriter In directory sc8-pr-cvs4.sourceforge.net:/tmp/cvs-serv27295/examples/test.jdbcbatchwriter Added Files: create_db.sql build.xml runconsole.sh runconsole.bat mysql.jar readme.txt Log Message: --- NEW FILE: build.xml --- <!-- Created by Ivan Ryndin <a href="mailto:jj...@us..."> --> <project name="testcvstosql" default="run"> <description> This ant file helps to run test for next two things: ExtendedConsoleMain frontend and JdbcExtendedBatchWriter writer. What should you do to run test: 1) Copy "cvstosql.jar" from "bin" folder to here. 2) Run ANT. </description> <property name="db.url" value="jdbc:mysql://localhost/testdb"/> <property name="db.user" value="ryndin"/> <property name="db.password" value="ryndin"/> <property name="db.driver.class" value="com.mysql.jdbc.Driver"/> <property name="lib.dir" value="**/../../../lib"/> <path id="clp"> <pathelement location="mysql.jar"/> <pathelement location="csvtosql.jar"/> <pathelement path="..\..\lib"/> <fileset dir="${lib.dir}"> <include name="**/*.jar"/> </fileset> </path> <target name="create-db" description="Creates test database. Suitable for MySQL."> <sql driver="${db.driver.class}" password="${db.password}" url="${db.url}" userid="${db.user}"> <classpath refid="clp" /> <transaction src="create_db.sql"/> </sql> </target> <target name="run" depends="create-db" description="Run test task"> <java classname="net.sf.csv2sql.frontends.console.ExtendedConsoleMain" fork="true" classpathref="clp"> <arg line="-d data\tables.txt"/> <syspropertyset> <propertyref prefix="db." /> </syspropertyset> </java> </target> </project> --- NEW FILE: runconsole.sh --- java -classpath csvtosql.jar;mysql.jar;../../lib/commons-cli-1.0.jar -Ddb.url=jdbc:mysql://localhost/testdb -Ddb.user=ryndin -Ddb.password=ryndin -Ddb.driver.class=com.mysql.jdbc.Driver net.sf.csv2sql.frontends.console.ExtendedConsoleMain $1 $2 $3 $4 $5 $6 $7 $8 --- NEW FILE: create_db.sql --- drop database if exists testdb; create database testdb character set 'utf8'; use testdb; create table ADDR_TYPE ( ID integer not null auto_increment, DELETED bit not null, CR_TS datetime, MOD_TS datetime, NAME varchar(255), CODE varchar(60), CREATOR_ID integer, MODIFIER_ID integer, COMPANY_ID integer, primary key (ID) ) type=InnoDB; create table EFFECT ( ID integer not null auto_increment, DELETED bit not null, CR_TS datetime, MOD_TS datetime, NAME varchar(255), CODE varchar(60), DESCR text, CREATOR_ID integer, MODIFIER_ID integer, primary key (ID) ) type=InnoDB; create table MATRIX ( ID integer not null auto_increment, DELETED bit not null, CR_TS datetime, MOD_TS datetime, NAME varchar(255), CODE varchar(60), CREATOR_ID integer, MODIFIER_ID integer, primary key (ID) ) type=InnoDB; create table SAMPLE_LOC ( ID integer not null auto_increment, DELETED bit not null, CR_TS datetime, MOD_TS datetime, NAME varchar(255), CODE varchar(60), CREATOR_ID integer, MODIFIER_ID integer, COMPANY_ID integer, primary key (ID) ) type=InnoDB; --- NEW FILE: runconsole.bat --- java -classpath csvtosql.jar;mysql.jar;..\..\lib\commons-cli-1.0.jar -Ddb.url=jdbc:mysql://localhost/testdb -Ddb.user=ryndin -Ddb.password=ryndin -Ddb.driver.class=com.mysql.jdbc.Driver net.sf.csv2sql.frontends.console.ExtendedConsoleMain -d data\tables.txt --- NEW FILE: mysql.jar --- (This appears to be a binary file; contents omitted.) --- NEW FILE: readme.txt --- This test case does testing of the ExtendedConsoleMain frontend and JdbcBatchMain writer. What should you do to run test: 1) Copy "cvstosql.jar" from "bin" folder to here. 2) Execute "create_db.sql" for creating database and its tables. Use MySQL database. It wasn't tested on others databases. But at a glance, all should work well on others databases. You need only to change a little "create_db.sql" and XML descriptors in "data" folder. 3) Run either "runconsole.bat" (or "runconsole.sh") or "build.xml" for running the task with ANT. |