ℹ️ This is an interpretation of RAW(16) for the GUID on Oracle Database.
SELECT
Anderson Guarnier da Silva andersoal
🚀
andersoal
/ extract-svg-from-drawio-library.py
Last active
May 23, 2025 02:31
— forked from ajmaradiaga/extract-svg-from-drawio-library.py
The Python script process the Draw.io library files and "extract" the images from within it. In my case, I want to save the images as SVG and PNG files.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import xml.etree.ElementTree as ET | |
| import base64 | |
| import cairosvg | |
| import os | |
| import json | |
| def process_mxlibrary(xml_file, output_dir="output"): | |
| """ | |
| Processes a .drawio XML file containing an mxlibrary, extracts SVG/PNG images, | |
| and saves them to the specified output directory. |
andersoal
/ MuleSoft_File_Filter.WinMerge.flt
Last active
September 6, 2025 15:36
MuleSoft loose - Suppresses various folder and files related to MuleSoft Project using Anypoint Studio
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ## This is a directory/file filter template for WinMerge | |
| name: MuleSoft loose | |
| desc: Suppresses various folder and files related to MuleSoft Project using Anypoint Studio | |
| ## Select if filter is inclusive or exclusive | |
| ## Inclusive (loose) filter lets through all items not matching rules | |
| ## Exclusive filter lets through only items that match to rule | |
| ## include or exclude | |
| def: include |
andersoal
/ RAW(16)_with_DataWeave.md
Last active
September 4, 2025 23:47
Oracle Database RAW(16) with DataWeave
andersoal
/ ohmyposhv3-v2.json
Created
December 5, 2023 11:24
— forked from shanselman/ohmyposhv3-v2.json
ohmyposhv3-v2
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "final_space": true, | |
| "console_title": true, | |
| "console_title_style": "folder", | |
| "blocks": [ | |
| { | |
| "type": "prompt", | |
| "alignment": "left", | |
| "horizontal_offset": 0, | |
| "vertical_offset": 0, |
andersoal
/ fun_transform_XML_Keys_Force_As_Array.dwl
Last active
December 7, 2024 11:19
DataWeave - Transform XML into JSON forcing Keys to Always return as Array
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| %dw 2.0 | |
| output application/json duplicateKeyAsArray = true | |
| // | |
| var payload = read('<?xml version="1.0" encoding="UTF-8"?><Root><About><Code>29329573000145</Code><Name>COMPANY X</Name><CodeStatus>Ativa</CodeStatus></About><Emails><Email>[email protected]</Email></Emails><Emails><Email>[email protected]</Email></Emails><Phones><AreaCode>19</AreaCode><Phone>34140000</Phone></Phones><Phones><AreaCode>19</AreaCode><Phone>34370005</Phone></Phones><Mobiles><AreaCode>11</AreaCode><Phone>912341234</Phone></Mobiles><Mobiles><AreaCode>11</AreaCode><Phone>956785678</Phone></Mobiles></Root>', 'application/xml') | |
| var root = 'Root' | |
| var arrayKeys = ["Emails", "Phones", "Mobiles"] | |
| var objectKeys = keysOf( (payload.'$(root)' default {}) as Object) -- (arrayKeys) |
andersoal
/ fun_rangeDate_filter_holidays_and_weekend.dwl
Created
November 28, 2023 01:19
DataWeave - Range of Dates (Array) filtering Holidays, Saturday and Sunday.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| %dw 2.0 | |
| output application/json | |
| fun isWeekend(d: String | Date) = do { | |
| ["1","7"] contains ((d as Date) as String { format: "c"}) | |
| } | |
| fun isWeekday(d: String | Date) = do { | |
| not (["1","7"] contains ((d as Date) as String { format: "c"})) | |
| } |
andersoal
/ tab_modifier.json
Last active
February 28, 2023 17:21
Tab Modifier Extension - https://github.com/sylouuu/chrome-tab-modifier
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "settings": { | |
| "enable_new_version_notification": false | |
| }, | |
| "rules": [ | |
| { | |
| "name": "Anypoint Management Center", | |
| "detection": "STARTS", | |
| "url_fragment": "https://anypoint.mulesoft.com/cloudhub/#/console/applications/cloudhub/", | |
| "tab": { |
andersoal
/ Anypoint Design Center - API Design - Title with Project + Branch.js
Created
June 24, 2022 00:02
Changes the Title of the Page for the Design Center Project opened.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // ==UserScript== | |
| // @name Anypoint Design Center - API Design - Title with Project/Branch | |
| // @namespace http://tampermonkey.net/ | |
| // @version 0.3 | |
| // @description Improves the browser window title when using Anypoint Design Center by adding the project name +c branch | |
| // @author AndyDaSilva52 | |
| // @match https://anypoint.mulesoft.com/designcenter/designer/ | |
| // @icon https://www.google.com/s2/favicons?sz=64&domain=bing.com | |
| // @grant none | |
| // ==/UserScript== |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| let openTabList = Array.from( document.querySelector("body > history-app").shadowRoot.querySelector('#main-container > #content > #synced-devices').shadowRoot.querySelector('#synced-device-list > history-synced-device-card:nth-child(1)').shadowRoot.querySelector('#history-item-container > #collapse > div#tab-item-list').querySelectorAll('div.item-container') ) | |
| .map(e => ` ${e.querySelector('a').getAttribute("href")}`); | |
| copy(openTabList.join('\n')); |
andersoal
/ MGTRF.TRF_NCM_Ajustar_NCM_Pai_Sintético.sql
Created
April 15, 2021 22:32
#Mega #Tributos - NCM (Nomenclatura Comum do Mercosul) - Ajusta o NCM Pai (Sintético) em todos considerando o Extenso que coincidir mais próximo #MegaERP
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| declare | |
| v_max_len_ncm_extenso integer; | |
| v_achou_pai CHAR := 'N'; | |
| v_pai_ncm_tab_in mgtrf.trf_ncm.ncm_tab_in_codigo%type; | |
| v_pai_ncm_pad_in mgtrf.trf_ncm.ncm_pad_in_codigo%type; | |
| v_pai_ncm_in mgtrf.trf_ncm.ncm_in_codigo%type; | |
| v_pai_ncm_ext mgtrf.trf_ncm.ncm_st_extenso%type; | |
| begin | |
| begin | |
| select max(length(ncm_st_extenso)) |
NewerOlder