Am Freitag 12 Februar 2010 11:21:55 schrieben Sie: > Le Vendredi 12 Février 2010 11:01:52, Philipp Storz a écrit : > > Am Freitag 12 Februar 2010 09:50:53 schrieben Sie: > > > Hello, > > > > > > Le Vendredi 12 Février 2010 09:41:51, Philipp Storz a écrit : > > > > > > - copy the examples/sample-query.sql to query.sql, as before, the > > > > > > "query" > > > > > > > > > > > > command had no queries. > > > > > > > > > > I don't know what this refers to. > > > > > > > > This refers to > > > > http://www.bacula.org/5.0.x-manuals/en/main/main/New_Features_in_5_0_ > > > >0. ht > > > > > > > >ml > > > > > > > > : --------------------------- > > > > > > > > Custom Catalog queries > > > > If you wish to add specialized commands that list the contents of the > > > > catalog, you can do so by adding them to the query.sql file. This > > > > query.sql file is now empty by default. The file > > > > examples/sample-query.sql has an a number of sample commands you > > > > might find useful. > > > > --------------------------- > > > > I think that a rpm package should directly use the sample-query.sql > > > > file installed as the query.sql file, as otherwise the query command > > > > would have no single entry. > > > > > > We now use an empty query.sql file because we don't want to support > > > custom queries across all database engines and all database versions. > > > > > > If you still use the sample query file, support requests will continue > > > to come... > > > > > > In the 5.0.1 release, the first line of the query file explains where > > > the > > > > > > user can find samples. I think that you should do the same. (with the > > > appropriate RPM path) > > > > > > Bye > > > > Hello Eric, > > > > I understand what you are thinking about, but I think that having such a > > really useful command like "query" without any use in the default > > configuration is not the right way to do it. > > > > Maybe it would be possible to have at least one single command (like jobs > > are saved on a certain medium, or something even simpler) should be > > supported, so that a potential user has something to play with. > > Yes, this is possible, but it requires lots of work, if someone is ready to > write them and test them on a dozen of different databases, why not. (it > can be done step by step)
Well, i think that this sounds exactly like something that could be tested automatically by an regression test. > (For example, SQLite3 versions between 3.50 and 3.60 have problems with > JOIN Table USING ()...) Do you have more information about problems regarding the query commands? Which one does not work etc. > An other solution can be to test them and have a sample-mysql.sql, > sample-postgresql.sql, etc... Your package will be able to choose the right > one. > > I personally don't have time to do it, so if any volunteers want to do > that, it's time to speak up... I would try to build first an regression test, in order to test if the queries work. What do you think about that? regards, Philipp ------------------------------------------------------------------------------ SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev _______________________________________________ Bacula-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
