Re: Altering a (populated) database column

Oleg Broytman <[email protected]> Tue, 24 Oct 2017 21:37:57 +0200

Newsgroups	gmane.comp.python.sqlobject
Message-ID	<[email protected]>

Hi!

On Tue, Oct 24, 2017 at 08:00:13PM +0100, Hugo Mills <[email protected]> wrote:
>    Is there any way that I can modify an existing database column,
> with data in it, without losing the data in it? All I need to be able
> to do is increase the size of a StringCol.
> 
>    I can see addColumn and delColumn methods of the sqlmeta object,
> but not an alterColumn or anything similar.

   Probably yes (depends on the backend) but not with SQLObject.
SQLObject can CREATE/DROP tables, columns and indices but cannot ALTER
them.
   You need to execute ALTER TABLE connecting directly or call
connection.execute("ALTER TABLE ...")

   What us your backend? MySQL?

>    Thanks,
>    Hugo.
> 
> -- 
> Dr Hugo Mills                           | [email protected]
> Chief Technologist                      |
> Nightglass Medical Rostering Ltd        | +44 207 040 4054

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            [email protected]
           Programmers don't die, they just GOSUB without RETURN.

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot