[Zope] Mapping acl_users to a database

Jim Sanford jsanford@atinucleus.com
Wed, 22 Mar 2000 14:40:46 -0600


I use a wrapper sql method called UserSettings.

Any calls to data are wrapped in a call to UserSettings eg.

<dtml-in UserSettings>
...
</dtml-in>

UserSettings SQL is : "select * from online where username=<dtml-sqlvar "_.str(AUTHENTICATED_USER)" type=string>"

The online table has columns for data (user name , etc) as text and memos  and permissions (is_super, edit_media...) as logicals
(True/False)

I use the returned information to decide whether an item is displayed or how it is displayed.

 __________________________________________________________________

              Jim Sanford
      .       Database/Web Engineer
     / \  /   Accelerated Technology, Inc.
    /   /     720 Oak Circle Drive East
   /  /  \    Mobile, AL 36609
  / /     \   Voice: 334-661-5770  fax: 334-661-5788
 /         \  E-Mail: jsanford@atinucleus.com
              Web: http://www.atinucleus.com

 Nucleus.  All You NEED in an RTOS.  Royalty Free.
 __________________________________________________________________


----- Original Message -----
From: Ken Kinder <kkinder@messagemedia.com>
To: <zope@zope.org>
Sent: Wednesday, March 22, 2000 2:23 PM
Subject: [Zope] Mapping acl_users to a database


Does anyone have code that map acl_users to a database table?

--
Ken Kinder
303.381.7631

_______________________________________________
Zope maillist  -  Zope@zope.org
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists -
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )