Skip to content

Instantly share code, notes, and snippets.

View isaqueprofeta's full-sized avatar
🎯
Focusing

Isaque Profeta isaqueprofeta

🎯
Focusing
109 followers · 8 following
View GitHub Profile
@isaqueprofeta
isaqueprofeta / docker-compose.yml
Created October 2, 2019 20:53
Simple Zabbix Lab using official images (need to create some folder volumes and import zapix project from monitoringartist)
version: '3'
volumes:
db_data:
driver: local
grafana_data:
driver: local
networks:
app_net:
@isaqueprofeta
isaqueprofeta / install.sh
Last active April 17, 2020 03:25
My theme with cursive font setup in vscode for python
# For Ubuntu 18.04
# If you dont have one, create personal font dir
mkdir ~/.fonts
# Clone FiraCodeiScript
git clone https://github.com/kencrocken/FiraCodeiScript.git /tmp/FiraCodeiScript
mv /tmp/FiraCodeiScript/*.ttf ~/.fonts
# Rebuild font cache
@isaqueprofeta
isaqueprofeta / rename.sh
Created March 1, 2020 05:02
Batch rename removing a pattern on bash
#!/bin/bash
for my_files in *; do mv -v "$my_files" "${my_files/my pattern to remove/}";done
@isaqueprofeta
isaqueprofeta / show_size.sql
Created January 24, 2020 21:38
Check size of tables and objects in PostgreSQL database
SELECT
relname as "Table",
pg_size_pretty(pg_total_relation_size(relid)) As "Size",
pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as "External Size"
FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;
@isaqueprofeta
isaqueprofeta / speedtest.sh
Created September 3, 2018 19:59
Retorna a velocidade de download de um arquivo para coleta via zabbix
#!/bin/bash
# ARQUIVO A SER FEITO O DOWNLOAD
# FONTE: https://www.thinkbroadband.com/download
download='http://ipv4.download.thinkbroadband.com/10MB.zip'
# EXECUTA DONWLOAD
# --report-speed=bits = APRESENTA A INFORMAÇÃO EM BITS/SEGUNDO
# -o /dev/stdout = SAÍDA DE INFORMAÇÃO PARA O SCRIPT
@isaqueprofeta
isaqueprofeta / common.py
Created August 24, 2018 17:41
Coleção de funções de manipulação para python
#!/usr/bin/python3.5
import os
def importa_ssl():
"""
Importa certificados SSL
"""
# CentOS 7.5
if os.path.exists("/etc/pki/ca-trust/extracted/openssl/ca-bundle.trust.crt"):
@isaqueprofeta
isaqueprofeta / php_zabbix_api.md
Last active April 17, 2020 18:25
Usando a API do zabbix rapidamente em PHP

Instalar PHP:

sudo apt-get install php7.0 php7.0-cli php7.0-common php7.0-curl

Instalar Composer:

sudo php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');"
sudo php composer-setup.php
sudo php -r "unlink('composer-setup.php');"
@isaqueprofeta
isaqueprofeta / Dockerfile
Created March 7, 2018 23:00
phpipam_docker_72
FROM php:7.2-apache
MAINTAINER Pierre Cheynier <pierre.cheynier@gmail.com>
ENV PHPIPAM_SOURCE https://github.com/phpipam/phpipam/
ENV PHPIPAM_VERSION 1.3.1
ENV PHPMAILER_SOURCE https://github.com/PHPMailer/PHPMailer/
ENV PHPMAILER_VERSION 5.2.21
ENV PHPSAML_SOURCE https://github.com/onelogin/php-saml/
ENV PHPSAML_VERSION 2.10.6
ENV WEB_REPO /var/www/html
@isaqueprofeta
isaqueprofeta / docker-compose.yml
Last active April 17, 2020 18:25
Postgres and Pgadmin4 with volumes
version: '2'
volumes:
db_data:
driver: local
pgadmin_data:
driver: local
services:
db:
@isaqueprofeta
isaqueprofeta / laravel_postgresschema2json.php
Created January 24, 2018 19:15
<?php
use Illuminate\Support\Facades\DB;
$query = "SELECT tables.table_name, columns.column_name, columns.data_type, columns.udt_name FROM information_schema.tables AS tables JOIN information_schema.columns AS columns ON tables.table_name = columns.table_name WHERE tables.table_type = 'BASE TABLE' AND tables.table_schema NOT IN ('pg_catalog', 'information_schema')";
$data = json_decode(collect(DB::select($query)));