iterate_query with static userdb ?

[Laura Smith]

On Sunday, 17 May 2020 11:11, James <list at xdrv.co.uk> wrote:

> On 17/05/2020 10:43, Laura Smith wrote:
>
> > Because I wanted to avoid storing uid/gid/home in the database ?
>
> I use:
>
> user_query = "SELECT 'vmail' AS uid, 'vmail' AS gid, allow_nets,
> '*:storage=' || quota || 'M' AS quota_rule FROM mailbox WHERE username =
> '%n' AND domain = '%d';"
>
> ... uid and gid are not stored in my database but are returned by the query.


Thanks !