[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
http://www.ecosm.com/
- [bug-anubis] database access with 3,9,95 - feature request,
Jim Cheetham <=