Bacula-users

Re: [Bacula-users] feature request: fixed naming/numbering of sql queries

2009-02-04 16:12:43
Subject: Re: [Bacula-users] feature request: fixed naming/numbering of sql queries
From: Ryan Novosielski <novosirj AT umdnj DOT edu>
To: bacula-users AT lists.sourceforge DOT net
Date: Wed, 04 Feb 2009 16:06:52 -0500
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Kern Sibbald wrote:
> Hello,
> 
> I have added this to the projects list.
> 
> Best regards,
> 
> Kern
> 
> On Wednesday 24 January 2007 16:43:45 mark.bergman AT uphs.upenn DOT edu 
> wrote:
>> Item  1:  enable persistent naming/number of SQL queries
>>
>>   Date:   24 Jan, 2007
>>   Origin: Mark Bergman
>>   Status:
>>
>>   What:
>>         Change the parsing of the query.sql file and the query command so
>> that queries are named/numbered by a fixed value, not their order in the
>> file.
>>
>>
>>   Why:
>>         One of the real strengths of bacula is the ability to query the
>>         database, and the fact that complex queries can be saved and
>>         referenced from a file is very powerful. However, the choice
>>         of query (both for interactive use, and by scripting input
>>         to the bconsole command) is completely dependent on the order
>>         within the query.sql file. The descriptve labels are helpful for
>>         interactive use, but users become used to calling a particular
>>         query "by number", or may use scripts to execute queries. This
>>         presents a problem if the number or order of queries in the file
>>         changes.

Wanted to give a +1 on this one. It's inconvenient to have this change
on you when you aren't routinely checking on your crontabs that may be
using it.

- --
 ---- _  _ _  _ ___  _  _  _
 |Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - Systems Programmer II
 |$&| |__| |  | |__/ | \| _| |novosirj AT umdnj DOT edu - 973/972.0922 (2-0922)
 \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkmKA2wACgkQmb+gadEcsb6fXgCfcW0dgW7cwbRkqSp7ow0eQP2R
JC4Anjhs5ev14qzyY6hOCzO8tna9zbDc
=LVeI
-----END PGP SIGNATURE-----

Attachment: novosirj.vcf
Description: Vcard

------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
<Prev in Thread] Current Thread [Next in Thread>