Skip to content

Instantly share code, notes, and snippets.

View alasarr's full-sized avatar

Alberto Asuero alasarr

59 followers · 9 following
View GitHub Profile
@alasarr
alasarr / gist:ea130fd1caf2288a843f5011cff9c26b
Last active May 27, 2016 18:55
NodeJS script to migrate all repos from bitbucket to GitHub
var USER_BITBUCKET='XXX',
ORG_BITBUCKET='XXX',
PASS_BITBUCKET='XXX',
USER_GITHUB='XXX',
ORG_GITHUB='XXX',
PASS_GITHUB='XXX';
var request = require('request');
var listrepos = [];
@alasarr
alasarr / gist:46624682dcf159e08291b092ffc76452
Created May 28, 2016 10:22
GitHub API create label
#!/bin/bash
USER=XXX
ORG=XXX
PASS=XXX
REPO=XXX
# Delete default labels
curl --user "$USER:$PASS" --include --request DELETE "https://api.github.com/repos/$ORG/$REPO/labels/bug"
# curl --user "$USER:$PASS" --include --request DELETE "https://api.github.com/repos/$ORG/$REPO/labels/duplicate"
# curl --user "$USER:$PASS" --include --request DELETE "https://api.github.com/repos/$ORG/$REPO/labels/enhancement"
@alasarr
alasarr / gist:475cdd31435e8df9d78a511ba59d4b85
Created July 20, 2016 07:48
Fetch all GIT repos. Useful for backup
Users:
curl -u "XXXX" -s https://api.github.com/users/malkab/repos\?per_page\=1000 | perl -ne 'print "$1\n" if (/"ssh_url": "([^"]+)/)' | xargs -n 1 git clone
ORGS:
curl -u "XXXX" -s https://api.github.com/orgs/geographicags/repos\?per_page\=1000 | perl -ne 'print "$1\n" if (/"ssh_url": "([^"]+)/)' | xargs -n 1 git clone
@alasarr
alasarr / CARTO batch API Node sample
Created March 14, 2017 17:31
CARTO batch API sample script
var request = require("request");
var api_key = "XXXX";
var url = "https://{{account}}.carto.com/api/v2/sql/job";
var options = {
method: "POST",
url: url,
qs: {
"api_key": api_key
@alasarr
alasarr / docker.md
Last active April 11, 2017 07:20
Docker useful commands

Docker

Cleaning

docker images -qf dangling=true | xargs docker rmi
docker volume ls -f dangling=true
docker volume rm $(docker volume ls -qf dangling=true)
@alasarr
alasarr / PostgreSQL.md
Last active August 31, 2017 14:42
Useful commands PostgreSQL

PostgreSQL

Useful commands for PostgreSQL

Size

SELECT *, pg_size_pretty(total_bytes) AS total
    , pg_size_pretty(index_bytes) AS INDEX
    , pg_size_pretty(toast_bytes) AS toast
@alasarr
alasarr / OldKernelsRemover.md
Last active April 11, 2017 09:44
Remove old kernels commandline

Remove old kernels

apt-get remove --purge $(dpkg -l | tail -n +6 | grep -E 'linux-image-[0-9]+' | grep -Fv $(uname -r) |awk '{print $2}')
apt-get remove --purge $(dpkg -l | tail -n +6 | grep -E 'linux-image-extra-[0-9]+' | grep -Fv $(uname -r) |awk '{print $2}')

### Bash script

#!bin/bash
@alasarr
alasarr / template.html
Created May 30, 2017 15:51
Infowindow CARTO
<div class="cartodb-popup v2">
<a href="#close" class="cartodb-popup-close-button close">x</a>
<div class="cartodb-popup-content-wrapper">
<div class="cartodb-popup-content">
<% if (data.terrunit!='no_unit') { %>
<h4><%= data.terrunit=='delegaciones' ? Utils.tr('Delegación') : Utils.tr('Colonia') %></h4>
<p><%= data.name %><p>
<% } %>
<h4><%= data.indicator %></h4>
<p class="big"><%= Utils.nbf(data.do_value,{decimals: 0}) %></p>
@alasarr
alasarr / functions.sql
Last active June 8, 2017 18:50
HOW TO access to a private table in CARTO and get rid of NAMED MAPS.
---
-- HOW TO access to a private tabled in CARTO and get rid of NAMED MAPS.
-- It uses SECURITY DEFINER
-- tesla_supercharger is a privated table .
---
CREATE table user_tokens (token text, user_id integer, expiration timestamp);
INSERT INTO user_tokens VALUES ('eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMjM0NTY3ODkwIiwibmFtZSI6IkpvaG4gRG9lIiwiYWRtaW4iOnRydWV9.TJVA95OrM7E2cBab30RMHrHDcEfxjoYZgeFONFh7HgQ',1,now()+'10 years'::interval);
----------
@alasarr
alasarr / index.html
Last active August 28, 2017 12:05
CARTO Mapnik reserved word
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>
<script src="https://cartodb-libs.global.ssl.fastly.net/cartodb.js/v3/3.15/cartodb.js"></script>
<link rel="stylesheet" href="https://cartodb-libs.global.ssl.fastly.net/cartodb.js/v3/3.15/themes/css/cartodb.css" />
<link rel="stylesheet" href="main.css" />