INSTALL

Unpack the tar-file in our Products directory.

HOWTO USE

Your Product file:

    ...
    from Products.DCDSQL.DCDSQLMethod import DCDSQLMethod
    from Products.DCDSQL.DCDSQLConnection import DCDSQLConnection

    connection=DCDSQLConnection()
    connection.edit("<database connection string>")

    ...

    class YourProduct(<base classes>):

        class MyBrain:
            """\
            MyBrain is a class that gets returned by a
            SQL Method. You can add stuff to it like methods
            and attributes.
            """

            def dollar_volume_backordered(self):
                return self.name * self.id

        mysql_method=DCDSQLMethod('mysql_method', connection,
            '''\
            id:int
            ''', '''\
            select * from mytable where id=<dtml-sqlvar name="id" type="int">;
            ''', MyBrain)

        def manage_test_method(self, id=1, REQUEST=None):
            """\
            Calling the 'mysql_method' method.
            It returns a list of MyBrains.
            """
            out=""
            result=self.mysql_method(id=id)
            for r in result:
                out=out+"%d: %s<br>" %(r.id, r.dollar_volume_backordered())
            return out

    ...

    Globals.InitializeClass(YourProduct)

    def initialize(context, globals):
        """Initialize EasyEditable Product"""