sqlobject-discuss

[SQLObject] deleting an intermediate table

[Timothy W. G. <tim...@si...>]

If I have an old database which contains an intermediate table generated 
by code such as 'videos = RelatedJoin("ExplanatoryVideos")' , and the 
class has been changed to no longer require a 'many-to-many' 
relationship, can this intermediate table be deleted through SQLObject 
to update the old database?

Tim

Re: [SQLObject] deleting an intermediate table

[Oleg B. <ph...@ph...>]

On Mon, Mar 14, 2011 at 11:40:24AM +0000, Timothy W. Grove wrote:
> If I have an old database which contains an intermediate table generated 
> by code such as 'videos = RelatedJoin("ExplanatoryVideos")' , and the 
> class has been changed to no longer require a 'many-to-many' 
> relationship, can this intermediate table be deleted through SQLObject 
> to update the old database?

   Table.dropJoinTables() drops all intermediate tables. If you want to
drop only a specific table, you ought to copy some code from
.dropJoinTables() to find out what table you want to drop - and drop it.

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.