faraday/migrations/versions/be89aa03e35e_add_severities_column_to_executive_.py - python-faraday (62d1b14)

Tree @62d1b14 (Download .tar.gz)

..
.gitignore
077b7c925ded_add_last_run_to_executors.py
085188e0a016_create_rules_tables.py
08d02214aedc_add_advanced_filter_to_executive_report_table.py
0d216660da28_add_notification_table.py
1574fbcf72f5_disable_several_notifications_and_add_event_enabled_flag.py
15d70093d262_severities_histogram_model.py
18891ca61db6_add_cascade_delete_from_workspace.py
1b2533cc16fe_fix_custom_fields_display_name_was_used_.py
1dbe9e8e4247_add_rule_execution_start_and_end_fields.py
20f3d0c2f71f_alter_table_executive_report_add_.py
247a90b029f2_fix_severities_ordering.py
282ac9b6569f_add_agent_as_import_source_to_command.py
2a0de6132377_add_searchfilter_table.py
2ca03a8feef5_workspace_readonly.py
2db31733fb78_unique_field_name_in_customfield.py
38bb251889e6_bulks.py
3f771124f0a2_add_metadata_to_cf_schema.py
526aa91cac98_vulnerability_merge_model.py
5272b3f5a820_add_markdown_column_to_exectuive_reports.py
5658775e113f_add_command_id_to_agent_execution.py
59bed5515407_vuln_external_id.py
5cf9660bba80_policyviolationvulnerabilityassociation_.py
5d7a930c439e_cve_many_to_many.py
6471033046cb_added_delete_on_cascade_to_schedule.py
7dea3a6caf51_cascade_in_vuls_relation.py
84f266a05be3_add_tool_column_to_vuln.py
89115e133f0a_add_hosts_notifications.py
8a10ff3926a5_2fa_columns.py
904a517a2f0c_create_executor_table.py
97a9348d0406_add_fields_to_report.py
9c4091d1a09b_create_agent_table.py
9c678c44aa61_add_enabled_field_to_rule.py
a39a3a6e3f99_create_user_preferences_column.py
a4def820a5bb_alter_otp_secret_length_in_user.py
a9fcf8444c79_add_notification_event_and_subscription_.py
aa56852fa76d_update_rule_fields.py
b1d15a55556d_remove_ticketing_tools_credentials.py
b49d8efbd0c2_add_configuration_table.py
be89aa03e35e_add_severities_column_to_executive_.py
d3afdb4e0b11_add_enum_to_comment_model.py
d8f0b32a5c0e_cvss_model.py
e03a13c41a67_check_important_host.py
e61afb450465_add_custom_fields.py
ed403da439d4_agents_with_multiple_workspaces.py
f00247a92a14_add_agent_execution_data.py
f0439bf6688a_updating_to_a_role_model_to_use_faraday_.py
f0a507afabd4_adding_fs_uniquifier_to_user_model.py
f28eae25416b_fix_constraint_in_cve_association.py
f8a44acd0e41_add_new_user_role.py
fa12b8322112_update_workflow_modules.py

be89aa03e35e_add_severities_column_to_executive_.py @62d1b14 — raw · history · blame

"""Add severities column to executive reports

Revision ID: be89aa03e35e
Revises: 0d216660da28
Create Date: 2019-05-14 18:12:52.724079+00:00

"""

from alembic import op


# revision identifiers, used by Alembic.
revision = 'be89aa03e35e'
down_revision = '59bed5515407'
branch_labels = None
depends_on = None


def upgrade():
    conn = op.get_bind()
    conn.execute('ALTER TABLE executive_report ADD COLUMN filter JSONB')


def downgrade():
    conn = op.get_bind()
    conn.execute('ALTER TABLE executive_report DROP COLUMN filter')