[sqlalchemy] Re: mod_wsgi, SQLite3 and a threading anomaly because connection is not returned to pool by session.remove()

On Jun 10, 10:08 pm, Michael Bayer mike...@zzzcomputing.com wrote: First off, the absolute recommended behavior for SQLite if a file-based database is to not use pooling.  I would suggest you use a NullPool to eliminate any connection pooling.  Some detail on this

[sqlalchemy] Re: help with 0.6 migration

Sorry, I found error... -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options,

RE: [sqlalchemy] Kerberos authentication with sybase

The DBAPI is python-sybase (http://python-sybase.sourceforge.net/). Here is an example: conn = Sybase.connect(hostname, , , delay_connect=1) conn.set_property(Sybase.CS_SEC_NETWORKAUTH, Sybase.CS_TRUE) conn.set_property(Sybase.CS_SEC_SERVERPRINCIPAL, principal) conn.connect() The variable

[sqlalchemy] How to map to read only descriptor

I am trying to map to a simple read only property. According to the docs, I *think* I am supposed to use synonym. The problem is that I am getting a None value for the mapped descriptor's column. For example: import datetime from sqlalchemy import Column, Table, Integer, String, MetaData,

[sqlalchemy] Session with multiple data insert

Hi all, i have the following situation: i have a table (imported_data) with data generated from some wifi terminals and i have other table (using_data) where user can modify / delete the data. Every time i run the program, i need to copy new data of imported_data into using_data. i using this

Re: [sqlalchemy] How to map to read only descriptor

On Fri, Jun 11, 2010 at 4:16 AM, jpeck peck.j...@gmail.com wrote: I am trying to map to a simple read only property. According to the docs, I *think* I am supposed to use synonym. The problem is that I am getting a None value for the mapped descriptor's column. Ok, so I got this working with

[sqlalchemy] Using Inspector with oracle+zxjdbc

Hello, I'm trying to retrieve some column properties from a oracle database using oracle+zxjdbc: jdbcUrl = '%(engine_dialect)s://%(username)s:%(password)s...@%(hostname)s:%(port)d/%(data base)s' % connection engine = sa.create_engine(jdbcUrl) inspector = sa.engine.reflection.Inspector(engine)

Re: [sqlalchemy] Kerberos authentication with sybase

On Jun 11, 2010, at 4:50 AM, Cserna, Zsolt wrote: The DBAPI is python-sybase (http://python-sybase.sourceforge.net/). Here is an example: conn = Sybase.connect(hostname, , , delay_connect=1) conn.set_property(Sybase.CS_SEC_NETWORKAUTH, Sybase.CS_TRUE)

Re: [sqlalchemy] How to map to read only descriptor

On Jun 11, 2010, at 5:16 AM, jpeck wrote: I am trying to map to a simple read only property. According to the docs, I *think* I am supposed to use synonym. The problem is that I am getting a None value for the mapped descriptor's column. For example: import datetime from sqlalchemy

Re: [sqlalchemy] Using Inspector with oracle+zxjdbc

On Jun 11, 2010, at 11:17 AM, Michael Bayer wrote: On Jun 11, 2010, at 7:46 AM, Witzel, Stefan wrote: Hello, I'm trying to retrieve some column properties from a oracle database using oracle+zxjdbc: jdbcUrl =

Re: [sqlalchemy] Using Inspector with oracle+zxjdbc

On Jun 11, 2010, at 7:46 AM, Witzel, Stefan wrote: Hello, I'm trying to retrieve some column properties from a oracle database using oracle+zxjdbc: jdbcUrl = '%(engine_dialect)s://%(username)s:%(password)s...@%(hostname)s:%(port)d/%(data base)s' % connection engine =

[sqlalchemy] Re: How to map to read only descriptor

On Jun 11, 10:13 am, Michael Bayer mike...@zzzcomputing.com wrote: On Jun 11, 2010, at 5:16 AM, jpeck wrote: I am trying to map to a simple read only property. According to the docs, I *think* I am supposed to use synonym. The problem is that I am getting a None value for the mapped

[sqlalchemy] cross-database joins with MySQL

Hi All, We have engines set up like: engine1 = create_engine('mysql://username:passw...@server/db1') engine2 = create_engine('mysql://username:passw...@server/db2') ..and then have them bound to separate sessions, with separate model classes mapped to them. Now, mysql supports cross

Re: [sqlalchemy] cross-database joins with MySQL

On Jun 11, 2010, at 12:51 PM, Chris Withers wrote: Hi All, We have engines set up like: engine1 = create_engine('mysql://username:passw...@server/db1') engine2 = create_engine('mysql://username:passw...@server/db2') ..and then have them bound to separate sessions, with separate model

[sqlalchemy] is attribute changes?

Hello. Is sqlachemy allow to check for changes on particallar mapped attribute? Receive it's old value? -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this

[sqlalchemy] Managing access and permissions to mapped objects and base tables

I am somewhat new to sqla and python. I am developing a module of sqla OR mapped objects that will be used by other developers. Those developers who will not be involved in the (currently postgres) database or model details. They will be using the module to write their own python clients to upload

Re: [sqlalchemy] good IDE for SQLAlchemy and wxPython?

On 10/06/2010 11:26 PM, werner wrote: Carl, That would be nice but I am not aware of one. Personally I use Boa to develop, it has a GUI designer built in you can use to generate the dialogs/frames etc and I then use validators to load data to/from the controls. I've had a quick look at