Is there such a thing as SQLAlchemy training or a SA consultant? I'm
starting to think that my team might benefit from some time with
someone who really knows their stuff.
/George Reilly, Seattle
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To
I'm not entirely sure why this is happening… it seems to work for me
in nearly all other circumstances so I'm a bit stumped. Basically, I
have a declarative table which has a character field as its primary
key (it's not an ID which can be returned by the server), yet
SQLAlchemy is issuing an
I'm using Postgres
On Aug 18, 1:27 pm, Oliver Beattie oli...@obeattie.com wrote:
I'm not entirely sure why this is happening… it seems to work for me
in nearly all other circumstances so I'm a bit stumped. Basically, I
have a declarative table which has a character field as its primary
key
Thanks! Will try to get this working.
I am using GeoAlchemy quite extensively but these more obscure
functions and types are not supported...
On Aug 16, 9:14 pm, Michael Bayer mike...@zzzcomputing.com wrote:
On Aug 16, 2010, at 11:21 AM, bekozi wrote:
Is it possible to work with
Thanks a lot Lance, that did the trick.
best regards,
jeroen
On Mon, Aug 16, 2010 at 10:18 PM, Lance Edgar lance.ed...@gmail.com wrote:
See
http://groups.google.com/group/sqlalchemy/browse_thread/thread/aa9c753384532e6c/8d070ff7208494b1
The solution though I believe is just:
from
Hello,
sqlalchemy seems to be the proper tool for my needs but I can't figure
out how to design my project or set the ORM properly.
Let's say, I build a music database, storing tracks and their
associated metadata in an sql-like database defined as such :
TRACK_TABLE ( ident *, url , duration )
On Tue, Aug 17, 2010 at 07:32:41PM -0700, Enrico wrote:
Micahael gave me this advice:
http://groups.google.com/group/sqlalchemy/browse_thread/thread/df6e451855d13a60/386232232434ff92?lnk=gstq=enrico#386232232434ff92
in which there are two backrefs and I think it's declarative whereas
yours is
On Aug 17, 2010, at 11:45 AM, Kent wrote:
The logging FAQ states Therefore, when using Python logging, ensure
all echo flags are set to False at all times, to avoid getting
duplicate log lines.
http://www.sqlalchemy.org/docs/dbengine.html#configuring-logging
Is this no longer correct
On Aug 17, 2010, at 5:05 PM, flzz wrote:
Thanks this did the trick, I agree, an option in relationship to
define how this behaves would be nice.
its a long term TODO.
Cheers
Etrik
On Aug 17, 3:27 pm, Conor conor.edward.da...@gmail.com wrote:
On 08/17/2010 11:21 AM, flzz wrote:
Ah. Then the problem is in turbogears (which creates a default .ini
file with):
#echo shouldn't be used together with the logging module.
sqlalchemy.echo = false
sqlalchemy.echo_pool = false
sqlalchemy.pool_recycle = 3600
...logging sections...
On 08/17/2010 11:32 AM, yota wrote:
Hello,
sqlalchemy seems to be the proper tool for my needs but I can't figure
out how to design my project or set the ORM properly.
Let's say, I build a music database, storing tracks and their
associated metadata in an sql-like database defined as such :
Thank you very much for the source,
I also learned the term of vertical paradigm and stumble upon the
dictlike.py example in the sqlalchemy source ...
even if yours remains simpler
On Aug 18, 5:05 pm, Conor conor.edward.da...@gmail.com wrote:
On 08/17/2010 11:32 AM, yota wrote:
Hello,
Hello,
I'd like to query the database and get read-only objects with session
object. I need to save the objects in my server and use them through
the user session. If I use a object outside of the function that calls
the database, I get this error:
DetachedInstanceError: Parent instance is not
Hi All,
Does anyone have any good examples of migration scripts?
The documentation is surprisingly sparse..
Of course, an alernative which doesn't do any abusive monkey patching or
have any annoying * imports would be handy. Michael, how's Alembic coming?
Chris
--
You received this message
On 08/18/2010 10:27 AM, Alvaro Reinoso wrote:
Hello,
I'd like to query the database and get read-only objects with session
object. I need to save the objects in my server and use them through
the user session. If I use a object outside of the function that calls
the database, I get this
On Aug 18, 3:39 pm, Michael Bayer mike...@zzzcomputing.com wrote:
Sent from my iPhone
On Aug 18, 2010, at 8:27 AM, Oliver Beattie oli...@obeattie.com wrote:
I'm not entirely sure why this is happening… it seems to work for me
in nearly all other circumstances so I'm a bit stumped.
SQLAlchemy seems pretty smart about updating only the changed columns in an orm
object...
If I have an orm object. Something changes one of the columns. Just before I
commit() the session, is there a way to tell which columns will be updated vs
those that are unchanged?
Any way to ascertain
The little diddly below is comparing performance of orm access vs sql
expression language.
When I run it with number=1 I get a 5.8x advantage for sql. When I run it 10
times I get a 2.7x advantage. The actual numbers are, respectively:
1.47375132
0.25630808
5.45569524
1.96911144
Is this a
On Aug 18, 2010, at 12:29 PM, Oliver Beattie wrote:
On Aug 18, 3:39 pm, Michael Bayer mike...@zzzcomputing.com wrote:
Sent from my iPhone
On Aug 18, 2010, at 8:27 AM, Oliver Beattie oli...@obeattie.com wrote:
I'm not entirely sure why this is happening… it seems to work for me
On Aug 18, 2010, at 4:16 PM, Michael Hipp wrote:
The little diddly below is comparing performance of orm access vs sql
expression language.
When I run it with number=1 I get a 5.8x advantage for sql. When I run it 10
times I get a 2.7x advantage. The actual numbers are, respectively:
20 matches
Mail list logo