provider "aws" {
  region = var.aws_region
}

# Terraform backends cannot contain interpolations
terraform {
  backend "s3" {
    bucket  = "dev-orcd-terraform-state"
    key     = "dev/kafka-infra/jdbc-source/snowflake-example/terraform.tfstate"
    region  = "us-east-1"
    encrypt = "true"
  }
}

data "aws_caller_identity" "current" {}

module "kafka_jdbc_source_snowflake_example_fargate_environment" {
  source = "git@github.com:theorchard/terraform-fargate.git//?ref=4.0.0"

  environment                       = var.environment
  service_name                      = var.service_name
  non_ecr_image                     = "103233932089.dkr.ecr.us-east-1.amazonaws.com/kafka-connect-jdbc-source:latest"
  application_family                = "kafka-data-highway"
  aws_region                        = var.aws_region
  service_platform_version          = "1.4.0"
  desired_task_count                = 0
  minimum_capacity                  = 0
  maximum_capacity                  = 0
  task_cpu                          = 1024
  task_memory                       = 2048
  container_port                    = 8083
  health_check_grace_period_seconds = 180
  blocking_waf_enabled              = true
  health_check_path                 = "/connectors/${var.connector_name}"
  web_service_health_check_command  = "[ \"$(curl -s -f http://localhost:8083/connectors/${var.connector_name}/tasks/0/status | jq -r .state)\" == 'RUNNING' ] || exit 1"
  vpc_id                            = "vpc-34dbfd51"

  environment_variables = [
    {
      Environment = var.environment
    },
    {
      SERVICE_NAME = var.service_name
    },
    {
      CONNECT_BOOTSTRAP_SERVERS = var.connect_bootstrap_servers
    },
    {
      QUERY = "select ID, object_construct( 'id', id, 'last_modified_at', last_modified_at, 'nestedField', object_construct( 'upc', upc ) ) as RECORD, LAST_MODIFIED_AT from dev_engineering.ssavva.orchard_product"
    },
    {
      QUOTE_SQL_IDENTIFIERS = "never"
    },
    {
      MODE = "timestamp"
    },
    {
      TIMESTAMP_COLUMN_NAME = "LAST_MODIFIED_AT"
    },
    {
      TIMESTAMP_INITIAL = "-1"
    },
    {
      TOPIC_PREFIX = "jdbc_source_snowflake_example"
    },
    {
      POLL_INTERVAL_MS = "3000"
    },
    {
      BATCH_MAX_ROWS = "1000"
    },
    {
      SNOWFLAKE_CONFIGURATION = "true"
    },
    {
      SNOWFLAKE_SUBDOMAIN = "orchard"
    },
    {
      SNOWFLAKE_WAREHOUSE = "DEV_OWS_WAREHOUSE"
    },
    {
      SNOWFLAKE_DATABASE = "dev_engineering"
    },
    {
      SNOWFLAKE_ROLE = "DEV_ENGINEERING"
    },
    {
      SNOWFLAKE_SCHEMA = "ssavva"
    },
    {
      SNOWFLAKE_USER = "ssavva"
    },
    {
      SNOWFLAKE_PRIVATE_KEY_FILENAME = "rsa_key.p8"
    },
    {
      EXTRACT_NESTED_OBJECT = "true"
    },
    {
      FIELD_NAME_FOR_KEY = "ID"
    },
    {
      FIELD_NAME_FOR_VALUE = "RECORD"
    },
    {
      VALIDATE_NON_NULL = "false"
    },
    {
      DEBUG_MODE = "true"
    },
    {
      AWS_SECRETS_MANAGER = "true"
    }
  ]
  secrets = [
    {
      SNOWFLAKE_PRIVATE_KEY_SECRET = "${var.environment}/${var.service_name}/SNOWFLAKE_PRIVATE_KEY"
    }
  ]
}

# This rule will allow kafka-connect tasks to communicate with each other in distributed mode
resource "aws_security_group_rule" "allow_intra_cluster_communication" {
  from_port         = 8083
  to_port           = 8083
  protocol          = "tcp"
  security_group_id = module.kafka_jdbc_source_snowflake_example_fargate_environment.fargate_security_group_id
  self              = true
  type              = "ingress"
}