[Zope-dev] SQL-Methods Through-the-FileSystem

[Johan Carlsson]

> Seb:
> > Does anybody have a good suggestion how to
> > develope SQL Method ftfs (through the filesystem)
> > rather than ttw.
> > 
> > Perferably in someway similare to the HTMLFile way 
> 
> try something like this:
> 
>   from Products.ZSQLMethods.SQL import SQL
>   import PoPy
> 
>   def manage_add_user(self,email,password):
> 
>     conn = 'PoPy_database_connection'
>     self.sql_add_user=SQL('sql_add_user', '', conn, 'email password', _sql_add_user)
> 
>     _sql_add_user = """
>     insert into tbl_users(email,password)
>     values (
>       <dtml-sqlvar email type=string>,
>       <dtml-sqlvar password type=string>
>     )
>     """

Hi Seb,

I guess I could skip putting it in a method and create the SQL instance 
as a attribute of the class (that I currently would be working on)?

Why do I need to import the database module?
Couldn't I just try to locate/create a DA when my class is instantiated?

Would it be poor design to create a DA connection as an attribute of the class?
Or would it be perferd to create it in the __init__ as a instance attribute?

Thanks,
Johan