5j? SSKrSSKrSSKJr SrSSSSSSS /S S .S .S SSSS.SSSSSS.S.S.SS0SSSSSSSSSSSS.S SS!.S".S#.0S$S%S&S'S(S).S*S+.0S,.S-S.S/S0S1S2.S3.S4S5S6S7S8.S3.S9S:S;S<.S3.S=S>S?0S>S@0S>SA0S>SB0S>SC0SD.S3.SESFSGSH.SISJSK.SSL.SMSNSO0SPSQSRSSSTSUSV.SWSX0SY.SZS[S\SH.S]S^SISJS_.SSL.S`SaSbScSdSeSf.S3.SgShSiSjSkSlSmSn.S3.SoSpSqSr0SSs.StSuSvSwSxSySzS{S|.S}S~SSSSSSS.SSS.SS0SS.S3.SSSS.SSS.SSSSSSSSS.SSSS.S.S3.SSSSSSS.S3.SSSS.SSS0S.S. SWSSrSSS.S3.0SSSS.S3.SSSS0SS0SrS//S.0S3.SSSS//S.0S3.SSSFSS//S.0S3.SSSS//S.0S3.S.SSS0S3.S.SSSSSSSS.SS.S.SSSS.S.SSSSS./SS/SS/SSSSSSSS.S.S.00S.r\R "\"\5R55R5r Sr \ \ :wa\R"S5 \"\5r \S:Xa \"S\ 5 gg)N)config_from_dict)configFTdi)znumber-of-retriesz on-errorszbackoff-factor)zmax-connectionszmax-keepalive-connectionszrequest-timeout auto-retryinfo*)enabledcolorizezlseg-data-lib.log10M1d )r namesizeintervalmaxFiles)consolefile)levelfilter transportsr zdesktop.workspacedefaultzhttps://api.refinitiv.comz/auth/oauth2/v1/revokez/auth/oauth2/v1z /authorizez/token)url authorizetokenz/auth/oauth2/v2)rr)revokev1v2)signon_controlzauto-reconnectz server-mode verify_scopebase-urlauth workspaceDEFAULT_WORKSPACE_APP_KEYzhttp://localhost:9000z/api/rdpz/api/udf)rdpudfz/api/handshake)zapp-keyr#zplatform-pathsz handshake-url)rplatformdesktopz/file-store/v1z/bucketsz /file-setsz/filesz /packages)bucketsz file-setsfilespackages)r endpointsz/data/historical-pricing/v1z /views/eventsz/views/interday-summariesz/views/intraday-summaries)eventsinterday-summariesintraday-summariesz /data/pricingz/snapshots/v1/z /chains/v1/) snapshotschainsz3/data/quantitative-analytics-dates-and-calendars/v1syncz /add-periodsz /holidaysz/count-periodsz/date-schedulez/is-working-day)z add-periodsholidaysz count-periodsz date-schedulezis-working-dayz/data/quantitative-analytics/v1z/financial-contractsz/async-financial-contracts)r4asyncz/async-operationz/async-resource)financial-contractsasync-operationasync-resource)rr.r z3/data/quantitative-analytics-curves-and-surfaces/v1curvesz/curves/bond-curves/curvesz$/curves/cross-currency-curves/curvesz0/curves/cross-currency-curves/definitions/createz0/curves/cross-currency-curves/definitions/deletez-/curves/cross-currency-curves/definitions/getz0/curves/cross-currency-curves/definitions/searchz0/curves/cross-currency-curves/definitions/update)createdeletegetsearchupdater>zr/r0r1API_Playgroundz$155d9dbf-f0ac-46d9-8b77-f7f6dcd238f8z*/*)ClientIDz X-Api-KeyAcceptz/data/filings/v1 retrievalz /retrieval)headersrr.) zhistorical-pricingpricingz*quantitative-analytics-dates-and-calendarsz*quantitative-analytics-financial-contractsz*quantitative-analytics-curves-and-surfacesnewszenvironmental-social-governancedatagrid ownership estimatescustom-instrumentsfilingsz/discovery/search/v1/z/lookupz/metadata/views)r>lookupmetadataz/tradefeedr/v1zfx/algo/parent-ordersz/fx/algo/pre-trade-forecast)z parent-orderszpre-trade-forecastz/streaming/pricing/v1mainzfield-validationdownloadOMM)contribrgpath protocols locationsz /streaming/custom-instruments/v1resourcez /resource)rlrmrnz'/streaming/quantitative-analytics/beta1r7RDPz/streaming/benchmark/v1)r_rdzquantitative-analytics benchmarkz/data-store/v1graphqlz/graphql)z file-storedata discovery tradefeedr streamingz data-storeesgstandard_scoreszbulk-ESGz)Bulk-ESG-Global-Scores-Wealth-Standard-v1z./downloads/esg/standard_scores)r count)rlr z auto-extract)bucketrrisqlite3)databaseuri)module parametersMY_STANDARD_SCORES_TABLEaCREATE TABLE IF NOT EXISTS MY_STANDARD_SCORES_TABLE(ORGANIZATION varchar(255),INSERT_DATE varchar(255), INSTRUMENT varchar(255), PERIOD_END_DATE varchar(255), ESG_C_SCORE varchar(255),ESG_SCORE varchar(255),ENVIRONMENT_PILLAR_SCORE varchar(255), SOCIAL_PILLAR_SCORE varchar(255), GOVERNANCE_PILLAR_SCORE varchar(255), CONSTRAINT UC_MY_STANDARD_SCORES UNIQUE (INSTRUMENT,PERIOD_END_DATE))z SHOW TABLES)z table-namez create-queryzcheck-if-exists-queryzFSELECT * FROM MY_STANDARD_SCORES_TABLE WHERE INSTRUMENT IN #{universe}a{REPLACE INTO MY_STANDARD_SCORES_TABLE(ORGANIZATION, INSERT_DATE, INSTRUMENT, PERIOD_END_DATE, ESG_C_SCORE, ESG_SCORE, ENVIRONMENT_PILLAR_SCORE, SOCIAL_PILLAR_SCORE, GOVERNANCE_PILLAR_SCORE) VALUES ('#{Fields.ESGOrganization.Names.Name.OrganizationName.0.OrganizationNormalizedName}', '#{File.DateTime}', '#{Fields.StatementDetails.OrganizationId}', '#{Fields.StatementDetails.FinancialPeriodEndDate}', '#{Fields.ESGScores.ESGCombinedScore.Value}', '#{Fields.ESGScores.ESGScore.Value}', '#{Fields.ESGScores.EnvironmentPillarScore.Value}', '#{Fields.ESGScores.SocialPillarScore.Value}', '#{Fields.ESGScores.GovernancePillarScore.Value}')z$DELETE FROM MY_STANDARD_SCORES_TABLE instrument periodenddatezTR.TRESGCScorez TR.TRESGScorezTR.EnvironmentPillarScorezTR.SocialPillarScorezTR.GovernancePillarScore) INSTRUMENTPERIOD_END_DATE ESG_C_SCORE ESG_SCOREENVIRONMENT_PILLAR_SCORESOCIAL_PILLAR_SCOREGOVERNANCE_PILLAR_SCORE) connectionztable-auto-creationzcreate-table-queriesz search-queryzinsert-queriesz stop-on-errorzclean-up-querieszoutput-fields-mapping)packagedb)z#config-change-notifications-enabledraise_exception_on_errorhttplogs usage_loggersessionsapisbulk 1b7e592f495a615a1c4c0bf150ee73c1zDefault library config was changed. This may cause unexpected errors. Please use user config to introduce new changes. You can reinstall lseg-data to revert changes back.__main__zcurrent checksum: )hashlibwarnings2lseg.data._external_libraries.python_configurationr__all__rsmd5reprencode hexdigestcurrent_checksumfixed_checksumwarnr__name__printY/root/lseg-credit/backend/venv/lib/python3.13/site-packages/lseg/data/_config_defaults.pyrsQO ,1 $%',-SEUVW  #(e< +      5' "'"&$ $76"3,Yab"3hG    63*4Z"H!1  !6$%)!'  5-*E*E#'+;}U M$*N#;!' 5&,.>%?&,.>%?'-/@&A  ;9!7!=,(:&7 # ;M!">$#I&X&X#R&X&X (%&d4 .'?)4?P Q!4,J'9&7-0#5;:'!-) +'&7  B ++%;)C#7'?  0.',(#.49 ,&E)L%D+P7h/X/X%&=)D%<$:+H7`/P/P 0T.Q ",-G H 13>,#9#:% #=#>) #9GAJGKI@t#:1V+J %#=4`#>)':5#1''*?*?  #!1!G# *)<8}g R .!' 1  $!8&C /$6#>%/$7 #&+W%'  : +&+W%'! #A) 6&+U^%', '1 +&+W%'! C+ X/i=TU_p d  (G A26&C(,!#,35d&C#,0+E-r5B-%mV '&+)O(P&2+:'7%44O/E3M.'' ) + I Pd ;;tDz0023==?3~% MM , $  z  01r