Hi All,
We are using jooq to generate model form csv file with maven
(jooq-codegen-maven3.6.4)
we need to run n csvs to generate the whole model.
we have something like this in our pom.xml
<jdbc>
<driver>org.h2.Driver</driver>
<user>pass</user>
<password>pass</password>
<url>jdbc:h2:mem:test;INIT=CREATE TABLE
MY_TABLE AS SELECT * FROM
CSVREAD('src/test/resources/myFile.csv');TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0</url>
</jdbc>
is it possible to have something like this working ?
<jdbc>
<driver>org.h2.Driver</driver>
<user>sa</user>
<password>sa</password>
<url>jdbc:h2:mem:test;INIT=CREATE TABLE MY_TABLE_A AS SELECT * FROM
CSVREAD('src/test/resources/myFileA.csv');TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0</url>
<url>jdbc:h2:mem:test;INIT=CREATE TABLE MY_TABLE_B AS SELECT * FROM
CSVREAD('src/test/resources/myFileB.csv');TRACE_LEVEL_FILE=0;TRACE_LEVEL_SYSTEM_OUT=0</url>
</jdbc>
or an INIT clause like this :
INIT=CREATE TABLE MY_TABLE_A AS SELECT * FROM
CSVREAD('src/test/resources/myFileA.csv') ; CREATE TABLE MY_TABLE_B AS
SELECT * FROM CSVREAD('src/test/resources/myFileB.csv');
Thanks for your answers
Regards,
Yacine
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
