viewpnt

#! /bin/bash
set -e
echo 01 > ca.srl
openssl genrsa -out ca-key.pem

cat << CNF > ca.cnf
req_extensions = v3_req

[ req ]
distinguished_name     = req_distinguished_name

viewpnt

def paridad_dolar_dof(dia, mes, year ):
	""" funcion python para extraer tipo de cambio del colar
	segun el Diario Oficial de la Federacion
	Autor : @jdaguilera
	"""
	from BeautifulSoup import BeautifulSoup
	from urllib2 import urlopen
	url = "http://dof.gob.mx/indicadores_detalle.php?cod_tipo_indicador=158&dfecha={0:02d}%2F{1:02d}%2F{2}&hfecha={0:02d}%2F{1:02d}%2F{2}".format( dia, mes, year)
	contents = urlopen(url).read()
	soup = BeautifulSoup( contents )

viewpnt

CREATE OR REPLACE FUNCTION public.json_append(data json, insert_data json)
RETURNS json
IMMUTABLE
LANGUAGE sql
AS $$
    SELECT ('{'||string_agg(to_json(key)||':'||value, ',')||'}')::json
    FROM (
        SELECT * FROM json_each(data)
        UNION ALL
        SELECT * FROM json_each(insert_data)

viewpnt

<?php
// source: http://www.paulferrett.com/2009/php-camel-case-functions/

  /**
   * Translates a camel case string into a string with underscores (e.g. firstName -&gt; first_name)
   * @param    string   $str    String in camel case format
   * @return    string            $str Translated into underscore format
   */
  function from_camel_case($str) {
    $str[0] = strtolower($str[0]);

viewpnt

git cheat-sheet

The git command-line utility has plenty of inconsistencies http://steveko.wordpress.com/2012/02/24/10-things-i-hate-about-git/

A GUI like http://sourcetreeapp.com is often helpful, but staying on the command line usually quicker. This is a list of the commands I use most frequently, listed by funcional category:

current state

git status list which (unstaged) files have changed

viewpnt

-- Create a group
CREATE ROLE readaccess;

-- Grant access to existing tables
GRANT USAGE ON SCHEMA public TO readaccess;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;

-- Grant access to future tables
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;

viewpnt

location ~* \.(txt|log|xml|css|js)$ {
    add_header X-Robots-Tag noindex;
}

viewpnt

#!/bin/bash
dn="dc=example,dc=com"
ldap_server='192.168.1.1'
group_name='group'

available_uidNumber=`expr $(ldapsearch -x -b ${dn} -h ${ldap_server} '(objectClass=posixAccount)' uidNumber | grep "uidNumber: " | sed "s|uidNumber: ||" | uniq | sort -n | tail -n 1) + 1 `
echo ${available_uidNumber}

available_gidNumber=`expr $(ldapsearch -x -b ${dn} -h ${ldap_server} '(objectClass=posixGroup)' gidNumber | grep "gidNumber: " | sed "s|gidNumber: ||" | uniq | sort -n | tail -n 1) + 1 `
echo ${available_gidNumber}

viewpnt

CREATE TABLE public.gapless_sequence (
  sequence_schema TEXT,
  sequence_name TEXT,
  last_value BIGINT DEFAULT 0,
  step INTEGER DEFAULT 1
);

ALTER TABLE public.gapless_sequence
  ADD CONSTRAINT gapless_sequence_pk PRIMARY KEY (sequence_schema, sequence_name);

viewpnt

# run this as root
while [ 1 ]; do echo | nc -l -U /tmp/reload_nginx && /etc/init.d/nginx reload; done

# or as an upstart job
script
  echo | nc -l -U /tmp/reload_nginx && /etc/init.d/nginx reload
end script
respawn

# now any process can run this or do the equivalent with sockets to trigger reload