Aa Sent from my iPhone
On Jun 14, 2010, at 12:39 AM, "sqlalchemy+nore...@googlegroups.com" < sqlalchemy+nore...@googlegroups.com> wrote: Today's Topic Summary Group: http://groups.google.com/group/sqlalchemy/topics - Multiple databases or multiple schemas? <#group_thread_0> [2 Updates] - Error trying to use session.execute <#group_thread_1> [4 Updates] - Windows and Linux Tips <#group_thread_2> [1 Update] - Questions about "session" <#group_thread_3> [1 Update] - Where can I learn more <#group_thread_4> [2 Updates] - Using SQL aggregate fcns on a PGArray column <#group_thread_5> [2 Updates] - Add a unit to column <#group_thread_6> [2 Updates] Topic: Multiple databases or multiple schemas?<http://groups.google.com/group/sqlalchemy/t/c93e1ab26c4ae5a6> Henry Precheur <he...@precheur.org> Jun 13 01:27PM -0700 ^ <#digest_top> I'm starting a new project which is roughly hosting a bunch of sites. I want the sites to be isolated, they'll all have the same schema (data definition), but will store their data on different more...<http://groups.google.com/group/sqlalchemy/msg/92246cf43927e2b8> Faheem Mitha <fah...@email.unc.edu> Jun 14 02:53AM +0530 ^ <#digest_top> [This message has also been posted.] > Solution #2 is not supported natively by SQLAlchemy. Each time a request > comes-in I'll have to issue an additional query "SET search_path TO more... <http://groups.google.com/group/sqlalchemy/msg/839cc05d071b70cd> Topic: Error trying to use session.execute<http://groups.google.com/group/sqlalchemy/t/3fd8f8ef8e0a546e> Michael Bayer <mike...@zzzcomputing.com> Jun 12 07:58PM -0400 ^<#digest_top> this pattern: try: foo() except: pass will get you killed every time. the difference in result is between the session's default of transactionalized execution and the Connection's more...<http://groups.google.com/group/sqlalchemy/msg/df5de254e3d22d43> Faheem Mitha <fah...@email.unc.edu> Jun 13 01:33PM +0530 ^ <#digest_top> [This message has also been posted.] On Sat, 12 Jun 2010 19:58:28 -0400, Michael Bayer > the difference in result is between the session's default of > transactionalized execution and the more...<http://groups.google.com/group/sqlalchemy/msg/c6f9b0eac14d3212> Faheem Mitha <fah...@email.unc.edu> Jun 13 12:51PM ^ <#digest_top> > I remembered that text() has the autocommit=True option, and tried > using it with create_drop_constraint_if_exists_function, but it didn't > help. [Following up to myself] Adding more... <http://groups.google.com/group/sqlalchemy/msg/f23140f7980082f8> Michael Bayer <mike...@zzzcomputing.com> Jun 13 11:20AM -0400 ^<#digest_top> On Jun 13, 2010, at 4:03 AM, Faheem Mitha wrote: > aren't, please correct me. > As regards 1, I assume you mean try... pass... is a bad idea. I agree, > but there is no When an exception more...<http://groups.google.com/group/sqlalchemy/msg/867ef9217ee2689> Topic: Windows and Linux Tips<http://groups.google.com/group/sqlalchemy/t/5b8270f1f9ce392e> pavelhaque <pavelha...@gmail.com> Jun 13 05:01AM -0700 ^ <#digest_top> Hi friends, Do u need Windows and Linux Tips? Please visit the following site: http://windowsandlinuxtips.blogspot.com/ more... <http://groups.google.com/group/sqlalchemy/msg/ab5809a268b14de9> Topic: Questions about "session"<http://groups.google.com/group/sqlalchemy/t/9ed8ef9a193fbe5e> Az <azfarul.is...@gmail.com> Jun 12 05:45PM -0700 ^ <#digest_top> Hi Conor, Many apologies for being pushy but since I'm pretty much in the processing of finishing up my code (due in two days), I wonder if you could just take a look at the last three posts of more...<http://groups.google.com/group/sqlalchemy/msg/8dc1429e8fba0a64> Topic: Where can I learn more<http://groups.google.com/group/sqlalchemy/t/a3036c1cf8b66187> Paul Hemans <p_hem...@hotmail.com> Jun 12 05:27PM -0700 ^ <#digest_top> Where can I learn more about creating a dialect for SQLalchemy? I could just copy one of the existing dialects, but I don't know what I am looking for in what needs to be changed. I need a kind of more...<http://groups.google.com/group/sqlalchemy/msg/731aa49491b7ad01> Michael Bayer <mike...@zzzcomputing.com> Jun 12 08:39PM -0400 ^<#digest_top> Essential SQLAlchemy unfortunately is out of date in most areas and certainly with regards to dialect creation (as a note to anyone reading this, we are interested in authors for a new SQLAlchemy more...<http://groups.google.com/group/sqlalchemy/msg/b9561f6d7316898e> Topic: Using SQL aggregate fcns on a PGArray column<http://groups.google.com/group/sqlalchemy/t/901593fa025c327c> David Korz <david.k...@gmail.com> Jun 11 05:55PM -0700 ^ <#digest_top> I have a table like such: CREATE TABLE test ( mykey integer not null, mydata double precision [2][10] ) without oids; with a table defn like: test = Table("test",metadata, more...<http://groups.google.com/group/sqlalchemy/msg/f87c994c330e79c2> Michael Bayer <mike...@zzzcomputing.com> Jun 12 08:18PM -0400 ^<#digest_top> On Jun 11, 2010, at 8:55 PM, David Korz wrote: > test.c.mydata can't be indexed so this is illegal. Is there a way I > can access an array element in SA without just putting the actual SQL more... <http://groups.google.com/group/sqlalchemy/msg/faf14af21cf96d14> Topic: Add a unit to column<http://groups.google.com/group/sqlalchemy/t/59de2b8e785ec611> Charlie de Zhoushan <charlie.xia....@gmail.com> Jun 11 04:54PM -0700 ^<#digest_top> Hi all, Is there a way to add unit for a column for SqlAlchemy table? like: height = sa.Column(sa.Integer, unit='meter') Thanks! Charlie more... <http://groups.google.com/group/sqlalchemy/msg/26db41cf98d3b33a> Michael Bayer <mike...@zzzcomputing.com> Jun 12 07:59PM -0400 ^<#digest_top> I've never heard of "unit", what database backend is this and can you illustrate a sample of the DDL you'd like to see produced ? On Jun 11, 2010, at 7:54 PM, Charlie de Zhoushan wrote: more... <http://groups.google.com/group/sqlalchemy/msg/5c64bd48935bc35> -- 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, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. -- 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, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.