Thread: [SQLObject] delColumn on ForeignKey
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Tom E. <tom...@ja...> - 2008-12-11 19:23:01
|
How do I use delColumn on a ForeignKey? Table.sqlmeta.delColumn('colname') does not work. Neither does Table.sqlmeta.delColumn(ForeignKey('OtherTable', name='colname')). Table.sqlmeta.delColumn('colnameID') works, but it doesn't feel like the right way to do it. Suggestions? Tom |
From: Oleg B. <ph...@ph...> - 2008-12-11 19:43:25
|
On Thu, Dec 11, 2008 at 07:22:57PM +0000, Tom Ellis wrote: > How do I use delColumn on a ForeignKey? > > Table.sqlmeta.delColumn('colname') does not work. Neither does > Table.sqlmeta.delColumn(ForeignKey('OtherTable', name='colname')). > > Table.sqlmeta.delColumn('colnameID') works, Yes, that's the way. > but it doesn't feel like the > right way to do it. Do you want to work on a fix? Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Tom E. <tom...@ja...> - 2008-12-11 19:54:22
|
On Thu, Dec 11, 2008 at 10:43:22PM +0300, Oleg Broytmann wrote: > > Table.sqlmeta.delColumn('colnameID') works, > > Yes, that's the way. > > > but it doesn't feel like the > > right way to do it. > > Do you want to work on a fix? A fix being what? So that a) Table.sqlmeta.delColumn('colname') works, or b) Table.sqlmeta.delColumn(ForeignKey('OtherTable', name='colname')) works, or both? Or something else? If I come across this situation a lot in the future then I'll certainly look into fixing it. Tom |
From: Oleg B. <ph...@ph...> - 2008-12-11 20:09:53
|
On Thu, Dec 11, 2008 at 07:54:19PM +0000, Tom Ellis wrote: > A fix being what? So that > > a) Table.sqlmeta.delColumn('colname') > > works, or Yes, I think IWBN to have it working. > b) Table.sqlmeta.delColumn(ForeignKey('OtherTable', name='colname')) Why do you want to create a ForeignKey instance to delete a column? (-: Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Tom E. <tom...@ja...> - 2008-12-11 20:12:40
|
On Thu, Dec 11, 2008 at 11:09:44PM +0300, Oleg Broytmann wrote: > On Thu, Dec 11, 2008 at 07:54:19PM +0000, Tom Ellis wrote: > > A fix being what? So that > > > > a) Table.sqlmeta.delColumn('colname') > > > > works, or > > Yes, I think IWBN to have it working. OK > > b) Table.sqlmeta.delColumn(ForeignKey('OtherTable', name='colname')) > > Why do you want to create a ForeignKey instance to delete a column? (-: I don't, but I was under the impression that Table.sqlmeta.delColumn(StringCol(name='colname')) works, so going via the ForeignKey also ought to work by analogy. Tom |
From: Oleg B. <ph...@ph...> - 2008-12-11 20:18:57
|
On Thu, Dec 11, 2008 at 08:12:35PM +0000, Tom Ellis wrote: > > > b) Table.sqlmeta.delColumn(ForeignKey('OtherTable', name='colname')) > > > > Why do you want to create a ForeignKey instance to delete a column? (-: > > I don't, but I was under the impression that > Table.sqlmeta.delColumn(StringCol(name='colname')) works Yes, I think it works; I have never understood that, though. :-) Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |