def upgrade(): op.add_column( model.HTTPSOAP.__tablename__, sa.Column('has_rbac', sa.Boolean(), nullable=True)) alter_column_nullable_false( model.HTTPSOAP.__tablename__, 'has_rbac', False, sa.Boolean()) op.execute(CreateSequence(sa.Sequence('rbac_role_seq'))) op.create_table( model.RBACRole.__tablename__, sa.Column('id', sa.Integer(), sa.Sequence('rbac_cli_rol_seq'), primary_key=True), sa.Column('name', sa.String(200), nullable=False), sa.Column('parent_id', sa.Integer(), sa.ForeignKey('rbac_role.id', ondelete='CASCADE')), sa.Column('cluster_id', sa.Integer(), sa.ForeignKey('cluster.id', ondelete='CASCADE'), nullable=False), ) op.create_unique_constraint( 'rbac_role_name_cluster_id_key', model.RBACRole.__tablename__, ['name', 'cluster_id'] ) op.execute(CreateSequence(sa.Sequence('rbac_cli_rol_seq'))) op.create_table( model.RBACClientRole.__tablename__, sa.Column('id', sa.Integer(), sa.Sequence('rbac_cli_rol_seq'), primary_key=True), sa.Column('name', sa.String(400), nullable=False), sa.Column('client_def', sa.String(200), nullable=False), sa.Column('role_id', sa.Integer(), sa.ForeignKey('rbac_role.id', ondelete='CASCADE'), nullable=False), sa.Column('cluster_id', sa.Integer(), sa.ForeignKey('cluster.id', ondelete='CASCADE'), nullable=False), ) op.create_unique_constraint( 'rbac_client_role_client_def_role_id_cluster_id_key', model.RBACClientRole.__tablename__,\ ['client_def', 'role_id', 'cluster_id'] ) op.execute(CreateSequence(sa.Sequence('rbac_perm_seq'))) op.create_table( model.RBACPermission.__tablename__, sa.Column('id', sa.Integer(), sa.Sequence('rbac_cli_rol_seq'), primary_key=True), sa.Column('name', sa.String(200), nullable=False), sa.Column('cluster_id', sa.Integer(), sa.ForeignKey('cluster.id', ondelete='CASCADE'), nullable=False), ) op.create_unique_constraint( 'rbac_perm_name_cluster_id_key', model.RBACPermission.__tablename__, ['name', 'cluster_id'] ) op.execute(CreateSequence(sa.Sequence('rbac_role_perm_seq'))) op.create_table( model.RBACRolePermission.__tablename__, sa.Column('id', sa.Integer(), sa.Sequence('rbac_cli_rol_seq'), primary_key=True), sa.Column('role_id', sa.Integer(), sa.ForeignKey('rbac_role.id', ondelete='CASCADE'), nullable=False), sa.Column('perm_id', sa.Integer(), sa.ForeignKey('rbac_perm.id', ondelete='CASCADE'), nullable=False), sa.Column('service_id', sa.Integer(), sa.ForeignKey('service.id', ondelete='CASCADE'), nullable=False), sa.Column('cluster_id', sa.Integer(), sa.ForeignKey('cluster.id', ondelete='CASCADE'), nullable=False), ) op.create_unique_constraint( 'rbac_role_perm_role_id_perm_id_service_id_cluster_id_key', model.RBACRolePermission.__tablename__,\ ['role_id', 'perm_id', 'service_id', 'cluster_id'] )
def upgrade(): add_col( model.HTTPSOAP.__tablename__, sa.Column('audit_enabled', sa.Boolean(), nullable=True)) alter_column_nullable_false( model.HTTPSOAP.__tablename__, 'audit_enabled', False, sa.Boolean()) add_col( model.HTTPSOAP.__tablename__, sa.Column('audit_back_log', sa.Integer(), nullable=True)) alter_column_nullable_false( model.HTTPSOAP.__tablename__, 'audit_back_log', MISC.DEFAULT_AUDIT_BACK_LOG, sa.Integer()) add_col( model.HTTPSOAP.__tablename__, sa.Column( 'audit_max_payload', sa.Integer(), nullable=True, default=MISC.DEFAULT_AUDIT_MAX_PAYLOAD)) alter_column_nullable_false( model.HTTPSOAP.__tablename__,'audit_max_payload', MISC.DEFAULT_AUDIT_MAX_PAYLOAD, sa.Integer()) add_col( model.HTTPSOAP.__tablename__, sa.Column('audit_repl_patt_type', sa.String(200), nullable=True)) alter_column_nullable_false( model.HTTPSOAP.__tablename__, 'audit_repl_patt_type', MSG_PATTERN_TYPE.JSON_POINTER.id, sa.String(200))
def upgrade(): op.create_unique_constraint( 'sec_base_cluster_id_username_sec_type_key', model.SecurityBase.__tablename__, ['cluster_id', 'username', 'sec_type']) op.create_table( model.NTLM.__tablename__,sa.Column('id', sa.Integer(), sa.ForeignKey('sec_base.id'), primary_key=True) ) op.create_table( model.APIKeySecurity.__tablename__,sa.Column('id', sa.Integer(), sa.ForeignKey('sec_base.id'), primary_key=True) ) op.create_table( model.XPathSecurity.__tablename__, sa.Column('id', sa.Integer(), sa.ForeignKey('sec_base.id'), primary_key=True), sa.Column('username_expr', sa.String(200), nullable=False), sa.Column('password_expr', sa.String(200), nullable=True), ) add_col( model.HTTPSOAP.__tablename__, sa.Column('serialization_type', sa.String(200), nullable=True)) alter_column_nullable_false( model.HTTPSOAP.__tablename__, 'serialization_type', HTTP_SOAP_SERIALIZATION_TYPE.SUDS.id, sa.String(200)) add_col( model.HTTPSOAP.__tablename__, sa.Column('timeout', sa.Integer(), nullable=True)) alter_column_nullable_false( model.HTTPSOAP.__tablename__, 'timeout', MISC.DEFAULT_HTTP_TIMEOUT, sa.Integer()) op.create_table( model.AWSSecurity.__tablename__, sa.Column('id', sa.Integer(), sa.ForeignKey('sec_base.id'), primary_key=True)) op.execute(CreateSequence(sa.Sequence('deliv_def_seq'))) op.execute(CreateSequence(sa.Sequence('deliv_seq'))) op.execute(CreateSequence(sa.Sequence('deliv_payl_seq'))) op.execute(CreateSequence(sa.Sequence('msg_ns_seq'))) op.execute(CreateSequence(sa.Sequence('http_soap_audit_seq'))) op.create_table( model.HTTSOAPAudit.__tablename__, sa.Column('id', sa.Integer(), sa.Sequence('http_soap_audit_seq'), primary_key=True), sa.Column('name', sa.String(200), nullable=False, index=True), sa.Column('cid', sa.String(200), nullable=False, index=True), sa.Column('transport', sa.String(200), nullable=False, index=True), sa.Column('connection', sa.String(200), nullable=False, index=True), sa.Column('req_time', sa.DateTime(), nullable=False), sa.Column('resp_time', sa.DateTime(), nullable=True), sa.Column('user_token', sa.String(200), nullable=True, index=True), sa.Column('invoke_ok', sa.Boolean, nullable=True), sa.Column('auth_ok', sa.Boolean, nullable=True), sa.Column('remote_addr', sa.String(200), nullable=False, index=True), sa.Column('req_headers', sa.LargeBinary(), nullable=True), sa.Column('req_payload', sa.LargeBinary(), nullable=True), sa.Column('resp_headers', sa.LargeBinary(), nullable=True), sa.Column('resp_payload', sa.LargeBinary(), nullable=True), sa.Column('cluster_id', sa.Integer(), sa.ForeignKey('cluster.id', ondelete='CASCADE'), nullable=False), sa.Column('conn_id', sa.Integer(), sa.ForeignKey('http_soap.id', ondelete='CASCADE'), nullable=False), ) op.execute(CreateSequence(sa.Sequence('htp_sp_ad_rpl_p_jp_seq'))) op.create_table( model.HTTSOAPAuditReplacePatternsJSONPointer.__tablename__, sa.Column('id', sa.Integer(), sa.Sequence('htp_sp_ad_rpl_p_jp_seq'), primary_key=True), sa.Column('conn_id', sa.Integer, sa.ForeignKey('http_soap.id', ondelete='CASCADE'), nullable=False), sa.Column('pattern_id', sa.Integer, sa.ForeignKey('msg_json_pointer.id', ondelete='CASCADE'), nullable=False), sa.Column('cluster_id', sa.Integer, sa.ForeignKey('cluster.id', ondelete='CASCADE'), nullable=False), sa.UniqueConstraint('conn_id','pattern_id') ) op.execute(CreateSequence(sa.Sequence('htp_sp_ad_rpl_p_xp_seq'))) op.create_table( model.HTTSOAPAuditReplacePatternsXPath.__tablename__, sa.Column('id', sa.Integer(), sa.Sequence('htp_sp_ad_rpl_p_xp_seq'), primary_key=True), sa.Column('conn_id', sa.Integer(), sa.ForeignKey('http_soap.id', ondelete='CASCADE'), nullable=False), sa.Column('pattern_id', sa.Integer(), sa.ForeignKey('msg_xpath.id', ondelete='CASCADE'), nullable=False), sa.Column('cluster_id', sa.Integer(), sa.ForeignKey('cluster.id', ondelete='CASCADE'), nullable=False), sa.UniqueConstraint('conn_id','pattern_id') ) op.execute(CreateSequence(sa.Sequence('pub_sub_topic_seq'))) op.create_table( model.PubSubTopic.__tablename__, sa.Column('id', sa.Integer(), sa.Sequence('pub_sub_topic_seq'), primary_key=True), sa.Column('name', sa.String(200), nullable=False), sa.Column('is_active', sa.Boolean, nullable=False), sa.Column('max_depth', sa.Integer(), nullable=False), sa.Column('cluster_id', sa.Integer(), sa.ForeignKey('cluster.id', ondelete='CASCADE'), nullable=False), sa.UniqueConstraint('name','cluster_id') ) op.execute(CreateSequence(sa.Sequence('pub_sub_cons_seq'))) op.create_table( model.PubSubConsumer.__tablename__, sa.Column('id', sa.Integer(), sa.Sequence('pub_sub_cons_seq'), primary_key=True), sa.Column('is_active', sa.Boolean, nullable=False), sa.Column('sub_key', sa.String(200), nullable=False), sa.Column('max_backlog', sa.Integer(), nullable=False), sa.Column('delivery_mode', sa.String(200), nullable=False), sa.Column('callback_id', sa.Integer(), sa.ForeignKey('http_soap.id', ondelete='CASCADE'), nullable=True), sa.Column('callback_type', sa.String(20), nullable=True, default=PUB_SUB.CALLBACK_TYPE.OUTCONN_PLAIN_HTTP), sa.Column('topic_id', sa.Integer(), sa.ForeignKey('pub_sub_topic.id', ondelete='CASCADE'), nullable=False), sa.Column('sec_def_id', sa.Integer(), sa.ForeignKey('sec_base.id', ondelete='CASCADE'), nullable=False), sa.Column('cluster_id', sa.Integer(), sa.ForeignKey('cluster.id', ondelete='CASCADE'), nullable=False), sa.UniqueConstraint('sec_def_id','topic_id','cluster_id') ) op.create_table( model.PubSubProducer.__tablename__, sa.Column('id', sa.Integer(), sa.Sequence('pub_sub_cons_seq'), primary_key=True), sa.Column('is_active', sa.Boolean, nullable=False), sa.Column('topic_id', sa.Integer(), sa.ForeignKey('pub_sub_topic.id', ondelete='CASCADE'), nullable=False), sa.Column('sec_def_id', sa.Integer(), sa.ForeignKey('sec_base.id', ondelete='CASCADE'), nullable=False), sa.Column('cluster_id', sa.Integer(), sa.ForeignKey('cluster.id', ondelete='CASCADE'), nullable=False), sa.UniqueConstraint('sec_def_id','topic_id','cluster_id') ) op.execute(CreateSequence(sa.Sequence('os_swift_seq'))) op.create_table( model.OpenStackSwift.__tablename__, sa.Column('id', sa.Integer(), sa.Sequence('os_swift_seq'), primary_key=True), sa.Column('name', sa.String(200), nullable=False), sa.Column('is_active', sa.Boolean, nullable=False), sa.Column('auth_url', sa.String(200), nullable=False), sa.Column('auth_version', sa.String(200), nullable=False, default=CLOUD.OPENSTACK.SWIFT.DEFAULTS.AUTH_VERSION), sa.Column('user', sa.String(200), nullable=True), sa.Column('key', sa.String(200), nullable=True), sa.Column('retries', sa.Integer, nullable=False, default=CLOUD.OPENSTACK.SWIFT.DEFAULTS.RETRIES), sa.Column('is_snet', sa.Boolean, nullable=False), sa.Column('starting_backoff', sa.Integer(), nullable=False, default=CLOUD.OPENSTACK.SWIFT.DEFAULTS.BACKOFF_STARTING), sa.Column('max_backoff', sa.Integer(), nullable=False, default=CLOUD.OPENSTACK.SWIFT.DEFAULTS.BACKOFF_MAX), sa.Column('tenant_name', sa.String(200), nullable=True), sa.Column('should_validate_cert', sa.Boolean, nullable=False), sa.Column('cacert', sa.String(200), nullable=True), sa.Column('should_retr_ratelimit', sa.Boolean, nullable=False), sa.Column('needs_tls_compr', sa.Boolean, nullable=False), sa.Column('custom_options', sa.String(2000), nullable=True), sa.Column('cluster_id', sa.Integer(), sa.ForeignKey('cluster.id', ondelete='CASCADE'), nullable=False), sa.UniqueConstraint('name','cluster_id') ) op.execute(CreateSequence(sa.Sequence('aws_s3_seq'))) op.create_table( model.AWSS3.__tablename__, sa.Column('id', sa.Integer, sa.Sequence('aws_s3_seq'), primary_key=True), sa.Column('name', sa.String(200), nullable=False), sa.Column('is_active', sa.Boolean, nullable=False), sa.Column('pool_size', sa.Integer(), nullable=False, default=CLOUD.AWS.S3.DEFAULTS.POOL_SIZE), sa.Column('address', sa.String(200), nullable=False, default=CLOUD.AWS.S3.DEFAULTS.ADDRESS), sa.Column('debug_level', sa.Integer, nullable=False, default=CLOUD.AWS.S3.DEFAULTS.DEBUG_LEVEL), sa.Column('suppr_cons_slashes', sa.Boolean, nullable=False, default=True), sa.Column('content_type', sa.String(200), nullable=False, default=CLOUD.AWS.S3.DEFAULTS.CONTENT_TYPE), sa.Column('metadata_', sa.String(2000), nullable=True), sa.Column('bucket', sa.String(2000), nullable=True), sa.Column('encrypt_at_rest', sa.Boolean, nullable=False, default=False), sa.Column('storage_class', sa.String(200), nullable=False, default=CLOUD.AWS.S3.STORAGE_CLASS.DEFAULT), sa.Column('security_id', sa.Integer(), sa.ForeignKey('sec_base.id', ondelete='CASCADE'), nullable=False), sa.Column('cluster_id', sa.Integer(), sa.ForeignKey('cluster.id', ondelete='CASCADE'), nullable=False), sa.UniqueConstraint('name','cluster_id') ) op.alter_column(model.Cluster.__tablename__, 'odb_host', nullable=True) op.alter_column(model.Cluster.__tablename__, 'odb_port', nullable=True) op.alter_column(model.Cluster.__tablename__, 'odb_user', nullable=True) op.alter_column(model.Cluster.__tablename__, 'odb_db_name', nullable=True)
def upgrade(): op.add_column(model.HTTPSOAP.__tablename__, sa.Column('has_rbac', sa.Boolean(), nullable=True)) alter_column_nullable_false(model.HTTPSOAP.__tablename__, 'has_rbac', False, sa.Boolean()) op.execute(CreateSequence(sa.Sequence('rbac_role_seq'))) op.create_table( model.RBACRole.__tablename__, sa.Column('id', sa.Integer(), sa.Sequence('rbac_cli_rol_seq'), primary_key=True), sa.Column('name', sa.String(200), nullable=False), sa.Column('parent_id', sa.Integer(), sa.ForeignKey('rbac_role.id', ondelete='CASCADE')), sa.Column('cluster_id', sa.Integer(), sa.ForeignKey('cluster.id', ondelete='CASCADE'), nullable=False), ) op.create_unique_constraint('rbac_role_name_cluster_id_key', model.RBACRole.__tablename__, ['name', 'cluster_id']) op.execute(CreateSequence(sa.Sequence('rbac_cli_rol_seq'))) op.create_table( model.RBACClientRole.__tablename__, sa.Column('id', sa.Integer(), sa.Sequence('rbac_cli_rol_seq'), primary_key=True), sa.Column('name', sa.String(400), nullable=False), sa.Column('client_def', sa.String(200), nullable=False), sa.Column('role_id', sa.Integer(), sa.ForeignKey('rbac_role.id', ondelete='CASCADE'), nullable=False), sa.Column('cluster_id', sa.Integer(), sa.ForeignKey('cluster.id', ondelete='CASCADE'), nullable=False), ) op.create_unique_constraint( 'rbac_client_role_client_def_role_id_cluster_id_key', model.RBACClientRole.__tablename__,\ ['client_def', 'role_id', 'cluster_id'] ) op.execute(CreateSequence(sa.Sequence('rbac_perm_seq'))) op.create_table( model.RBACPermission.__tablename__, sa.Column('id', sa.Integer(), sa.Sequence('rbac_cli_rol_seq'), primary_key=True), sa.Column('name', sa.String(200), nullable=False), sa.Column('cluster_id', sa.Integer(), sa.ForeignKey('cluster.id', ondelete='CASCADE'), nullable=False), ) op.create_unique_constraint('rbac_perm_name_cluster_id_key', model.RBACPermission.__tablename__, ['name', 'cluster_id']) op.execute(CreateSequence(sa.Sequence('rbac_role_perm_seq'))) op.create_table( model.RBACRolePermission.__tablename__, sa.Column('id', sa.Integer(), sa.Sequence('rbac_cli_rol_seq'), primary_key=True), sa.Column('role_id', sa.Integer(), sa.ForeignKey('rbac_role.id', ondelete='CASCADE'), nullable=False), sa.Column('perm_id', sa.Integer(), sa.ForeignKey('rbac_perm.id', ondelete='CASCADE'), nullable=False), sa.Column('service_id', sa.Integer(), sa.ForeignKey('service.id', ondelete='CASCADE'), nullable=False), sa.Column('cluster_id', sa.Integer(), sa.ForeignKey('cluster.id', ondelete='CASCADE'), nullable=False), ) op.create_unique_constraint( 'rbac_role_perm_role_id_perm_id_service_id_cluster_id_key', model.RBACRolePermission.__tablename__,\ ['role_id', 'perm_id', 'service_id', 'cluster_id'] )