(and to the list.. Apologies Gavin for private reply...)
On 7 May 2010 19:19, Gavin McCullagh <gavin.mccull...@gcd.ie> wrote:
> On Thu, 06 May 2010, Steve Polyack wrote:
>
> > These are certainly good points. My thought is just that instead of
> > breaking out of bconsole to perform these tasks can be cumbersome.
> > Personally, I feel that it's something that I'd use a lot, simply to
> > prevent me from constantly breaking in and out of the interactive
> > bconsole session. However, perhaps a solution would be to have bconsole
> > parse the pipe character and feed output into the command that follows
> > which could be any arbitrary *nix command (as opposed to
> > writing/including our own version of grep).
>
> For comparison, the Postgresql and MySQL command line interfaces include
> something similar to this.
>
> MySQL offers the "pager" command which can be set to "less" or "grep xxxx",
> etc. as well as the tee command to also send output to a file. Postgresql
> offers a single:
>
> \o [FILE] send all query results to file or |pipe
>
> Neither allow anything as simple as
>
> SELECT ....... ; | grep blah
>
>
my $0.02,
Bconsole already performs SQL queries for all commands that would issue a
long listing, right?
SQL was meant for filtering & relating data ... Why not add some filter
param that is added to the SQL being sent to the backend? something like the
original suggestion,but simply as an extra parameter to the existing
command. for example:
*list files jobid=999 incFile="%budget%2009%" excFile="%.doc"
to include all *budget*2009* files, except *.doc .
Similar extensions:
- case sensitive , or not.
- paths instead of file
- client names
- etc
The tricky bit may be avoiding SQL injection attacks, but there should be
some libraries / standard practices for dealing with this.
I think this may be a cleaner approach for then end user.
This may not apply if you have 1,000 clients, 'list clients' may not benefit
from this as it doesnt query SQL...
B
_________________________
{Beto|Norberto|Numard} Meijome
"I detest people who take shortcuts rather than do things right, because
they leave shit for the rest of us to clean up."
PHK
------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
