chapeupreto

SELECT 
  pool_name,
  COUNT(*) AS total,
  (SELECT 
    COUNT(*) 
  FROM
    radius.radippool r2 
  WHERE r1.pool_name = r2.pool_name 
    AND NASIPAddress <> '' 
  GROUP BY pool_name) AS allocated 

chapeupreto

# this should be included in .bashrc or /etc/profile
# this function extracts the hostname of a url

function h()
{
    [[ -z $1 ]] && echo "url deve ser fornecida" && return 1
    echo "$1" | sed -E 's#(ftp|https?)://## ; s#:[0-9]*##g ; s#/.*##'
}

chapeupreto

https://github.com/andrewpuch/code-commit-setup

chapeupreto

#!/bin/bash

function formata()
{
    local data="$1"
	
    local dia="${data:(-2)}"
    local mes="${data:5:2}"
    local ano="${data:0:4}"

chapeupreto

Instalação mongodb (1.1.8) com PHP5.6 (Ubuntu 14.04.5 LTS)

sudo apt-get install -y php5.6-dev
sudo apt-get install -y php-pear
sudo apt-get install -y pkg-config

sudo pecl channel-update pecl.php.net
sudo pecl install mongodb

chapeupreto

http://docs.aws.amazon.com/codecommit/latest/userguide/how-to-notify-lambda-cc.html#how-to-notify-lam-perm

chapeupreto

<?php

function getRawSql(string $sql, array $inputs)
{
	foreach ($inputs as $input) {
		$index = strpos($sql, '?');
		$f = substr($sql, 0, $index);
		$f .= is_string($input) ? "'" . $input . "'" : $input;
		$t = substr($sql, $index + 1);
		$sql = $f . $t;