14a181620c
This DRYs up setting up encrypted columns for a model. You just need to specify the column or columns to be encrypted, and the plugin takes care of setting up the column_encryption plugin. Other advantages: * Model.redacted_columns is now an attr_reader, and does not need to check for encrypted columns every time it is called. * Model#before_destroy can look at Model.encrypted_columns (also an attr_reader), so it is simplified as well. Simplify the method while here by using hash key omission, and make sure the constant it uses is frozen.
59 lines
2.6 KiB
Ruby
59 lines
2.6 KiB
Ruby
# frozen_string_literal: true
|
|
|
|
require_relative "../model"
|
|
|
|
class VictoriaMetricsResource < Sequel::Model
|
|
one_to_one :strand, key: :id
|
|
many_to_one :project
|
|
many_to_one :location, key: :location_id
|
|
one_to_many :servers, class: :VictoriaMetricsServer, key: :victoria_metrics_resource_id
|
|
many_to_one :private_subnet
|
|
|
|
plugin ResourceMethods, redacted_columns: [:admin_password, :root_cert_1, :root_cert_2],
|
|
encrypted_columns: [:admin_password, :root_cert_key_1, :root_cert_key_2]
|
|
plugin SemaphoreMethods, :destroy, :reconfigure
|
|
|
|
def hostname
|
|
"#{name}.#{Config.victoria_metrics_host_name}"
|
|
end
|
|
|
|
def root_certs
|
|
[root_cert_1, root_cert_2].join("\n") if root_cert_1 && root_cert_2
|
|
end
|
|
|
|
def set_firewall_rules
|
|
private_subnet.firewalls.first.replace_firewall_rules([
|
|
{cidr: "0.0.0.0/0", port_range: Sequel.pg_range(22..22)},
|
|
{cidr: "::/0", port_range: Sequel.pg_range(22..22)},
|
|
{cidr: "0.0.0.0/0", port_range: Sequel.pg_range(8427..8427)},
|
|
{cidr: "::/0", port_range: Sequel.pg_range(8427..8427)}
|
|
])
|
|
end
|
|
end
|
|
|
|
# Table: victoria_metrics_resource
|
|
# Columns:
|
|
# id | uuid | PRIMARY KEY
|
|
# name | text | NOT NULL
|
|
# created_at | timestamp with time zone | NOT NULL DEFAULT now()
|
|
# admin_user | text | NOT NULL
|
|
# admin_password | text | NOT NULL
|
|
# target_vm_size | text | NOT NULL
|
|
# target_storage_size_gib | bigint | NOT NULL
|
|
# root_cert_1 | text |
|
|
# root_cert_key_1 | text |
|
|
# root_cert_2 | text |
|
|
# root_cert_key_2 | text |
|
|
# certificate_last_checked_at | timestamp with time zone | NOT NULL DEFAULT now()
|
|
# project_id | uuid | NOT NULL
|
|
# location_id | uuid | NOT NULL
|
|
# private_subnet_id | uuid |
|
|
# Indexes:
|
|
# victoria_metrics_resource_pkey | PRIMARY KEY btree (id)
|
|
# Foreign key constraints:
|
|
# victoria_metrics_resource_location_id_fkey | (location_id) REFERENCES location(id)
|
|
# victoria_metrics_resource_private_subnet_id_fkey | (private_subnet_id) REFERENCES private_subnet(id)
|
|
# victoria_metrics_resource_project_id_fkey | (project_id) REFERENCES project(id)
|
|
# Referenced By:
|
|
# victoria_metrics_server | victoria_metrics_server_victoria_metrics_resource_id_fkey | (victoria_metrics_resource_id) REFERENCES victoria_metrics_resource(id)
|