Re: [Zope] Upload to database from a table (fwd)

2007-09-30 Thread Andreas Jung

Please stay on the list!

-aj

 Forwarded Message 
Date: 1. Oktober 2007 17:58:06 +1200
From: Inspire <[EMAIL PROTECTED]>
To: Andreas Jung <[EMAIL PROTECTED]>
Subject: Re: [Zope] Upload to database from a table

Thanks for the response Andreas

You are correct in that my understanding of Zope is rather shallow!

More to the point as to what I am attempting to do:

What I have done with Paradox and do not know how to duplicate with Zope is
to place three editable fields on a form (Date, Person and Account) and a
table  that lists the store inventory.

The store inventory is downloaded from Postgres each time the form is
accessed, and is sorted (type, item).  This info is displayed on the table
as  well as the item store number which is hidden from view or rather is in
the  underlying table.  On the table is also an editable field to enter the
quantity of goods issued.

Paradox makes it a simple matter to filter the displayed info by type, or
to  search for the required item to locate it and enter the issued goods.

The great benefit of using Zope is of course the access levels that can be
set  up.  The site is to cover Safety, Quality and the store.  The
organisations  owner/manager can from a browser, access the information he
wants.  Supplying  him and others with the information from Zope, is of
course relatively  straight forward - it is the input forms that have me.
Once I have got this  one going the rest should be straight forward.

As both Paradox and Python have a common root in Pascal I have not found
too  much difficulty in writing code in either.

Some help will be much appreciated

regards
Max



On Monday 01 October 2007 06:03, Andreas Jung wrote:

--On 1. Oktober 2007 05:52:07 +1200 Inspire <[EMAIL PROTECTED]> wrote:
> To update one entry into the database from the browser is
> straight-forward.

Huh? You can of course as much SQL statements within one Zodb request as
you like. Why should this be limited to only one update??

>  I  have not worked out how to enter multiple
> transaction yet.

There is usually no need to deal with transactions on your own. Most
database adapters abort/commit together with a ZODB abort/commit. The
transactional integrity is given.

> It is probably pushing the boundary of Zope,

Unlikely your pushing the boundary...obviously you need a deeper
understanding of Zopeat least your posting does not contain much
valuable informations about what you are really trying to achieve and how
you are trying it to achieve...another try...explain what you're trying to
do and how.

-aj


-- End Forwarded Message --



--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376
Registergericht: Amtsgericht Stuttgart, Handelsregister A 381535
Geschäftsführer/Gesellschafter: ZOPYX Limited, Birmingham, UK

E-Publishing, Python, Zope & Plone development, Consulting


pgpr5YgoPjZaQ.pgp
Description: PGP signature
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] Upload to database from a table

2007-09-30 Thread Andreas Jung



--On 1. Oktober 2007 05:52:07 +1200 Inspire <[EMAIL PROTECTED]> wrote:


To update one entry into the database from the browser is
straight-forward.


Huh? You can of course as much SQL statements within one Zodb request as 
you like. Why should this be limited to only one update??



 I  have not worked out how to enter multiple
transaction yet.


There is usually no need to deal with transactions on your own. Most 
database adapters abort/commit together with a ZODB abort/commit. The 
transactional integrity is given.


It is probably pushing the boundary of Zope,


Unlikely your pushing the boundary...obviously you need a deeper
understanding of Zopeat least your posting does not contain much
valuable informations about what you are really trying to achieve and how 
you are trying it to achieve...another try...explain what you're trying to 
do and how.


-aj

pgpfWMF0LFnK5.pgp
Description: PGP signature
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


[Zope] Upload to database from a table

2007-09-30 Thread Inspire
To update one entry into the database from the browser is straight-forward.  I 
have not worked out how to enter multiple transaction yet.

My stop gap solution is to enter such data; in this case issuing items from a 
store, from Paradox directly into the database (Postgres).

It is probably pushing the boundary of Zope, however it would help if a 
searchable list of the store items are presented and the issue quantity can 
be inserted along side of the item.  My Paradox input displays the item and 
its category with it sorted by category and subsorted by item.

Any ideas out there

thanks
Max
___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists -
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )