Breaking associations, how?

[martin]

Tried to find an answer with Google, but I must not be using the right search terms ;-(

I've got a simple one-to-many association:

Club hasMany Teams.

Team belongsTo Club

I want to remove a team from a club without deleting the club or the team.

I figured I just get the team and set it's clubid to 0 (I also tried '') and 'save' the team.

Team = model("Team").findOneByIdAndClubid(value="#params.key#,#params.clubid#");

team.clubid = 0;

if (Team.save()){

renderWith(status="success", message="The team was removed successfully.", redirect={back="true"});

} else {

renderWith(status="error", message="There was an error removing the teams.", redirect={back="true"});

}

Team.save() throws an error.

I bet I'm just missing something obvious, right?

Thanks in advance…martin

[martin]

How about many-to-may relationships?

With an event and a team connected via eventTeam, when I delete the eventTeam record, it fails later because it was only 'soft-deleted'.

How do I handle that?

Thanks…martin

[Adam Chapman]

Hi Martin,

Use eventTeam.delete(softDelete=false) to permanently delete the database row.

Regards,

Adam

http://cfwheels.org/docs/1-1/function/delete

[martin]

Excellent. That solves the problem with breaking many-to-many relationships.

Do I have to do a custom sql solution for the one-to-many break up?

[Adam Chapman]

You shouldn't need a custom query, have a look at the "dependent" argument for your model associations.

[martin]

Perhaps I don't understand how 'dependent' work with one-to-many. I use it right now, when I delete an object that has dependencies to others…and it works great.

However, I don't see how it would be used to unassociate (not delete) an associated item. I don't want to delete either club or team, just break the relationship.

[martin]

So I tried the dynamic Finder methods:

Team = model("Team").findOneByIdAndClubid(value="#params.key#,#params.clubid#");

club = model("Club").findByKey(key=params.clubid);

if (club.removeTeam(team)){

renderWith(status="success", message="The team was removed successfully.", redirect={back="true"});

} else {

renderWith(status="error", message="There was an error removing the teams.", redirect={back="true"});

}

No luck. Then I tried updateByKey:

model("team").updateByKey(key=params.key, clubid="");

Still get an error…so that make me wonder what's going on underneath the hood. I checked the database and the clubid is just an INT that's nullable.

What am I missing?

[martin]

If I by pass wheels I can get it to work:  

team.updateProperty('clubid', params.clubid)

Baffling…and there doesn't seem to be an easy way to debug this…

[Adam Chapman]

It may depend on how your models are setup, but from the sounds of it, you just want to set the teams.clubid column to null.

If I'm not mistaken, the simplest way to achieve this (depending on how your UI works) is to pass params.team.clubid as an empty string. If you have a dropdown containing the clubs in your edit team form.. make sure there is an empty option..

You should then be able to use the bog stock scaffold style controller..