Skip to content

Instantly share code, notes, and snippets.

View olucasmac's full-sized avatar
👾
“Be excellent to each other.”

Lucas M. A. Costa olucasmac

👾
“Be excellent to each other.”
90 followers · 132 following
View GitHub Profile
@olucasmac
olucasmac / commands.php
Created March 20, 2018 19:57 — forked from ChgoChad/commands.php
Script to run Mautic (https://mautic.org) commands from a URL.
<?php
if (!isset($_GET['ILoveMautic'])) {
echo 'The secret phrase is wrong.';
die;
}
$link = "https://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";
$allowedTasks = array(
'cache:clear',
@olucasmac
olucasmac / boto-elastic-transcoder-manager-example.py
Created March 20, 2018 20:13 — forked from mingrammer/boto-elastic-transcoder-manager-example.py
Python script for AWS Elastic Transcoder with boto api
# -*- coding: utf-8 -*-
import hashlib
import boto3
class ETSManager:
"""
@todo: manages and provides the ets services
@olucasmac
olucasmac / liberar-username-wordpress-multisite
Created May 24, 2018 19:38 — forked from erikasarti/liberar-username-wordpress-multisite
Como liberar um username bloqueado no WordPress Multisite
// Remove um nome de usuário reservado no WordPress Multisite
function erikasarti_remove_usuario_multisite( $user_login ) {
global $wpdb;
$success = false;
if ( false !== $wpdb->delete( $wpdb->signups, array( 'user_login' => sanitize_text_field( $user_login ) ) ) ) {
$success = true;
@olucasmac
olucasmac / postgres_queries_and_commands.sql
Created July 3, 2018 13:07 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(query_start, clock_timestamp()), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
@olucasmac
olucasmac / psql_useful_stat_queries.sql
Created July 3, 2018 13:07 — forked from anvk/psql_useful_stat_queries.sql
List of some useful Stat Queries for PSQL
--- PSQL queries which also duplicated from https://github.com/anvk/AwesomePSQLList/blob/master/README.md
--- some of them taken from https://www.slideshare.net/alexeylesovsky/deep-dive-into-postgresql-statistics-54594192
-- I'm not an expert in PSQL. Just a developer who is trying to accumulate useful stat queries which could potentially explain problems in your Postgres DB.
------------
-- Basics --
------------
-- Get indexes of tables
@olucasmac
olucasmac / count_to_date.js
Created July 13, 2018 11:44 — forked from noahub/count_to_date.js
Add a Countdown to a Date
<script>
countdown('06/26/2017 8:00 PM', 'timer'); //date format: mm/dd/yyyy hh:mm AM
function countdown(dt, id)
{
var end = new Date(dt);
var _second = 1000;
var _minute = _second * 60;
var _hour = _minute * 60;
var _day = _hour * 24;
@olucasmac
olucasmac / node_exporter.sh
Last active April 15, 2020 02:37 — forked from galexrt/node_exporter.sh
Simple Prometheus node_exporter install script
#!/bin/bash
version="${VERSION:-0.18.1}"
arch="${ARCH:-linux-amd64}"
bin_dir="${BIN_DIR:-/usr/local/bin}"
wget "https://github.com/prometheus/node_exporter/releases/download/v$version/node_exporter-$version.$arch.tar.gz" \
-O /tmp/node_exporter.tar.gz
mkdir -p /tmp/node_exporter
@olucasmac
olucasmac / git.md
Created April 3, 2019 17:05 — forked from leocomelli/git.md
Lista de comandos úteis do GIT

#GIT

Estados

  • Modificado (modified);
  • Preparado (staged/index)
  • Consolidado (comitted);

Ajuda

@olucasmac
olucasmac / Kubernetes - Tips.md
Created May 2, 2019 17:20 — forked from savishy/Kubernetes - Tips.md
Kubernetes Cheatsheet

About kubeconfig and Sharing kubeconfigs

When you create a Google Cloud Container cluster with gcloud container clusters create it also generates a kubeconfig entry. See the output below:

Creating cluster petclinic...done.
Created [https://container.googleapis.com/v1/projects/gcloud-testing-vish/zones/asia-east1-a/clusters/petclinic].
kubeconfig entry generated for petclinic.
NAME       LOCATION      MASTER_VERSION  MASTER_IP       MACHINE_TYPE   NODE_VERSION  NUM_NODES  STATUS
@olucasmac
olucasmac / mysql-docker.sh
Created April 20, 2020 23:49 — forked from spalladino/mysql-docker.sh
Backup and restore a mysql database from a running Docker mysql container
# Backup
docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql
# Restore
cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE