I guess most good use cases would be coupled to \f {tab|csv} to re-process
tabular data easily.
For example, to visualize the result of your queries as plots rather than
raw data:
sql>\f tab
sql>\| makePlot.sh
sql>select ....; -- a plot pops up
sql>select ....; -- another plot pops up
As for security, it may look scary, but unless I'm overlooking something it
shouldn't be dangerous.
Yes, you can execute external commands, but on the client, not the server.
And since you have supposedly run mclient yourself, you cannot run from
within mclient anything that you could have run outside it anyway.
Roberto
On Thu, 13 Jul 2017 at 14:39 Brian Hood
So you can actually execute commands in mclient what are the normal use cases for this and looks dangerous.
Regards,
Brian Hood
On Wed, Jul 12, 2017 at 2:09 PM, Roberto Cornacchia < roberto.cornacchia@gmail.com> wrote:
Oh dear.
I'm almost ashamed of sharing this, but here's the solution I found.
The following script could be piped to an interactive (-i) session of mclient (only meant as a trick for some benchmarking scripts):
sql>\|grep EXEC | perl -pe 's/^.*EXEC (\d+).*$/EXEC $1();/' > /tmp/myexec sql>prepare select 1; 1 tuple (1.097ms) sql>\| sql>\
Do I win any prize for the most ugly, unsafe mclient trick of the year?
Any cleaner solution is welcome ;) Roberto
On Wed, 12 Jul 2017 at 14:36 Roberto Cornacchia < roberto.cornacchia@gmail.com> wrote:
Hi there,
I'm trying to script the execution of (generated) prepared queries. It does not look possible, because the identifier to use for the EXEC statement is returned dynamically by the PREPARE statement:
sql>prepare select 1; execute prepared statement using: EXEC 73(...)
This can obviously not be scripted. If I tried to parse the output of the prepare statement to retrieve the identifier, this would split PREPARE and EXEC in two different mclient sessions, losing the prepared statement.
As far as I know, there is at the moment no syntax available for providing the identifier, something like:
sql>prepare myid as select 1;
(that wouldn't be a bad idea, would it?)
Besides syntax extensions, I was wondering if there is any trick I could use at runtime with the current syntax to retrieve that identifier. Like, is it stored in some system table? Is it available as any undocumented variable? I could not find anything like that, but I might have missed it.
Cheers, Roberto
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list