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

[seb bacon]

Hi Johan,

> 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>
    )
    """

hth,

seb