Re: RFC: script to run sqlalchemy migrations on the db

2008-08-11 Thread Toshio Kuratomi
Toshio Kuratomi wrote: app2 $ migrate-runner -h db2 -d fas2 /usr/share/fas/database This script must create a temporary db user, fas2temp on db2. That user will have permission to modify anything in the fas2 database. If you stop this script in the middle of running you will want to remove the

Re: RFC: script to run sqlalchemy migrations on the db

2008-08-11 Thread Yaakov Nemoy
On Mon, Aug 11, 2008 at 4:31 PM, Mike McGrath <[EMAIL PROTECTED]> wrote: > On Mon, 11 Aug 2008, Yaakov Nemoy wrote: > >> 2008/8/9 Toshio Kuratomi <[EMAIL PROTECTED]>: >> > FAS started using the python-migrate package to update its db. This is a >> > good thing for third-parties that want to instal

Re: RFC: script to run sqlalchemy migrations on the db

2008-08-11 Thread Mike McGrath
On Mon, 11 Aug 2008, Yaakov Nemoy wrote: > 2008/8/9 Toshio Kuratomi <[EMAIL PROTECTED]>: > > FAS started using the python-migrate package to update its db. This is a > > good thing for third-parties that want to install their own FAS server as it > > lets us ship the database changes in a way tha

Re: RFC: script to run sqlalchemy migrations on the db

2008-08-11 Thread Yaakov Nemoy
2008/8/9 Toshio Kuratomi <[EMAIL PROTECTED]>: > FAS started using the python-migrate package to update its db. This is a > good thing for third-parties that want to install their own FAS server as it > lets us ship the database changes in a way that is easy for those users to > apply to their own

Re: RFC: script to run sqlalchemy migrations on the db

2008-08-10 Thread Toshio Kuratomi
Mike McGrath wrote: On Fri, 8 Aug 2008, Toshio Kuratomi wrote: # 1) Create a db user. # 2) grant access to all the values in the specified db # 3) run the migrate commands to create the manage.py script and run it with the new username and password # 4) Reassign any new tables to the postgres us

Re: RFC: script to run sqlalchemy migrations on the db

2008-08-09 Thread Mike McGrath
On Fri, 8 Aug 2008, Toshio Kuratomi wrote: > FAS started using the python-migrate package to update its db. This is a good > thing for third-parties that want to install their own FAS server as it lets > us ship the database changes in a way that is easy for those users to apply to > their own pr

RFC: script to run sqlalchemy migrations on the db

2008-08-08 Thread Toshio Kuratomi
FAS started using the python-migrate package to update its db. This is a good thing for third-parties that want to install their own FAS server as it lets us ship the database changes in a way that is easy for those users to apply to their own production databases. However, it doesn't work ve