Skip to content

Instantly share code, notes, and snippets.

View AgustinaNahas's full-sized avatar
🦉
Focusing

Agustina Nahas AgustinaNahas

🦉
Focusing
View GitHub Profile
cached!
4f30b1b2c07c41aa5acc45e973a82b0a46608c739433135fbc76ef5bb7a0bfec
Reusing connection
SELECT gr.* FROM Grid_Raw.Grid_Dataset gr where gr.INDICATOR = @INDICATOR and gr.REF_AREA = @REF_AREA and gr.SUBREGION='_T' and gr.TIME_PERIOD IS NOT NULL and gr.OBS_VALUE IS NOT NULL;
1ae62e76b9e10150dcf15d6d6e6643ea32825385cdd4ff83b5243904b698add7
Reusing connection
SELECT gr.* FROM Grid_Raw.Grid_Dataset gr where gr.INDICATOR = @INDICATOR and gr.REF_AREA = @REF_AREA and gr.SUBREGION!='_T' and gr.OBS_VALUE IS NOT NULL;
8e10a094a406171a1724866a099321fc226b97f12109aafa0ace11453d469e9a
Reusing connection
SELECT gr.REF_AREA ,gr.INDICATOR, gr.TEXT_INCLUSIVE_PROGRESS_SDG FROM Grid_Raw.Inclusive_Progress_SGD gr where gr.INDICATOR = @INDICATOR and gr.REF_AREA = @REF_AREA;
const members = [
{
"name": "Ameerah",
"surname": "Haq",
"quote": "“I think one of our most important roles is to provide positive role models for women’s involvement at all levels of decision making. My experience as one of three female Special Representatives of the Secretary-General leading peacekeeping missions is that the presence of a woman in high-level discussions can make a difference.”",
"bio": "Ms. Ameerah Haq was Vice Chair of the High-Level Independent Panel on Peace Operations for the United Nations as well as UN Under-Secretary-General for Field Support from 2012 to 2014. She was the Special Representative of the Secretary-General (SRSG) in the UN Integrated Mission in Timor-Leste. Ms. Haq has also served as Deputy SRSG and UN Resident Coordinator in Sudan, Deputy SRSG and UN Resident Coordinator in Afghanistan, as well as UN Resident Coordinator in Malaysia and Laos. She has also held senior positions within the UN Development Programme. As of December 2019, Ms Haq is the Cha
@AgustinaNahas
AgustinaNahas / loadCountriesGWL.js
Last active October 14, 2024 16:20
Load GWL countries from json
var myHeaders = new Headers();
myHeaders.append("Content-Type", "application/json");
myHeaders.append("Authorization", "Bearer 90cd686cf4f40241855ca60e670695e6ef1bd9106e9dd658472529999280726a2c8634bf69f01c498a8238af2ad81beb649207ea6a23d942b84b244dca25a6996ac0dd9e09e04548be070ea0a6485d3b4833201285ca7230f8155fedf5a74fcaf2eba586c8a93696a5aca6762feece81a9f214baf58d5bbca667ddf96b7be7cd");
var data = (d) => JSON.stringify({
"data": d
});
var request = (d) => { return {
method: 'POST',
This file has been truncated, but you can view the full file.
{"log":"Mon, 22 Jan 2024 18:02:08 GMT body-parser deprecated undefined extended: provide extended option at index.js:26:17\n","stream":"stderr","time":"2024-01-22T18:02:08.281292269Z"}
{"log":"Server is running...\n","stream":"stdout","time":"2024-01-22T18:02:08.287527325Z"}
{"log":"Connected to MSSQL server\n","stream":"stdout","time":"2024-01-22T18:02:25.677432541Z"}
{"log":"Connected to MSSQL server\n","stream":"stdout","time":"2024-01-22T18:02:26.388537698Z"}
{"log":"Connected to MSSQL server\n","stream":"stdout","time":"2024-01-22T18:02:26.393412343Z"}
{"log":"Connected to MSSQL server\n","stream":"stdout","time":"2024-01-22T18:02:26.397130152Z"}
{"log":"SELECT t.TOPIC_CODE, t.TOPIC_NAME, t.THEME_NAME FROM Grid_Raw.Topics t where t.TOPIC_CODE != 'HL.CO';\n","stream":"stdout","time":"2024-01-22T18:02:26.700492374Z"}
{"log":"Reusing connection\n","stream":"stdout","time":"2024-01-22T18:02:26.726873366Z"}
{"log":"SELECT gr.REF_AREA ,gr.INDICATOR, gr.TEXT_INCLUSIVE_PROGRESS_SDG FROM Grid_Raw.Inclusive_Progre
{"log":"Mon, 22 Jan 2024 18:02:08 GMT body-parser deprecated undefined extended: provide extended option at index.js:26:17\n","stream":"stderr","time":"2024-01-22T18:02:08.281292269Z"}
{"log":"-----------------------TIEMOUT ERROR-------------------------------\n","stream":"stderr","time":"2024-01-22T18:02:43.686134885Z"}
{"log":"SELECT gr.*, cr.REGION_CODE FROM Grid_Raw.Grid_Dataset gr INNER JOIN Grid_Raw.CountriesRegions cr on cr.REF_AREA = gr.REF_AREA where gr.INDICATOR = @INDICATOR and gr.RECENT = 1 and DIMENSION = '_T' and gr.SUBREGION='_T' AND LEN(gr.REF_AREA) = 3 and gr.OBS_VALUE!='NaN' and gr.OBS_VALUE IS NOT NULL ;\n","stream":"stderr","time":"2024-01-22T18:02:43.686198064Z"}
{"log":"[ { name: 'INDICATOR', value: 'CME_MRY0T4' } ]\n","stream":"stderr","time":"2024-01-22T18:02:43.688641322Z"}
{"log":"-------------------------------------------------------------------\n","stream":"stderr","time":"2024-01-22T18:02:43.688703501Z"}
{"log":"-----------------------TIEMOUT ERROR-------------------------------
const list = [
{
"COUNTRY": "Afghanistan",
"ISO": "AFG",
"NAME": "Solaiman",
"AGE": 12,
"SEX": "",
"EDITED_QUOTE": "Everything has changed, like markets where rice, flour, and oil have become so expensive.",
"THEMES": "CI,CI,NT,SD"
},
const list1 = list.map((obj) => {
var obj2 = {};
obj2.testimony = { testimony_text: obj.testimony_text, testimony_source: obj.testimony_source, quote_author: obj.quote_source, quote_link: obj.quote_link};
obj2.country_code = obj.country_code;
obj2.country_name = obj.country_nme;
obj2.coverage = { coverage_title: obj.coverage_title, coverage_scheme_type: obj.coverage_scheme_type, coverage_related_law: obj.coverage_related_law, coverage_benefit_amount: obj.coverage_benefit_amount, coverage_link_text: obj.coverage_link_text, coverage_link_url: obj.coverage_link_url, coverage_source_text: obj.source_text, coverage_source_link: obj.source_link };
obj2.spi = { spi_text: obj.spi_text, spi_source: obj.spi_source };
obj.prospects = { prospects_explanation_change: obj.prospects_explanation_change, prospects_explanation_future: obj.prospects_explanation_future };
return obj2;
})
@AgustinaNahas
AgustinaNahas / 1.js
Last active November 17, 2022 18:31
document.getElementById("ida_vuelta").checked = true;
document.getElementById("fecha_ida").value = "08/12/2022";
document.getElementById("fecha_vuelta").value = "12/12/2022";
$("#origen").parent().find(".selectize-input").click();
setTimeout(function(){
$("#origen").parent().find("[data-value='481']").click();
}, 500);
setTimeout(function(){
$("#destino").parent().find(".selectize-input").click();
{
"audio": {
"mime": "audio/mp4",
"data": "AAAAHGZ0eXBNNEEgAAAAAE00QSBtcDQyaXNvbQAAC6ttb292AAAAbG12aGQAAAAA3VRXk91UV5MAALuAAAgoAAABAAABAAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAAAKPXRyYWsAAABcdGtoZAAAAAfdVFeT3VRXkwAAAAEAAAAAAAgoAAAAAAAAAAAAAAAAAAEAAAAAAQAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAACdltZGlhAAAAIG1kaGQAAAAA3VRXk91UV5MAALuAAAgoAAAAAAAAAAAiaGRscgAAAAAAAAAAc291bgAAAAAAAAAAAAAAAAAAAAAJj21pbmYAAAAQc21oZAAAAAAAAAAAAAAAJGRpbmYAAAAcZHJlZgAAAAAAAAABAAAADHVybCAAAAABAAAJU3N0YmwAAABnc3RzZAAAAAAAAAABAAAAV21wNGEAAAAAAAAAAQAAAAAAAAAAAAIAEAAAAAC7gAAAAAAAM2VzZHMAAAAAA4CAgCIAAAAEgICAFEAUABgAAAEL8AAA+gAFgICAAhGIBoCAgAECAAAAGHN0dHMAAAAAAAAAAQAAAgoAAAQAAAAAKHN0c2MAAAAAAAAAAgAAAAEAAAAYAAAAAQAAABYAAAASAAAAAQAACDxzdHN6AAAAAAAAAAAAAAIKAAAABAAAACQAAAAZAAAADgAAAJoAAADfAAAAjQAAAKAAAACtAAAAjAAAAIkAAACHAAAAkAAAAIQAAACYAAAAmgAAAIsAAACKAAAAjQAAAIkAAACOAAAAkAAAAIcAAACNAAAAhAAAAIkAAACJAAAAkAAAAIoAAACVAAAApAAAAKQAAACmAAAAnwAAAKEAAACrAAAAogAAAKYAAAD
@AgustinaNahas
AgustinaNahas / provinciasArgentinas.json
Last active April 8, 2021 23:20
provinciasArgentinas.json
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.