[sqlalchemy] SQLAlchemny SAWarning - which Session Query is giving this?

) Regards Harish -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group

[sqlalchemy] Re: Custom MySQL Socket with SQL Alchemy

when we restarted Apache Web Server (using mod_wsgi), and then gave errors after same page was visited few times On Apr 5, 6:30 am, Michael Bayer mike...@zzzcomputing.com wrote: On Apr 4, 2011, at 9:07 PM, Harish Tejwani wrote: We are trying to point SQLAlchemny (0.6.5 engine) to use custom

[sqlalchemy] Custom MySQL Socket with SQL Alchemy

We are trying to point SQLAlchemny (0.6.5 engine) to use custom MySQL Socket using URL Parameter as below WRITEDATASTORE = topsight_config.DATASTORE + '?unix_socket=/opt/mysql/ mysql.sock' writeengine = create_engine(WRITEDATASTORE, echo=topsight_config.SQL_DEBUG, pool_recycle=3600) However

[sqlalchemy] SQL Alchemy Out of memory (re-posted)

Michael suggested to repost this. We are running on a fairly beefy Linux machine and SQLAlchemny 0.6.5 We have started getting getting Out of Memory errors like below (MySQL runs on same machine). Any ideas or suggestion why this could be happening and how to go about identifying root

[sqlalchemy] Re: SQL Alchemy Out of memory (re-posted)

, to see what was passed. On Mar 31, 2011, at 11:32 AM, Harish Tejwani wrote: Michael suggested to repost this. We are running on a fairly beefy Linux machine and SQLAlchemny 0.6.5 We have started getting getting Out of Memory errors like below (MySQL runs on same machine

[sqlalchemy] Formatting return of 'query'

modify this query to return something like : [(fname~lname~22~pwd)...] with '~' being preferred delimiter. I would like to know if I can return something like above directly from the query itself. Thanks, Harish --~--~-~--~~~---~--~~ You received this message because

[sqlalchemy] Query.delete() issues a select before delete?

issued before a DELETE? Regards, Harish --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email

[sqlalchemy] Re: Query.delete() doesn't cascade on Sqlite

records to Objects. - More CPU 2. Triggers on SQLite. - http://www.sqlite.org/tempfiles.html, seems that SQLite maintains transaction logs in a journal file. I am doing more testing to find out the best option. Regards, Harish On Fri, May 29, 2009 at 9:35 PM, Randy Syring ra...@rcs-comp.com

[sqlalchemy] Query.delete() doesn't cascade on Sqlite

impose FK constraints. Is there any way to solve this problem? Regards, Harish --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com

[sqlalchemy] Re: Questions on SQLA Queries

Thanks! Could you elaborate on how you use the map function? I couldn't find it myself in the docs. Regards, Harish On Wed, May 27, 2009 at 3:07 PM, Timothy N. Tsvetkov timothy.tsvet...@gmail.com wrote: Q1. Good question %) I didn't find anything about it in docs (but i didn't search

[sqlalchemy] Questions on SQLA Queries

be logged after every 30 deletes. I am using Sqlite DB. Regards, Harish --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe

[sqlalchemy] Re: SQLAlchemy 0.5 Released

Congratulations! And many thanks for the wonderful SQLA! Cheers. On Wed, Jan 7, 2009 at 1:12 AM, Michael Bayer mike...@zzzcomputing.comwrote: Hello list - I am pleased to announce the release of SQLAlchemy 0.5.0, the first official release in the 0.5 series. This series has been in the

[sqlalchemy] Fastest Way of removing an object from session.identity_map

of objects after a bulk query/insertion etc., Is there a better way to do this? Thanks for the help! Regards, Harish --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email

[sqlalchemy] Problem in working with two sessions to the same database.

users? Thanks for the help! Cheers, Harish --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email

[sqlalchemy] Invalid Request Error at session level.

is trying to query, would this problem arise? I am not very sure on how connection objects are created during this scenario. Appreciate your help. Regards, Harish --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy

[sqlalchemy] Re: Trouble with Strings getting converted to Unicode types

every time a connect() is requested. This is an embedded system, and I am little worried if that could degrade performance. Would appreciate your comments! Thanks again for the help! Regards, Harish On Tue, Nov 25, 2008 at 11:07 AM, Michael Bayer [EMAIL PROTECTED]wrote: On Nov 24, 2008, at 11

[sqlalchemy] Re: Trouble with Strings getting converted to Unicode types

a place where I can pass this option to SQLA so that it can in turn use the above option while obtaining the connection from PySqlite. Please let me know if there is a way of achieving this. Thank! Regards, Harish On Tue, Nov 18, 2008 at 9:47 PM, Michael Bayer [EMAIL PROTECTED]wrote

[sqlalchemy] Trouble with Strings getting converted to Unicode types

, since I am having issues with marshalling and transmitting unicode objects over the network. Is there any option I am missing? Kindly let me know. -- Regards, Harish --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups

[sqlalchemy] Force Load all attributes during a Query

getting an object. If there is a way to force all my queries by default to load all attributes of the object, if would be great. -- Regards, Harish --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group

[sqlalchemy] Re: Orphans not deleted using cascade parameter

is related. -- Regards, Harish --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL

[sqlalchemy] Re: Fwd: Autoexpire on commit is causing problems?

users in the thread, and the below exception occurs randomly during the addition. Any inputs? Thank you so much again! On Mon, Aug 25, 2008 at 8:12 PM, Michael Bayer [EMAIL PROTECTED]wrote: On Aug 25, 2008, at 12:24 AM, Harish K Vishwanath wrote: The line USERIDLIST.append(user.UserID

[sqlalchemy] Re: Fwd: Autoexpire on commit is causing problems?

by another thread which tries to modify the object. Its throwing up exceptions there. This error will go away if I set expire_on_commit = False. Cheers, Harish On Fri, Aug 22, 2008 at 8:41 PM, Michael Bayer [EMAIL PROTECTED]wrote: The actual fix for this is in r5052. The ticket is not complete

[sqlalchemy] Autoexpire on commit is causing problems?

Hello, I am SQLA 0.5beta4r5051. I am having issues with session having expire_on_commit as True. Below is an example : *File : sqla05betatest.py* from sqlalchemy import create_engine, Table, Column, Integer, String, MetaData from sqlalchemy.orm import mapper, sessionmaker engine =

[sqlalchemy] Fwd: Autoexpire on commit is causing problems?

query seems to work. Does flush internally query and get the object before flushing it to DB which commit() doesn't seem to do? -- Forwarded message -- From: Harish K Vishwanath [EMAIL PROTECTED] Date: Fri, Aug 22, 2008 at 3:02 PM Subject: Autoexpire on commit is causing problems

[sqlalchemy] Re: Code working on SQLA 0.4.6 is breaking on SQLA 0.5beta3

. It is not giving any problems with Exceptions class in Py2.4 though. Could this be a possible issue? On Wed, Aug 20, 2008 at 9:28 PM, Michael Bayer [EMAIL PROTECTED]wrote: On Aug 20, 2008, at 11:52 AM, Harish K Vishwanath wrote: Hello, Sorry if I am being stupid. I saw the ticket and r0535 and 537

[sqlalchemy] Could there be a behavioural difference in user defined DataTypes?

type. Could there be any difference between the two versions? -- Regards, Harish --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com

[sqlalchemy] Re: Code working on SQLA 0.4.6 is breaking on SQLA 0.5beta3

Thanks Jason. Downloaded R5051, it works fine! Cheers, Harish On Thu, Aug 21, 2008 at 7:58 PM, jason kirtland [EMAIL PROTECTED] wrote: Thanks for the traceback. Give r5050 a try. Cheers, Jason Harish K Vishwanath wrote: Hello Michael, Thanks for your input! I got the latest trunk

[sqlalchemy] Facing Invalid Request Error in 0.5beta4r5051

exceptions that can be raised by a commit() call , issuing a rollback and reporting them. But I dont seen any rollbacks at all, but even then the exception says so. Appreciate any inputs. Thanks, Harish --~--~-~--~~~---~--~~ You received this message because you

[sqlalchemy] Fwd: Facing Invalid Request Error in 0.5beta4r5051

The error goes away when I make the session expire_on_commit=False., But its a nice feature to have, how can I fix the exception below retaining this feature? -- Forwarded message -- From: Harish K Vishwanath [EMAIL PROTECTED] Date: Fri, Aug 22, 2008 at 11:04 AM Subject: Facing

[sqlalchemy] Code working on SQLA 0.4.6 is breaking on SQLA 0.5beta3

-0.5.0beta3-py2.4.egg\sqlalchemy \util.py, line 408, in class_hierarchy for s in [_ for _ in c.__subclasses__() if _ not in hier]: AttributeError: class IRObject has no attribute '__subclasses__' IRObject is our app specific base class. Any ideas? Thanks, Harish

[sqlalchemy] Re: Code working on SQLA 0.4.6 is breaking on SQLA 0.5beta3

, but it doesn't seem to be so in py 2.4. Is there a way to bypass this assumption of SA? Thanks, Harish On Wed, Aug 20, 2008 at 4:02 PM, [EMAIL PROTECTED] wrote: seems your baseclass is oldstyle class, not inheriting 'object'. python 2.5 newstyle classes (off object) has that __subclasses__

[sqlalchemy] Re: Code working on SQLA 0.4.6 is breaking on SQLA 0.5beta3

Hello, Sorry if I am being stupid. I saw the ticket and r0535 and 537 changeset. Which version of SQLA incorporates these changesets? On Wed, Aug 20, 2008 at 7:15 PM, Michael Bayer [EMAIL PROTECTED]wrote: On Aug 20, 2008, at 5:39 AM, Harish K Vishwanath wrote: Hello, I was using elixir

[sqlalchemy] Query is checking for transaction status

in advance for the help! Cheers, Harish --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email