Subject: | The hsql command is a special case that requires different behavior. |
The SCM command "hsql" needs to be treated differently than other commands. It allows
sending arbitrary select queries, the important ones being anything in the harvest schema. It
allows you to check which packages exist, which package groups exist, etc etc. Basically access
to all the metadata.
The scripter would supply a query string to that particular method, which should return values in
a similar fashion to the DBI module. It could even de-stupidify the <nl> and <tab> substrings
that CA thinks is an intelligent way to escape embedded newlines and tabs in records.
I'm willing to help with the coding, just would like some input on all the details.