### snowflake cursor doesn't support string sseparation, thus this var is adjusted

sf_check_1 = """select count(*) "count", 'src; SF main'  \
from "DELPHI_EXPLORATION"."MAIN"."TIKTOK_TRENDS_DAILY"  \
where REPORT_LICENSOR  = 'sme'   \
union \
select count(*) "count", 'dest; SF raw'  \
from "DELPHI_CHARTS_RAW"."CHARTS_TIKTOK"."TIKTOK_TRENDS_DAILY";"""

sf_check_2 = """select count(distinct territory) * 8 + 8 + 4  "count", 'src; SF raw' \
from "DELPHI_CHARTS_RAW"."CHARTS_TIKTOK"."TIKTOK_TRENDS_DAILY"  \
union  \
select count(*) "count", 'dest; SF main' \
from "DELPHI_CHARTS_MAIN"."CHARTS_TIKTOK"."DIM_TIKTOK_TOP_CHART";"""

sf_check_3 = """select count(distinct PLATFORM_SONG_ID, ISRC) "count", 'src; SF raw' \
from "DELPHI_CHARTS_RAW"."CHARTS_TIKTOK"."TIKTOK_TRENDS_DAILY" \
where isrc is not null \
union \
select count(*) "count", 'dest; SF main' \
from "DELPHI_CHARTS_MAIN"."CHARTS_TIKTOK"."DIM_TIKTOK_TOP_SONG";"""

sf_check_4 = """select count(*) "count", 'src; SF main' \
from "DELPHI_CHARTS_MAIN"."CHARTS_TIKTOK"."FACT_TIKTOK_TOP_CHART_POSITION" \
union \
select count(*) "count", 'dest; SF main' \
from "DELPHI_CHARTS_MAIN"."CHARTS_TIKTOK"."FACT_TIKTOK_TOP_CHART_ISRC";"""

sf_check_5 = """select count(*) "count", 'src; SF main'    from (( \
select distinct tiktok_chart_id , chart_entity \
from "DELPHI_CHARTS_MAIN"."CHARTS_TIKTOK"."FACT_TIKTOK_TOP_CHART_ISRC"  \
minus  \
select distinct tiktok_chart_id , chart_entity \
from "DELPHI_CHARTS_MAIN"."CHARTS_TIKTOK"."FACT_TIKTOK_TOP_CHART_ISRC_LIFETIME" ) \
union ( \
select distinct tiktok_chart_id, isrc \
from "DELPHI_CHARTS_MAIN"."CHARTS_TIKTOK"."FACT_TIKTOK_TOP_CHART_ISRC"  \
minus  \
select distinct tiktok_chart_id, isrc \
from "DELPHI_CHARTS_MAIN"."CHARTS_TIKTOK"."FACT_TIKTOK_TOP_CHART_ISRC_LIFETIME" ) )  \
union  \
select 0 "count" , 'expected; SF main'; """

sf_check_6 = """select count(*) "count", 'src; SF main'  \
from "DELPHI_CHARTS_MAIN"."CHARTS_TIKTOK"."DIM_TIKTOK_TOP_CHART" \
union \
select count(*) "count", 'dest; SF etl'  \
from "DELPHI_CHARTS_ETL"."CHARTS_TIKTOK"."DIM_TIKTOK_TOP_CHART";"""

sf_check_7 = """select count(*) "count", 'src; SF main'  \
from "DELPHI_CHARTS_MAIN"."CHARTS_TIKTOK"."FACT_TIKTOK_TOP_CHART_ISRC" \
union \
select count(*) "count", 'dest; SF etl'  \
from "DELPHI_CHARTS_ETL"."CHARTS_TIKTOK"."FACT_TIKTOK_TOP_CHART_ISRC";"""

sf_check_8 = """select count(distinct tiktok_chart_id , chart_entity) "count",  'src; SF main'  \
from "DELPHI_CHARTS_MAIN"."CHARTS_TIKTOK"."FACT_TIKTOK_TOP_CHART_ISRC_LIFETIME"  \
union \
select count(distinct tiktok_chart_id , chart_entity) "count", 'dest; SF etl'  \
from "DELPHI_CHARTS_ETL"."CHARTS_TIKTOK"."FACT_TIKTOK_TOP_CHART_ISRC_LIFETIME";"""

sf_check_9 = """select count(*) "count", 'src; SF main'  \
from "DELPHI_CHARTS_MAIN"."CHARTS_TIKTOK"."DIM_TIKTOK_TOP_SONG" \
union \
select count(*) "count", 'dest; SF etl'  \
from "DELPHI_CHARTS_ETL"."CHARTS_TIKTOK"."DIM_TIKTOK_TOP_SONG";"""

sf_check_11 = """select count(*) "count" \
from "DELPHI_CHARTS_ETL"."CHARTS_TIKTOK"."DIM_TIKTOK_TOP_CHART"; """
pg_check_11 = """select count(*) "count" from tiktok.dim_tiktok_top_chart; """

sf_check_12 = """select count(*) "count" \
from "DELPHI_CHARTS_ETL"."CHARTS_TIKTOK"."DIM_TIKTOK_TOP_SONG" \
where ISRC in ( \
  select ISRC \
  from "DELPHI_CHARTS_ETL"."CHARTS_TIKTOK"."FACT_TIKTOK_TOP_CHART_ISRC" \
  union \
  select ISRC \
  from "DELPHI_CHARTS_ETL"."CHARTS_TIKTOK"."FACT_TIKTOK_TOP_CHART_ISRC_LIFETIME"); """
pg_check_12 = """select count(*) "count" from tiktok.dim_tiktok_top_song; """

sf_check_13 = """select count(*) "count" \
from "DELPHI_CHARTS_ETL"."CHARTS_TIKTOK"."FACT_TIKTOK_TOP_CHART_ISRC";"""
pg_check_13 = """select count(*) "count" from tiktok.fact_tiktok_top_chart_isrc;"""

sf_check_14 = """select count(distinct tiktok_chart_id,isrc ) "count" \
from "DELPHI_CHARTS_ETL"."CHARTS_TIKTOK"."FACT_TIKTOK_TOP_CHART_ISRC_LIFETIME";"""
pg_check_14 = """select count(*) "count" from tiktok.fact_tiktok_top_chart_track_lifetime; """

if __name__ == '__main__':
    pass