h=:dZddlZddlZddlZddlZddlmZddlmZmZm Z ddl Z ej ej dej dejgejeZGdd ZGd d Zd Zed kr edSdS)aX GeoNames to Google Sheets Data Synchronizer ============================================ This script downloads country data from GeoNames.org and uploads it to a Google Sheets document. Data source: https://download.geonames.org/export/dump/countryInfo.txt Target: Google Sheets spreadsheet Author: Claude Code Assistant Created: 2025-01-13 N)datetime)ListDictOptionalz)%(asctime)s - %(levelname)s - %(message)szgeonames_sync.log)levelformathandlerscBeZdZdZdZdeefdZd dedefdZ dS) GeoNamesDownloaderz2Downloads and processes country data from GeoNamesc"d|_g|_dS)Nz9https://download.geonames.org/export/dump/countryInfo.txt)country_info_urldata)selfs >/home/www/claudev.cz/jirka2/tabulka_data/geonames_to_sheets.py__init__zGeoNamesDownloader.__init__$s [ returnc tdtj|jd}||jd}d}g}|D]O}| dr$|s!d|vrtd|<|sQ|d }t|d krid |d d |dd|dd|dd|dd|dd|dd|dd|dd|dd|d d!|d"d#|d$d%|d&d'|d(d)|d*d+|d,|d-t|d kr|d nd.d/}| |Qtd0t|d1||_ |S#tj $r#}td2|d3}~wt$r#}td4|d3}~wwxYw)5z*Download country information from GeoNamesz)Downloading country data from GeoNames...)timeout F#ISOz Header info:   iso_alpha2r iso_alpha3 iso_numeric fips_code country_namecapitalarea_km2 population continenttld currency_code currency_name phone postal_code_format postal_code_regex languages geoname_id) neighboursequivalent_fips_codezSuccessfully downloaded z countrieszError downloading data: NzError processing data: )loggerinforequestsgetr raise_for_statustextstripsplit startswithlenappendrRequestExceptionerror Exception) rresponselines header_foundprocessed_datalinefields country_dataes rdownload_country_dataz(GeoNamesDownloader.download_country_data(s9  KKC D D D|D$92FFFH  % % ' ' 'M''))//55E LN$ 8$ 8??3'''A&kkB>N>Nr TV'$$$L*#)),777 KKR3~3F3FRRR S S S&DI! !(    LL7A77 8 8 8     LL6166 7 7 7  s$G?HIH// I<IIcountries_data.csvfilenamec|jstdd|} t|ddd5}|jrc|jd}t j||}|||jd d d n #1swxYwYt d ||S#t$r#}t d |d }~wwxYw) z Save downloaded data to CSV filez3No data to save. Run download_country_data() first.z)/home/www/claudev.cz/jirka2/tabulka_data/wr>zutf-8)newlineencodingr) fieldnamesNzData saved to zError saving CSV: ) r ValueErroropenkeyscsv DictWriter writeheader writerowsrArBrNrM)rrYfilepathcsvfiler^writerrVs r save_to_csvzGeoNamesDownloader.save_to_csvesSy TRSS SIxII hR'BBB 0g90!%1!2!2!4!4J ^G KKKF&&((($$TY///  0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 KK333 4 4 4O    LL1a11 2 2 2  s;CA+B' C'B++C.B+/!C C>C99C>N)rX) __name__ __module__ __qualname____doc__rrrrWstrrirrr r !sp<<;tDz;;;;zC3rr cFeZdZdZdefdZdZd deedede fd Z d S) GoogleSheetsUploaderz'Handles uploading data to Google Sheetsspreadsheet_idc0||_d|_d|_dS)Nzgoogle_credentials.json)rrcredentials_fileservice)rrrs rrzGoogleSheetsUploader.__init__~s, 9 rc tdtddS#t$r(}td|Yd}~dSd}~wwxYw)z#Setup Google Sheets API credentialsz+Setting up Google Sheets API credentials...z>Google API credentials setup required - see setup instructionsTzError setting up credentials: NF)rArBwarningrNrM)rrVs rsetup_credentialsz&GoogleSheetsUploader.setup_credentialss{  KKE F F F NN[ \ \ \ 4    LL=!== > > >55555 s48 A*A%%A*Sheet1r sheet_namerc |stddStdt |d|stddSt |d}|g}|D]#|fd|D$tdt |d td d S#t$r(}td |Yd }~dSd }~wwxYw)zUpload data to Google SheetszFailed to setup credentialsFz Uploading z rows to Google Sheets...zNo data to uploadrcVg|]%}t|d&S)r>)rnrD).0headerrows r z4GoogleSheetsUploader.upload_data..s/NNNFs37762#6#677NNNrz Prepared z# rows (including header) for uploadz"Data upload completed successfullyTzError uploading data: N) rxrArMrBrJrwlistrarKrN)rrrzheadersvaluesrVrs @r upload_dataz GoogleSheetsUploader.upload_datas^$ ))++  :;;;u KKISYYIII J J J 2333u47<<>>**GYF P P NNNNgNNNOOOO KKTCKKTTT U U U KK< = = =4    LL5!55 6 6 655555 s$.DADrsY   ''''''''''  , 6/00  8 $ $XXXXXXXXt????????B: zDFFFFFr