Hello guys,
I am implementing a round robin database for my project in SQLAlchemy and I
have some problems with TRIGGERS.
Everything works but for each INSERT OR REPLACE, the trigger is not called
at all so in this case I would have only 25 rows rather than 50.
Any suggestion to debug it?
Hi,
I've run into a rather interesting issue, where calling session.rollback()
dies. The error I get with SQLA 0.7 is:
class 'sqlalchemy.exc.InvalidRequestError': Can't attach instance Foo at
0x2acf68808710; another instance with key (class 'module.Foo', (342,)) is
already present in this
I've tested the 0.7 0.8 snapshots, and both work fine now. Thanks!
From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On
Behalf Of Michael Bayer
Sent: 03 October 2012 17:20
To: sqlalchemy@googlegroups.com
Subject: Re: [sqlalchemy] SQLite rollback() fails
On Oct 3, 2012, at
Hi-
I have a sql query which is returning 2 rows. But when is transformed to
ORM query, its not returning any rows.
My SQL Statement:
select distinct(inst.hostname) as server_name,
fip.address as fixed_ip_address,
vif.address as fixed_ip_mac_address
from instances inst,
On Wed, Oct 3, 2012 at 5:02 PM, Trinath Somanchi
trinath.soman...@gmail.com wrote:
Hi-
I have a sql query which is returning 2 rows. But when is transformed to ORM
query, its not returning any rows.
My SQL Statement:
select distinct(inst.hostname) as server_name,
fip.address as
Hi Simon-
I have update my ORM query this way
result =
session.query(models.Instance.hostname.distinct(),models.FixedIp.address,models.VirtualInterface.address).\
join((models.InstanceMetadata,
models.InstanceMetadata.instance_id ==
On Wed, Oct 3, 2012 at 5:23 PM, Trinath Somanchi
trinath.soman...@gmail.com wrote:
Hi Simon-
I have update my ORM query this way
result =
session.query(models.Instance.hostname.distinct(),models.FixedIp.address,models.VirtualInterface.address).\
Hi-
I have solved the issue mysql.
Just converted the LIST to string for key and value..
and the query is working fine.
Thanks a lot guys for the help..
Thanks a lot Simon...for the precious help./
-
Trinath
On Wednesday, 3 October 2012 21:53:05 UTC+5:30, Trinath Somanchi wrote:
Hi
thanks a lot for the answer, I didn't expect that, nice from you. I'll take a
look at that and see what I keep doing, in fact I have set all the backend and
client part, the only thing I need is to leave the door open to my pg tables,
so I can (at first) search inside them and plot the
It sounds like you are trying to do at least 6 quite complicated
things all at once, without really understanding any of them. This
will not be easy.
Sigh. The story of my life in one sentence.
On Tue, Oct 2, 2012 at 8:43 AM, Simon King si...@simonking.org.uk wrote:
On Mon, Oct 1, 2012 at 11:38
10 matches
Mail list logo