o 8DiG @s~ddlZddlZddlmZmZmZ ddedejeefdej ejdej efddZ d d d DZ d ede fd dZ dS)N) TrieResultin_trienew_triestringmappingtriereturnc s|sdSd}d}t|}|pt}|}g}d}||krn|||} t|| d\} }| tjkrQ|r;|d8}|} d}n| d} |d}|t| 7}|| |}n| tjkrX| }|d7}| tjkrj||krj|| ||ksdfdd|DS)aN Converts a time string given a mapping. Examples: >>> format_time("%Y", {"%Y": "YYYY"}) 'YYYY' Args: mapping: dictionary of time format to target time format. trie: optional trie, can be passed in for performance. Returns: The converted time string. Nrc3s|] }||VqdSN)get).0charsrE/var/www/Datamplify/venv/lib/python3.10/site-packages/sqlglot/time.py =szformat_time..)lenrrrFAILEDappendEXISTSjoin) rrrstartendsizecurrentchunkssymrresultrrr format_time s:       r cCsh|]}|qSr)lower)rtzrrr @sr#(TzAfrica/Abidjanz Africa/AccrazAfrica/Addis_AbabazAfrica/Algiersz Africa/Asmaraz Africa/Asmeraz Africa/Bamakoz Africa/Banguiz Africa/Banjulz Africa/BissauzAfrica/BlantyrezAfrica/BrazzavillezAfrica/Bujumburaz Africa/CairozAfrica/Casablancaz Africa/CeutazAfrica/Conakryz Africa/DakarzAfrica/Dar_es_SalaamzAfrica/Djiboutiz Africa/DoualazAfrica/El_AaiunzAfrica/FreetownzAfrica/Gaboronez Africa/HararezAfrica/Johannesburgz Africa/JubazAfrica/KampalazAfrica/Khartoumz Africa/KigalizAfrica/Kinshasaz Africa/LagoszAfrica/Librevillez Africa/Lomez Africa/LuandazAfrica/Lubumbashiz Africa/Lusakaz Africa/Malaboz Africa/Maputoz Africa/MaseruzAfrica/MbabanezAfrica/MogadishuzAfrica/MonroviazAfrica/NairobizAfrica/Ndjamenaz Africa/NiameyzAfrica/NouakchottzAfrica/OuagadougouzAfrica/Porto-NovozAfrica/Sao_TomezAfrica/TimbuktuzAfrica/Tripoliz Africa/TuniszAfrica/Windhoekz America/AdakzAmerica/AnchoragezAmerica/AnguillazAmerica/AntiguazAmerica/AraguainazAmerica/Argentina/Buenos_AireszAmerica/Argentina/Catamarcaz America/Argentina/ComodRivadaviazAmerica/Argentina/CordobazAmerica/Argentina/JujuyzAmerica/Argentina/La_RiojazAmerica/Argentina/MendozazAmerica/Argentina/Rio_GallegoszAmerica/Argentina/SaltazAmerica/Argentina/San_JuanzAmerica/Argentina/San_LuiszAmerica/Argentina/TucumanzAmerica/Argentina/Ushuaiaz America/ArubazAmerica/AsuncionzAmerica/Atikokanz America/Atkaz America/BahiazAmerica/Bahia_BanderaszAmerica/Barbadosz America/BelemzAmerica/BelizezAmerica/Blanc-SablonzAmerica/Boa_VistazAmerica/Bogotaz America/BoisezAmerica/Buenos_AireszAmerica/Cambridge_BayzAmerica/Campo_GrandezAmerica/CancunzAmerica/CaracaszAmerica/CatamarcazAmerica/CayennezAmerica/CaymanzAmerica/ChicagozAmerica/ChihuahuazAmerica/Ciudad_JuarezzAmerica/Coral_HarbourzAmerica/CordobazAmerica/Costa_RicazAmerica/CrestonzAmerica/CuiabazAmerica/CuracaozAmerica/DanmarkshavnzAmerica/DawsonzAmerica/Dawson_CreekzAmerica/DenverzAmerica/DetroitzAmerica/DominicazAmerica/EdmontonzAmerica/EirunepezAmerica/El_SalvadorzAmerica/EnsenadazAmerica/Fort_NelsonzAmerica/Fort_WaynezAmerica/FortalezazAmerica/Glace_BayzAmerica/GodthabzAmerica/Goose_BayzAmerica/Grand_TurkzAmerica/GrenadazAmerica/GuadeloupezAmerica/GuatemalazAmerica/GuayaquilzAmerica/GuyanazAmerica/HalifaxzAmerica/HavanazAmerica/HermosillozAmerica/Indiana/IndianapoliszAmerica/Indiana/KnoxzAmerica/Indiana/MarengozAmerica/Indiana/PetersburgzAmerica/Indiana/Tell_CityzAmerica/Indiana/VevayzAmerica/Indiana/VincenneszAmerica/Indiana/WinamaczAmerica/IndianapoliszAmerica/InuvikzAmerica/IqaluitzAmerica/Jamaicaz America/JujuyzAmerica/JuneauzAmerica/Kentucky/LouisvillezAmerica/Kentucky/MonticellozAmerica/Knox_INzAmerica/KralendijkzAmerica/La_Pazz America/LimazAmerica/Los_AngeleszAmerica/LouisvillezAmerica/Lower_PrinceszAmerica/MaceiozAmerica/ManaguazAmerica/ManauszAmerica/MarigotzAmerica/MartiniquezAmerica/MatamoroszAmerica/MazatlanzAmerica/MendozazAmerica/MenomineezAmerica/MeridazAmerica/MetlakatlazAmerica/Mexico_CityzAmerica/MiquelonzAmerica/MonctonzAmerica/MonterreyzAmerica/MontevideozAmerica/MontrealzAmerica/MontserratzAmerica/NassauzAmerica/New_YorkzAmerica/Nipigonz America/NomezAmerica/NoronhazAmerica/North_Dakota/BeulahzAmerica/North_Dakota/CenterzAmerica/North_Dakota/New_Salemz America/NuukzAmerica/OjinagazAmerica/PanamazAmerica/PangnirtungzAmerica/ParamaribozAmerica/PhoenixzAmerica/Port-au-PrincezAmerica/Port_of_SpainzAmerica/Porto_AcrezAmerica/Porto_VelhozAmerica/Puerto_RicozAmerica/Punta_ArenaszAmerica/Rainy_RiverzAmerica/Rankin_InletzAmerica/RecifezAmerica/ReginazAmerica/ResolutezAmerica/Rio_BrancozAmerica/RosariozAmerica/Santa_IsabelzAmerica/SantaremzAmerica/SantiagozAmerica/Santo_DomingozAmerica/Sao_PaulozAmerica/ScoresbysundzAmerica/Shiprockz America/SitkazAmerica/St_BarthelemyzAmerica/St_JohnszAmerica/St_KittszAmerica/St_LuciazAmerica/St_ThomaszAmerica/St_VincentzAmerica/Swift_CurrentzAmerica/Tegucigalpaz America/ThulezAmerica/Thunder_BayzAmerica/TijuanazAmerica/TorontozAmerica/TortolazAmerica/VancouverzAmerica/VirginzAmerica/WhitehorsezAmerica/WinnipegzAmerica/YakutatzAmerica/YellowknifezAntarctica/CaseyzAntarctica/DaviszAntarctica/DumontDUrvillezAntarctica/MacquariezAntarctica/MawsonzAntarctica/McMurdozAntarctica/PalmerzAntarctica/RotherazAntarctica/South_PolezAntarctica/SyowazAntarctica/TrollzAntarctica/VostokzArctic/Longyearbyenz Asia/Adenz Asia/Almatyz Asia/Ammanz Asia/Anadyrz Asia/Aqtauz Asia/Aqtobez Asia/AshgabatzAsia/Ashkhabadz Asia/Atyrauz Asia/Baghdadz Asia/Bahrainz Asia/Bakuz Asia/Bangkokz Asia/Barnaulz Asia/Beirutz Asia/Bishkekz Asia/Bruneiz Asia/Calcuttaz Asia/ChitazAsia/ChoibalsanzAsia/ChongqingzAsia/Chungkingz Asia/Colomboz Asia/Daccaz Asia/Damascusz Asia/Dhakaz Asia/Diliz Asia/Dubaiz Asia/DushanbezAsia/Famagustaz Asia/Gazaz Asia/Harbinz Asia/HebronzAsia/Ho_Chi_MinhzAsia/Hong_Kongz Asia/Hovdz Asia/Irkutskz Asia/Istanbulz Asia/Jakartaz Asia/JayapurazAsia/Jerusalemz Asia/KabulzAsia/Kamchatkaz Asia/Karachiz Asia/KashgarzAsia/Kathmanduz Asia/Katmanduz Asia/Khandygaz Asia/KolkatazAsia/KrasnoyarskzAsia/Kuala_Lumpurz Asia/Kuchingz Asia/Kuwaitz Asia/Macaoz Asia/Macauz Asia/Magadanz Asia/Makassarz Asia/Manilaz Asia/Muscatz Asia/NicosiazAsia/NovokuznetskzAsia/Novosibirskz Asia/Omskz Asia/OralzAsia/Phnom_PenhzAsia/PontianakzAsia/Pyongyangz Asia/Qatarz Asia/QostanayzAsia/Qyzylordaz Asia/Rangoonz Asia/Riyadhz Asia/Saigonz Asia/SakhalinzAsia/Samarkandz Asia/Seoulz Asia/ShanghaizAsia/SingaporezAsia/Srednekolymskz Asia/Taipeiz Asia/Tashkentz Asia/Tbilisiz Asia/Tehranz Asia/Tel_Avivz Asia/Thimbuz Asia/Thimphuz Asia/Tokyoz Asia/TomskzAsia/Ujung_PandangzAsia/UlaanbaatarzAsia/Ulan_Batorz Asia/Urumqiz Asia/Ust-NerazAsia/VientianezAsia/Vladivostokz Asia/Yakutskz Asia/YangonzAsia/Yekaterinburgz Asia/YerevanzAtlantic/AzoreszAtlantic/BermudazAtlantic/CanaryzAtlantic/Cape_VerdezAtlantic/FaeroezAtlantic/FaroezAtlantic/Jan_MayenzAtlantic/MadeirazAtlantic/ReykjavikzAtlantic/South_GeorgiazAtlantic/St_HelenazAtlantic/Stanleyz Australia/ACTzAustralia/AdelaidezAustralia/BrisbanezAustralia/Broken_HillzAustralia/CanberrazAustralia/CurriezAustralia/DarwinzAustralia/EuclazAustralia/Hobartz Australia/LHIzAustralia/LindemanzAustralia/Lord_HowezAustralia/Melbournez Australia/NSWzAustralia/NorthzAustralia/PerthzAustralia/QueenslandzAustralia/SouthzAustralia/SydneyzAustralia/TasmaniazAustralia/VictoriazAustralia/WestzAustralia/Yancowinnaz Brazil/AcrezBrazil/DeNoronhaz Brazil/Eastz Brazil/WestCETCST6CDTzCanada/AtlanticzCanada/CentralzCanada/EasternzCanada/MountainzCanada/NewfoundlandzCanada/PacificzCanada/Saskatchewanz Canada/YukonzChile/ContinentalzChile/EasterIslandCubaEETESTEST5EDTEgyptEirezEtc/GMTz Etc/GMT+0z Etc/GMT+1z Etc/GMT+10z Etc/GMT+11z Etc/GMT+12z Etc/GMT+2z Etc/GMT+3z Etc/GMT+4z Etc/GMT+5z Etc/GMT+6z Etc/GMT+7z Etc/GMT+8z Etc/GMT+9z Etc/GMT-0z Etc/GMT-1z Etc/GMT-10z Etc/GMT-11z Etc/GMT-12z Etc/GMT-13z Etc/GMT-14z Etc/GMT-2z Etc/GMT-3z Etc/GMT-4z Etc/GMT-5z Etc/GMT-6z Etc/GMT-7z Etc/GMT-8z Etc/GMT-9zEtc/GMT0z Etc/GreenwichzEtc/UCTzEtc/UTCz Etc/UniversalzEtc/ZuluzEurope/AmsterdamzEurope/AndorrazEurope/Astrakhanz Europe/AthenszEurope/BelfastzEurope/Belgradez Europe/BerlinzEurope/BratislavazEurope/BrusselszEurope/BucharestzEurope/BudapestzEurope/BusingenzEurope/ChisinauzEurope/Copenhagenz Europe/DublinzEurope/GibraltarzEurope/GuernseyzEurope/HelsinkizEurope/Isle_of_ManzEurope/Istanbulz Europe/JerseyzEurope/Kaliningradz Europe/Kievz Europe/Kirovz Europe/Kyivz Europe/LisbonzEurope/Ljubljanaz Europe/LondonzEurope/Luxembourgz Europe/Madridz Europe/MaltazEurope/Mariehamnz Europe/Minskz Europe/Monacoz Europe/MoscowzEurope/Nicosiaz Europe/Osloz Europe/PariszEurope/Podgoricaz Europe/Praguez Europe/Rigaz Europe/Romez Europe/SamarazEurope/San_MarinozEurope/SarajevozEurope/SaratovzEurope/Simferopolz Europe/Skopjez Europe/SofiazEurope/StockholmzEurope/Tallinnz Europe/TiranezEurope/TiraspolzEurope/UlyanovskzEurope/Uzhgorodz Europe/VaduzzEurope/Vaticanz Europe/ViennazEurope/VilniuszEurope/Volgogradz Europe/Warsawz Europe/ZagrebzEurope/Zaporozhyez Europe/ZurichGBzGB-EireGMTzGMT+0zGMT-0GMT0 GreenwichHSTHongkongIcelandzIndian/Antananarivoz Indian/ChagoszIndian/Christmasz Indian/Cocosz Indian/ComorozIndian/Kerguelenz Indian/MahezIndian/MaldiveszIndian/MauritiuszIndian/MayottezIndian/ReunionIranIsraelJamaicaJapan KwajaleinLibyaMETMSTMST7MDTzMexico/BajaNortezMexico/BajaSurzMexico/GeneralNZzNZ-CHATNavajoPRCPST8PDTz Pacific/ApiazPacific/AucklandzPacific/BougainvillezPacific/Chathamz Pacific/ChuukzPacific/Easterz Pacific/EfatezPacific/EnderburyzPacific/Fakaofoz Pacific/FijizPacific/FunafutizPacific/GalapagoszPacific/GambierzPacific/Guadalcanalz Pacific/GuamzPacific/HonoluluzPacific/JohnstonzPacific/KantonzPacific/KiritimatizPacific/KosraezPacific/KwajaleinzPacific/MajurozPacific/MarquesaszPacific/Midwayz Pacific/Nauruz Pacific/NiuezPacific/NorfolkzPacific/NoumeazPacific/Pago_Pagoz Pacific/PalauzPacific/PitcairnzPacific/PohnpeizPacific/PonapezPacific/Port_MoresbyzPacific/RarotongazPacific/Saipanz Pacific/SamoazPacific/TahitizPacific/TarawazPacific/Tongatapuz Pacific/Trukz Pacific/WakezPacific/Wallisz Pacific/YapPolandPortugalROCROK SingaporeTurkeyUCTz US/Alaskaz US/Aleutianz US/Arizonaz US/CentralzUS/East-Indianaz US/Easternz US/HawaiizUS/Indiana-Starkez US/Michiganz US/Mountainz US/PacificzUS/SamoaUTC UniversalzW-SUWETZulutimestamp_literalcCs^z$tj|}tt|jd}d}|dkrd}|WS|dkr"d}|WSty.YdSw)a Given an ISO-8601 timestamp literal, eg '2023-01-01 12:13:14.123456+00:00' figure out its subsecond precision so we can construct types like DATETIME(6) Note that in practice, this is either 3 or 6 digits (3 = millisecond precision, 6 = microsecond precision) - 6 is the maximum because strftime's '%f' formats to microseconds and almost every database supports microsecond precision in timestamps - Except Presto/Trino which in most cases only supports millisecond precision but will still honour '%f' and format to microseconds (replacing the remaining 3 digits with 0's) - Python prior to 3.11 only supports 0, 3 or 6 digits in a timestamp literal. Any other amounts will throw a 'ValueError: Invalid isoformat string:' error 0r)datetime fromisoformatrstr microsecondrstrip ValueError)rKparsedsubsecond_digit_count precisionrrrsubsecond_precisions  rXr )typingtrO sqlglot.trierrrrQDictOptionalr TIMEZONESintrXrrrrs*   7_