Well, I was thinking simple.
Place a Base file with the sakila table definitions (sans indexes, triggers)
in a directory.
Place the file sakila-data.sql in the same directory.
In the Base database create a TEXT table, with a single column per record
for each line in the file.
CREATE TEXT TABLE SAKILA_DATA (INPUT_LINE LONGVARCHAR(1000000000));
Source the text table to the data file and set the field separator to a
semi-colon.
SET TABLE SAKILA_DATA SOURCE "sakila-data.sql;fs=\semi";
Now in the data file there are 17 insert statements - which can be had with
a simple query.
SELECT INPUT_LINE
FROM SAKILA_DATA
WHERE LEFT( INPUT_LINE, LENGTH('INSERT INTO')) = 'INSERT_INTO');
Create a basic procedure:
Create a ResultSet by executing the above query in a statement.
FOR EACH ROW in the result set
STATEMENT.EXECUTE( resultset.getstring(1) )
DROP TABLE SAKILA_DATA
Everything up to the "create basic procedure" works
- off to try the macro.
OOPS - I switched from OpenSUSE to Win 7 for that last step.
Open new issue, seems one can not SOURCE a text table under Win
7...arrrgh....back to Linux for the moment.
