[sqlalchemy] Sanity checks

2009-01-01 Thread vctr...@gmail.com
Is there a way to do some sanity check through thr SQLAlchemy. Check like - SQL Service is running, DB exists etc. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email

[sqlalchemy] Re: Convert type from dbapi description

2009-01-01 Thread goo...@venix.com
On Dec 31 2008, 4:00 pm, Dusty Phillips buch...@gmail.com wrote: Hi there, I've been searching all over for a solution to this and have concluded that I must be doing it all wrong. I need to create a simple view of an arbitrary sql query result that includes the column names and types as

[sqlalchemy] Re: metadata.bind.echo = True

2009-01-01 Thread Michael Bayer
thats the SQL which SQLAlchemy is emitting. On Jan 1, 2009, at 2:31 AM, Ash wrote: Hello i am using sqlalchemy and to trace the query i use metadata.bind.echo = True but the o/p is very strange it gives the catalog queries. like INFO:sqlalchemy.engine.base.Engine.0x..4c:

[sqlalchemy] Re: Creating a custom type

2009-01-01 Thread Kless
I've been trying create the extension. Here is the code with a test: http://paste.pocoo.org/show/97502/ - Extension http://paste.pocoo.org/show/97503/ - Test I need help to solve this little issue: entity._descriptor.add_mapper_extension(BcryptMapperExtension()) AttributeError: 'str'

[sqlalchemy] LucidDB - open RDBMS with advanced features

2009-01-01 Thread Kless
Here there is a presentation [1] over LucidDB [2], a new open-source RDBMS with advanced features and greater performance than MySQL. Besides column-store, other features covered include bitmap indexing, hash join/aggregation, page-level multiversioning, intelligent prefetch, star-join

[sqlalchemy] Re: Creating a custom type

2009-01-01 Thread Michael Bayer
mapper extensions are established during the mapper() phase: mapper(someclass, sometable, extension=BycryptMapperExtension()) On Jan 1, 2009, at 1:35 PM, Kless wrote: I've been trying create the extension. Here is the code with a test: http://paste.pocoo.org/show/97502/ - Extension

[sqlalchemy] Re: Creating a custom type

2009-01-01 Thread Kless
It's being passed from the IsBcrypt constructor, so: entity._descriptor.add_mapper_extension(BcryptMapperExtension()) On 1 ene, 19:48, Michael Bayer mike...@zzzcomputing.com wrote: mapper extensions are established during the mapper() phase: mapper(someclass, sometable,

[sqlalchemy] Re: Creating a custom type

2009-01-01 Thread Kless
I just see that will be by a problem of change in API AttributeError: 'str' object has no attribute '_descriptor' Kless ha escrito: It's being passed from the IsBcrypt constructor, so: entity._descriptor.add_mapper_extension(BcryptMapperExtension()) On 1 ene, 19:48, Michael Bayer

[sqlalchemy] Re: Creating a custom type

2009-01-01 Thread Jonathan LaCour
Kless wrote: I just see that will be by a problem of change in API AttributeError: 'str' object has no attribute '_descriptor' As I indicated to you over on the Elixir list, you seem to have used the Elixir encryption extension as a starting point. The _descriptor and the concept of an

[sqlalchemy] Re: Creating a custom type

2009-01-01 Thread Kless
Thanks. This was your message on the Elixir list: It looks to me like you are using SQLAlchemy without Elixir, and therefore this isn't the proper place to be asking this question. You should ask over on the SQLAlchemy mailing list. If you would like help creating an elixir extension, I can

[sqlalchemy] Re: schema inspection api

2009-01-01 Thread Nicolas Echaniz
On Monday 29 December 2008 13:31:02 Michael Bayer wrote: [...] There are already a lot of tools that build forms and such based on tables which use the existing reflection capabilities, so what's currently available is probably sufficient for your needs. Michael, Do you by any chance have a

[sqlalchemy] Re: schema inspection api

2009-01-01 Thread Michael Bayer
sure we have: http://code.google.com/p/dbsprockets/ http://code.google.com/p/formalchemy/ http://www.sprox.org/ to be fair, sprox seems to be a reorganization of dbsprokets. On Jan 1, 2009, at 6:36 PM, Nicolas Echaniz wrote: On Monday 29 December 2008 13:31:02 Michael Bayer wrote: [...]

[sqlalchemy] How to identify a transaction that has already begun

2009-01-01 Thread Jaimy Azle
Hi All, I configure a session (from elixir) using this code: session = sqlalchemy.orm.scoped_session( sqlalchemy.orm.sessionmaker( autoflush=False, autocommit=False ) ) Is there any way to