Thanks for your answer!
The ability to generate standard SQL is one thing, but beeing able to hande binary data at all (maybe not for all databases)
is sure an import point. Maybe I can provide an extension for this at some point in time…
Actually I stumbled over LiquiBase in search of a standard SQL way to insert binary data! (which doesn’t exist it seems…)
But don’t you think it’s possible to use the LoadData tag for this purpose?
Unfortunately the documention for this tag is somewhat short, I didn’t even achieve to load anything!
Using the LiquiBase 1.9 ant task, MySQL 5.1, I tried the following:
‘profile.csv’ contained no binary data, it’s contents was:
First I tried it to the changelog, then I used the file path relative to the CP root, but only with an absolute file path
it succeeded. With any relative path I always got:
java.lang.RuntimeException: profile.csv could not be found
But then, with an absolute path the command passed successfully but no data where inserted into the DB!
So how to specify the file attribute? (relative to what?)
And are the column definitions mandatory for loadData? The command passed with and without them but in
neither case any data were inserted! (and no error, no warning reported)
And then: if this would succeed, do you think I can import binary data with this?
Using a CSV like: 1,myname,xxxxxxxxxx
where xxxxxx would be binary data encoded in UTF-8 or Base64?
thanks in advance,