[kforge-dev] Changeset [92]: Proper solution to problem with many-to-many entries not being deleted by ...

28: Timeline admin at okfn.org
Tue Feb 20 18:38:09 UTC 2007


Proper solution to problem with many-to-many entries not being deleted by creating explicit 'join' tables (*not* sovled in previous commit as hoped). 

* models/init.py, 

> models/package.py: SQLObject does not allow you to create 'cascade' constraints on [RelatedJoin?][1] columns. Thus if one wants proper behaviour for many-to-many relationships (i.e. entry in join table deleted when either of referenced objects deleted) one needs to create explicit join table oneself. 

  *     * [PackageTag?][2]: for Package *---* Tag 
    * [LicenseTag?][3]: Package *---* License 

* tests/models/test_package.py: 

  * Remove erroneous change introduced in previous commit ([r38][4]) 
  * test_package_purge_deletes_tag_relations: turn this into a proper functioning test 

    [1]: http://project.knowledgeforge.net/ckan/trac/wiki/RelatedJoin
    [2]: http://project.knowledgeforge.net/ckan/trac/wiki/PackageTag
    [3]: http://project.knowledgeforge.net/ckan/trac/wiki/LicenseTag
    [4]: http://project.knowledgeforge.net/ckan/trac/changeset/38 (Added support for A-Z finding.
)

URL: http://project.knowledgeforge.net/ckan/trac/changeset/92




More information about the kforge-dev mailing list