robbles

robbles

--
-- NOTE: this will just give you the original data if the attribute is not present.
-- You might need to wrap it in an IF somehow if it's not always there.
--
SELECT
  substring_index(substring_index(TABLE.JSON_COLUMN, '"ATTRIBUTE_TO_EXTRACT": "', -1), '",', 1)
from TABLE.JSON_COLUMN

-- If the JSON data looks like this: {"key":"value"} instead of this: {"key": "value"} (no space after colon),
-- you'll need to use this slightly modified version:

robbles

# Find all files matching "src/*.go" and replace "src/%.go" with "bin/%"
OUTPUTS := $(patsubst src/%.go,bin/%,$(wildcard src/*.go))

# Reference all files to be built in a single rule
all: $(OUTPUTS)

# Rule for compiling a single output file in bin/
bin/%: src/%.go
	# $* is replaced with the value of the wildcard in the rule (%)
	go build -o bin/$* src/$*.go

robbles

def runserver(app, port=5000, profile_log=None):
    """Runs a development server."""
    from werkzeug.serving import run_with_reloader
    from werkzeug.debug import DebuggedApplication
    from werkzeug.contrib.profiler import ProfilerMiddleware
    
    app.debug = True
    
    port = int(port)

robbles

#!/bin/bash

socat -d -d pty,raw,echo=0,link=/tmp/ttysA1 pty,raw,echo=0,link=/tmp/ttysB1 &
socat -d -d pty,raw,echo=0,link=/tmp/ttysA2 pty,raw,echo=0,link=/tmp/ttysB2 &
socat -d -d pty,raw,echo=0,link=/tmp/ttysA3 pty,raw,echo=0,link=/tmp/ttysB3 &
socat -d -d pty,raw,echo=0,link=/tmp/ttysA4 pty,raw,echo=0,link=/tmp/ttysB4 &
socat -d -d pty,raw,echo=0,link=/tmp/ttysA5 pty,raw,echo=0,link=/tmp/ttysB5 &

robbles

var crypto = require('crypto');

var message = 'GET /foo/bar?arg1=aaaa&arg2=bbbb';
var secret = 'secret';

crypto.createHmac('sha256', secret).update(message).digest('base64');
// '82LHSJc4h/5BpLrBcGyWjTIiLuJTBYkgyGAb7cNmXew='

robbles

#!/usr/bin/env node

var spawn = require('child_process').spawn;
var extname = require('path').extname;

// where to store the virtual ports while running
var virtual_port_dir = '/tmp/';

// socat displays this when successfully connected
var success_str = 'starting data transfer loop';

robbles

/**
 * Simple jQuery plugin that replaces $.click with a mobile-responsive version
 * that doesn't break scrolling.
 */
(function($){
  $.fn.extend({ 
    clickTouch: function(handler) {
       return this.each(function() {
         var touchedWithoutScroll = false;
         var self = $(this);

robbles

require
global
process
console
log
error
warning
Buffer
__filename
__dirname

robbles

#!/bin/bash
# virtualenv-auto-activate.sh
# 
# Installation:
#   Add this line to your .bashrc or .bash-profile:
#
#       source /path/to/virtualenv-auto-activate.sh
#
#   Go to your project folder, run "virtualenv .venv", so your project folder
#   has a .venv folder at the top level, next to your version control directory.