[Csvtosql-cvs] csvtosql_jdk50/examples/test.simple.thread descriptor.xml,NONE,1.1 users.txt,NONE,1.1
Brought to you by:
davideconsonni
|
From: consonni d. <dav...@us...> - 2005-04-25 10:50:51
|
Update of /cvsroot/csvtosql/csvtosql_jdk50/examples/test.simple.thread In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14241/test.simple.thread Added Files: descriptor.xml users.txt Log Message: no message --- NEW FILE: users.txt --- 1, John,Doe,120 jefferson st.,Riverside, NJ, 08075, 23/8/1980,dummy value 0, Jack,McGinnis,220 hobo Av.,Phila, PA,09119, 14/1/1984, 1, John Da Man,Repici,120 Jefferson St.,Riverside, NJ, 08075 , 19/10/1979,dummy value 0, Stephen,Tyler,7452 Terrace At the Plaza road,SomeTown,SD, 91234, 25/11/1999, 1, John,Doe,120 jefferson st.,Riverside, NJ, 08075, 23/8/1980,dummy value 0, Jack,McGinnis,220 hobo Av.,Phila, PA,09119, 14/1/1984, 1, John Da Man,Repici,120 Jefferson St.,Riverside, NJ, 08075 , 19/10/1979,dummy value 0, Stephen,Tyler,7452 Terrace At the Plaza road,SomeTown,SD, 91234, 25/11/1999, 1, John,Doe,120 jefferson st.,Riverside, NJ, 08075, 23/8/1980,dummy value 0, Jack,McGinnis,220 hobo Av.,Phila, PA,09119, 14/1/1984, 1, John Da Man,Repici,120 Jefferson St.,Riverside, NJ, 08075 , 19/10/1979,dummy value 0, Stephen,Tyler,7452 Terrace At the Plaza road,SomeTown,SD, 91234, 25/11/1999, 1, John,Doe,120 jefferson st.,Riverside, NJ, 08075, 23/8/1980,dummy value 0, Jack,McGinnis,220 hobo Av.,Phila, PA,09119, 14/1/1984, 1, John Da Man,Repici,120 Jefferson St.,Riverside, NJ, 08075 , 19/10/1979,dummy value 0, Stephen,Tyler,7452 Terrace At the Plaza road,SomeTown,SD, 91234, 25/11/1999, 1, John,Doe,120 jefferson st.,Riverside, NJ, 08075, 23/8/1980,dummy value 0, Jack,McGinnis,220 hobo Av.,Phila, PA,09119, 14/1/1984, 1, John Da Man,Repici,120 Jefferson St.,Riverside, NJ, 08075 , 19/10/1979,dummy value [...2960 lines suppressed...] 1, John,Doe,120 jefferson st.,Riverside, NJ, 08075, 23/8/1980,dummy value 0, Jack,McGinnis,220 hobo Av.,Phila, PA,09119, 14/1/1984, 1, John Da Man,Repici,120 Jefferson St.,Riverside, NJ, 08075 , 19/10/1979,dummy value 0, Stephen,Tyler,7452 Terrace At the Plaza road,SomeTown,SD, 91234, 25/11/1999, 1, John,Doe,120 jefferson st.,Riverside, NJ, 08075, 23/8/1980,dummy value 0, Jack,McGinnis,220 hobo Av.,Phila, PA,09119, 14/1/1984, 1, John Da Man,Repici,120 Jefferson St.,Riverside, NJ, 08075 , 19/10/1979,dummy value 0, Stephen,Tyler,7452 Terrace At the Plaza road,SomeTown,SD, 91234, 25/11/1999, 1, John,Doe,120 jefferson st.,Riverside, NJ, 08075, 23/8/1980,dummy value 0, Jack,McGinnis,220 hobo Av.,Phila, PA,09119, 14/1/1984, 1, John Da Man,Repici,120 Jefferson St.,Riverside, NJ, 08075 , 19/10/1979,dummy value 0, Stephen,Tyler,7452 Terrace At the Plaza road,SomeTown,SD, 91234, 25/11/1999, 1, John,Doe,120 jefferson st.,Riverside, NJ, 08075, 23/8/1980,dummy value 0, Jack,McGinnis,220 hobo Av.,Phila, PA,09119, 14/1/1984, 1, John Da Man,Repici,120 Jefferson St.,Riverside, NJ, 08075 , 19/10/1979,dummy value 0, Stephen,Tyler,7452 Terrace At the Plaza road,SomeTown,SD, 91234, 25/11/1999, 1, John,Doe,120 jefferson st.,Riverside, NJ, 08075, 23/8/1980,dummy value 0, Jack,McGinnis,220 hobo Av.,Phila, PA,09119, 14/1/1984, 1, John Da Man,Repici,120 Jefferson St.,Riverside, NJ, 08075 , 19/10/1979,dummy value 0, Jack,McGinnis,220 hobo Av.,Phila, PA,09119, 14/1/1984, --- NEW FILE: descriptor.xml --- <?xml version="1.0" encoding="UTF-8"?> <root> <!-- CONFIGURATOR DATA --> <descriptor version="3"/> <!-- DEFINE HERE TABLE STRUCTURE --> <structure tablename="tab_users"> <field name="ID" type="NUMBER"/> <field name="name" type="VARCHAR"/> <field name="surname" type="VARCHAR"/> <field name="address" type="VARCHAR"/> <field name="city" type="VARCHAR"/> <field name="state" type="VARCHAR"/> <field name="cap" type="VARCHAR"/> <field name="borndate" type="DATE"> <param name="inputformat" value="dd/MM/yy"/> <param name="outputformat" value="yyyy-MM-dd"/> </field> <field name="dummyField" type="VARCHAR"> <param name="notnullvalue" value="'10'"/> </field> </structure> <!-- WHAT GRAMMAR USE --> <grammar class="net.sf.csv2sql.grammars.oracle.GrammarFactory"/> <!-- TEMPORARY STORAGE --> <storage class="net.sf.csv2sql.storage.Memory"/> <!-- RENDERER CONFIGURATION --> <render class="net.sf.csv2sql.renders.SqlInsertRenderer"> <param name="inputfile" value="users.txt"/> <param name="separator" value=","/> <!--optional--> <param name="trimdata" value="true"/> <param name="suppressheader" value="false"/> <param name="removedoublequotes" value="false"/> <!-- decomment for add id autogeneated field --> <param name="idGenerator" value="net.sf.csv2sql.idgenerators.Incremental"/> </render> <!-- WRITER CONFIGURATION --> <output> <writerAppender active="true" class="net.sf.csv2sql.writers.ThreadedStandardOutputWriter"> <param name="printprogress" value="true"/> <param name="stopatprogress" value="100"/> </writerAppender> </output> </root> |