I hereby claim:
- I am carlosromel on github.
- I am carlosromel (https://keybase.io/carlosromel) on keybase.
- I have a public key whose fingerprint is 018E DDDC 9531 74D0 6AAD E6E2 8886 F947 8651 2E49
To claim this, I am signing this object:
Carlos Romel Pereira da Silva carlosromel
carlosromel
/ compasso-politico.sql
Last active
June 3, 2021 16:43
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| with x (compasso, partidos) as (select 'Esquerda', array['PT', 'PDT', 'REDE', ''] | |
| union select 'Centro', array['MDB', 'PSD', 'PSDB', 'DEM', 'CIDADANIA', 'PSB'] | |
| union select 'Direita', array['PROS', 'PSL', 'PODEMOS', 'PP', 'PL', 'PSC', 'REPUBLICANOS']), | |
| senado (senador, partido, uf) as (values ('SÉRGIO PETECÂO', 'PSD', 'AC'), ('MAILZA GOMES', 'PP', 'AC'), ('MARCIO BITTAR', 'MDB', 'AC'), | |
| ('FERNANDO COLLOR', 'PROS', 'AL'), ('RENAN CALHEIROS', 'MDB', 'AL'), ('RODRIGO CUNHA', 'PSDB', 'AL'), | |
| ('PLÍNIO VALÉRIO', 'PSDB', 'AM'), ('EDUARDO BRAGA', 'MDB', 'AM'), ('OMAR AZIZ', 'PSD', 'AM'), | |
| ('DAVI ALCOLUMBRE', 'DEM', 'AP'), ( |
carlosromel
/ snx_install_linux_30.sh.b64
Created
January 4, 2021 19:46
This file has been truncated, but you can view the full file.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| IyEvYmluL3NoCkFSQ0hJVkVfT0ZGU0VUPTgwCgpUTVBfRElSPS90bXAKCkxvZ0V2ZW50KCkKewoJ | |
| ZWNobyAkMwoJaWYgWyAkMSA9IDEgXQoJdGhlbgoJCWV4aXQgJDIKCWZpCn0KCkV4dHJhY3RTTlgo | |
| KQp7Cgl0YWlsIC1uICskMSAkMiB8IGJ1bnppcDIgLWMgLSB8IChjZCAke1RNUF9ESVJ9OyB0YXIg | |
| eGYgLSkgPiAvZGV2L251bGwgMj4mMQoJaWYgWyAhICQ/IC1lcSAwIF0KCXRoZW4KCQlMb2dFdmVu | |
| dCAxIDEgImZhaWxlZCB0byBleHRyYWN0IGFyY2hpdmUiCglmaQp9CgpDbGVhbnVwKCkKewoJcm0g | |
| LWYgJHtUTVBfRElSfS9TTlhcIEluc3RhbGxlcgoJcm0gLWYgJHtUTVBfRElSfS9zbngKCXJtIC1m | |
| ICR7VE1QX0RJUn0vc254X3VuaW5zdGFsbC5zaAoJZXhpdCAwCn0KCklzTm90U3VwcGVyVXNlcigp | |
| CnsKCWlmIFsgYGlkIC11YCAhPSAwIF0KCXRoZW4KCQlyZXR1cm4gMAoJZmkKCglyZXR1cm4gMQp9 | |
| CgoKdHJhcCBDbGVhbnVwIDIKdHJhcCBDbGVhbnVwIDMKdHJhcCBDbGVhbnVwIDEzCnRyYXAgQ2xl |
carlosromel
/ snx_easy_install.sh
Last active
January 4, 2021 19:14
Instalação do cliente SNX do EndPoint VPN.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| mkdir -p ~/bin | |
| sudo apt install --yes \ | |
| libnss3-tools \ | |
| libpam0g:i386 \ | |
| libstdc++5:i386 \ | |
| libx11-6:i386 | |
| sudo apt autoremove --yes |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| mkdir -p ~/fill | |
| PONTO_MONTAGEM=$(pwd) | |
| TAMANHO=$(df "${PONTO_MONTAGEM}" | tail -n 1 | awk '{ print $4; }') | |
| QUANTIDADE=$(( ${TAMANHO} / 1000000 / 2 )) | |
| echo "Serão gerados ${QUANTIDADE} arquivos." |
carlosromel
/ keybase.md
Last active
May 16, 2018 03:38
carlosromel
/ crosstab.sql
Last active
October 31, 2017 18:31
— forked from romansklenar/crosstab.sql
PostgreSQL "pivot table" example using tablefunc extension
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE EXTENSION tablefunc; | |
| select * | |
| from (values (2007, 1, 1000), | |
| (2007, 2, 1500), | |
| (2007, 7, 500), | |
| (2007, 11, 1500), | |
| (2007, 12, 2000), | |
| (2008, 1, 1000), | |
| (2009, 5, 2500), |