[Zope-DB] Process one PloneFormGen request into many SQL tables

[Dennis Schulz]

Hi Paul,

Ok to tell you honestly the truth, as a beginner you should try to leave 
your fingers of zope 3 /alchemist.
The learning curve is steep.
You will have to learn about Zope 3 widgets, schemas, interfaces, 
adapters....
You have to know how to configure the mapper, have to know how to handle 
the mapped objects....
And there is a lot of automatic machinery in the background going on 
such as automatic interface generation, formlib machinery etc. you have 
to be aware of.

I am currently writing my final project about it and to figure out all 
this it took me a lot of time....

Unfortunately I dont have much experience with Archetypes Widgets or 
PloneFormGen so I can't really help you.

But what you could certainly do is to write a zope 2 filesystem product 
that uses archetypes widgets.
I personally prefer not to use zsql methods since they include very 
special DTML systax and variables and stuff you dont need anywhere else.
You can also query the database adapter directly when you have a product.
Here an example: (conn is the db connection)
            sql  = "select max(a.idAmendment) as last_id from 
cyc_Amendments a"
            resultset = conn.manage_test(sql)
            result = int(resultset[0][0])

Or learn how to use SQLAlchemy, it really is a usefull toolkit you can 
also use standalone.


Dennis

Paul Eipper escribió:
> (this list replies to authors instead of the list as default >_< )
>
> ---------- Forwarded message ----------
> From: Paul Eipper <lkraider at gmail.com>
> Date: 19/01/2007 13:52
> Subject: Re: [Zope-DB] Process one PloneFormGen request into many SQL 
> tables
> To: d.schulz81 at gmx.net
>
>
> Hi Dennis,
>
> I was referred to the alchemist product by the PloneFormGen dev, but
> unfortunatelly I found the documentation for it extremely lacking (as
> in nonexistant :P)
>
> Since I am only learning all this, I can't take a product where there
> aren't at least intro docs for it and try to figure it all out by
> myself :(
>
> The only thing i could find is a video presentation that I will be
> taking a look at this weekend. Maybe it will serve as a good intro
> doc. For now I am trying to make it work using Python scripts + ZSQL
> methods manually.
>
> Would alchemist really simplify the coding? (/me has no idea)
>
> Thanks for the reply!
>
> -- 
> Paul Eipper
> Brasil
>
> 2007/1/19, Dennis Schulz <d.schulz81 at gmx.net>:
>> Hi,
>>
>> if you want to do things like this, you also could use the alchmist 
>> product.
>> However, I think the archetype / plone formgen integration at the moment
>> is not functional. (ask kapil t. and roché c. for closer info)
>> You would have to start out with plain zope 3 schema and formlib like in
>> the alchemist included orgpeople example.
>> I developed a neat little application that uses the unit of work and
>> automatic transaction support of sql alchemy and all dependent tables
>> are deleted, updated and inserted automatically by the mapper
>> (www.*sqlalchemy*.org/)
>>
>> Dennis
> _______________________________________________
> Zope-DB mailing list
> Zope-DB at zope.org
> http://mail.zope.org/mailman/listinfo/zope-db
>
>