jpetitcolas

-- Decoding
SELECT CONVERT_FROM(DECODE(field, 'BASE64'), 'UTF-8') FROM table;

-- Encoding
SELECT ENCODE(CONVERT_TO(field, 'UTF-8'), 'base64') FROM table;

jpetitcolas

aws logs start-query \
    --profile [PROFILE] \
    --log-group-name [GROUP_NAME] \
    --start-time `date --date="-30 minutes" "+%s"` \
    --end-time `date "+%s"` \
    --query-string 'fields @message | limit 50' \
    | jq '.queryId' \
    | xargs -I{} aws --profile [PROFILE] logs get-query-results --query-id {} \
    | jq '.results | .[][0].value'

jpetitcolas

<table>
    {% for record in records %}
        <tr class="record{% if loop.index is divisibleby(2) %}even{% else %}odd{% endif %}">
            <td>{{ record.id }}</td>
            <td>{{ record.title }}</td>
        </tr>
    {% endfor %}
</table>

jpetitcolas

/**
 * Camelize a string, cutting the string by separator character.
 * @param string Text to camelize
 * @param string Word separator (underscore by default)
 * @return string Camelized text
 */
function camelize(text, separator) {
 
  // Assume separator is _ if no one has been provided.
  if(typeof(separator) == "undefined") {

jpetitcolas

driver.manage().logs()
    .get('browser')
    .then(v => v && v.length && console.log(v));

jpetitcolas

/*
Python and Node don't stringify JSON object the same way. 
Python adds some spaces after `:` and `,`, causing some trouble if
you try to compute the same hashes across languages.

Here is a Node function turning a Node generated JSON string into
its Python equivalent.
*/
export const pythonizeJsonDump = (jsonDump) =>
    jsonDump.replace(/(?!\B"[^"]*)(:|,)(?![^"]*"\B)/g, '$1 ');

jpetitcolas

package main

import (
    "bytes"
    "encoding/binary"
    "fmt"
    "log"
    "os"
)

jpetitcolas

const COLUMN_NAME = "Deployed to Prod"

var column = [...document.querySelectorAll(".BoardBody-column")].filter(
    column =>
        column.querySelector('.BoardColumnHeader-name') &&
        column.querySelector('.BoardColumnHeader-name').textContent == COLUMN_NAME
)[0]

Array.from(column.querySelectorAll(".BoardCard")).map(card => {
	card.querySelector(".BoardCard-dropdownButton").click()

jpetitcolas

#!/bin/sh
#
# Based on http://nrocco.github.io/2012/04/19/git-pre-commit-hook-for-PHP.html post
#
# Do not forget to: chmod +x .git/hooks/pre-commit

BAD_PHP_WORDS='var_dump|die|todo'
BAD_TWIG_WORDS='{{ dump(.*) }}'

EXITCODE=0

jpetitcolas

/**
 * Uncamelize a string, joining the words by separator character.
 * @param string Text to uncamelize
 * @param string Word separator
 * @return string Uncamelized text
 */
function uncamelize(text, separator) {
 
  // Assume separator is _ if no one has been provided.
  if(typeof(separator) == "undefined") {