Hi all<div><br></div><div>I'm using relstorage for a long time with very good results. Until know, I also use database adapters like ZPsycopgDA to connect the same SQL database and store information in other application tables. I was thinking to create a Relstorage Database Adapter able to do the work using relstorage configuration and connections. Some preliminary simple tests seems to work:</div>
<div><br></div><div><div><div>def execute_query(conn, cursor, *args, **kw):</div><div> query = kw['query']</div><div> cursor.execute(query);</div><div> return cursor </div><div> </div><div>query = 'SELECT COUNT(*) FROM kmkey_task' </div>
<div>rows = app._p_jar._storage._with_store(execute_query, query=query)</div><div>print rows.fetchone()</div><div><br></div><div><br></div><div>The question is, can I go on ? Or use same connections than relstorage could cause problems at ZODB level ?</div>
<div><br></div><div>Thanks in advance</div>-- <br>Santi Camps <br>KMKey hacker (<a href="http://www.kmkey.com">http://www.kmkey.com</a>)<br>Earcon S.L. (<a href="http://www.earcon.com">http://www.earcon.com</a>)<br><br><br>
</div></div>