tertek

SELECT d.record, d.field_name, d.value, dqr.comment, dqr.ts as `Time Raised`, u.username as `User Assigned`, dqr.response
FROM `redcap_data` as d 

LEFT JOIN `redcap_data_quality_status` as dqs ON d.record = dqs.record AND d.field_name = dqs.field_name
LEFT JOIN `redcap_data_quality_resolutions` as dqr ON dqr.status_id = dqs.status_id
LEFT JOIN `redcap_user_information` as u ON dqs.assigned_user_id = u.ui_id

WHERE 
# exclude unneeded fields
d.field_name NOT LIKE "%_complete"

tertek

delete from redcap_external_module_settings 
where `project_id`= 14 and `external_module_id` = 9
and `key` <> "enabled"

tertek

python:
#!/usr/bin/env python
import requests
data = {
    'token': '<PLEASE INSERT API TOKEN HERE>',
    'content': 'record',
    'format': 'csv',
    'type': 'flat',
    'csvDelimiter': '',
    'records[0]': '1',

tertek

RewriteEngine On

# Rewrite Rules needed for pretty URLS for the Modules API

# Add trailing slash to all requests within /api directory
RewriteCond %{REQUEST_URI} !(/$|\.) 
RewriteRule (.*) %{REQUEST_URI}/ [R=301,L]

# Route URL Query parameters to pretty URls with "endpoints" - DO NOT CHANGE THE ORDER - can break things
RewriteRule ^v1/$ ?NOAUTH&pid=472&type=module&prefix=em_submission_module&page=module-repo-api

tertek

# Clear Build Cache
# https://docs.docker.com/engine/reference/commandline/builder_prune/
$ docker builder prune

# Remove Image
# https://docs.docker.com/engine/reference/commandline/image_rm/
$ docker image rm IMAGE

# Run docker build with output to console
# https://stackoverflow.com/a/69524819/3127170

tertek

Example package with structure:

project
│   composer.json
│   ...
│
└───packagename
│   │   composer.json
│   │
│ └───src

tertek

<?php

    function addRepeatingForm($projectId=null, $eventId=null, $form=null, $customLabel=null) {

        //  Prepare parameters
        if($projectId === null) {
            $projectId = PROJECT_ID;
        }

        if($eventId === null){

tertek

def hello():
  return "Hello World from Github"

test = hello()

output = [{'test-2': test}]

tertek

#!/bin/bash
set -euo pipefail

########################
### SCRIPT VARIABLES ###
########################

# Name of the user to create and grant sudo privileges
USERNAME=sammy

tertek

function makeThumb(page) {
        // draw page to fit into 96x96 canvas
        var vp = page.getViewport({ scale: 1, });
        var canvas = document.createElement("canvas");
        var scalesize = 1;
        canvas.width = vp.width * scalesize;
        canvas.height = vp.height * scalesize;
        var scale = Math.min(canvas.width / vp.width, canvas.height / vp.height);
        console.log(vp.width, vp.height, scale);
        return page.render({ canvasContext: canvas.getContext("2d"), viewport: page.getViewport({ scale: scale }) }).promise.then(function () {