Pablo Pazos Gutiérrez ppazos
🌎
ppazos
/ colums_with_type.sql
Created
October 19, 2025 01:53
Get columns with a specific type from mysql
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
| SELECT | |
| TABLE_SCHEMA, | |
| TABLE_NAME, | |
| COLUMN_NAME, | |
| DATA_TYPE | |
| FROM | |
| INFORMATION_SCHEMA.COLUMNS | |
| WHERE | |
| DATA_TYPE = 'datetime' AND TABLE_SCHEMA = 'atomik' | |
| ORDER BY |
ppazos
/ hapi_fhir_extract_patient_names.java
Created
August 11, 2025 22:12
Read all the names and extensions from given and family names from a patient resource instance in HAPI FHIR.
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
| Patient fhirPatient = ... | |
| for (HumanName name : fhirPatient.getName()) | |
| { | |
| // family names with extensions | |
| StringType familyElement = name.getFamilyElement(); | |
| if (familyElement != null) { | |
| System.out.println("Family: " + familyElement.getValue()); | |
| for (Extension ext : familyElement.getExtension()) { | |
| System.out.println(" Family Extension: " + ext.getUrl() + " = " + ext.getValue()); |
ppazos
/ rss_read.groovy
Created
June 30, 2025 17:33
— forked from kdabir/rss_read.groovy
Parsing rss in groovy
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
| // define the url | |
| def url = "http://news.google.com/news?ned=us&topic=h&output=rss" | |
| def rss = new XmlSlurper().parse(url) | |
| println rss.channel.title | |
| rss.channel.item.each { | |
| println "- ${it.title}" | |
| } |
ppazos
/ xml_utils.js
Created
June 19, 2025 00:57
Functions to format and render XML content as a string.
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
| // Convierte un documento XML a un string XML | |
| // http://stackoverflow.com/questions/6507293/convert-xml-to-string-with-jquery | |
| function xmlToString(xmlData) { | |
| var xmlString; | |
| //IE | |
| if (window.ActiveXObject) { | |
| xmlString = xmlData.xml; | |
| } | |
| // code for Mozilla, Firefox, Opera, etc. |
ppazos
/ check_uuid_format.groovy
Created
June 10, 2025 19:09
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
| def subjectUid = '...' | |
| if (!(subjectUid ==~ /([a-zA-Z0-9]{8}-[a-zA-Z0-9]{4}-[a-zA-Z0-9]{4}-[a-zA-Z0-9]{4}-[a-zA-Z0-9]{12})/)) | |
| { | |
| return 'error' | |
| } | |
| return 'ok' |
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
| // CSV is simple means it doesn't include commas so there is no value separator like " inside the CSV | |
| // Though we take into account there could be spaces after the commas and before the values, and those are removed | |
| // Though the spaces after the values are not removed so "a , b" would be parsed as ["a ", "b"] | |
| def b = "a, b b, c c c" | |
| b = b.replaceAll(",( )*", ",") | |
| println b |
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
| def a = ["a", "b", "c"] | |
| "value LIKE "+ a.collect {"'%"+ it + "%'"}.join(" OR value LIKE ") | |
| // value LIKE '%a%' OR value LIKE '%b%' OR value LIKE '%c%' |
ppazos
/ class_name_standardization.php
Last active
September 19, 2024 05:20
Stanrdardizes class names with generics to a single string
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
| <?php | |
| function snakeToCamelCase(string $input): string | |
| { | |
| return ucfirst(str_replace('_', '', ucwords(strtolower($input), '_'))); | |
| } | |
| function getClassNameRecursive($string, $start, $end) | |
| { |
ppazos
/ last_modified_http_header_date_format.groovy
Created
August 25, 2024 04:36
Format a date in the Last-Modified HTTP header format
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
| // Formats to comply with https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/Last-Modified | |
| java.text.SimpleDateFormat format = new java.text.SimpleDateFormat("EEE, dd MMM yyyy HH:mm:ss zzz"); | |
| format.setTimeZone(TimeZone.getTimeZone("GMT")); | |
| println format.format(new Date()) |
ppazos
/ mirth_connect_maps.js
Created
August 19, 2024 02:53
Shorthand names for accessing the maps in Mirth Connect
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
| function $co(key, value) { if (arguments.length == 1) { return connectorMap.get(key); } else { return connectorMap.put(key, value); } } | |
| function $c(key, value) { if (arguments.length == 1) { return channelMap.get(key); } else { return channelMap.put(key, value); } } | |
| function $s(key, value) { if (arguments.length == 1) { return sourceMap.get(key); } else { return sourceMap.put(key, value); } } | |
| function $gc(key, value) { if (arguments.length == 1) { return globalChannelMap.get(key); } else { return globalChannelMap.put(key, value); } } | |
| function $g(key, value) { if (arguments.length == 1) { return globalMap.get(key); } else { return globalMap.put(key, value); } } | |
| function $cfg(key, value) { if (arguments.length == 1) { return configurationMap.get(key); } else { return configurationMap.put(key, value); } } | |
| function $r(key, value) { if (arguments.length == 1) { return responseMap.get(key); } else { return responseMap.put(key, value); } } | |
| function $(string) { | |
| try { if(responseMap.containsKey(string)) { return |
NewerOlder