openstack
/
murano
Code Issues Proposed changes

Merge "Merge all migrations to one"

This commit is contained in:
Jenkins 2013-08-09 10:00:06 +00:00 committed by Gerrit Code Review
parent eb0a06c2da b3a45217bf
commit 4a0eb5179c
12 changed files with 45 additions and 454 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

52
muranoapi/db/migrate_repo/versions/001_add_initial_tables.py
View File

@ -14,7 +14,7 @@
from migrate.changeset.constraint import ForeignKeyConstraint
from sqlalchemy.schema import MetaData, Table, Column
from sqlalchemy.types import String, Text, DateTime
from sqlalchemy.types import String, Text, DateTime, BigInteger
meta = MetaData()
@ -30,22 +30,60 @@ def upgrade(migrate_engine):
Column('created', DateTime(), nullable=False),
Column('updated', DateTime(), nullable=False),
Column('tenant_id', String(32), nullable=False),
Column('version', BigInteger, nullable=False,
server_default='0'),
Column('description', Text(), nullable=False))
environment.create()
service = Table('service', meta,
session = Table('session', meta,
Column('id', String(32), primary_key=True),
Column('name', String(255), nullable=False),
Column('type', String(40), nullable=False),
Column('environment_id', String(32), nullable=False),
Column('created', DateTime, nullable=False),
Column('updated', DateTime, nullable=False),
Column('description', Text(), nullable=False))
service.create()
Column('user_id', String(32), nullable=False),
Column('version', BigInteger, nullable=False,
server_default='0'),
Column('description', Text(), nullable=True, default='{}'),
Column('state', Text(), nullable=False))
session.create()
ForeignKeyConstraint(columns=[service.c.environment_id],
environment = Table('environment', meta, autoload=True)
ForeignKeyConstraint(columns=[session.c.environment_id],
refcolumns=[environment.c.id]).create()
deployment = Table('deployment', meta,
Column('id', String(32), primary_key=True),
Column('environment_id', String(32), nullable=False),
Column('created', DateTime, nullable=False),
Column('updated', DateTime, nullable=False),
Column('started', DateTime, nullable=False),
Column('description', Text(), nullable=True,
server_default='{}'),
Column('finished', DateTime, nullable=True))
deployment.create()
environment = Table('environment', meta, autoload=True)
ForeignKeyConstraint(columns=[deployment.c.environment_id],
refcolumns=[environment.c.id]).create()
status = Table('status', meta,
Column('id', String(32), primary_key=True),
Column('created', DateTime, nullable=False),
Column('updated', DateTime, nullable=False),
Column('entity', String(10), nullable=False),
Column('entity_id', String(32), nullable=True),
Column('environment_id', String(32), nullable=True),
Column('deployment_id', String(32), nullable=False),
Column('text', Text(), nullable=False),
Column('details', Text(), nullable=True),
Column('level', String(32), nullable=False,
server_default='info')
)
status.create()
ForeignKeyConstraint(columns=[status.c.deployment_id],
refcolumns=[deployment.c.id]).create()
def downgrade(migrate_engine):
meta.bind = migrate_engine

45
muranoapi/db/migrate_repo/versions/002_add_session_table.py
View File

@ -1,45 +0,0 @@
# Copyright (c) 2013 Mirantis, Inc.
#
# Licensed under the Apache License, Version 2.0 (the "License"); you may
# not use this file except in compliance with the License. You may obtain
# a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
# License for the specific language governing permissions and limitations
# under the License.
from migrate.changeset.constraint import ForeignKeyConstraint
from sqlalchemy.schema import MetaData, Table, Column
from sqlalchemy.types import String, Text, DateTime
meta = MetaData()
def upgrade(migrate_engine):
meta.bind = migrate_engine
meta.reflect()
session = Table('session', meta,
Column('id', String(32), primary_key=True),
Column('environment_id', String(32), nullable=False),
Column('created', DateTime, nullable=False),
Column('updated', DateTime, nullable=False),
Column('user_id', String(32), nullable=False),
Column('state', Text(), nullable=False))
session.create()
environment = Table('environment', meta, autoload=True)
ForeignKeyConstraint(columns=[session.c.environment_id],
refcolumns=[environment.c.id]).create()
def downgrade(migrate_engine):
meta.bind = migrate_engine
meta.reflect()
session = Table('session', meta, autoload=True)
session.drop()

50
muranoapi/db/migrate_repo/versions/003_add_status_table.py
View File

@ -1,50 +0,0 @@
# Copyright (c) 2013 Mirantis, Inc.
#
# Licensed under the Apache License, Version 2.0 (the "License"); you may
# not use this file except in compliance with the License. You may obtain
# a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
# License for the specific language governing permissions and limitations
# under the License.
from migrate.changeset.constraint import ForeignKeyConstraint
from sqlalchemy.schema import MetaData, Table, Column
from sqlalchemy.types import String, Text, DateTime
meta = MetaData()
def upgrade(migrate_engine):
meta.bind = migrate_engine
meta.reflect()
status = Table('status', meta,
Column('id', String(32), primary_key=True),
Column('created', DateTime, nullable=False),
Column('updated', DateTime, nullable=False),
Column('entity', String(10), nullable=False),
Column('environment_id', String(32), nullable=False),
Column('session_id', String(32), nullable=False),
Column('text', Text(), nullable=False),
)
status.create()
environment = Table('environment', meta, autoload=True)
ForeignKeyConstraint(columns=[status.c.environment_id],
refcolumns=[environment.c.id]).create()
session = Table('session', meta, autoload=True)
ForeignKeyConstraint(columns=[status.c.session_id],
refcolumns=[session.c.id]).create()
def downgrade(migrate_engine):
meta.bind = migrate_engine
meta.reflect()
status = Table('status', meta, autoload=True)
status.drop()

31
muranoapi/db/migrate_repo/versions/004_add_description_column_to_session.py
View File

@ -1,31 +0,0 @@
# Copyright (c) 2013 Mirantis, Inc.
#
# Licensed under the Apache License, Version 2.0 (the "License"); you may
# not use this file except in compliance with the License. You may obtain
# a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
# License for the specific language governing permissions and limitations
# under the License.
from sqlalchemy.schema import MetaData, Table, Column
from sqlalchemy.types import Text
meta = MetaData()
def upgrade(migrate_engine):
meta.bind = migrate_engine
session = Table('session', meta, autoload=True)
description = Column('description', Text(), nullable=True, default='{}')
description.create(session)
def downgrade(migrate_engine):
meta.bind = migrate_engine
session = Table('session', meta, autoload=True)
session.c.description.drop()

45
muranoapi/db/migrate_repo/versions/005_remove_obsolete_service_table.py
View File

@ -1,45 +0,0 @@
# Copyright (c) 2013 Mirantis, Inc.
#
# Licensed under the Apache License, Version 2.0 (the "License"); you may
# not use this file except in compliance with the License. You may obtain
# a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
# License for the specific language governing permissions and limitations
# under the License.
from migrate.changeset.constraint import ForeignKeyConstraint
from sqlalchemy.schema import MetaData, Table, Column
from sqlalchemy.types import String, DateTime, Text
meta = MetaData()
def upgrade(migrate_engine):
meta.bind = migrate_engine
meta.reflect()
service = Table('service', meta, autoload=True)
service.drop()
def downgrade(migrate_engine):
meta.bind = migrate_engine
meta.reflect()
service = Table('service', meta,
Column('id', String(32), primary_key=True),
Column('name', String(255), nullable=False),
Column('type', String(40), nullable=False),
Column('environment_id', String(32), nullable=False),
Column('created', DateTime, nullable=False),
Column('updated', DateTime, nullable=False),
Column('description', Text(), nullable=False))
service.create()
environment = Table('environment', meta, autoload=True)
ForeignKeyConstraint(columns=[service.c.environment_id],
refcolumns=[environment.c.id]).create()

31
muranoapi/db/migrate_repo/versions/006_add_entity_id_column_to_status.py
View File

@ -1,31 +0,0 @@
# Copyright (c) 2013 Mirantis, Inc.
#
# Licensed under the Apache License, Version 2.0 (the "License"); you may
# not use this file except in compliance with the License. You may obtain
# a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
# License for the specific language governing permissions and limitations
# under the License.
from sqlalchemy.schema import MetaData, Table, Column
from sqlalchemy.types import String
meta = MetaData()
def upgrade(migrate_engine):
meta.bind = migrate_engine
status = Table('status', meta, autoload=True)
entity_id = Column('entity_id', String(32), nullable=True)
entity_id.create(status)
def downgrade(migrate_engine):
meta.bind = migrate_engine
status = Table('status', meta, autoload=True)
status.c.entity_id.drop()

31
muranoapi/db/migrate_repo/versions/007_add_version_column_to_environment.py
View File

@ -1,31 +0,0 @@
# Copyright (c) 2013 Mirantis, Inc.
#
# Licensed under the Apache License, Version 2.0 (the "License"); you may
# not use this file except in compliance with the License. You may obtain
# a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
# License for the specific language governing permissions and limitations
# under the License.
from sqlalchemy.schema import MetaData, Table, Column
from sqlalchemy.types import BigInteger
meta = MetaData()
def upgrade(migrate_engine):
meta.bind = migrate_engine
environment = Table('environment', meta, autoload=True)
version = Column('version', BigInteger, nullable=False, server_default='0')
version.create(environment)
def downgrade(migrate_engine):
meta.bind = migrate_engine
environment = Table('environment', meta, autoload=True)
environment.c.version.drop()

31
muranoapi/db/migrate_repo/versions/008_add_version_column_to_session.py
View File

@ -1,31 +0,0 @@
# Copyright (c) 2013 Mirantis, Inc.
#
# Licensed under the Apache License, Version 2.0 (the "License"); you may
# not use this file except in compliance with the License. You may obtain
# a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
# License for the specific language governing permissions and limitations
# under the License.
from sqlalchemy.schema import MetaData, Table, Column
from sqlalchemy.types import BigInteger
meta = MetaData()
def upgrade(migrate_engine):
meta.bind = migrate_engine
session = Table('session', meta, autoload=True)
version = Column('version', BigInteger, nullable=False, server_default='0')
version.create(session)
def downgrade(migrate_engine):
meta.bind = migrate_engine
session = Table('session', meta, autoload=True)
session.c.version.drop()

45
muranoapi/db/migrate_repo/versions/009_add_deployment_table.py
View File

@ -1,45 +0,0 @@
# Copyright (c) 2013 Mirantis, Inc.
#
# Licensed under the Apache License, Version 2.0 (the "License"); you may
# not use this file except in compliance with the License. You may obtain
# a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
# License for the specific language governing permissions and limitations
# under the License.
from migrate.changeset.constraint import ForeignKeyConstraint
from sqlalchemy.schema import MetaData, Table, Column
from sqlalchemy.types import String, DateTime
meta = MetaData()
def upgrade(migrate_engine):
meta.bind = migrate_engine
meta.reflect()
deployment = Table('deployment', meta,
Column('id', String(32), primary_key=True),
Column('environment_id', String(32), nullable=False),
Column('created', DateTime, nullable=False),
Column('updated', DateTime, nullable=False),
Column('started', DateTime, nullable=False),
Column('finished', DateTime, nullable=True))
deployment.create()
environment = Table('environment', meta, autoload=True)
ForeignKeyConstraint(columns=[deployment.c.environment_id],
refcolumns=[environment.c.id]).create()
def downgrade(migrate_engine):
meta.bind = migrate_engine
meta.reflect()
deployment = Table('deployment', meta, autoload=True)
deployment.drop()

68
muranoapi/db/migrate_repo/versions/010_add_deployment_column_and_remove_session_column_to_status.py
View File

@ -1,68 +0,0 @@
# Copyright (c) 2013 Mirantis, Inc.
#
# Licensed under the Apache License, Version 2.0 (the "License"); you may
# not use this file except in compliance with the License. You may obtain
# a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
# License for the specific language governing permissions and limitations
# under the License.
from migrate.changeset.constraint import ForeignKeyConstraint
from sqlalchemy.schema import MetaData, Table, Column
from sqlalchemy.types import String
meta = MetaData()
def upgrade(migrate_engine):
meta.bind = migrate_engine
meta.reflect()
status = Table('status', meta, autoload=True)
environment = Table('environment', meta, autoload=True)
session = Table('session', meta, autoload=True)
deployment = Table('deployment', meta, autoload=True)
deployment_id = Column('deployment_id', String(32), nullable=False)
deployment_id.create(status)
ForeignKeyConstraint(columns=[status.c.deployment_id],
refcolumns=[deployment.c.id]).create()
ForeignKeyConstraint(columns=[status.c.environment_id],
refcolumns=[environment.c.id]).drop()
status.c.environment_id.drop()
ForeignKeyConstraint(columns=[status.c.session_id],
refcolumns=[session.c.id]).drop()
status.c.session_id.drop()
status.c.entity.alter(nullable=True)
def downgrade(migrate_engine):
meta.bind = migrate_engine
meta.reflect()
status = Table('status', meta, autoload=True)
environment = Table('environment', meta, autoload=True)
session = Table('session', meta, autoload=True)
deployment = Table('deployment', meta, autoload=True)
ForeignKeyConstraint(columns=[status.c.deployment_id],
refcolumns=[deployment.c.id]).drop()
status.c.deployment_id.drop()
environment_id = Column('environment_id', String(32), nullable=False)
environment_id.create(status)
ForeignKeyConstraint(columns=[status.c.environment_id],
refcolumns=[environment.c.id]).create()
session_id = Column('session_id', String(32), nullable=False)
session_id.create(status)
ForeignKeyConstraint(columns=[status.c.session_id],
refcolumns=[session.c.id]).create()
status.c.entity.alter(nullable=False)

31
muranoapi/db/migrate_repo/versions/011_add_description_column_to_deployment.py
View File

@ -1,31 +0,0 @@
# Copyright (c) 2013 Mirantis, Inc.
#
# Licensed under the Apache License, Version 2.0 (the "License"); you may
# not use this file except in compliance with the License. You may obtain
# a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
# License for the specific language governing permissions and limitations
# under the License.
from sqlalchemy.schema import MetaData, Table, Column
from sqlalchemy.types import Text
meta = MetaData()
def upgrade(migrate_engine):
meta.bind = migrate_engine
deployment = Table('deployment', meta, autoload=True)
description = Column('description', Text(), nullable=True, default='{}')
description.create(deployment)
def downgrade(migrate_engine):
meta.bind = migrate_engine
deployment = Table('deployment', meta, autoload=True)
deployment.c.description.drop()

39
muranoapi/db/migrate_repo/versions/012_add_details_and_level_columns_to_status.py
View File

@ -1,39 +0,0 @@
# Copyright (c) 2013 Mirantis, Inc.
#
# Licensed under the Apache License, Version 2.0 (the "License"); you may
# not use this file except in compliance with the License. You may obtain
# a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
# License for the specific language governing permissions and limitations
# under the License.
from sqlalchemy.schema import MetaData, Table, Column
from sqlalchemy.types import Text, String
meta = MetaData()
def upgrade(migrate_engine):
meta.bind = migrate_engine
meta.reflect()
status = Table('status', meta, autoload=True)
details = Column('details', Text(), nullable=True)
level = Column('level', String(32), nullable=False, server_default='info')
details.create(status)
level.create(status)
def downgrade(migrate_engine):
meta.bind = migrate_engine
meta.reflect()
status = Table('status', meta, autoload=True)
status.c.details.drop()
status.c.level.drop()