[sqlalchemy] boolean value for column_property

2009-02-24 Thread coder_gus
Hi guys, I just discovered column_property and I am trying to make a boolean property out of a table column. Let's say I have this didactic table: tblUsers = Table('users', metadata, Column('user', Integer), Column('type', Integer)) mapper(Users, tblUsers, properties = dict(isSubcontractor =

[sqlalchemy] Re: with_statement support in session objects

2009-02-24 Thread coder_gus
I am using a decorator that handles all this dirty work: @session_manager('get_session') def do_session_stuff(self): pass Gunnlaugur Briem wrote: Hi, trying to be careful to close all sessions when I'm done with them, I find myself doing this all the time: session = Session() try:

[sqlalchemy] Re: Can't connect to local MySQL server

2008-10-12 Thread coder_gus
Check that /tmp is writable. morecowbell wrote: make sure your mysqld.sock is in the location mysql expects it to be. default is /tmp/mysql.sock; if you are using darwinports, depending on mysql version it's /opt/local/var/run/mysqld/mysqld.sock (append mysql version to mysqld).

[sqlalchemy] concurrency issues?

2008-10-06 Thread coder_gus
Hi, I am writing an application server using twisted and sqlalchemy. On the server - database relation I use a pool of threads each with its own database connection, session etc. The problem is that I have 2 tables (one with products and one with events that might happen to a product) and I

[sqlalchemy] Re: concurrency issues?

2008-10-06 Thread coder_gus
Schaffrick wrote: On Mon, 6 Oct 2008 11:24:00 -0700 (PDT) Michael Bayer [EMAIL PROTECTED] wrote: On Oct 6, 2:19 pm, coder_gus [EMAIL PROTECTED] wrote: Hi, I am writing an application server using twisted and sqlalchemy. On the server - database relation I use a pool of threads each

[sqlalchemy] Re: Interval and mx.TimeDelta

2008-05-30 Thread coder_gus
Probably you could get away with import psycopg2.extensions psycopg2.extensions.register_type(psycopg2._psycopg.MXDATETIME) psycopg2.extensions.register_type(psycopg2._psycopg.MXINTERVAL) psycopg2.extensions.register_type(psycopg2._psycopg.MXDATE)

[sqlalchemy] how to see table mappers and unload them if needed

2008-05-30 Thread coder_gus
Is there a way I can get all the mappers for a Table? And if yes how can I unload them? Thanks. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] Re: how to see table mappers and unload them if needed

2008-05-30 Thread coder_gus
which subclasses pb.RemoteCopy. It works now ... sorry for asking before doing a deeper research. Thanks. coder_gus wrote: Is there a way I can get all the mappers for a Table? And if yes how can I unload them? Thanks

[sqlalchemy] connect sql server

2008-01-13 Thread coder_gus
Hi, How can I connect to sql server with windows authentication using sqlalchemy? Using pymssql I haven't find a way. Thanks. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this