carlosromel

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

IyEvYmluL3NoCkFSQ0hJVkVfT0ZGU0VUPTgwCgpUTVBfRElSPS90bXAKCkxvZ0V2ZW50KCkKewoJ
ZWNobyAkMwoJaWYgWyAkMSA9IDEgXQoJdGhlbgoJCWV4aXQgJDIKCWZpCn0KCkV4dHJhY3RTTlgo
KQp7Cgl0YWlsIC1uICskMSAkMiB8IGJ1bnppcDIgLWMgLSB8IChjZCAke1RNUF9ESVJ9OyB0YXIg
eGYgLSkgPiAvZGV2L251bGwgMj4mMQoJaWYgWyAhICQ/IC1lcSAwIF0KCXRoZW4KCQlMb2dFdmVu
dCAxIDEgImZhaWxlZCB0byBleHRyYWN0IGFyY2hpdmUiCglmaQp9CgpDbGVhbnVwKCkKewoJcm0g
LWYgJHtUTVBfRElSfS9TTlhcIEluc3RhbGxlcgoJcm0gLWYgJHtUTVBfRElSfS9zbngKCXJtIC1m
ICR7VE1QX0RJUn0vc254X3VuaW5zdGFsbC5zaAoJZXhpdCAwCn0KCklzTm90U3VwcGVyVXNlcigp
CnsKCWlmIFsgYGlkIC11YCAhPSAwIF0KCXRoZW4KCQlyZXR1cm4gMAoJZmkKCglyZXR1cm4gMQp9
CgoKdHJhcCBDbGVhbnVwIDIKdHJhcCBDbGVhbnVwIDMKdHJhcCBDbGVhbnVwIDEzCnRyYXAgQ2xl
YW51cCAxNQoKQ09NTUFORF9UT19SVU49Imluc3RhbGwgLS1vd25lcj1yb290IC0tZ3JvdXA9cm9v

carlosromel

#!/bin/bash

mkdir -p ~/bin

sudo apt install --yes \
	 libnss3-tools \
	 libpam0g:i386 \
	 libstdc++5:i386 \
	 libx11-6:i386
sudo apt autoremove --yes

carlosromel

#!/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 proof

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:

carlosromel

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),