sql config problem with position-dependent config params

[ha...@t-online.de]

Hi,

I am trying to use sql config, but it seems quite troublesome to receive sql data in
the correct order.

Assuming the default config is
- just tag headers but do not modify message (report_safe 0)
- no test report in the header (remove_header Report)
and a user wants to turn the reports on, the user config should say
add_header all Report _REPORT_
and be read after the defaults.

If, however, default policy leaves the report header and the user wants to disable, the user
config should be
remove_header all Report

The suggested database layout does not ensure that the remove_header is actually following
the report_safe part

Wolfgang Hamann

Re: sql config problem with position-dependent config params

[Michael Barnes <mb...@compsci.wm.edu>]

On Mon, Nov 01, 2004 at 02:22:39PM -0000, hamann.w@t-online.de wrote:
> I am trying to use sql config, but it seems quite troublesome to
> receive sql data in the correct order.
>
> Assuming the default config is
> - just tag headers but do not modify message (report_safe 0)
> - no test report in the header (remove_header Report)
> and a user wants to turn the reports on, the user config should say
> add_header all Report _REPORT_
> and be read after the defaults.
> 
> If, however, default policy leaves the report header and the user
> wants to disable, the user config should be
> remove_header all Report
> 
> The suggested database layout does not ensure that the remove_header
> is actually following the report_safe part

My only suggestion would be to use the user_scores_sql_custom_query
configuration option to create a custom SQL query that enforces the
order of the configuration directives.

It may not be ideal, but it is a workaround.

Mike

-- 
/-----------------------------------------\
| Michael Barnes <mb...@compsci.wm.edu> |
| UNIX Systems Administrator              |
| College of William and Mary             |
| Phone: (757) 879-3930                   |
\-----------------------------------------/