How to add a table in Nova Database : Openstack

Question

I'm adding one class nova.db.sqlalchemy.models to create associated table in Nova DB but its not reflecting there.

Doing same in neutron is creating a Table in Neutron DB.

Openstack documentation does not explains how to extend the database anywhere. http://docs.openstack.org/developer/nova/api/nova.db.sqlalchemy.models.html

How this issue can be resolved ?

i thought db transacations were now being done out of oslo's sqlalchmey classes. — Matt Joyce, Oct 18 '13 at 15:33
common db have just one ModelBase class. All the model definition classes are in nova.db.sqlalchemy.models only. — devesh-ahuja, Oct 22 '13 at 07:55
like this: http://docs.openstack.org/developer/nova/devref/database.html#the-nova-db-sqlalchemy-models-module — devesh-ahuja, Oct 24 '13 at 07:17

score 3 · Accepted Answer · answered Jan 06 '14 at 05:23

3

you would also have to add migration file in nova/db/sqlalchemy/migrate_repo/versions/, after that do 'nova-manage db sync'. The new table should be reflected now. HTH

answered Jan 06 '14 at 05:23

Pensu

3,263
10
46
71

score 2 · Answer 2 · answered Jul 23 '14 at 01:15

Create your model inside nova/db/sqlalchemy/models.py
Create migration file inside nova/db/sqlalchemy/migrate_repo/versions/ .
You can do this by simply adding a .py file with an increased version number
Provide upgrade() and downgrade() functions as described in this pdf
sync nova db using:

nova-manage db sync

How to add a table in Nova Database : Openstack

2 Answers2