def define_logic_networks_table(meta):
logic_networks = Table('logic_networks',
meta,
Column('id', String(36), primary_key=True,
nullable=False),
Column('name', String(255), nullable=False),
Column('type', String(36)),
Column('physnet_name', String(255)),
Column('cluster_id', String(36), ForeignKey(
'clusters.id'), nullable=False),
Column('segmentation_id', BigInteger()),
Column(
'segmentation_type', String(64),
nullable=False),
Column('shared', Boolean(), default=False),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return logic_networks
def define_versions_table(meta):
versions = Table('versions',
meta,
Column('id', String(36), primary_key=True,
nullable=False),
Column('name', String(256), nullable=False),
Column('size', BigInteger()),
Column('status', String(30)),
Column('checksum', String(128)),
Column('owner', String(256)),
Column('version', String(32)),
Column('type', String(30)),
Column('description', Text()),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return versions
def define_service_disks_table(meta):
disks = Table('service_disks',
meta,
Column('id', String(36), primary_key=True,
nullable=False),
Column('service', String(255)),
Column('role_id',
String(36),
ForeignKey('roles.id'),
nullable=False),
Column(
'disk_location', String(255),
nullable=False, default='local'),
Column('lun', Integer()),
Column('data_ips', String(255)),
Column('size', Integer()),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return disks
def define_configs_table(meta):
configs = Table('configs',
meta,
Column('id', String(36), primary_key=True,
nullable=False),
Column('section', String(255)),
Column('key', String(255), nullable=False),
Column('value', String(255)),
Column('config_file_id', String(36), ForeignKey(
'config_files.id'), nullable=False),
Column('config_version', Integer(), default=0),
Column('running_version', Integer(), default=0),
Column('description', Text()),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return configs
def define_host_roles_table(meta):
host_roles = Table('host_roles',
meta,
Column('id', String(36), primary_key=True,
nullable=False),
Column('host_id',
String(36),
ForeignKey('hosts.id'),
nullable=False),
Column('role_id',
String(36),
ForeignKey('roles.id'),
nullable=False),
Column(
'status', String(32), nullable=False,
default='init'),
Column('progress', Integer(), default=0),
Column('messages', Text()),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return host_roles
def define_cinder_volumes_table(meta):
disks = Table('cinder_volumes',
meta,
Column('id', String(36), primary_key=True,
nullable=False),
Column('user_name', String(255)),
Column('user_pwd', String(255)),
Column('management_ips', String(255)),
Column('pools', String(255)),
Column('volume_driver', String(255)),
Column('volume_type', String(255)),
Column('backend_index', String(255)),
Column('role_id',
String(36),
ForeignKey('roles.id'),
nullable=False),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return disks
def define_clusters_table(meta):
clusters = Table('clusters',
meta,
Column('id', String(36), primary_key=True,
nullable=False),
Column(
'name', String(255), default='TECS', nullable=False),
Column('owner', String(255)),
Column('description', Text()),
Column('net_l23_provider', String(64)),
Column('base_mac', String(128)),
Column('gre_id_start', Integer()),
Column('gre_id_end', Integer()),
Column('vlan_start', Integer()),
Column('vlan_end', Integer()),
Column('vni_start', BigInteger()),
Column('vni_end', BigInteger()),
Column('public_vip', String(128)),
Column('segmentation_type', String(64)),
Column(
'auto_scale', Integer(), nullable=False, default=0),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return clusters
def define_host_interfaces_table(meta):
host_interfaces = Table('host_interfaces',
meta,
Column('id', String(36), primary_key=True,
nullable=False),
Column('host_id', String(36),
ForeignKey('hosts.id'),
nullable=False),
Column('name', String(64)),
Column('ip', String(256)),
Column('netmask', String(256)),
Column('gateway', String(256)),
Column('mac', String(256)),
Column('pci', String(32)),
Column(
'type', String(32), nullable=False,
default='ether'),
Column('slave1', String(32)),
Column('slave2', String(32)),
Column('mode', String(36)),
Column('is_deployment', Boolean(), default=False),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return host_interfaces
def define_optical_switchs_table(meta):
optical_switchs = Table('optical_switchs',
meta,
Column('id',
String(36),
primary_key=True,
nullable=False),
Column('user_name', String(255)),
Column('user_pwd', String(255)),
Column('switch_ip', String(36)),
Column('switch_port', String(36)),
Column('role_id', String(36)),
Column('fc_driver', String(36)),
Column('fc_zoneing_policy', String(36)),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return optical_switchs
def define_neutron_backend_table(meta):
# NOTE(bcwaldon): load the images table for the ForeignKey below
sqlalchemy.Table('roles', meta, autoload=True)
neutron_backend = Table('neutron_backend',
meta,
Column('id',
String(36),
primary_key=True,
nullable=False),
Column('role_id',
String(36),
ForeignKey('roles.id'),
nullable=False),
Column('user_name', String(255)),
Column('user_pwd', String(255)),
Column('controller_ip', String(255)),
Column('neutron_backends_type', String(255)),
Column('sdn_type', String(255)),
Column('port', String(255)),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return neutron_backend
def define_template_config_roles_table(meta):
template_config_roles = \
Table('template_config_roles',
meta,
Column('id', String(36), primary_key=True, nullable=False),
Column('config_id', String(80)),
Column('role_name', String(36)),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('created_at', DateTime(), nullable=False),
Column('deleted', Boolean(), nullable=False, default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return template_config_roles
def define_template_service_table(meta):
template_service = \
Table('template_service',
meta,
Column('id', String(36), primary_key=True, nullable=False),
Column('service_name', String(100), nullable=False),
Column('force_type', String(50)),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('created_at', DateTime(), nullable=False),
Column('deleted', Boolean(), nullable=False, default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return template_service
def define_component_config_table(meta):
component_config = \
Table('component_config',
meta,
Column('id', String(36), primary_key=True, nullable=False),
Column('component_id', String(36), nullable=False),
Column('cluster_id', String(36), nullable=False),
Column('enable', Integer(), nullable=False, default=0),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('created_at', DateTime(), nullable=False),
Column('deleted', Boolean(), nullable=False, default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return component_config
def define_config_service_table(meta):
config_service = \
Table('config_service',
meta,
Column('id', String(36), primary_key=True,
nullable=False),
Column('config_id', String(36)),
Column('service_id', String(36)),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('created_at', DateTime(), nullable=False),
Column('deleted', Boolean(), nullable=False, default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return config_service
def define_template_func_table(meta):
template_func = \
Table('template_func',
meta,
Column('id', String(36), primary_key=True, nullable=False),
Column('name', String(50), nullable=False),
Column('ch_desc', Text()),
Column('en_desc', Text()),
Column('data_check_script', Text()),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('created_at', DateTime(), nullable=False),
Column('deleted', Boolean(), nullable=False, default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return template_func
def define_hwm_table(meta):
hwm = Table('hwm',
meta,
Column('id', String(36), primary_key=True, nullable=False),
Column('hwm_ip', String(36), nullable=False),
Column('description', Text()),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('created_at', DateTime(), nullable=False),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return hwm
def define_config_files_table(meta):
config_files = Table('config_files',
meta,
Column('id', String(36), primary_key=True,
nullable=False),
Column('name', String(255), nullable=False),
Column('description', Text()),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return config_files
def define_task_infos_table(meta):
task_infos = Table('task_infos',
meta,
Column('task_id', String(36)),
Column('input', Text()),
Column('result', Text()),
Column('message', Text()),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return task_infos
def define_config_historys_table(meta):
config_historys = Table('config_historys',
meta,
Column('id', String(36), primary_key=True,
nullable=False),
Column('config_id', String(36)),
Column('value', String(255)),
Column('version', Integer()),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return config_historys
def define_ip_ranges_table(meta):
ip_ranges = Table('ip_ranges',
meta,
Column('id', String(36), primary_key=True,
nullable=False),
Column('start', String(128)),
Column('end', String(128)),
Column('network_id', String(36)),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return ip_ranges
def define_tasks_table(meta):
tasks = Table('tasks',
meta,
Column('id', String(36), primary_key=True, nullable=False),
Column('type', String(30), nullable=False),
Column('status', String(30), nullable=False),
Column('owner', String(255), nullable=False),
Column('expires_at', DateTime()),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return tasks
def define_host_template_table(meta):
host_templates = Table('host_templates',
meta,
Column('id',
String(36),
primary_key=True,
nullable=False),
Column('cluster_name', String(36), nullable=False),
Column('hosts', Text(), nullable=True),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('created_at', DateTime(), nullable=False),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return host_templates
def define_dns_nameservers_table(meta):
dns_nameservers = Table('dns_nameservers',
meta,
Column('id', String(36), primary_key=True,
nullable=False),
Column('dns', String(128)),
Column(
'subnet_id', String(36),
ForeignKey('subnets.id'), nullable=False),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return dns_nameservers
def define_roles_table(meta):
roles = Table('roles',
meta,
Column('id',
String(36), primary_key=True,
nullable=False, index=True),
Column('name',
String(255),
nullable=False),
Column('status', String(32), nullable=False, default='init'),
Column('progress', Integer(), default=0),
Column('config_set_id',
String(36),
ForeignKey('config_sets.id')),
Column('description', Text()),
Column('cluster_id', String(36)),
Column('type', String(36), nullable=False, default='custom'),
Column('vip', String(256)),
Column('messages', Text()),
Column('db_lv_size', Integer()),
Column('glance_lv_size', Integer()),
Column('nova_lv_size', Integer(), default=0),
Column(
'disk_location', String(255), nullable=False,
default='local'),
Column('deployment_backend', String(36)),
Column('config_set_update_progress', Integer(), default=0),
Column('ntp_server', String(255)),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return roles
def define_service_roles_table(meta):
service_roles = Table('service_roles',
meta,
Column('id', String(36), primary_key=True,
nullable=False),
Column('role_id', String(36), ForeignKey('roles.id'),
nullable=False),
Column(
'service_id', String(36), ForeignKey(
'services.id'), nullable=False),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return service_roles
def define_routers_table(meta):
routers = Table('routers',
meta,
Column('id', String(36), primary_key=True,
nullable=False),
Column('name', String(255)),
Column('description', Text()),
Column('cluster_id', String(36), ForeignKey(
'clusters.id'), nullable=False),
Column('external_logic_network', String(255)),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return routers
def define_subnets_table(meta):
subnets = Table('subnets',
meta,
Column('id', String(36), primary_key=True,
nullable=False),
Column('cidr', String(128)),
Column('gateway', String(128)),
Column('logic_network_id', String(36), ForeignKey(
'logic_networks.id'), nullable=False),
Column('name', String(255), nullable=False),
Column('router_id', String(36), ForeignKey('routers.id')),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return subnets
def define_assigned_networks_table(meta):
assigned_networks = Table('assigned_networks',
meta,
Column('id', String(36), primary_key=True,
nullable=False),
Column('mac', String(128)),
Column('network_id', String(36)),
Column('interface_id', String(36)),
Column('ip', String(256)),
Column('vswitch_type', String(256)),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return assigned_networks
def define_config_set_items_table(meta):
config_set_items = Table('config_set_items',
meta,
Column('id', String(36), primary_key=True,
nullable=False),
Column('config_set_id', String(36),
ForeignKey('config_sets.id'),
nullable=False),
Column('config_id', String(36), ForeignKey(
'configs.id'), nullable=False),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return config_set_items
def define_users_table(meta):
users = Table('users',
meta,
Column('id', String(36), primary_key=True,
nullable=False),
Column('name', String(256), nullable=False),
Column('password', String(256)),
Column('email', String(256)),
Column('phone', String(128)),
Column('address', String(256)),
Column('created_at', DateTime(), nullable=False),
Column('updated_at', DateTime(), nullable=False),
Column('deleted_at', DateTime()),
Column('deleted',
Boolean(),
nullable=False,
default=False,
index=True),
mysql_engine='InnoDB',
extend_existing=True)
return users