-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 27 Aug 2008, at 15:48, Alex Mathieu wrote:

>
> F*ck... I just realized that I was using  MyISAM table engine...
> here's the deal then... I cannot use InnoDB for this projet so.... I
> think I will be writing some recursive code that can determine if an
> object has childs dependencies and will delete the proper objects....


Hm, the SA docs may be lagging behind the code development.

It might be worth upgrading to SA 0.5beta3 and checking whether the  
problem persists as the new 0.5 docs make no mention of back-end  
restrictions:

http://www.sqlalchemy.org/docs/05/ormtutorial.html#datamapping_deleting_cascade

IIRC, the only impact that 0.5beta3 has on elixir is a change to the  
engine binding keywords to the call on sessionmaker():

0.5beta3:
Session = scoped_session(sessionmaker(autoflush=True,  
expire_on_commit=True))

0.5beta:
Session = scoped_session(sessionmaker(autoflush=True, autocommit=True))

0.4 and below
Session = scoped_session(sessionmaker(autoflush=True,  
transactional=True))

Moving from SA0.4* to SA 0.5* has a more extensive impact on elixir- 
based projects that use SA's relational query language --- references  
in the style of <Klass.c.fieldname> become <Klass.fieldname>, e.g.  
"User.c.name" becomes "User.name".

There's a doc covering migration to SA0.5 ...

http://www.sqlalchemy.org/trac/wiki/05Migration


Cheers,

Graham



-----BEGIN PGP SIGNATURE-----

iEYEARECAAYFAki1fZQACgkQOsmLt1Nhivw98ACfe+4xTBe8TaIrSecPQ77YY9cN
bwYAoJvOuwKuaxFJ6O4EZJCnYUEtc0RLiQCVAgUBSLV9lFnrWVZ7aXD1AQKzVAQA
sNzz4Y8D1XRdfNh0u90cizfA3GKJ2L545q9fEFD9i9cmpmSRFOLE/ox+pH2X/Tdb
g2+3ggZOeaMoIpb9MRRXDJcGEOlbpl5vg6mJwUMJr6ajMmmA+K8+Y69b+ItAxQf1
/bfKz8VF5DFyxXvKaqBZW4DMiZBJGK+rx7ArU8b3mAs=
=4X7z
-----END PGP SIGNATURE-----


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"SQLElixir" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlelixir?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to