On Jun 2, 2010, at 12:48 AM, SQLAlchemy User wrote:
OK, I get the need for column_property, but the select is fairly
complex and involves unions of the containing class (and it hasn't
been defined yet). How do I get around this, and other questions
below
I think I got the SQL right
Hi
I am using Oracle with SQLalchemy in my application.
1. The SQLalchemy documentation gives the following as the connect
string for Oracle
sqlalchemy.url=oracle://user:passw...@localhost:1521/
SID_name
2. The above connect string does not seem to work in my
application.
the behavior here is exactly that which I described at
http://groups.google.com/group/sqlalchemy/msg/ab479d4762c24c65 . The presence
of the slash invokes the usage of cx_oracle makedsn(), in this case with a
blank dsn, whereas when not, sends the hostname localhost as the DSN argument
On May 30, 8:39 pm, Michael Bayer mike...@zzzcomputing.com wrote:
OK well by re018792aea57 I've bumped the callcounts down a *little*, reducing
compiler overhead within the flush(). Perhaps it will be a bigger
difference for your app which seems to be heavy on flush() calls.
As it turns
On Jun 2, 2010, at 1:47 PM, Jason Baker wrote:
On May 30, 8:39 pm, Michael Bayer mike...@zzzcomputing.com wrote:
OK well by re018792aea57 I've bumped the callcounts down a *little*,
reducing compiler overhead within the flush(). Perhaps it will be a
bigger difference for your app which
Is there anyway to have sqlalchemy send the queries to the database as
a single line instead of multiline? The reason for this is we
generate multiple GB of database logs each hour, and trying to find
the rest of a given sqlalchemy query is quite a pain right now. It
would be much easier for us
very easy. throw in a ConnectionProxy, override cursor_execute(), strip
newlines from the statements.
On Jun 2, 2010, at 2:02 PM, Chris H. wrote:
Is there anyway to have sqlalchemy send the queries to the database as
a single line instead of multiline? The reason for this is we
generate
I have a lot of questions, so bear with me. I've been having some
doubts about whether I'm really using sqlalchemy in a good way.
--
Is there any use case for having more than one session active in the
same thread? Or does everyone use threadlocal sessions? If you bind
different tables to
On Jun 2, 6:43 am, Michael Bayer mike...@zzzcomputing.com wrote:
On Jun 2, 2010, at 12:48 AM, SQLAlchemy User wrote:
OK, I get the need for column_property, but the select is fairly
complex and involves unions of the containing class (and it hasn't
been defined yet). How do I get around
In my code, I am currently adding to the session in various modules
(this is the same session since I'm importing it from my most
prominent module).
Some sample code would be:
## BEGIN CODE 1 ###
Session = sessionmaker(bind=engine)
session = Session()
def addToTable():
Very
Also:
I'm using [Python 2.6.5] and [SQLAlchemy 0.5.8]
Previously I was just shallow copying my dictionaries, and there were
no issues then with my simulations.
My dictionaries contain objects such that my students dictionary is
basically:
students[stud_id] = Student(stud_id, name,
11 matches
Mail list logo