This data provider reads a database model from a text file, as documented in the below sample file: # Comments start off with a hash # Statement strings have no prefix and should be ended with a semi-colon select 'A' from dual; # Statements may be followed by results, using > > A > - > A # Statements should be followed by "@ rows: [N]" indicating the update count @ rows: 1 # New statements can be listed int his file select 'A', 'B' from dual; > A B > - - > A B @ rows: 1 # Beware of the exact syntax (e.g. using quotes) select "TABLE1"."ID1", "TABLE1"."NAME1" from "TABLE1"; > ID1 NAME1 > --- ----- > 1 X > 2 Y @ rows: 2 # Statements can return several results > F1 F2 F3 is a bit more complex > --- -- ---------------------------- > 1 2 and a string containing data > 1.1 x another string @ rows: 2 > A B "C D" > - - ----- > x y z @ rows: 1
Results can be loaded using several techniques:
>, then {@link DSLContext#fetchFromTXT(String)} is usedThis implementation is still very experimental and not officially supported! @author Lukas Eder
| |