ctkdev

$['entry'][*]['resource'].[?(@.resourceType==='Appointment')]
$['entry'][*]['resource'].[?(@.resourceType==='Practitioner')]
$['entry'][*]['resource'].[?(@.resourceType==='Patient')]

ctkdev

# https://www.timeanddate.com/time/change/usa
select dateTimeAccess dateTimeAccessEastern,
                CASE
                    when dateTimeAccess between '2021-03-14 02:00:00' and '2021-11-07 02:00:00' then DATE_FORMAT(
                            DATE_ADD(dateTimeAccess, INTERVAL 4 HOUR), '%Y-%m-%d %H:%i:%s')
                    when dateTimeAccess between '2021-11-07 02:00:01' and '2022-03-13 02:00:00' then DATE_FORMAT(
                            DATE_ADD(dateTimeAccess, INTERVAL 5 HOUR), '%Y-%m-%d %H:%i:%s')
                    when dateTimeAccess > '2022-03-13 02:00:01' then DATE_FORMAT(
                            DATE_ADD(dateTimeAccess, INTERVAL 4 HOUR), '%Y-%m-%d %H:%i:%s')
                    end as dateTimeAccessUTC

ctkdev

Date decode(String id) {
    final String PUSH_CHARS = "-0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ_abcdefghijklmnopqrstuvwxyz"
    id = id.substring(0, 8)
    Long timestamp = 0
    for (int i = 0; i < id.size(); i++) {
        String c = id.charAt(i).toString()
        println "i=$i PUSH_CHARS.indexOf(c)=${PUSH_CHARS.indexOf(c)}"
        timestamp = timestamp * 64 + PUSH_CHARS.indexOf(c)
    }
    return new Date(timestamp)

ctkdev

### Basic authorization with variables.
### https://api.athenahealth.com/oauthpreview/token
### Retrieves the Access Token in the same manner as the I/O Docs API Documentation https://developer.athenahealth.com/io-docs
POST https://api.athenahealth.com/oauthpreview/token
Authorization: Basic YourAthenaClientID YourAthenaClientSecret
Content-Type: application/x-www-form-urlencoded

grant_type=client_credentials&scope=athena/service/Athenanet.MDP.*

# This will trigger a POST and the following Response

ctkdev

To remove a submodule you need to:

• Delete the relevant section from the .gitmodules file.
• Stage the .gitmodules changes git add .gitmodules
• Delete the relevant section from .git/config.
• Run git rm --cached path_to_submodule (no trailing slash).
• Run rm -rf .git/modules/path_to_submodule (no trailing slash).
• Commit git commit -m "Removed submodule "
• Delete the now untracked submodule files rm -rf path_to_submodule

ctkdev

def nullTrustManager = [
    checkClientTrusted: { chain, authType ->  },
    checkServerTrusted: { chain, authType ->  },
    getAcceptedIssuers: { null }
]

def nullHostnameVerifier = [
    verify: { hostname, session -> 
        //true 
        hostname.startsWith('yuml.me')

ctkdev

$ aws s3 ls --summarize --human-readable --recursive s3://bucket-name-o/

# output will look similar to the following: 
Total Objects: 5702031
   Total Size: 91851.8 GiB

ctkdev

npm uninstall <package_name> -g 

or 

npm uninstall <package_name> --global

e.g.

npm uninstall angular-cli -g

ctkdev

cd node_modules
git clone https://github.com/valor-software/ng2-bootstrap.git
cd ng2-bootstrap
git checkout feature-branch
npm install

ctkdev

SET FOREIGN_KEY_CHECKS = 0;
SET GROUP_CONCAT_MAX_LEN=32768;
SET @tables = NULL;
SELECT GROUP_CONCAT('`', table_name, '`') INTO @tables
  FROM information_schema.tables
  WHERE table_schema = (SELECT DATABASE());
SELECT IFNULL(@tables,'dummy') INTO @tables;

SET @tables = CONCAT('DROP TABLE IF EXISTS ', @tables);
PREPARE stmt FROM @tables;