Roberto Spadim rspadim
rspadim
/ gist:9ae10b849725ce7cbf4d617a035f46d0
Last active
October 10, 2021 03:18
Cognito + FastAPI + BeaverPassword + swagger + allow * cors
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
| import json | |
| import os | |
| from typing import Optional | |
| import boto3 | |
| from jose import jws | |
| from pydantic import BaseModel | |
| from starlette.middleware.cors import CORSMiddleware | |
| from starlette.status import HTTP_401_UNAUTHORIZED | |
| from fastapi.security import OAuth2PasswordBearer, OAuth2PasswordRequestForm, HTTPBearer, HTTPAuthorizationCredentials | |
| from fastapi import FastAPI, Depends, Security, HTTPException |
rspadim
/ gist:835361480550ba31b1f50412f45e50b3
Created
May 30, 2019 12:04
Filter most frequent WINEDEBUG informations
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
| WINE_DEBUG=any_thing wine64 some_executable.exe &> stderr.txt | |
| ---- | |
| python3 | |
| ---- | |
| import os | |
| f = open("stderr.txt", 'r') | |
| f.seek(0, os.SEEK_SET) |
rspadim
/ gist:d4ac40b2d7f3b379ee53
Created
August 21, 2014 20:58
SQL - LEGENDAS DE TODO BRASIL - RETIRADO DE (http://agencia.tse.jus.br/estatistica/sead/odsele/consulta_legendas/consulta_legendas_2014.zip) DIA 21/08/2014 17:21 BRT
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
| -- -------------------------------------------------------- | |
| -- Versão do servidor: 10.0.10-MariaDB-log - MariaDB Server | |
| -- OS do Servidor: Linux | |
| -- -------------------------------------------------------- | |
| CREATE TABLE IF NOT EXISTS `legendas` ( | |
| `DATA_GERACAO` varchar(255) DEFAULT NULL COMMENT 'Data de geração do arquivo (data da extração)', | |
| `HORA_GERACAO` varchar(255) DEFAULT NULL COMMENT 'Hora de geração do arquivo (hora da extração) - Horário de Brasília', | |
| `ANO_ELEICAO` varchar(255) DEFAULT NULL COMMENT 'Ano da eleição', | |
| `NUM_TURNO` varchar(255) DEFAULT NULL COMMENT '(*) Número do turno', | |
| `DESCRICAO_ELEICAO` varchar(255) DEFAULT NULL COMMENT '(*) Descrição da eleição', |
rspadim
/ gist:de94f10b074b404e8b37
Created
August 21, 2014 20:22
LEGENDAS DE TODO BRASIL - RETIRADO DE (http://agencia.tse.jus.br/estatistica/sead/odsele/consulta_legendas/consulta_legendas_2014.zip) DIA 21/08/2014 17:21 BRT
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
| "20/08/2014";"20:08:24";"2014";"1";"ELEIÇÕES GERAIS 2014";"AC";"AC";"ACRE";"7";"DEPUTADO ESTADUAL";"COLIGACAO";"13";"PT";"PARTIDO DOS TRABALHADORES";"#NE#";"FRENTE POPULAR DO ACRE 5";"PT / PEN / PROS" | |
| "20/08/2014";"20:08:24";"2014";"1";"ELEIÇÕES GERAIS 2014";"AC";"AC";"ACRE";"7";"DEPUTADO ESTADUAL";"COLIGACAO";"51";"PEN";"PARTIDO ECOLÓGICO NACIONAL";"#NE#";"FRENTE POPULAR DO ACRE 5";"PT / PEN / PROS" | |
| "20/08/2014";"20:08:24";"2014";"1";"ELEIÇÕES GERAIS 2014";"AC";"AC";"ACRE";"7";"DEPUTADO ESTADUAL";"COLIGACAO";"90";"PROS";"PARTIDO REPUBLICANO DA ORDEM SOCIAL";"#NE#";"FRENTE POPULAR DO ACRE 5";"PT / PEN / PROS" | |
| "20/08/2014";"20:08:24";"2014";"1";"ELEIÇÕES GERAIS 2014";"AC";"AC";"ACRE";"10";"2º SUPLENTE";"COLIGACAO";"12";"PDT";"PARTIDO DEMOCRÁTICO TRABALHISTA";"#NE#";"FRENTE POPULAR DO ACRE";"PDT / PRB / PT / PSL / PTN / PSDC / PHS / PSB / PRP / PEN / PPL / PC do B / PROS / PTB" | |
| "20/08/2014";"20:08:24";"2014";"1";"ELEIÇÕES GERAIS 2014";"AC";"AC";"ACRE";"9";"1º SUPLENTE";"COLIGACAO";"12";"PDT";"PARTIDO DEMOCRÁTIC |
rspadim
/ gist:591e7df42eaa7ffcdead
Created
August 21, 2014 20:20
VAGAS PARA ELEIÇÕES - retirado de (http://agencia.tse.jus.br/estatistica/sead/odsele/consulta_vagas/consulta_vagas_2014.zip) DIA 21/08/2014 17:20
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
| "20/08/2014";"20:08:24";"2014";"Eleições Gerais 2014";"AC";"AC";"ACRE";"3";"Governador";"1" | |
| "20/08/2014";"20:08:24";"2014";"Eleições Gerais 2014";"AC";"AC";"ACRE";"4";"Vice-governador";"1" | |
| "20/08/2014";"20:08:24";"2014";"Eleições Gerais 2014";"AC";"AC";"ACRE";"5";"Senador";"1" | |
| "20/08/2014";"20:08:24";"2014";"Eleições Gerais 2014";"AC";"AC";"ACRE";"6";"Deputado Federal";"8" | |
| "20/08/2014";"20:08:24";"2014";"Eleições Gerais 2014";"AC";"AC";"ACRE";"7";"Deputado Estadual";"24" | |
| "20/08/2014";"20:08:24";"2014";"Eleições Gerais 2014";"AC";"AC";"ACRE";"9";"1º Suplente";"1" | |
| "20/08/2014";"20:08:24";"2014";"Eleições Gerais 2014";"AC";"AC";"ACRE";"10";"2º Suplente";"1" | |
| "20/08/2014";"20:08:24";"2014";"Eleições Gerais 2014";"AL";"AL";"ALAGOAS";"3";"Governador";"1" | |
| "20/08/2014";"20:08:24";"2014";"Eleições Gerais 2014";"AL";"AL";"ALAGOAS";"4";"Vice-governador";"1" | |
| "20/08/2014";"20:08:24";"2014";"Eleições Gerais 2014";"AL";"AL";"ALAGOAS";"5";"Senador";"1" |
rspadim
/ gist:dcff5b3d7922be6531cb
Created
August 21, 2014 20:20
CANDIDATOS DE TODO O BRASIL- RETIRADO DE (http://agencia.tse.jus.br/estatistica/sead/odsele/consulta_cand/consulta_cand_2014.zip) DIA 21/08/2014 17:16 BRT
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
| "20/08/2014";"20:08:22";"2014";"1";"Eleições Gerais 2014";"AC";"AC";"ACRE";"7";"DEPUTADO ESTADUAL";"REGINALDO DA SILVA CORDEIRO";"10000000072";"55789";"REGINALDO CORDEIRO";"2";"DEFERIDO";"55";"PSD";"PARTIDO SOCIAL DEMOCRÁTICO";"10000000022";"#NULO#";"PSD";"PARTIDO ISOLADO";"166";"LOCUTOR E COMENTARISTA DE RÁDIO E TELEVISÃO E RADIALISTA";"06/07/1953";"000651892437";"61";"2";"MASCULINO";"4";"ENSINO FUNDAMENTAL COMPLETO";"3";"CASADO(A)";"03";"PARDA";"1";"BRASILEIRA NATA";"AC";"-3";"TARAUACÁ";"400000";"-1";"#NULO#" | |
| "20/08/2014";"20:08:22";"2014";"1";"Eleições Gerais 2014";"AC";"AC";"ACRE";"7";"DEPUTADO ESTADUAL";"FRANCISCO ROQUE DA COSTA";"10000000073";"55800";"ROQUE DA PUBLICIDADE";"2";"DEFERIDO";"55";"PSD";"PARTIDO SOCIAL DEMOCRÁTICO";"10000000022";"#NULO#";"PSD";"PARTIDO ISOLADO";"257";"EMPRESÁRIO";"01/01/1967";"000694562488";"47";"2";"MASCULINO";"4";"ENSINO FUNDAMENTAL COMPLETO";"9";"DIVORCIADO(A)";"03";"PARDA";"1";"BRASILEIRA NATA";"AC";"-3";"XAPURI";"400000";"-1";"#NULO#" | |
| "20/08/2014";"20:08:22";"2014";"1"; |
rspadim
/ gist:f839a9cae4e274577a1d
Created
August 21, 2014 19:58
SQL - ZONAS ELEITORAIS - RETIRADO DE (http://www.tse.jus.br/eleitor/zonas-eleitorais/pesquisa-a-zonas-eleitorais) DIA 21/08/2014 16:40 BRT
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
| -- -------------------------------------------------------- | |
| -- Versão do servidor: 10.0.10-MariaDB-log - MariaDB Server | |
| -- OS do Servidor: Linux | |
| -- -------------------------------------------------------- | |
| -- Copiando estrutura para tabela teste.zonas | |
| CREATE TABLE IF NOT EXISTS `zonas` ( | |
| `Nr_Zona` int(11) NOT NULL DEFAULT '0', | |
| `Cod_Processual_65_CNJ` varchar(255) NOT NULL DEFAULT '', | |
| `Endereço` varchar(255) NOT NULL DEFAULT '', |
rspadim
/ gist:e1a330078234f82c7533
Created
August 21, 2014 19:40
ZONAS ELEITORAIS - RETIRADO DE (http://www.tse.jus.br/eleitor/zonas-eleitorais/pesquisa-a-zonas-eleitorais) DIA 21/08/2014 16:40 BRT
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
| "Nr Zona";"Cod Processual Res nº 65/CNJ";"Endereço";"CEP";"Bairro";"Município Sede";"UF"; | |
| "1";"01-0001";"FÓRUM ELEITORAL, BR 364, KM 02, ALAMEDA MIN. MIGUEL FERRANTE, S/N";"69915632";"PORTAL DA AMAZONIA";"RIO BRANCO";"AC" | |
| "2";"01-0002";"RUA CORONEL BRANDÃO, 1972";"69930000";"AEROPORTO";"XAPURI";"AC" | |
| "3";"01-0003";"RUA CUNHA VASCONCELOS, 659";"69940000";"CENTRO";"SENA MADUREIRA";"AC" | |
| "4";"01-0004";"AV RODRIGUES ALVES, N 309";"69980000";"CENTRO";"CRUZEIRO DO SUL";"AC" | |
| "5";"01-0005";"RUA FLORIANO PEIXOTO, 160";"69970000";"CENTRO";"TARAUACÁ";"AC" | |
| "6";"01-0006";"AV. RUI LINO, N. 1128 - CENTRO";"69932000";"CENTRO";"BRASILÉIA";"AC" | |
| "7";"01-0007";"RUA CORNELIO DE OLIVEIRA LIMA, 81";"69960000";"CIDADE NOVA";"FEIJÓ";"AC" | |
| "8";"01-0008";"RUA 03 DE MAIO, 1.397";"69925000";"CENTRO";"SENADOR GUIOMARD";"AC" | |
| "9";"01-0009";"CENTRAL DE ATENDIMENTO AO ELEITOR BR 364 KM 02";"69914220";"DISTRITO INDUSTRIAL";"RIO BRANCO";"AC" |