Skip to content

Instantly share code, notes, and snippets.

View arturoleon's full-sized avatar

Arturo Leon arturoleon

View GitHub Profile
@arturoleon
arturoleon / supervisord.service
Created October 21, 2019 05:45 — forked from mozillazg/supervisord.service
install and configure supervisord on centos 7.
[Unit]
Description=supervisord - Supervisor process control system for UNIX
Documentation=http://supervisord.org
After=network.target
[Service]
Type=forking
ExecStart=/bin/supervisord -c /etc/supervisord/supervisord.conf
ExecReload=/bin/supervisorctl reload
ExecStop=/bin/supervisorctl shutdown
@arturoleon
arturoleon / estados_mexico.sql
Last active July 20, 2018 15:46
Estados de México para Magento
-- Los códigos de estado corresponden al estándar ISO 3166-2:MX
-- Deberás cambiar el nombre de la tabla si estás utilizando un prefijo
INSERT INTO `directory_country_region` (`country_id`, `code` , `default_name`)
VALUES
('MX', 'AGU', 'Aguascalientes'),
('MX', 'BCN', 'Baja California'),
('MX', 'BCS', 'Baja California Sur'),
('MX', 'CAM', 'Campeche'),
('MX', 'CHP', 'Chiapas'),
('MX', 'CHH', 'Chihuahua'),

Keybase proof

I hereby claim:

  • I am arturoleon on github.
  • I am arturoleon (https://keybase.io/arturoleon) on keybase.
  • I have a public key ASCL9p60WKHjon-YrkXcNh1WnVr_pJtVh4FD8tNb8RRn5Qo

To claim this, I am signing this object:

@arturoleon
arturoleon / app.js
Last active January 6, 2018 03:55
Loading window for Titanium Mobile
//Usage example
var win = Ti.UI.createWindow();
var loadingWindow = require('LoadingWindow')();
win.add(loadingWindow);
//win.remove(loadingWindow)
win.open();
@arturoleon
arturoleon / tunnel.py
Created October 19, 2017 14:38
SSH Tunnel for MySQLdb in Python
import MySQLdb
import sshtunnel
with sshtunnel.SSHTunnelForwarder(
("remote_ip", 22),
ssh_username="centos",
ssh_pkey="~/.ssh/id_rsa",
remote_bind_address=("mysql_host", 3306),
) as tunnel:
connection = MySQLdb.connect(
@arturoleon
arturoleon / app.js
Created January 29, 2014 01:31
Aplicación de ejemplo: Mapas
//http://j.mp/ejemplomodulos
(function(){
var db = Titanium.Database.open('tabla');
db.execute('CREATE TABLE IF NOT EXISTS favoritos (fila INTEGER)');
var tabla = require('tabla');
var favoritos = require('favoritos');
var mapa = require('mapa');
var tabGroup = Ti.UI.createTabGroup();
@arturoleon
arturoleon / app.js
Last active January 3, 2016 13:09
Ejemplo de módulos
//http://j.mp/ejemplomodulos
(function(){
var db = Titanium.Database.open('tabla');
db.execute('CREATE TABLE IF NOT EXISTS favoritos (fila INTEGER)');
var tabla = require('tabla');
var favoritos = require('favoritos');
var tabGroup = Ti.UI.createTabGroup();
var win1 = tabla(),
@arturoleon
arturoleon / app.js
Last active January 2, 2016 18:49
Ejercicio de ejemplo para Titanium con bases de datos
(function(){
var bd = Ti.Database.open('baseDeDatosCompleta');
bd.file.setRemoteBackup(false);
bd.execute('CREATE TABLE IF NOT EXISTS entradas(id INTEGER PRIMARY KEY, nombre TEXT, apellido TEXT);');
var ventanaInicio = require('ventanaInicio');
ventanaInicio(bd).open();
})();
@arturoleon
arturoleon / gist:5833945
Created June 21, 2013 20:07
Count and sort IP's by accesses number.
cat access_log |awk '{print $1}' |sort | uniq -c | sort -n
@arturoleon
arturoleon / s3backup.rb
Created May 29, 2013 04:33
Script to copy incremental daily cpanel backups to a S3 bucket.
require 'rubygems'
require 'aws-sdk'
backup_dir = "/backup/cpbackup/" #end with /
users = "appspinc,arturo" #cpanel accounts to backup
users = users.split(",")
bucket = 'BUCKET_NAME'