Re: [Zope-DB] use of cx_oracle adapter from within python script ?

---t3039608.html -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Automatic capture of user ids for auditing

. You may take a look at CCZSQLMethods as they are example of extending ZSQLMethods. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] case insensitive ZSQL queries

thanks -- it now works like a charm AFAIR 'ilike' in postgres doesn't properly support i18n characters, so be carefull with that. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] updating fields in a zsql method programmatically

) or even: context.insertNew(field1='something', field2=other_variable) It is more clear than getting values from context I think. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] updating fields in a zsql method programmatically

onsombal napisał(a): I tried the techniques you suggested and it results in the same error -- KeyError: 'form.submitted' You didn't tell about this kind of error before. Post a full traceback, please. I suppose that error is somewhere else... -- Maciej Wisniowski

Re: [Zope-DB] Reference DTML-sqlvar in ZPT?

/name/div /div -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

[Zope-DB] Re: [Zope] Conflict errors

Could anyone suggest whats happening here that cause this error. Look at list archives. You may try to incerase session-resolution-seconds to 300 in your instances zope.conf and see if there is less of these errors. BTW. Zope-DB is about Zope and relational databases only. -- Maciej

Re: [Zope-DB] Using dtml-vars in ZSQL methods?

be harmful unless you're sure that it is not possible to do sql injection. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Using dtml-vars in ZSQL methods?

? It may be used to do 'where colname in ' statements. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Seeking a suitable ZpsycopgDA

zope instance Products/ this will work (if only you will have correct version). -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Unified DA for Zope 2 using SQLAlchemy?

) is a nice idea :) -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Unified DA for Zope 2 using SQLAlchemy?

from databases. How does SQLAlchemy support this? Another thing, what about speed of ORMs in comparision to traditional queries with ZSQLMethods? -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] DCOracle2 and x86_64

servers in order to avoid segfaults :) ) but I'll try when it'll be possible. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] DCOracle2 with a Stored Procedure that Returns REFCURSOR / ORA TIMESTAMP DataType Issue

systems everything was ok. Is your problem with TimeStamp related to 64 bit platform or it happens on 32 bit platforms too? -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] form-controllerPythonScript-ZSQL

zsql: how to do it Have you read 'Relational database connectivity' chapter of Zope Book? -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] How to export data from ZODB to MYSQL

database connectivity at http://www.plope.com/Books/2_7Edition/) 2. You want to use MySQL instead of ZODB (alternative storage) So, what do you want to do? -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman

Re: [Zope-DB] Extract Files from ZODB

stores objects... BTW. This list is for relational database connectivity and zope not for ZODB issues. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: RE : Re: [Zope-DB] modifications on a query

any suggestions? Write a procedure in the database that does this and just call this procedure from Zope. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: RE : [Zope-DB] How lunch SQL request from python script ?

it to your database. Create external method like: def callSQL(self, statement): conn = self.myconnection() return conn.query(statement) -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: RE : [Zope-DB] How lunch SQL request from python script ?

calling ZSQLMethod? -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] [Zope] ZSQL Methods and transaction control

connection to the pool here # if your DA uses one If you'll have to do something more with database, then do it after calling this function otherwise it will be commited or rolled back during call to callSQLtransactionSet method. I'm not sure that this will work. -- Maciej Wisniowski

Re: [Zope-DB] Basic tsql example using MxODBC Zope DA adaptor?

without any mxODBCZopeDA features (there are examples in mxODBC docs). Just write a python script (without zope) that does what you need and then plug it into Zope as external method (or product). -- Maciej Wisniowski Maciej, Thank you for your assistance. I plugged in the new code, using

Re: [Zope-DB] Sybase Adapter error :: alternatives?

b) any alternatives to get connect to a Sybase DB? How about mxODBC? There is also SQLRelay that should work with Sybase -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

[Zope-DB] DCOracle2 and x86_64

/instancje/kfk_kw_testa/Products/DCOracle2/src' -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] [ANN] Modified version of DCOracle2 is available

. Unfortunatelly I have no Solaris. But would be nice if you can check dco2.c from this version on Solaris machine. At last I'll add a note about this Solaris issue into INSTALL file. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http

Re: AW: [Zope-DB] [ANN] Modified version of DCOracle2 is available

into dco2.c. Thank you very much for these fixes. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] [ANN] Modified version of DCOracle2 is available

version, with some code from ChrisW branch (reconnect after connection is broken) is now at: https://dcoracle2da.googlecode.com/svn/branches/sqlalchemypool In general all this code is considered 'under developement'. There is nothing in tags/ yet. -- Maciej Wisniowski

Re: [Zope-DB] [ANN] Modified version of DCOracle2 is available

, but there are no parts of it's code here. Seems this is same as need to have Oracle Client installed in system in order to use DCOracle2. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] [ANN] Modified version of DCOracle2 is available

already has such statement. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

[Zope-DB] [ANN] Modified version of DCOracle2 is available

THAT THIS WILL WORK FOR YOU, SO BE CAREFULL :) -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

[Zope-DB] Re: Zope database connectivity

with transactions integrity in this situation. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

[Zope-DB] Zope3.3.0 - zope.rdb implementation - bug, feature or what?

useful...? Is this issue a bug or feature or something else. I'm not able to recognise them myself (especially after submitting request.locale issue on z3-five list :)). I would like to know your's opinions before submiting a bug and/or trying to create a patch. -- Maciej Wisniowski

Re: [Zope-DB] working with zope rdbms transaction mgmt

Upsss... sorry It's really old post... My sort order failed or something... -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Zope database connectivity

. As a result if we have a lot of SP calls during one request there is a lot of commits (rollbacks) to the same db connection. Maybe it's something about caching procedure objects in volatile attributes. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB

Re: [Zope-DB] Zope database connectivity

database was restarted shouldn't be too difficult too. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Zope database connectivity

() for this? Isn't Transaction something persistent? Or maybe its better to use request object instead (sounds a bit ugly but why not?)? Seems to be too simple so I've possibly missed something :) Any ideas? -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB

Re: [Zope-DB] Zope database connectivity

('Shared.DC.ZRDB.Connection', ERROR, 'Error connecting to relational database.', error=exc_info()) Do you have 'connect_' defined elsewhere or it is expected to raise an exception here and just log this? -- Maciej Wisniowski

Re: [Zope-DB] Zope database connectivity

of TransactionManager is called - it may close the database connection like SQLRelayDA: def _finish(self, *ignored): self.con.commit() self.con.close() or just commit a connection (DCOracle2). -- Maciej Wisniowski

Re: [Zope-DB] TAL and empty sql-list

If you really have to do it in TAL try: div tal:define=results python:here.project(uname=username) tal:content=python: results and results[0].project or '---' / -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http

Re: [Zope-DB] Checkboxes selecting records...

: select * from table_horses where horse_id in (1, 3, 4, 6) You can find how to write such ZSQLMethod in Zope Book (chapter about relational database connectivity). Hope I understood you correctly :) -- Maciej Wisniowski ___ Zope-DB mailing list Zope

Re: [Zope-DB] dealing with dropped database connections

-discussion. - Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] can't Show More than 20 records

'resolved' bugs in collector hth -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

[Zope-DB] DCOracle2 and ConnectionReleasedError

._v_connection_id ) db.rollback() returnConnection( self._v_connection_id ) self._v_connection_id = None #--- -- Maciej Wisniowski

Re: [Zope-DB] Zope 2.8 and DCOracle2 Stored Procedures

return 1 to Procedure class in SP.py (and to DB class in db.py - just in case) and it seems to work now :) Tomorrow I'll try with chrisw version too. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope