import datetime
import factory
from collections import namedtuple
from factory import fuzzy

from apollo_main_db.apollo.models import BuzzCategory, BuzzUser
from apollo_main_db.spotify import models
from src.db.base import session


Track = namedtuple("Track", ["name", "url", "artist_name", "uri", "isrc"])


class SpotifyTrackAlbumFactory(factory.alchemy.SQLAlchemyModelFactory):
    track_id = fuzzy.FuzzyText(length=50)
    album_id = fuzzy.FuzzyText(length=50)

    class Meta:
        model = models.SpotifyTrackAlbum
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyTrackArtistFactory(factory.alchemy.SQLAlchemyModelFactory):
    track_id = fuzzy.FuzzyText(length=50)
    artist_id = fuzzy.FuzzyText(length=50)
    order = factory.Faker("pyint")

    class Meta:
        model = models.SpotifyTrackArtist
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyArtistFactory(factory.alchemy.SQLAlchemyModelFactory):
    id = fuzzy.FuzzyText(length=50)
    name = fuzzy.FuzzyText(length=50)

    class Meta:
        model = models.SpotifyArtist
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyTrack2Factory(factory.alchemy.SQLAlchemyModelFactory):
    id = fuzzy.FuzzyText(length=50)
    name = fuzzy.FuzzyText(length=100)
    isrc = fuzzy.FuzzyText(length=12)

    class Meta:
        model = models.SpotifyTrack2
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyPlaylistFactory(factory.alchemy.SQLAlchemyModelFactory):
    uri = fuzzy.FuzzyText(length=50)
    id = fuzzy.FuzzyText(length=22)
    name = fuzzy.FuzzyText(length=10)
    removed = factory.LazyAttribute(lambda _: 0)
    image = fuzzy.FuzzyText(length=5)
    country_code = fuzzy.FuzzyText(length=4)
    user_name = fuzzy.FuzzyText(length=12)
    buzz_category_id = 1
    track_count = fuzzy.FuzzyInteger(1, 999)

    class Meta:
        model = models.SpotifyPlaylist
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyPlaylistTrackList2Factory(factory.alchemy.SQLAlchemyModelFactory):
    playlist_id = fuzzy.FuzzyText(length=50)
    track_id = fuzzy.FuzzyText(length=100)
    playlist_index = factory.Faker("pyint")
    added_datetime = factory.Faker("date")
    added_earliest_datetime = factory.Faker("date")

    class Meta:
        model = models.SpotifyPlaylistTrackList2
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyPlaylistStreamSummaryFactory(factory.alchemy.SQLAlchemyModelFactory):
    playlist_id = fuzzy.FuzzyText(length=50)
    market = fuzzy.FuzzyText(length=2)
    streams_7_days = factory.Faker("pyint")

    class Meta:
        model = models.SpotifyPlaylistStreamSummary
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyPlaylistTrackListHistory2Factory(factory.alchemy.SQLAlchemyModelFactory):
    playlist_id = fuzzy.FuzzyText(length=50)
    playlist_index = factory.Faker("pyint")
    track_id = fuzzy.FuzzyText(length=50)
    date = factory.Faker("date")

    class Meta:
        model = models.SpotifyPlaylistTrackListHistory2
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyTrackPlaylistLastWeekHistoryFactory(factory.alchemy.SQLAlchemyModelFactory):
    date = factory.Faker("date")
    isrc = fuzzy.FuzzyText(length=12)
    playlist_id = fuzzy.FuzzyText(length=22)

    class Meta:
        model = models.SpotifyTrackPlaylistLastWeekHistory
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyPlaylistTrackListHistoryDates2Factory(factory.alchemy.SQLAlchemyModelFactory):
    playlist_id = fuzzy.FuzzyText(length=50)
    date = factory.Faker("date")
    timestamp = factory.LazyFunction(datetime.datetime.now)

    class Meta:
        model = models.SpotifyPlaylistTrackListHistoryDates2
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyPersonalizedPlaylistFactory(factory.alchemy.SQLAlchemyModelFactory):
    playlist_id = fuzzy.FuzzyText(length=22)

    class Meta:
        model = models.SpotifyPersonalizedPlaylist
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyViewPlaylistFactory(factory.alchemy.SQLAlchemyModelFactory):
    type = fuzzy.FuzzyChoice(
        (models.ViewPlaylistTypeEnum.HH, models.ViewPlaylistTypeEnum.NMF, models.ViewPlaylistTypeEnum.GTP)
    )
    playlist_id = fuzzy.FuzzyText(length=22)
    market_code = fuzzy.FuzzyText(length=10)
    category_id = fuzzy.FuzzyInteger(1, 5)
    last_date = factory.Faker("date")
    last_added_ts = factory.LazyFunction(datetime.datetime.now)

    class Meta:
        model = models.SpotifyViewPlaylist
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyMarketRankFactory(factory.alchemy.SQLAlchemyModelFactory):
    type = fuzzy.FuzzyChoice(
        (models.MarketRankTypeEnum.HH, models.MarketRankTypeEnum.NMF, models.MarketRankTypeEnum.GENERAL)
    )
    market_code = fuzzy.FuzzyText(length=10)
    rank = fuzzy.FuzzyInteger(1, 100)

    class Meta:
        model = models.SpotifyMarketRank
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyHotHitsPlaylistTrackSummaryFactory(factory.alchemy.SQLAlchemyModelFactory):
    id = fuzzy.FuzzyInteger(1, 9999)
    isrc = fuzzy.FuzzyText(length=15)
    playlist_id = fuzzy.FuzzyText(length=22)
    entry_date = factory.Faker("date")
    exit_date = factory.Faker("date")

    class Meta:
        model = models.SpotifyHotHitsPlaylistTrackSummary
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyHotHitsPlaylistTrackStatsFactory(factory.alchemy.SQLAlchemyModelFactory):
    id = fuzzy.FuzzyInteger(1, 99999)
    isrc = fuzzy.FuzzyText(length=15)
    playlist_id = fuzzy.FuzzyText(length=22)
    entry_date = factory.Faker("date")
    latest_date = factory.Faker("date")
    latest_position = fuzzy.FuzzyInteger(1, 999)
    previous_date = factory.Faker("date")
    previous_position = fuzzy.FuzzyInteger(1, 999)
    peak_position = fuzzy.FuzzyInteger(1, 999)
    peak_date = factory.Faker("date")
    added_date = factory.Faker("date")
    in_history = 1

    class Meta:
        model = models.SpotifyHotHitsPlaylistTrackStats
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyNewMusicFridayDateFactory(factory.alchemy.SQLAlchemyModelFactory):
    id = fuzzy.FuzzyInteger(1, 9999)
    date = factory.Faker("date")

    class Meta:
        model = models.SpotifyNewMusicFridayDate
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyNewMusicFridayPlaylistTrackHistoryFactory(factory.alchemy.SQLAlchemyModelFactory):
    date_id = fuzzy.FuzzyInteger(1, 9999)
    playlist_id = fuzzy.FuzzyText(length=22)
    playlist_index = fuzzy.FuzzyInteger(1, 9999)
    track_id = fuzzy.FuzzyText(length=22)
    added = factory.LazyFunction(datetime.datetime.now)
    isrc = fuzzy.FuzzyText(length=15)

    class Meta:
        model = models.SpotifyNewMusicFridayPlaylistTrackHistory
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyAlbumFactory(factory.alchemy.SQLAlchemyModelFactory):
    id = fuzzy.FuzzyText(length=50)
    name = fuzzy.FuzzyText(length=200)
    type = fuzzy.FuzzyText(length=45)
    popularity = fuzzy.FuzzyInteger(1, 9999)
    copyright = fuzzy.FuzzyText(length=200)
    label = fuzzy.FuzzyText(length=100)
    upc = fuzzy.FuzzyText(length=100)
    release_date = fuzzy.FuzzyText(length=20)
    release_date_precision = fuzzy.FuzzyInteger(1, 999)
    small_image_filename = fuzzy.FuzzyText(length=45)
    updated = factory.LazyFunction(datetime.datetime.now)

    class Meta:
        model = models.SpotifyAlbum
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyPlaylistFollowersFactory(factory.alchemy.SQLAlchemyModelFactory):
    playlist_uri = fuzzy.FuzzyText(length=100)
    playlist_id = fuzzy.FuzzyText(length=22)
    followers = fuzzy.FuzzyInteger(0, 999999)
    followers_1_day = fuzzy.FuzzyInteger(0, 999999)
    followers_7_days = fuzzy.FuzzyInteger(0, 999999)
    followers_14_days = fuzzy.FuzzyInteger(0, 999999)
    followers_28_days = fuzzy.FuzzyInteger(0, 999999)
    followers_56_days = fuzzy.FuzzyInteger(0, 999999)
    update_date = factory.Faker("date")

    class Meta:
        model = models.SpotifyPlaylistFollowers
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyPlaylistLegacyUriFactory(factory.alchemy.SQLAlchemyModelFactory):
    playlist_uri = fuzzy.FuzzyText(length=100)
    playlist_id = fuzzy.FuzzyText(length=22)

    class Meta:
        model = models.SpotifyPlaylistLegacyUri
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyAnalyticsPlaylistStreamInfoFactory(factory.alchemy.SQLAlchemyModelFactory):
    account = 1
    playlist_uri = fuzzy.FuzzyText(length=100)
    market = fuzzy.FuzzyText(length=5)
    date = factory.Faker("date")
    total_streams = fuzzy.FuzzyInteger(1, 99999)
    listeners = fuzzy.FuzzyInteger(1, 99999)

    class Meta:
        model = models.SpotifyAnalyticsPlaylistStreamInfo
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class BuzzCategoryFactory(factory.alchemy.SQLAlchemyModelFactory):
    id = fuzzy.FuzzyInteger(1, 12)
    name = fuzzy.FuzzyText(length=100)

    class Meta:
        model = BuzzCategory
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class BuzzUserFactory(factory.alchemy.SQLAlchemyModelFactory):
    id = fuzzy.FuzzyInteger(1, 12)
    user_name = fuzzy.FuzzyText(length=45)
    display_name = fuzzy.FuzzyText(length=255)
    category_id = fuzzy.FuzzyInteger(1, 9999999)
    country_code = fuzzy.FuzzyText(length=100)
    service_type = fuzzy.FuzzyInteger(1, 9999999)
    music_service = fuzzy.FuzzyInteger(1, 9999999)
    created_at = factory.Faker("date")

    class Meta:
        model = BuzzUser
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyPlaylistDigestStreamsPlaylistFactory(factory.alchemy.SQLAlchemyModelFactory):
    playlist_id = fuzzy.FuzzyText(length=22)
    category_id = fuzzy.FuzzyInteger(1, 3)
    country_code = fuzzy.FuzzyText(length=10)

    class Meta:
        model = models.SpotifyPlaylistDigestStreamsPlaylist
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyPlaylistDigestFollowersPlaylistFactory(factory.alchemy.SQLAlchemyModelFactory):
    playlist_id = fuzzy.FuzzyText(length=22)
    category_id = fuzzy.FuzzyInteger(1, 3)
    country_code = fuzzy.FuzzyText(length=10)

    class Meta:
        model = models.SpotifyPlaylistDigestFollowersPlaylist
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyPlaylistStreamsWeekHistoryFactory(factory.alchemy.SQLAlchemyModelFactory):
    date = factory.Faker("date")
    playlist_id = fuzzy.FuzzyText(length=22)
    value = fuzzy.FuzzyInteger(0, 999999)
    value_ad = fuzzy.FuzzyInteger(0, 999999)
    value_ae = fuzzy.FuzzyInteger(0, 999999)
    value_ag = fuzzy.FuzzyInteger(0, 999999)
    value_al = fuzzy.FuzzyInteger(0, 999999)
    value_am = fuzzy.FuzzyInteger(0, 999999)
    value_ao = fuzzy.FuzzyInteger(0, 999999)
    value_ar = fuzzy.FuzzyInteger(0, 999999)
    value_at = fuzzy.FuzzyInteger(0, 999999)
    value_au = fuzzy.FuzzyInteger(0, 999999)
    value_az = fuzzy.FuzzyInteger(0, 999999)
    value_ba = fuzzy.FuzzyInteger(0, 999999)
    value_bb = fuzzy.FuzzyInteger(0, 999999)
    value_bd = fuzzy.FuzzyInteger(0, 999999)
    value_be = fuzzy.FuzzyInteger(0, 999999)
    value_bf = fuzzy.FuzzyInteger(0, 999999)
    value_bg = fuzzy.FuzzyInteger(0, 999999)
    value_bh = fuzzy.FuzzyInteger(0, 999999)
    value_bi = fuzzy.FuzzyInteger(0, 999999)
    value_bj = fuzzy.FuzzyInteger(0, 999999)
    value_bn = fuzzy.FuzzyInteger(0, 999999)
    value_bo = fuzzy.FuzzyInteger(0, 999999)
    value_br = fuzzy.FuzzyInteger(0, 999999)
    value_bs = fuzzy.FuzzyInteger(0, 999999)
    value_bt = fuzzy.FuzzyInteger(0, 999999)
    value_bw = fuzzy.FuzzyInteger(0, 999999)
    value_by = fuzzy.FuzzyInteger(0, 999999)
    value_bz = fuzzy.FuzzyInteger(0, 999999)
    value_ca = fuzzy.FuzzyInteger(0, 999999)
    value_cd = fuzzy.FuzzyInteger(0, 999999)
    value_cg = fuzzy.FuzzyInteger(0, 999999)
    value_ch = fuzzy.FuzzyInteger(0, 999999)
    value_ci = fuzzy.FuzzyInteger(0, 999999)
    value_cl = fuzzy.FuzzyInteger(0, 999999)
    value_cm = fuzzy.FuzzyInteger(0, 999999)
    value_co = fuzzy.FuzzyInteger(0, 999999)
    value_cr = fuzzy.FuzzyInteger(0, 999999)
    value_cv = fuzzy.FuzzyInteger(0, 999999)
    value_cw = fuzzy.FuzzyInteger(0, 999999)
    value_cy = fuzzy.FuzzyInteger(0, 999999)
    value_cz = fuzzy.FuzzyInteger(0, 999999)
    value_de = fuzzy.FuzzyInteger(0, 999999)
    value_dj = fuzzy.FuzzyInteger(0, 999999)
    value_dk = fuzzy.FuzzyInteger(0, 999999)
    value_dm = fuzzy.FuzzyInteger(0, 999999)
    value_do = fuzzy.FuzzyInteger(0, 999999)
    value_dz = fuzzy.FuzzyInteger(0, 999999)
    value_ec = fuzzy.FuzzyInteger(0, 999999)
    value_ee = fuzzy.FuzzyInteger(0, 999999)
    value_eg = fuzzy.FuzzyInteger(0, 999999)
    value_es = fuzzy.FuzzyInteger(0, 999999)
    value_et = fuzzy.FuzzyInteger(0, 999999)
    value_fi = fuzzy.FuzzyInteger(0, 999999)
    value_fj = fuzzy.FuzzyInteger(0, 999999)
    value_fm = fuzzy.FuzzyInteger(0, 999999)
    value_fr = fuzzy.FuzzyInteger(0, 999999)
    value_ga = fuzzy.FuzzyInteger(0, 999999)
    value_gb = fuzzy.FuzzyInteger(0, 999999)
    value_gd = fuzzy.FuzzyInteger(0, 999999)
    value_ge = fuzzy.FuzzyInteger(0, 999999)
    value_gh = fuzzy.FuzzyInteger(0, 999999)
    value_gm = fuzzy.FuzzyInteger(0, 999999)
    value_gn = fuzzy.FuzzyInteger(0, 999999)
    value_gq = fuzzy.FuzzyInteger(0, 999999)
    value_gr = fuzzy.FuzzyInteger(0, 999999)
    value_gt = fuzzy.FuzzyInteger(0, 999999)
    value_gw = fuzzy.FuzzyInteger(0, 999999)
    value_gy = fuzzy.FuzzyInteger(0, 999999)
    value_hk = fuzzy.FuzzyInteger(0, 999999)
    value_hn = fuzzy.FuzzyInteger(0, 999999)
    value_hr = fuzzy.FuzzyInteger(0, 999999)
    value_ht = fuzzy.FuzzyInteger(0, 999999)
    value_hu = fuzzy.FuzzyInteger(0, 999999)
    value_id = fuzzy.FuzzyInteger(0, 999999)
    value_ie = fuzzy.FuzzyInteger(0, 999999)
    value_il = fuzzy.FuzzyInteger(0, 999999)
    value_in = fuzzy.FuzzyInteger(0, 999999)
    value_iq = fuzzy.FuzzyInteger(0, 999999)
    value_is = fuzzy.FuzzyInteger(0, 999999)
    value_it = fuzzy.FuzzyInteger(0, 999999)
    value_jm = fuzzy.FuzzyInteger(0, 999999)
    value_jo = fuzzy.FuzzyInteger(0, 999999)
    value_jp = fuzzy.FuzzyInteger(0, 999999)
    value_ke = fuzzy.FuzzyInteger(0, 999999)
    value_kg = fuzzy.FuzzyInteger(0, 999999)
    value_kh = fuzzy.FuzzyInteger(0, 999999)
    value_ki = fuzzy.FuzzyInteger(0, 999999)
    value_km = fuzzy.FuzzyInteger(0, 999999)
    value_kn = fuzzy.FuzzyInteger(0, 999999)
    value_kr = fuzzy.FuzzyInteger(0, 999999)
    value_kw = fuzzy.FuzzyInteger(0, 999999)
    value_kz = fuzzy.FuzzyInteger(0, 999999)
    value_la = fuzzy.FuzzyInteger(0, 999999)
    value_lb = fuzzy.FuzzyInteger(0, 999999)
    value_lc = fuzzy.FuzzyInteger(0, 999999)
    value_li = fuzzy.FuzzyInteger(0, 999999)
    value_lk = fuzzy.FuzzyInteger(0, 999999)
    value_lr = fuzzy.FuzzyInteger(0, 999999)
    value_ls = fuzzy.FuzzyInteger(0, 999999)
    value_lt = fuzzy.FuzzyInteger(0, 999999)
    value_lu = fuzzy.FuzzyInteger(0, 999999)
    value_lv = fuzzy.FuzzyInteger(0, 999999)
    value_ly = fuzzy.FuzzyInteger(0, 999999)
    value_ma = fuzzy.FuzzyInteger(0, 999999)
    value_mc = fuzzy.FuzzyInteger(0, 999999)
    value_md = fuzzy.FuzzyInteger(0, 999999)
    value_me = fuzzy.FuzzyInteger(0, 999999)
    value_mg = fuzzy.FuzzyInteger(0, 999999)
    value_mh = fuzzy.FuzzyInteger(0, 999999)
    value_mk = fuzzy.FuzzyInteger(0, 999999)
    value_ml = fuzzy.FuzzyInteger(0, 999999)
    value_mn = fuzzy.FuzzyInteger(0, 999999)
    value_mo = fuzzy.FuzzyInteger(0, 999999)
    value_mr = fuzzy.FuzzyInteger(0, 999999)
    value_mt = fuzzy.FuzzyInteger(0, 999999)
    value_mu = fuzzy.FuzzyInteger(0, 999999)
    value_mv = fuzzy.FuzzyInteger(0, 999999)
    value_mw = fuzzy.FuzzyInteger(0, 999999)
    value_mx = fuzzy.FuzzyInteger(0, 999999)
    value_my = fuzzy.FuzzyInteger(0, 999999)
    value_mz = fuzzy.FuzzyInteger(0, 999999)
    value_na = fuzzy.FuzzyInteger(0, 999999)
    value_ne = fuzzy.FuzzyInteger(0, 999999)
    value_ng = fuzzy.FuzzyInteger(0, 999999)
    value_ni = fuzzy.FuzzyInteger(0, 999999)
    value_nl = fuzzy.FuzzyInteger(0, 999999)
    value_no = fuzzy.FuzzyInteger(0, 999999)
    value_np = fuzzy.FuzzyInteger(0, 999999)
    value_nr = fuzzy.FuzzyInteger(0, 999999)
    value_nz = fuzzy.FuzzyInteger(0, 999999)
    value_om = fuzzy.FuzzyInteger(0, 999999)
    value_pa = fuzzy.FuzzyInteger(0, 999999)
    value_pe = fuzzy.FuzzyInteger(0, 999999)
    value_pg = fuzzy.FuzzyInteger(0, 999999)
    value_ph = fuzzy.FuzzyInteger(0, 999999)
    value_pk = fuzzy.FuzzyInteger(0, 999999)
    value_pl = fuzzy.FuzzyInteger(0, 999999)
    value_ps = fuzzy.FuzzyInteger(0, 999999)
    value_pt = fuzzy.FuzzyInteger(0, 999999)
    value_pw = fuzzy.FuzzyInteger(0, 999999)
    value_py = fuzzy.FuzzyInteger(0, 999999)
    value_qa = fuzzy.FuzzyInteger(0, 999999)
    value_ro = fuzzy.FuzzyInteger(0, 999999)
    value_rs = fuzzy.FuzzyInteger(0, 999999)
    value_ru = fuzzy.FuzzyInteger(0, 999999)
    value_rw = fuzzy.FuzzyInteger(0, 999999)
    value_sa = fuzzy.FuzzyInteger(0, 999999)
    value_sb = fuzzy.FuzzyInteger(0, 999999)
    value_sc = fuzzy.FuzzyInteger(0, 999999)
    value_se = fuzzy.FuzzyInteger(0, 999999)
    value_sg = fuzzy.FuzzyInteger(0, 999999)
    value_si = fuzzy.FuzzyInteger(0, 999999)
    value_sk = fuzzy.FuzzyInteger(0, 999999)
    value_sl = fuzzy.FuzzyInteger(0, 999999)
    value_sm = fuzzy.FuzzyInteger(0, 999999)
    value_sn = fuzzy.FuzzyInteger(0, 999999)
    value_sr = fuzzy.FuzzyInteger(0, 999999)
    value_st = fuzzy.FuzzyInteger(0, 999999)
    value_sv = fuzzy.FuzzyInteger(0, 999999)
    value_sz = fuzzy.FuzzyInteger(0, 999999)
    value_td = fuzzy.FuzzyInteger(0, 999999)
    value_tg = fuzzy.FuzzyInteger(0, 999999)
    value_th = fuzzy.FuzzyInteger(0, 999999)
    value_tj = fuzzy.FuzzyInteger(0, 999999)
    value_tl = fuzzy.FuzzyInteger(0, 999999)
    value_tn = fuzzy.FuzzyInteger(0, 999999)
    value_to = fuzzy.FuzzyInteger(0, 999999)
    value_tr = fuzzy.FuzzyInteger(0, 999999)
    value_tt = fuzzy.FuzzyInteger(0, 999999)
    value_tv = fuzzy.FuzzyInteger(0, 999999)
    value_tw = fuzzy.FuzzyInteger(0, 999999)
    value_tz = fuzzy.FuzzyInteger(0, 999999)
    value_ua = fuzzy.FuzzyInteger(0, 999999)
    value_ug = fuzzy.FuzzyInteger(0, 999999)
    value_us = fuzzy.FuzzyInteger(0, 999999)
    value_uy = fuzzy.FuzzyInteger(0, 999999)
    value_uz = fuzzy.FuzzyInteger(0, 999999)
    value_vc = fuzzy.FuzzyInteger(0, 999999)
    value_ve = fuzzy.FuzzyInteger(0, 999999)
    value_vn = fuzzy.FuzzyInteger(0, 999999)
    value_vu = fuzzy.FuzzyInteger(0, 999999)
    value_ws = fuzzy.FuzzyInteger(0, 999999)
    value_xk = fuzzy.FuzzyInteger(0, 999999)
    value_za = fuzzy.FuzzyInteger(0, 999999)
    value_zm = fuzzy.FuzzyInteger(0, 999999)
    value_zw = fuzzy.FuzzyInteger(0, 999999)
    change = fuzzy.FuzzyInteger(-99999, 99999)
    change_ad = fuzzy.FuzzyInteger(-99999, 99999)
    change_ae = fuzzy.FuzzyInteger(-99999, 99999)
    change_ag = fuzzy.FuzzyInteger(-99999, 99999)
    change_al = fuzzy.FuzzyInteger(-99999, 99999)
    change_am = fuzzy.FuzzyInteger(-99999, 99999)
    change_ao = fuzzy.FuzzyInteger(-99999, 99999)
    change_ar = fuzzy.FuzzyInteger(-99999, 99999)
    change_at = fuzzy.FuzzyInteger(-99999, 99999)
    change_au = fuzzy.FuzzyInteger(-99999, 99999)
    change_az = fuzzy.FuzzyInteger(-99999, 99999)
    change_ba = fuzzy.FuzzyInteger(-99999, 99999)
    change_bb = fuzzy.FuzzyInteger(-99999, 99999)
    change_bd = fuzzy.FuzzyInteger(-99999, 99999)
    change_be = fuzzy.FuzzyInteger(-99999, 99999)
    change_bf = fuzzy.FuzzyInteger(-99999, 99999)
    change_bg = fuzzy.FuzzyInteger(-99999, 99999)
    change_bh = fuzzy.FuzzyInteger(-99999, 99999)
    change_bi = fuzzy.FuzzyInteger(-99999, 99999)
    change_bj = fuzzy.FuzzyInteger(-99999, 99999)
    change_bn = fuzzy.FuzzyInteger(-99999, 99999)
    change_bo = fuzzy.FuzzyInteger(-99999, 99999)
    change_br = fuzzy.FuzzyInteger(-99999, 99999)
    change_bs = fuzzy.FuzzyInteger(-99999, 99999)
    change_bt = fuzzy.FuzzyInteger(-99999, 99999)
    change_bw = fuzzy.FuzzyInteger(-99999, 99999)
    change_by = fuzzy.FuzzyInteger(-99999, 99999)
    change_bz = fuzzy.FuzzyInteger(-99999, 99999)
    change_ca = fuzzy.FuzzyInteger(-99999, 99999)
    change_cd = fuzzy.FuzzyInteger(-99999, 99999)
    change_cg = fuzzy.FuzzyInteger(-99999, 99999)
    change_ch = fuzzy.FuzzyInteger(-99999, 99999)
    change_ci = fuzzy.FuzzyInteger(-99999, 99999)
    change_cl = fuzzy.FuzzyInteger(-99999, 99999)
    change_cm = fuzzy.FuzzyInteger(-99999, 99999)
    change_co = fuzzy.FuzzyInteger(-99999, 99999)
    change_cr = fuzzy.FuzzyInteger(-99999, 99999)
    change_cv = fuzzy.FuzzyInteger(-99999, 99999)
    change_cw = fuzzy.FuzzyInteger(-99999, 99999)
    change_cy = fuzzy.FuzzyInteger(-99999, 99999)
    change_cz = fuzzy.FuzzyInteger(-99999, 99999)
    change_de = fuzzy.FuzzyInteger(-99999, 99999)
    change_dj = fuzzy.FuzzyInteger(-99999, 99999)
    change_dk = fuzzy.FuzzyInteger(-99999, 99999)
    change_dm = fuzzy.FuzzyInteger(-99999, 99999)
    change_do = fuzzy.FuzzyInteger(-99999, 99999)
    change_dz = fuzzy.FuzzyInteger(-99999, 99999)
    change_ec = fuzzy.FuzzyInteger(-99999, 99999)
    change_ee = fuzzy.FuzzyInteger(-99999, 99999)
    change_eg = fuzzy.FuzzyInteger(-99999, 99999)
    change_es = fuzzy.FuzzyInteger(-99999, 99999)
    change_et = fuzzy.FuzzyInteger(-99999, 99999)
    change_fi = fuzzy.FuzzyInteger(-99999, 99999)
    change_fj = fuzzy.FuzzyInteger(-99999, 99999)
    change_fm = fuzzy.FuzzyInteger(-99999, 99999)
    change_fr = fuzzy.FuzzyInteger(-99999, 99999)
    change_ga = fuzzy.FuzzyInteger(-99999, 99999)
    change_gb = fuzzy.FuzzyInteger(-99999, 99999)
    change_gd = fuzzy.FuzzyInteger(-99999, 99999)
    change_ge = fuzzy.FuzzyInteger(-99999, 99999)
    change_gh = fuzzy.FuzzyInteger(-99999, 99999)
    change_gm = fuzzy.FuzzyInteger(-99999, 99999)
    change_gn = fuzzy.FuzzyInteger(-99999, 99999)
    change_gq = fuzzy.FuzzyInteger(-99999, 99999)
    change_gr = fuzzy.FuzzyInteger(-99999, 99999)
    change_gt = fuzzy.FuzzyInteger(-99999, 99999)
    change_gw = fuzzy.FuzzyInteger(-99999, 99999)
    change_gy = fuzzy.FuzzyInteger(-99999, 99999)
    change_hk = fuzzy.FuzzyInteger(-99999, 99999)
    change_hn = fuzzy.FuzzyInteger(-99999, 99999)
    change_hr = fuzzy.FuzzyInteger(-99999, 99999)
    change_ht = fuzzy.FuzzyInteger(-99999, 99999)
    change_hu = fuzzy.FuzzyInteger(-99999, 99999)
    change_id = fuzzy.FuzzyInteger(-99999, 99999)
    change_ie = fuzzy.FuzzyInteger(-99999, 99999)
    change_il = fuzzy.FuzzyInteger(-99999, 99999)
    change_in = fuzzy.FuzzyInteger(-99999, 99999)
    change_iq = fuzzy.FuzzyInteger(-99999, 99999)
    change_is = fuzzy.FuzzyInteger(-99999, 99999)
    change_it = fuzzy.FuzzyInteger(-99999, 99999)
    change_jm = fuzzy.FuzzyInteger(-99999, 99999)
    change_jo = fuzzy.FuzzyInteger(-99999, 99999)
    change_jp = fuzzy.FuzzyInteger(-99999, 99999)
    change_ke = fuzzy.FuzzyInteger(-99999, 99999)
    change_kg = fuzzy.FuzzyInteger(-99999, 99999)
    change_kh = fuzzy.FuzzyInteger(-99999, 99999)
    change_ki = fuzzy.FuzzyInteger(-99999, 99999)
    change_km = fuzzy.FuzzyInteger(-99999, 99999)
    change_kn = fuzzy.FuzzyInteger(-99999, 99999)
    change_kr = fuzzy.FuzzyInteger(-99999, 99999)
    change_kw = fuzzy.FuzzyInteger(-99999, 99999)
    change_kz = fuzzy.FuzzyInteger(-99999, 99999)
    change_la = fuzzy.FuzzyInteger(-99999, 99999)
    change_lb = fuzzy.FuzzyInteger(-99999, 99999)
    change_lc = fuzzy.FuzzyInteger(-99999, 99999)
    change_li = fuzzy.FuzzyInteger(-99999, 99999)
    change_lk = fuzzy.FuzzyInteger(-99999, 99999)
    change_lr = fuzzy.FuzzyInteger(-99999, 99999)
    change_ls = fuzzy.FuzzyInteger(-99999, 99999)
    change_lt = fuzzy.FuzzyInteger(-99999, 99999)
    change_lu = fuzzy.FuzzyInteger(-99999, 99999)
    change_lv = fuzzy.FuzzyInteger(-99999, 99999)
    change_ly = fuzzy.FuzzyInteger(-99999, 99999)
    change_ma = fuzzy.FuzzyInteger(-99999, 99999)
    change_mc = fuzzy.FuzzyInteger(-99999, 99999)
    change_md = fuzzy.FuzzyInteger(-99999, 99999)
    change_me = fuzzy.FuzzyInteger(-99999, 99999)
    change_mg = fuzzy.FuzzyInteger(-99999, 99999)
    change_mh = fuzzy.FuzzyInteger(-99999, 99999)
    change_mk = fuzzy.FuzzyInteger(-99999, 99999)
    change_ml = fuzzy.FuzzyInteger(-99999, 99999)
    change_mn = fuzzy.FuzzyInteger(-99999, 99999)
    change_mo = fuzzy.FuzzyInteger(-99999, 99999)
    change_mr = fuzzy.FuzzyInteger(-99999, 99999)
    change_mt = fuzzy.FuzzyInteger(-99999, 99999)
    change_mu = fuzzy.FuzzyInteger(-99999, 99999)
    change_mv = fuzzy.FuzzyInteger(-99999, 99999)
    change_mw = fuzzy.FuzzyInteger(-99999, 99999)
    change_mx = fuzzy.FuzzyInteger(-99999, 99999)
    change_my = fuzzy.FuzzyInteger(-99999, 99999)
    change_mz = fuzzy.FuzzyInteger(-99999, 99999)
    change_na = fuzzy.FuzzyInteger(-99999, 99999)
    change_ne = fuzzy.FuzzyInteger(-99999, 99999)
    change_ng = fuzzy.FuzzyInteger(-99999, 99999)
    change_ni = fuzzy.FuzzyInteger(-99999, 99999)
    change_nl = fuzzy.FuzzyInteger(-99999, 99999)
    change_no = fuzzy.FuzzyInteger(-99999, 99999)
    change_np = fuzzy.FuzzyInteger(-99999, 99999)
    change_nr = fuzzy.FuzzyInteger(-99999, 99999)
    change_nz = fuzzy.FuzzyInteger(-99999, 99999)
    change_om = fuzzy.FuzzyInteger(-99999, 99999)
    change_pa = fuzzy.FuzzyInteger(-99999, 99999)
    change_pe = fuzzy.FuzzyInteger(-99999, 99999)
    change_pg = fuzzy.FuzzyInteger(-99999, 99999)
    change_ph = fuzzy.FuzzyInteger(-99999, 99999)
    change_pk = fuzzy.FuzzyInteger(-99999, 99999)
    change_pl = fuzzy.FuzzyInteger(-99999, 99999)
    change_ps = fuzzy.FuzzyInteger(-99999, 99999)
    change_pt = fuzzy.FuzzyInteger(-99999, 99999)
    change_pw = fuzzy.FuzzyInteger(-99999, 99999)
    change_py = fuzzy.FuzzyInteger(-99999, 99999)
    change_qa = fuzzy.FuzzyInteger(-99999, 99999)
    change_ro = fuzzy.FuzzyInteger(-99999, 99999)
    change_rs = fuzzy.FuzzyInteger(-99999, 99999)
    change_ru = fuzzy.FuzzyInteger(-99999, 99999)
    change_rw = fuzzy.FuzzyInteger(-99999, 99999)
    change_sa = fuzzy.FuzzyInteger(-99999, 99999)
    change_sb = fuzzy.FuzzyInteger(-99999, 99999)
    change_sc = fuzzy.FuzzyInteger(-99999, 99999)
    change_se = fuzzy.FuzzyInteger(-99999, 99999)
    change_sg = fuzzy.FuzzyInteger(-99999, 99999)
    change_si = fuzzy.FuzzyInteger(-99999, 99999)
    change_sk = fuzzy.FuzzyInteger(-99999, 99999)
    change_sl = fuzzy.FuzzyInteger(-99999, 99999)
    change_sm = fuzzy.FuzzyInteger(-99999, 99999)
    change_sn = fuzzy.FuzzyInteger(-99999, 99999)
    change_sr = fuzzy.FuzzyInteger(-99999, 99999)
    change_st = fuzzy.FuzzyInteger(-99999, 99999)
    change_sv = fuzzy.FuzzyInteger(-99999, 99999)
    change_sz = fuzzy.FuzzyInteger(-99999, 99999)
    change_td = fuzzy.FuzzyInteger(-99999, 99999)
    change_tg = fuzzy.FuzzyInteger(-99999, 99999)
    change_th = fuzzy.FuzzyInteger(-99999, 99999)
    change_tj = fuzzy.FuzzyInteger(-99999, 99999)
    change_tl = fuzzy.FuzzyInteger(-99999, 99999)
    change_tn = fuzzy.FuzzyInteger(-99999, 99999)
    change_to = fuzzy.FuzzyInteger(-99999, 99999)
    change_tr = fuzzy.FuzzyInteger(-99999, 99999)
    change_tt = fuzzy.FuzzyInteger(-99999, 99999)
    change_tv = fuzzy.FuzzyInteger(-99999, 99999)
    change_tw = fuzzy.FuzzyInteger(-99999, 99999)
    change_tz = fuzzy.FuzzyInteger(-99999, 99999)
    change_ua = fuzzy.FuzzyInteger(-99999, 99999)
    change_ug = fuzzy.FuzzyInteger(-99999, 99999)
    change_us = fuzzy.FuzzyInteger(-99999, 99999)
    change_uy = fuzzy.FuzzyInteger(-99999, 99999)
    change_uz = fuzzy.FuzzyInteger(-99999, 99999)
    change_vc = fuzzy.FuzzyInteger(-99999, 99999)
    change_ve = fuzzy.FuzzyInteger(-99999, 99999)
    change_vn = fuzzy.FuzzyInteger(-99999, 99999)
    change_vu = fuzzy.FuzzyInteger(-99999, 99999)
    change_ws = fuzzy.FuzzyInteger(-99999, 99999)
    change_xk = fuzzy.FuzzyInteger(-99999, 99999)
    change_za = fuzzy.FuzzyInteger(-99999, 99999)
    change_zm = fuzzy.FuzzyInteger(-99999, 99999)
    change_zw = fuzzy.FuzzyInteger(-99999, 99999)

    class Meta:
        model = models.SpotifyPlaylistStreamsWeekHistory
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyPlaylistFollowersWeekHistoryFactory(factory.alchemy.SQLAlchemyModelFactory):
    date = factory.Faker("date")
    playlist_id = fuzzy.FuzzyText(length=22)
    value = fuzzy.FuzzyInteger(-999999, 999999)
    change = fuzzy.FuzzyInteger(-99999, 99999)

    class Meta:
        model = models.SpotifyPlaylistFollowersWeekHistory
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyAnalyticsAccountStreamInfoFactory(factory.alchemy.SQLAlchemyModelFactory):
    account = fuzzy.FuzzyInteger(1, 999999999)
    market = fuzzy.FuzzyText(length=10)
    date = factory.Faker("date")
    total_streams = fuzzy.FuzzyInteger(1, 99999)

    class Meta:
        model = models.SpotifyAnalyticsAccountStreamInfo
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyWeeklyTopPlaylistLatestFactory(factory.alchemy.SQLAlchemyModelFactory):
    date = factory.Faker("date")
    playlist_id = fuzzy.FuzzyText(length=22)
    rank = fuzzy.FuzzyInteger(1, 250)
    country_code = fuzzy.FuzzyText(length=10)

    class Meta:
        model = models.SpotifyWeeklyTopPlaylistLatest
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session


class SpotifyWeeklyTopPlaylistTrackSummaryFactory(factory.alchemy.SQLAlchemyModelFactory):
    playlist_id = fuzzy.FuzzyText(length=22)
    isrc = fuzzy.FuzzyText(length=22)
    entry_date = factory.Faker("date")
    exit_date = factory.Faker("date")

    class Meta:
        model = models.SpotifyWeeklyTopPlaylistTrackSummary
        sqlalchemy_session_persistence = "commit"
        sqlalchemy_session = session