[Zope] external method database connection

knight knight@righteous.net
Fri, 6 Oct 2000 02:05:26 -0700 (PDT)


Also, you could always import the specific module for your database, and
create a db connection, then execute() and fetch() directly. Although, if
you are putting this in an external method, it would be wiser to use your
existing ZSQL methods ;]

Knight
knight@phunc.com

On Fri, 6 Oct 2000, knight wrote:

> 
> > How do I get  a zope database connection from an enternal method? 
> 
> You can access your db using your existing ZSQL Methods by calling them
> from the namespace passed in, specifically self.
> 
> Example:
> 
> def myextmethod(self):
>   mfl_id = 3
>   results = self.sqlCountUsers(mfl_id=mfl_id)
>   for result in results:
>     print result[0], result[3]
> 
> 
> 
> Keep in mind that a list is returned, not a dictionary.
> 
> Knight
> knight@phunc.com
>     
> 
> 
> _______________________________________________
> 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 )
> 
>