SQLAlchemy DB Migration

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!gegeweb.org!de-l.enfer-du-nord.net!feeder2.enfer-du-nord.net!feeds.phibee-telecom.net!newsfeed.xs4all.nl!newsfeed6.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path	<merwin.irc@gmail.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.063
X-Spam-Evidence	'H': 0.87; 'S': 0.00; 'migrate': 0.07; 'migration': 0.07; 'everybody,': 0.09; 'columns': 0.16; 'goal.': 0.16; 'migrate.': 0.16; 'sqlalchemy': 0.16; 'received:74.125.82.44': 0.17; 'received:mail-ww0-f44.google.com': 0.17; 'simpler': 0.18; "doesn't": 0.23; "i'm": 0.26; 'column': 0.28; 'needed,': 0.28; 'exists,': 0.30; 'cases': 0.32; "can't": 0.32; 'to:addr:python-list': 0.32; 'header:User-Agent:1': 0.33; 'too': 0.33; 'message-id:@gmail.com': 0.34; 'another': 0.36; 'received:74.125.82': 0.37; 'doing': 0.37; 'but': 0.37; 'think': 0.37; 'could': 0.38; 'received:google.com': 0.38; 'received:192': 0.38; 'received:74.125': 0.39; '(with': 0.39; "it's": 0.39; 'tool': 0.39; 'might': 0.39; 'to:addr:python.org': 0.39; 'data': 0.40; 'more': 0.60; 'human': 0.63; 'easily.': 0.67; 'imagine': 0.71; '100%': 0.82; 'automated,': 0.84; 'hand.': 0.84
DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject :content-type:content-transfer-encoding; bh=eaDW9oLpflUK6J+GqOrCBCp1M3+JwQ1pAPpJE5z/r04=; b=bhiCSxL9V+BqX2Ra2CZ3E4E6nsHJvrYEYKGAhev/Vw1JFk5eotrMMbntOCoedmUKuP STANacim4vPIJGEt6XGlnKgdOMkUx4yamYXjUp0Okxl9XVuMcMmo5LGcg3h3DaYpgVJf VEqk1OYAiRgVkInceb/2JFEegUX59qDvHNrQ8=
Date	Sun, 06 Nov 2011 10:44:06 +0100
From	Merwin <merwin.irc@gmail.com>
User-Agent	Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1
MIME-Version	1.0
To	python-list@python.org
Subject	SQLAlchemy DB Migration
Content-Type	text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding	7bit
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.12
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.2462.1320572653.27778.python-list@python.org> (permalink)
Lines	25
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1320572653 news.xs4all.nl 6908 [2001:888:2000:d::a6]:56111
X-Complaints-To	abuse@xs4all.nl
Xref	x330-a1.tempe.blueboxinc.net comp.lang.python:15374

Show key headers only | View raw

Hi everybody,

I'm looking for a way to migrate SQLAlchemy based database easily. I 
found Migrate, but finally it's almost the same as doing the migration 
by hand.

If this doesn't exists, do you think that it would be hard to do a 
simple migration tool which would :

     - Add/Delete columns from DB if they are not anymore in the models 
(With a confirmation for deletion)
     - Add/Delete constraints/sequences on table if they are not on the 
model too

We could also imagine a way to :

     - Handle column rename, with data copy from one to another
     - Handle column type change, with proper data conversion

Of course, such a system can't be 100% automated, that's not the goal. 
Human interventation will be needed, but it might be more simpler for 
simple cases than Migrate.

--
Thibaut

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

SQLAlchemy DB Migration Merwin <merwin.irc@gmail.com> - 2011-11-06 10:44 +0100

csiph-web