Hi everybody!!
I'm trying to do this:
indg=IndicatorGroups()
indg.name=group
session.save(indg)
ind=Indicators()
ind.code=code
ind.name=indicator
ind.idindicatorgroup=indg
session.save(ind)
session.flush()
but I have this error:
Traceback (innermost last):
Module ZPublisher.Publish, line
Michael,
Michael Bayer wrote:
On Nov 6, 2007, at 12:20 PM, Werner F. Bruhin wrote:
I insert a raw into a table and then retrieve again but columns which
are filled by a db trigger don't return the updated values.
The following is a code snippet and I wonder what I am missing.
engine
This is strange. I had problems reproducing the bug for a long time
and was now quite happy that I succeeded.
Yes, I'm using PostgreSQL 8.1.5 and psycopg2. And I still see the
behavior that I reported. That should narrow the problem down to
something in my local setup... I'm sorry for wasting
u can use the timephase-separation, i.e. declare vs runtime;
i.e. use global scope in for B in A, but use runtime scope for A in B.
modB.py:
import A
...
modA.py:
def somefunc_or_method():
import B
...
another solution is to have sort-of forward-text-declarations that at
certain
Hi there,
We have a pretty large project by now and we run into import loops. So
I decided to restructure the code, and I hoped some people with more
experience can comment on this.
The basic problem is this:
We have the database object code, mappers and tables neatly organized
in one module
On Nov 7, 2007, at 1:02 PM, svilen wrote:
On Wednesday 07 November 2007 19:33:22 Michael Bayer wrote:
ohyoure *extending* abstractclauseprocessor ???
well yes, thats
going to change things quite a bit. I think you should study ACP
in its current form; what its doing now is
I gleaned from your stack trace that youre using
strategy=threadlocal (full test cases are much more helpful).
anyway, its a bug, fixed in r3748.
On Nov 7, 2007, at 9:22 AM, Manlio Perillo wrote:
Hi.
I'm trying to add support to SQLALchemy 0.4 in nadbapi:
On Wednesday 07 November 2007 19:33:22 Michael Bayer wrote:
ohyoure *extending* abstractclauseprocessor ???
well yes, thats
going to change things quite a bit. I think you should study ACP
in its current form; what its doing now is faithfully calling
convert_element() for *every*
Mike,
Michael Bayer wrote:
On Nov 7, 2007, at 12:32 PM, Werner F. Bruhin wrote:
Can you point out what I did wrong, please.
id have to see a larger example, seems like something is marking the
column as modified when it should not be.
I put a little test case together,
On Nov 7, 2007, at 11:05 AM, jason kirtland wrote:
Michael Bayer wrote:
On Nov 7, 2007, at 6:01 AM, klaus wrote:
This is strange. I had problems reproducing the bug for a long time
and was now quite happy that I succeeded.
Yes, I'm using PostgreSQL 8.1.5 and psycopg2. And I still see
Dear all,
I'm quite confused to use Session like a global statement through
different parts of a web program. The directory structure is the
following:
WebML/
+- webml.py (main program)
+- globals.py
+- managers/
+- __init__.py
+- users_schema.py
By the way, on a larger database, drop_all() runs into an endless
loop. However, I have no small script to reproduce this yet.
Klaus
On 7 Nov., 16:39, klaus [EMAIL PROTECTED] wrote:
That's very kind.
I'm on the trunk (0.4.1dev_r3747) and on linux. And I think your
script (with a changed
On Nov 7, 2007, at 10:23 AM, Werner F. Bruhin wrote:
How can I define a column in the table as read-only?
I have some computed by columns, e.g.:
consumedvalue computed by (quantity*unitprice)
These columns can not be updated, otherwise I get the following
exception:
That's very kind.
I'm on the trunk (0.4.1dev_r3747) and on linux. And I think your
script (with a changed connection string, nothing else) fails on my
machine. Here's the complete output:
2007-11-07 16:33:14,848 INFO sqlalchemy.engine.base.Engine.0x..b4
select relname from pg_class c join
Werner F. Bruhin wrote:
Michael,
Michael Bayer wrote:
On Nov 6, 2007, at 12:20 PM, Werner F. Bruhin wrote:
I insert a raw into a table and then retrieve again but columns which
are filled by a db trigger don't return the updated values.
The following is a code snippet and I
Is this what you want?
select([my_table.c.my_column], distinct=True)
Barry
- Original Message
From: JamesT [EMAIL PROTECTED]
To: sqlalchemy sqlalchemy@googlegroups.com
Sent: Wednesday, November 7, 2007 2:05:13 AM
Subject: [sqlalchemy] Select entire column
I am looking to filter
Michael Bayer ha scritto:
I gleaned from your stack trace that youre using
strategy=threadlocal (full test cases are much more helpful).
anyway, its a bug, fixed in r3748.
Thanks, now finally nadbapi works with SQLAlchemy 0.4.
Sorry for not having provided full test cases, I was
On Nov 7, 2007, at 1:09 PM, jason kirtland wrote:
Michael Bayer wrote:
what happens if you change the create_engine to:
engine = create_engine('sqlite://', echo=True, paramstyle=named)
that doesnt reproduce for me on linux. i find it hard to believe its
a bug within the PG dialect
On Nov 7, 2007, at 5:20 AM, lur ibargutxi wrote:
Does anyone knows what am I doing wrong??
nopewould need to see an entire reproducing test case for that one.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
On Nov 7, 2007, at 2:03 AM, [EMAIL PROTECTED] wrote:
- something changed in the traversing (AbstractClauseProcessor -
r3727)
and it does not find proper things...
ACP has been entirely rewritten. if you can provide simple tests in
the form that theyre present in test/sql/generative.py
On Nov 7, 2007, at 12:58 PM, Werner F. Bruhin wrote:
Mike,
Michael Bayer wrote:
On Nov 7, 2007, at 12:32 PM, Werner F. Bruhin wrote:
Can you point out what I did wrong, please.
id have to see a larger example, seems like something is marking the
column as modified when it should
Michael Bayer wrote:
On Nov 7, 2007, at 6:01 AM, klaus wrote:
This is strange. I had problems reproducing the bug for a long time
and was now quite happy that I succeeded.
Yes, I'm using PostgreSQL 8.1.5 and psycopg2. And I still see the
behavior that I reported. That should narrow the
On Nov 7, 2007, at 6:01 AM, klaus wrote:
This is strange. I had problems reproducing the bug for a long time
and was now quite happy that I succeeded.
Yes, I'm using PostgreSQL 8.1.5 and psycopg2. And I still see the
behavior that I reported. That should narrow the problem down to
On Nov 7, 2007, at 3:06 PM, Manlio Perillo wrote:
Michael Bayer ha scritto:
I gleaned from your stack trace that youre using
strategy=threadlocal (full test cases are much more helpful).
anyway, its a bug, fixed in r3748.
Thanks, now finally nadbapi works with SQLAlchemy 0.4.
Sorry
Michael Bayer wrote:
what happens if you change the create_engine to:
engine = create_engine('sqlite://', echo=True, paramstyle=named)
that doesnt reproduce for me on linux. i find it hard to believe its
a bug within the PG dialect itselfbuilding PG on my linux box now.
No
On Nov 7, 2007, at 12:32 PM, Werner F. Bruhin wrote:
Can you point out what I did wrong, please.
id have to see a larger example, seems like something is marking the
column as modified when it should not be.
--~--~-~--~~~---~--~~
You received this message
ohyoure *extending* abstractclauseprocessor ??? well yes, thats
going to change things quite a bit. I think you should study ACP in
its current form; what its doing now is faithfully calling
convert_element() for *every* element in the expression, and also is
not copying any elements
Mike,
Michael Bayer wrote:
On Nov 7, 2007, at 10:23 AM, Werner F. Bruhin wrote:
How can I define a column in the table as read-only?
I have some computed by columns, e.g.:
consumedvalue computed by (quantity*unitprice)
These columns can not be updated, otherwise I get the following
On Nov 7, 2007, at 11:03 AM, svilen wrote:
also, i put a
class ClauseVisitor( sql_util.AbstractClauseProcessor):
def convert_element( me, e): return None
in the beginning of the tests.sql.generative, and after ignoreing this
or that error, here is similar thing:
On Wednesday 07 November 2007 16:57:08 Michael Bayer wrote:
On Nov 7, 2007, at 2:03 AM, [EMAIL PROTECTED] wrote:
- something changed in the traversing (AbstractClauseProcessor -
r3727)
and it does not find proper things...
ACP has been entirely rewritten. if you can provide simple
How can I define a column in the table as read-only?
I have some computed by columns, e.g.:
consumedvalue computed by (quantity*unitprice)
These columns can not be updated, otherwise I get the following exception:
ProgrammingError: (ProgrammingError) (-151, 'isc_dsql_prepare: \n
attempted
On Nov 7, 2007, at 5:19 AM, Werner F. Bruhin wrote:
PassiveDefault is great to know.
However I still have a problem with the following.
In a program I do something like this:
botlot3 = session.query(db.Bottaglot).get(39)
Then some other user and/or application changes data (I faked this
Mike,
Michael Bayer wrote:
On Nov 7, 2007, at 5:19 AM, Werner F. Bruhin wrote:
PassiveDefault is great to know.
However I still have a problem with the following.
In a program I do something like this:
botlot3 = session.query(db.Bottaglot).get(39)
Then some other user and/or
On Nov 7, 2007, at 6:34 AM, Koen Bok wrote:
Hi there,
We have a pretty large project by now and we run into import loops. So
I decided to restructure the code, and I hoped some people with more
experience can comment on this.
The basic problem is this:
We have the database object
On Nov 7, 2007, at 12:51 AM, Hong Yuan wrote:
Hi,
In the release note of 0.3.7, the following is mentioned:
- much improved auto-reconnect support
But how can one configure this? I am using 0.3.10 with Postgresql.
Very often, after some period of inactivity, the connection is closed
http://www.moneycosmos.com/?r=321740
--~--~-~--~~~---~--~~
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
http://www.freewebs.com/homebusiness1
--~--~-~--~~~---~--~~
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
Michael Bayer ha scritto:
[...]
One last thing.
With SQLAlchemy 0.3.x, my Engine class can be used to execute
implicit
queries.
Now with 0.4.x this does not works, since the engine should implement
additionals methods:
statement_compiler and _execute_clauseelement.
What's the
On Nov 7, 2007, at 4:26 PM, Manlio Perillo wrote:
I would like this interface to be public, so I can implement it for
the
Engine class in nadbapi.
ok, its public, rev 3751.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the
I would like something to run on the Query class. It looks like you
used to be able to run select on this class, but the function is
deprecated. If I cannot, I will just use the execute function and run
plain SQL.
On Nov 7, 6:39 am, Barry Hart [EMAIL PROTECTED] wrote:
Is this what you want?
One of the reasons that Query.select() is deprecated is that the way it was
named led to this kind of confusion.
The Query() class is used for ORM operations, and when it's used as mapped
against a table, it's going to give you all the columns from the table by
default. There are ways of defining
Thanks. I have it working in SQL expression language, using text in
execute(). For better modularity and scalabililty, I will probably
move it over to using the select(), join(), etc. functions that are
built in.
On Nov 7, 5:26 pm, Rick Morrison [EMAIL PROTECTED] wrote:
One of the reasons that
OK i found some more things that i think is probably screwing you up.
will keep you posted.
On Nov 7, 2007, at 10:45 AM, svilen wrote:
On Wednesday 07 November 2007 16:57:08 Michael Bayer wrote:
On Nov 7, 2007, at 2:03 AM, [EMAIL PROTECTED] wrote:
- something changed in the traversing
On Nov 7, 2007, at 1:20 PM, svilen wrote:
ahha. so i am replacing one whole subexpr with somthing, and the
original subexpr is not traversed inside.
if i comment the stop_on.add(), it attempts to traverse the result
subexpr, not the original one.
i want the original to be traversed.
ahha. so i am replacing one whole subexpr with somthing, and the
original subexpr is not traversed inside.
if i comment the stop_on.add(), it attempts to traverse the result
subexpr, not the original one.
i want the original to be traversed. Something like doing onExit
instead of current
try out r3754.
On Nov 7, 2007, at 6:56 PM, Michael Bayer wrote:
OK i found some more things that i think is probably screwing you up.
will keep you posted.
On Nov 7, 2007, at 10:45 AM, svilen wrote:
On Wednesday 07 November 2007 16:57:08 Michael Bayer wrote:
On Nov 7, 2007, at 2:03 AM,
46 matches
Mail list logo