Skip to content

Instantly share code, notes, and snippets.

View felipsmartins's full-sized avatar
🇧🇷
loading, please wait a few seconds...

Martins, F. felipsmartins

🇧🇷
loading, please wait a few seconds...
46 followers · 116 following
View GitHub Profile
@felipsmartins
felipsmartins / total_row_count_from_database.sql
Last active February 8, 2020 23:24
total_row_count_from_database
SELECT SUM(TABLE_ROWS) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'MY_DATABASE_NAME';
SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'MY_DATABASE_NAME' order by table_rows;
@felipsmartins
felipsmartins / watchdog.py
Last active December 9, 2019 07:34
automatic rerun Go app on file changes
#!/usr/bin/env python2
# coding=utf-8
from __future__ import print_function, division
__author__ = "Martins, F."
__doc__ = """
System requirements (Debian):
- libnotify-bin (notify-send - optional)
@felipsmartins
felipsmartins / phpstorm_config_file_types.md
Last active November 18, 2019 17:16
Fazer IDE (phpstorm) ver arquivos .html como twig, zf2

Edifor -> File Types

  1. Na seção Recognized File Types buscar por Twig e clicar nele
  2. Na seção Registered Patterns, adicionar a o seguinte pattern: *?html
@felipsmartins
felipsmartins / start_server.sh
Created May 23, 2019 16:15
PHP built-in server with env vars
# https://github.com/symfony/symfony/pull/10914
# https://www.php.net/manual/en/ini.core.php#ini.variables-order
# i.e:
APPLICATION_ENV=development php -d variables_order=EGPCS -S 0.0.0.0:8080 -t public/
@felipsmartins
felipsmartins / laravel_homestead_php56.sh
Last active May 17, 2019 16:05
laravel homestead php 56, php56, php-5.6
#!/usr/bin/env bash
# script de provisionamento para laravel/homestead 7.16.*
# onde PHP 5.6 não está disponível
# atual ppa para php5.6
sudo add-apt-repository ppa:ondrej/php
sudo apt update
sudo apt install php5.6
@felipsmartins
felipsmartins / xdebug_2_5_5_rebuild_for_php56.sh
Last active February 13, 2019 19:50
xdebug rebuild script
#/bin/sh
# NOTA:
# precisei disso pra compilar a extensão contra PHP5.6, desde que o padrão no sistema (homestead) era 7.1 e pecl aponta para o 7.
# As instruções padrões estão em: https://github.com/derickr/xdebug
# mas não funciona em caso onde você quer usar o non-default PHP.
#testado contra PHP 5.6:
# phpize5.6
# php-config5.6
@felipsmartins
felipsmartins / mysqldump.sh
Last active January 3, 2019 17:56
#!/usr/bin/env bash
HOST=127.0.0.1
USER=root
PASSWD=root
OUTPATH=./
# backup de base dados
DATABASES="
database1
database2
@felipsmartins
felipsmartins / boost.sh
Created December 14, 2018 20:21
boost GPU&CPU
# /etc/rc.local
# GPU no máximo
nvidia-settings -a GPUPowerMizerMode=1
# CPU GOV
# performance ou powersave
G_SWITCH=performance
cpufreq-set -g $G_SWITCH -c 0
@felipsmartins
felipsmartins / MainActivity.java
Created October 20, 2018 09:49
package com.example.deodorojr.compartilharsommp3;
import android.Manifest;
import android.content.Intent;
import android.content.pm.PackageManager;
import android.net.Uri;
import android.support.v4.app.ActivityCompat;
import android.support.v4.content.ContextCompat;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
@felipsmartins
felipsmartins / collect.xml
Created October 4, 2018 02:25
colletc POSXML
<stringvariable variable="screen_title" value="COLETA NORMAL" />
<stringvariable variable="arquivo_coletas" value="ultima_coleta.txt" />
<stringvariable variable="arquivo_residuos" value="wastes.txt" />
<stringvariable variable="posto_user_info" value="" />
<stringvariable variable="is_valid_uc" value="1" />
<stringvariable variable="__residuos_coletados" value="" /> <!-- lista de coletas -->
<stringvariable variable="__input_uc" value="" />
<stringvariable variable="__input_codigo_residuo" value="" />
<stringvariable variable="__input_quantidade_residuo" value="" />
<stringvariable variable="__residuo_valor_unitario" value="" />