On Jun 6, 2011, at 7:13 PM, Geoff wrote:
> On Jun 6, 11:32 pm, Michael Bayer wrote:
>>
>> The table referenced by "secondary=" in a relationship() is managed
>> entirely, regardless of cascade setting, but
>> only from the perspective of the parent. Meaning if A references a
>> collection of
On Jun 6, 11:32 pm, Michael Bayer wrote:
>
> The table referenced by "secondary=" in a relationship() is managed entirely,
> regardless of cascade setting, but
> only from the perspective of the parent. Meaning if A references a
> collection of B, the row in a_to_b will be
> deleted if you 1. d
On Jun 6, 2011, at 6:11 PM, Geoff wrote:
> I've searched for an answer to this but can't find one but I did find
> an old archived e-mail discussing this which refers to ticket #249.
>
> I have two tables in a many-many relationship. I do not want deletes
> to cascade between these two tables bu
I've searched for an answer to this but can't find one but I did find
an old archived e-mail discussing this which refers to ticket #249.
I have two tables in a many-many relationship. I do not want deletes
to cascade between these two tables but I do want any delete to
cascade to the secondary ta
ah, so little bit of a bug on our end then. Seems to be hardcoded in the
oursql driver. this is #2186
On Jun 6, 2011, at 3:56 PM, Yuen Ho Wong wrote:
> Replace the double quotes around the "%s" with single quotes seems to
> have solved the problem with either default SQL MODE or ANSI_QUOTES
On Monday, June 6, 2011, Michael Bayer wrote:
> it just changes to .columns, should fix it as below:
>
> def __init__(self, table):
> event.listen(table, "before_create", self.before_create)
> event.listen(table, "after_create", self.after_create)
> event.listen(table,
it just changes to .columns, should fix it as below:
def __init__(self, table):
event.listen(table, "before_create", self.before_create)
event.listen(table, "after_create", self.after_create)
event.listen(table, "before_drop", self.before_drop)
event.listen(tabl
Replace the double quotes around the "%s" with single quotes seems to
have solved the problem with either default SQL MODE or ANSI_QUOTES
set.
Thanks for the helping!
On Jun 7, 3:25 am, Yuen Ho Wong wrote:
> Ah it seems that this bug only happens with sql-mode = ANSI set in
> my.cnf. This doesn
Hi
i'm currently in the process of porting GeoAlchemy to SQLAlchemy 0.7.
The first issue I'm having is related to before_create and
after_create DDL listeners we have in GeoAlchemy.
We use before_create and after_create listeners to prevent SQLA from
adding the geometry column, and do it ourselv
Ah it seems that this bug only happens with sql-mode = ANSI set in
my.cnf. This doesn't seem to be an issue with the mysql-python driver
tho.
On Jun 7, 2:57 am, Michael Bayer wrote:
> On Jun 6, 2011, at 2:23 PM, Yuen Ho Wong wrote:
>
>
>
>
>
> > I'm testing this on SQLAlchemy 0.7.1, oursql 0.9.2
On Jun 6, 2011, at 2:23 PM, Yuen Ho Wong wrote:
> I'm testing this on SQLAlchemy 0.7.1, oursql 0.9.2, MySQL 5.5.13 on
> Mac OS X 10.6.7
>
> Here's my test script:
>
>
> from sqlalchemy import create_engine, Column, Integer, Unicode
> from sqlalchemy.ext.declarative import declarative_base
> fr
I think the "session" about sessions do that explanation:
http://www.sqlalchemy.org/docs/orm/session.html
2011/6/6 Liju
> I'm new to SQLAlchemy and loving it. But reading all documentation
> online makes me wonder if there are any best practice documentation
> for sqlalchemy out there ?
>
> --
I'm testing this on SQLAlchemy 0.7.1, oursql 0.9.2, MySQL 5.5.13 on
Mac OS X 10.6.7
Here's my test script:
from sqlalchemy import create_engine, Column, Integer, Unicode
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import scoped_session, sessionmaker
Base = declar
I'm new to SQLAlchemy and loving it. But reading all documentation
online makes me wonder if there are any best practice documentation
for sqlalchemy out there ?
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to
14 matches
Mail list logo