Re: [openstack-dev] [Neutron][db][migration] Neutron db migrationby python scripts

2015-11-03 Thread Zhi Chang
Thanks for your reply.
 There is an error when I run migration cmd:


stack@devstack:~/neutron/neutron/db/migration$ neutron-db-manage revision -m 
'desc' --contract
usage: neutron-db-manage [-h] [--config-dir DIR] [--config-file PATH]
 [--core_plugin CORE_PLUGIN] [--nosplit_branches]
 [--service SERVICE] [--split_branches]
 [--subproject SUBPROJECT] [--version]
 [--database-connection DATABASE_CONNECTION]
 [--database-engine DATABASE_ENGINE]
 
{current,history,branches,check_migration,upgrade,downgrade,stamp,revision}
 ...
neutron-db-manage: error: unrecognized arguments: --contract

 
 
-- Original --
From:  "Anna Kamyshnikova"<akamyshnik...@mirantis.com>;
Date:  Tue, Nov 3, 2015 07:03 PM
To:  "OpenStack Development Mailing List (not for usage 
questions)"<openstack-dev@lists.openstack.org>; 

Subject:  Re: [openstack-dev] [Neutron][db][migration] Neutron db migrationby 
python scripts

 
You can create new migration using "neutron-db-manage revision -m 'desc' 
--expand/--contract" depends in what changes do you want to do in migration 
expand - add something, contract - delete or modify. More information - 
http://docs.openstack.org/developer/neutron/devref/alembic_migrations.html


On Tue, Nov 3, 2015 at 1:52 PM, Zhi Chang <chang...@unitedstack.com> wrote:
Hi, all
Now, I should make some database model definitions if I want to upgrade db. 
And a database migration script will generated when I run "neutron-db-manage 
revision -m "description of revision" --autogenerate". The database will 
upgraded when run "neutron-db-manage upgrade head". 
I want to upgrade db and I plan to write db migration scripts manually 
instead of change database model definitions. Is there some ways to realize it?
Does anyone have some good ideas?


Thanks
Zhi Chang


__
 OpenStack Development Mailing List (not for usage questions)
 Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
 http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
 





-- 
Regards,Ann Kamyshnikova
Mirantis, Inc__
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev


Re: [openstack-dev] [Neutron][db][migration] Neutron db migrationby python scripts

2015-11-03 Thread Henry Gessau
Your installed neutron is not current. When developing new db migrations you
should be working with the master branch. Fast forward your repo and re-run
devstack to get the latest neutron-db-manage.

On Tue, Nov 03, 2015, Zhi Chang <chang...@unitedstack.com> wrote:
> Thanks for your reply.
>  There is an error when I run migration cmd:
>
> stack@devstack:~/neutron/neutron/db/migration$ neutron-db-manage revision -m
> 'desc' --contract
> usage: neutron-db-manage [-h] [--config-dir DIR] [--config-file PATH]
>  [--core_plugin CORE_PLUGIN] [--nosplit_branches]
>  [--service SERVICE] [--split_branches]
>  [--subproject SUBPROJECT] [--version]
>  [--database-connection DATABASE_CONNECTION]
>  [--database-engine DATABASE_ENGINE]
>
>  {current,history,branches,check_migration,upgrade,downgrade,stamp,revision}
>  ...
> neutron-db-manage: error: unrecognized arguments: --contract
>  
>  
> -- Original --
> *From: * "Anna Kamyshnikova"<akamyshnik...@mirantis.com>;
> *Date: * Tue, Nov 3, 2015 07:03 PM
> *To: * "OpenStack Development Mailing List (not for usage
> questions)"<openstack-dev@lists.openstack.org>;
> *Subject: * Re: [openstack-dev] [Neutron][db][migration] Neutron db
> migrationby python scripts
>  
> You can create new migration using "neutron-db-manage revision -m 'desc'
> --expand/--contract" depends in what changes do you want to do in migration
> expand - add something, contract - delete or modify.
>  More information
> - http://docs.openstack.org/developer/neutron/devref/alembic_migrations.html
>
> On Tue, Nov 3, 2015 at 1:52 PM, Zhi Chang <chang...@unitedstack.com
> <mailto:chang...@unitedstack.com>> wrote:
>
> Hi, all
> Now, I should make some database model definitions if I want to
> upgrade db. And a database migration script will generated when I run
> "neutron-db-manage revision -m "description of revision" --autogenerate".
> The database will upgraded when run "neutron-db-manage upgrade head". 
> I want to upgrade db and I plan to write db migration scripts manually
> instead of change database model definitions. Is there some ways to
> realize it?
> Does anyone have some good ideas?
>
> Thanks
> Zhi Chang
>
> __
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
> <http://openstack-dev-requ...@lists.openstack.org?subject:unsubscribe>
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
>
>
>
> -- 
> Regards,
> Ann Kamyshnikova
> Mirantis, Inc
>
>
> __
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

__
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev


Re: [openstack-dev] [Neutron][db][migration] Neutron db migrationby python scripts

2015-11-03 Thread Anna Kamyshnikova
Do you have the lasted code of Neutron? Change [1] that allows this was
merged on the 22d of October.

[1] -
https://github.com/openstack/neutron/commit/9d069c48aed3a087c5c51366c8e70b29f339e794

On Tue, Nov 3, 2015 at 2:10 PM, Zhi Chang <chang...@unitedstack.com> wrote:

> Thanks for your reply.
>  There is an error when I run migration cmd:
>
> stack@devstack:~/neutron/neutron/db/migration$ neutron-db-manage revision
> -m 'desc' --contract
> usage: neutron-db-manage [-h] [--config-dir DIR] [--config-file PATH]
>  [--core_plugin CORE_PLUGIN] [--nosplit_branches]
>  [--service SERVICE] [--split_branches]
>  [--subproject SUBPROJECT] [--version]
>  [--database-connection DATABASE_CONNECTION]
>  [--database-engine DATABASE_ENGINE]
>
>  {current,history,branches,check_migration,upgrade,downgrade,stamp,revision}
>  ...
> neutron-db-manage: error: unrecognized arguments: --contract
>
>
> -- Original --
> *From: * "Anna Kamyshnikova"<akamyshnik...@mirantis.com>;
> *Date: * Tue, Nov 3, 2015 07:03 PM
> *To: * "OpenStack Development Mailing List (not for usage questions)"<
> openstack-dev@lists.openstack.org>;
> *Subject: * Re: [openstack-dev] [Neutron][db][migration] Neutron db
> migrationby python scripts
>
> You can create new migration using "neutron-db-manage revision -m 'desc'
> --expand/--contract" depends in what changes do you want to do in migration
> expand - add something, contract - delete or modify.
>  More information -
> http://docs.openstack.org/developer/neutron/devref/alembic_migrations.html
>
> On Tue, Nov 3, 2015 at 1:52 PM, Zhi Chang <chang...@unitedstack.com>
> wrote:
>
>> Hi, all
>> Now, I should make some database model definitions if I want to
>> upgrade db. And a database migration script will generated when I run 
>> "neutron-db-manage
>> revision -m "description of revision" --autogenerate". The database will
>> upgraded when run "neutron-db-manage upgrade head".
>> I want to upgrade db and I plan to write db migration scripts
>> manually instead of change database model definitions. Is there some ways
>> to realize it?
>> Does anyone have some good ideas?
>>
>> Thanks
>> Zhi Chang
>>
>> __
>> OpenStack Development Mailing List (not for usage questions)
>> Unsubscribe:
>> openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>>
>>
>
>
> --
> Regards,
> Ann Kamyshnikova
> Mirantis, Inc
>
> __
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
>


-- 
Regards,
Ann Kamyshnikova
Mirantis, Inc
__
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev