#!/bin/bash -x

# Uncomment to use these variables or export custom variables.
#export ORCD_AWS_PROD=437795906767
#export SME_CATALOG_ID="250735107403"
#export SME_DATABASE="youtube_api_db"

declare -a data_team=(
    "aadamu"
    "amccown"
    "aoshomoji"
    "buvarov"
    "cbeesley"
    "cvallecilla"
    "efedorov"
    "etaranenko"
    "fasadullayev"
    "fumar"
    "iburilo"
    "mmurha"
    "oefanova"
    "oshainoha"
    "rpashchenko"
    "rroy"
    "rtorres"
    "ssavva"
    "rshield"
    "prod-swf-feed-ingestion"
    "prod-swf-feed-ingestion-youtube-video-user"
    "qa-swf-youtube-claim-user"
    "prod-swf-youtube-claim-user"
    )

declare -a youtube_api_db=(
    '"content_owner_asset_a2"'
    '"content_owner_ad_revenue_summary_a1"'
    '"content_owner_asset_cards_a1"'
    '"content_owner_asset_a2"'
    '"content_owner_ad_revenue_summary_a1"'
    '"content_owner_asset_cards_a1"'
    '"content_owner_demographics_a1"'
    '"content_owner_device_os_a2"'
    '"content_owner_claim_audio_tier_revenue_summary_a1"'
    '"content_owner_asset_playback_location_a2"'
    '"content_owner_asset_estimated_revenue_a1"'
    '"content_owner_video_metadata_a2"'
    '"content_owner_asset_conflict_a2"'
    '"content_owner_asset_demographics_a1"'
    '"content_owner_claim_audio_tier_revenue_raw_a1"'
    '"content_owner_asset_device_os_a2"'
    '"content_owner_asset_traffic_source_a2"'
    '"content_owner_basic_a3"'
    '"content_owner_sharing_service_a1"'
    '"content_owner_asset_province_a2"'
    '"content_owner_asset_ad_revenue_raw_a1"'
    '"content_owner_playlist_device_os_a1"'
    '"content_owner_asset_end_screens_a1"'
    '"content_owner_combined_a2"'
    '"content_owner_playlist_province_a1"'
    '"content_owner_playlist_basic_a1"'
    '"content_owner_asset_sharing_service_a1"'
    '"content_owner_playlist_combined_a1"'
    '"content_owner_claim_ad_revenue_summary_a1"'
    '"content_owner_province_a2"'
    '"content_owner_cards_a1"'
    '"content_owner_estimated_revenue_a1"'
    '"content_owner_active_claims_a1"'
    '"content_owner_active_claims_a2"'
    '"content_owner_asset_annotations_a1"'
    '"content_owner_asset_combined_a2"'
    '"content_owner_subtitles_a2"'
    '"content_owner_end_screens_a1"'
    '"content_owner_asset_ad_revenue_summary_a1"'
    '"content_owner_active_references_a1"'
    '"content_owner_playlist_traffic_source_a1"'
    '"content_owner_playback_location_a2"'
    '"content_owner_traffic_source_a2"'
    '"content_owner_annotations_a1"'
    '"content_owner_ad_rates_a1"'
    '"content_owner_playlist_playback_location_a1"'
    '"content_owner_asset_basic_a2"'
    )

for iam_users in "${!data_team[@]}"
    do
      for tables in "${!youtube_api_db[@]}"
        do
          /usr/local/bin/aws lakeformation grant-permissions --principal DataLakePrincipalIdentifier=arn:aws:iam::$ORCD_AWS_PROD:user/${data_team[iam_users]} --permissions "SELECT" --resource '{ "Table": {"CatalogId":"'$SME_CATALOG_ID'", "DatabaseName":"'$SME_DATABASE'", "Name":'${youtube_api_db[tables]}'}}'
    done
done