← Back to branch summary

~rackspace-titan/nova/openstack-api-markers

« back to all changes in this revision

Viewing changes to nova/db/sqlalchemy/migrate_repo/versions/012_add_ipv6_flatmanager.py

  • Committer: Naveed Massjouni
  • Date: 2011-03-24 16:04:58 UTC
  • mfrom: (784.1.80 nova)
  • Revision ID: naveedm9@gmail.com-20110324160458-09aw4v7reem37sxa
Merge from trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
nova/db/sqlalchemy/migrate_repo/versions/012_add_ipv6_flatmanager.py
 
1
# Copyright (c) 2011 NTT.
 
2
# All Rights Reserved.
 
3
#
 
4
#    Licensed under the Apache License, Version 2.0 (the "License"); you may
 
5
#    not use this file except in compliance with the License. You may obtain
 
6
#    a copy of the License at
 
7
#
 
8
#         http://www.apache.org/licenses/LICENSE-2.0
 
9
#
 
10
#    Unless required by applicable law or agreed to in writing, software
 
11
#    distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
 
12
#    WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
 
13
#    License for the specific language governing permissions and limitations
 
14
#    under the License.
 
15
 
 
16
from sqlalchemy import *
 
17
from migrate import *
 
18
 
 
19
from nova import log as logging
 
20
 
 
21
 
 
22
meta = MetaData()
 
23
 
 
24
 
 
25
# Table stub-definitions
 
26
# Just for the ForeignKey and column creation to succeed, these are not the
 
27
# actual definitions of instances or services.
 
28
#
 
29
instances = Table('instances', meta,
 
30
        Column('id', Integer(),  primary_key=True, nullable=False),
 
31
        )
 
32
 
 
33
#
 
34
# Tables to alter
 
35
#
 
36
networks = Table('networks', meta,
 
37
        Column('created_at', DateTime(timezone=False)),
 
38
        Column('updated_at', DateTime(timezone=False)),
 
39
        Column('deleted_at', DateTime(timezone=False)),
 
40
        Column('deleted', Boolean(create_constraint=True, name=None)),
 
41
        Column('id', Integer(),  primary_key=True, nullable=False),
 
42
        Column('injected', Boolean(create_constraint=True, name=None)),
 
43
        Column('cidr',
 
44
               String(length=255, convert_unicode=False, assert_unicode=None,
 
45
                      unicode_error=None, _warn_on_bytestring=False)),
 
46
        Column('netmask',
 
47
               String(length=255, convert_unicode=False, assert_unicode=None,
 
48
                      unicode_error=None, _warn_on_bytestring=False)),
 
49
        Column('bridge',
 
50
               String(length=255, convert_unicode=False, assert_unicode=None,
 
51
                      unicode_error=None, _warn_on_bytestring=False)),
 
52
        Column('gateway',
 
53
               String(length=255, convert_unicode=False, assert_unicode=None,
 
54
                      unicode_error=None, _warn_on_bytestring=False)),
 
55
        Column('broadcast',
 
56
               String(length=255, convert_unicode=False, assert_unicode=None,
 
57
                      unicode_error=None, _warn_on_bytestring=False)),
 
58
        Column('dns',
 
59
               String(length=255, convert_unicode=False, assert_unicode=None,
 
60
                      unicode_error=None, _warn_on_bytestring=False)),
 
61
        Column('vlan', Integer()),
 
62
        Column('vpn_public_address',
 
63
               String(length=255, convert_unicode=False, assert_unicode=None,
 
64
                      unicode_error=None, _warn_on_bytestring=False)),
 
65
        Column('vpn_public_port', Integer()),
 
66
        Column('vpn_private_address',
 
67
               String(length=255, convert_unicode=False, assert_unicode=None,
 
68
                      unicode_error=None, _warn_on_bytestring=False)),
 
69
        Column('dhcp_start',
 
70
               String(length=255, convert_unicode=False, assert_unicode=None,
 
71
                      unicode_error=None, _warn_on_bytestring=False)),
 
72
        Column('project_id',
 
73
               String(length=255, convert_unicode=False, assert_unicode=None,
 
74
                      unicode_error=None, _warn_on_bytestring=False)),
 
75
        Column('host',
 
76
               String(length=255, convert_unicode=False, assert_unicode=None,
 
77
                      unicode_error=None, _warn_on_bytestring=False)),
 
78
        Column('cidr_v6',
 
79
        String(length=255, convert_unicode=False, assert_unicode=None,
 
80
               unicode_error=None, _warn_on_bytestring=False)),
 
81
        Column('ra_server', String(length=255,
 
82
                                   convert_unicode=False,
 
83
                                   assert_unicode=None,
 
84
                                   unicode_error=None,
 
85
                                   _warn_on_bytestring=False)),
 
86
        Column(
 
87
        'label',
 
88
        String(length=255, convert_unicode=False, assert_unicode=None,
 
89
               unicode_error=None, _warn_on_bytestring=False)))
 
90
 
 
91
fixed_ips = Table('fixed_ips', meta,
 
92
        Column('created_at', DateTime(timezone=False)),
 
93
        Column('updated_at', DateTime(timezone=False)),
 
94
        Column('deleted_at', DateTime(timezone=False)),
 
95
        Column('deleted', Boolean(create_constraint=True, name=None)),
 
96
        Column('id', Integer(),  primary_key=True, nullable=False),
 
97
        Column('address',
 
98
               String(length=255, convert_unicode=False, assert_unicode=None,
 
99
                      unicode_error=None, _warn_on_bytestring=False)),
 
100
        Column('network_id',
 
101
               Integer(),
 
102
               ForeignKey('networks.id'),
 
103
               nullable=True),
 
104
        Column('instance_id',
 
105
               Integer(),
 
106
               ForeignKey('instances.id'),
 
107
               nullable=True),
 
108
        Column('allocated', Boolean(create_constraint=True, name=None)),
 
109
        Column('leased', Boolean(create_constraint=True, name=None)),
 
110
        Column('reserved', Boolean(create_constraint=True, name=None)),
 
111
        Column("addressV6", String(length=255,
 
112
                                   convert_unicode=False,
 
113
                                   assert_unicode=None,
 
114
                                   unicode_error=None,
 
115
                                   _warn_on_bytestring=False)),
 
116
        Column("netmaskV6", String(length=3,
 
117
                                   convert_unicode=False,
 
118
                                   assert_unicode=None,
 
119
                                   unicode_error=None,
 
120
                                   _warn_on_bytestring=False)),
 
121
        Column("gatewayV6", String(length=255,
 
122
                                   convert_unicode=False,
 
123
                                   assert_unicode=None,
 
124
                                   unicode_error=None,
 
125
                                   _warn_on_bytestring=False)),
 
126
        )
 
127
#
 
128
# New Tables
 
129
#
 
130
# None
 
131
 
 
132
#
 
133
# Columns to add to existing tables
 
134
#
 
135
networks_netmask_v6 = Column(
 
136
        'netmask_v6',
 
137
        String(length=255, convert_unicode=False, assert_unicode=None,
 
138
               unicode_error=None, _warn_on_bytestring=False))
 
139
 
 
140
 
 
141
def upgrade(migrate_engine):
 
142
    # Upgrade operations go here. Don't create your own engine;
 
143
    # bind migrate_engine to your metadata
 
144
    meta.bind = migrate_engine
 
145
 
 
146
    # Alter column name
 
147
    networks.c.ra_server.alter(name='gateway_v6')
 
148
    # Add new column to existing table
 
149
    networks.create_column(networks_netmask_v6)
 
150
 
 
151
    # drop existing columns from table
 
152
    fixed_ips.c.addressV6.drop()
 
153
    fixed_ips.c.netmaskV6.drop()
 
154
    fixed_ips.c.gatewayV6.drop()