[bug-anubis] database access with 3,9,95 - feature request

[Jim Cheetham]

I'm querying a MySQL database for the user database, and things (now)
work fine.

Unfortunately, while extending my database schema to deal with all sorts
of interesting things, I want to normalise some of the fields Anubis
would like to see into separate tables.

Because I'm using MySQL, I can't construct a view (only available in
v5+, which is in alpha) that would provide a virtual table.

I can quite easily provide the table that Anubis would like to see as
the result of a query, however ...

The sort of query would be :-

SELECT concat(lhs,'@',domain) AS authid,
       password_plain AS passwd,
       uname AS account,
       anubisrc AS rcfile
FROM email_auth
        NATURAL JOIN email_address
        NATURAL JOIN domain
        NATURAL JOIN sysaccount

So, can I request consideration of a new database URL parameter, query,
which defaults to 'SELECT * from users' ?
-- 
Jim Cheetham
Systems Administrator, eCOSM Limited.
Phone +64 3 365 4176 | Mobile +64 21 177 8606
http://www.ecosm.com/