[Zope-DB] Re: Zope-DB digest, Vol 1 #191 - 1 msg

[Steve Spicklemire]

You can also use something like ZPatterns to keep your data in MySQL, 
but have it *appear* as attributes of Zope objects. There is a ZPatterns 
based authentication product (LoginManager) that would permit you to 
connect your existing MySQL username/password info to handle Zope 
authentication. I've used LoginManager with CMF and it works great!  The 
bad news is that ZPatterns has a bit of a learning curve, but we can 
help with that. ;-)

take care,
-steve


On Tuesday, June 4, 2002, at 03:20  PM, alan runyan wrote:

>> currently I'm running a "normal" website with PHP and MySQL. I want to
>> change my site and use Zope. In my DB there are Login information about
>> every user, ie. loginname / password / email and more. How can I 
>> migrate
>> these infos to a ZDB? Is there a possibility to do that ?
>
> sure.  you will need to have MySQL RDBMS in ZOPE and write some python
> scripts that suck out the data
> and create objects from them.  for your 'member properties' I would 
> suggest
> looking into exUserFolder or
> CMF (which has portal_memberdata tool).  Being a big CMF fan I would 
> suggest
> the latter.
>
> You may want to read over the ZODB Articles here
> http://zope.org/Documentation/Articles
> so you have deeper understanding of the ZODB.  ZODB is the thing you
> '/manage' through your web browser.
> those are not files but objects.  there is no SQL-commands to query the 
> ZODB
> with - there are some products
> that attempt to provide this functionality.  you write python to query 
> the
> ZODB -- its quite wonderful.
>
>> Is there a possibility to control a ZDB with SQL-commands like select 
>> or
>> update?
>
> not really.  you need to think more object oriented and less RDBMS when
> dealing with ZODB.
>
>> I appreciate any help.
>
> I would suggest keeping your data where it is.  unless you need ZODB
> functionality like undo, etc.
>
> ~runyaga
>
>> regards
>> Lars
>>
>>
>>
>>
>>
>>
>> --__--__--
>>
>> _______________________________________________
>> Zope-DB mailing list
>> Zope-DB@zope.org
>> http://lists.zope.org/mailman/listinfo/zope-db
>>
>>
>> End of Zope-DB Digest
>>
>
>
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://lists.zope.org/mailman/listinfo/zope-db