[Zope-dev] LoginManager question

[Phillip J. Eby]

At 12:19 PM 3/27/01 +0200, Bertrand Croq wrote:
>Hi,
>  I am currently using LoginManager to authenticate users from a MySQL 
>database. I followed the tutorials and it works quite well; but there are 
>other data associated with users in the database that I would like to use in 
>Zope. I have found a solution but I think it is quite complicated:
>
>- first, I added SQL_id_user (ZSQL-method) in the acl_users:
>
>select id_user
>from user
>where <dtml-sqltest username column=user_name type=string>
>
>- then, I added id_user (DTML-method) in the acl_users:
>
><dtml-in expr="SQL_id_user(username=username)">
>  <dtml-return id_user> 
></dtml-in>
>
>- now, when I want to get the id_user value associated with the current
user, 
>I need to do:
>
><dtml-with REQUEST>
> <dtml-var
>  expr = "AUTHENTICATED_USER.id_user(
>   AUTHENTICATED_USER,
>   username=AUTHENTICATED_USER
>  )"
> >
></dtml-with>
>
>Isn't there an easier way to get the id_user value?
>

Yes, there is.  Get rid of the "id_user" DTML method and add the following
to a SkinScript method inside your UserSource:

WITH QUERY SQL_id_user(username=self.id) COMPUTE id_user

You should then be able to do "AUTHENTICATED_USER.id_user" to retrieve the
attribute.