[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: Jim Cheetham
Subject: [bug-anubis] database access with 3,9,95 - feature request
Date: Mon, 13 Sep 2004 15:28:52 +1200

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

reply via email to

[Prev in Thread] Current Thread [Next in Thread]