Skip to content

Instantly share code, notes, and snippets.

View andresmrm's full-sized avatar

Andrés Martano andresmrm

60 followers · 9 following
View GitHub Profile
@andresmrm
andresmrm / gist:2cb123bad20eb93471b5
Created December 23, 2014 22:12
(IntegrityError) insert or update on table "orcamento_federal_teste__entry" violates foreign key constraint "fk_orcamento_federal_teste_orgao"
DETAIL: Key (orgao_id)=(36) is not present in table "orcamento_federal_teste__orgao".
'INSERT INTO orcamento_federal_teste__entry (id, orgao_id, funcao_id, uo_id, gnd_id, time_id, subfuncao_id, pago, amount, rppago) VALUES (%(id)s, %(orgao_id)s, %(funcao_id)s, %(uo_id)s, %(gnd_id)s, %(time_id)s, %(subfuncao_id)s, %(pago)s, %(amount)s, %(rppago)s)' {'subfuncao_id': 5, 'orgao_id': 36, 'time_id': 1, 'uo_id': 1, 'amount': 0.0, 'funcao_id': 7, 'pago': 0.0, 'gnd_id': 2, 'id': '13b451828dfb15d933f0b04671dc74220a26a0c1', 'rppago': 0.0}
@andresmrm
andresmrm / teste
Last active August 29, 2015 14:11
This file has been truncated, but you can view the full file.
"File","Ano/Mês","Órgão (Cod)","Órgão","UO (Cod)","UO","Função (Cod)","Função","Subfunção (Cod)","Subfunção","GND (Cod)","GND","Autorizado","Pago","RP Pago"
"2014-pre.csv","2014-01-01","26000","MINISTÉRIO DA EDUCAÇÃO","26276","FUNDAÇÃO UNIVERSIDADE FEDERAL DE MATO GROSSO","12","EDUCAÇÃO","364","ENSINO SUPERIOR","4","INVESTIMENTOS","57712467","0","2301380.11"
"2014-pre.csv","2014-01-01","26000","MINISTÉRIO DA EDUCAÇÃO","26235","UNIVERSIDADE FEDERAL DE GOIÁS","12","EDUCAÇÃO","364","ENSINO SUPERIOR","3","OUTRAS DESPESAS CORRENTES","106645686","6690274.08","5603560.95"
"2014-pre.csv","2014-01-01","26000","MINISTÉRIO DA EDUCAÇÃO","26298","FUNDO NACIONAL DE DESENVOLVIMENTO DA EDUCAÇÃO","12","EDUCAÇÃO","363","ENSINO PROFISSIONAL","3","OUTRAS DESPESAS CORRENTES","2861704077","0","42512503.88"
"2014-pre.csv","2014-01-01","36000","MINISTÉRIO DA SAÚDE","36201","FUNDAÇÃO OSWALDO CRUZ","10","SAÚDE","305","VIGILÂNCIA EPIDEMIOLÓGICA","4","INVESTIMENTOS","120169416","143160.48","12326848.65"
"2014-pre.csv","2014-01-01","2600
@andresmrm
andresmrm / teste.puml
Created November 19, 2014 23:44
@startuml
digraph world {
Receita [label="a"]
node1 [shape=box]
node3 [
href="https://github.com/okfn-brasil/gastos_abertos_dados/blob/master/Demonstrativos/Educacao/demonstrativo_SME_1bimestre.pdf",
fontcolor=blue,
label="a\nb\nc"]
@andresmrm
andresmrm / PKGBUILD
Last active August 29, 2015 14:09 — forked from anonymous/PKGBUILD
# Maintainer: Ivan Sichmann Freitas <ivansichfreitas@gmail.com>
# Contributor: Robson R S Peixoto <robsonpeixoto@gmail.com>
# Contributor: Luiz Ribeiro <luizribeiro@gmail.com>
# Contributor: Kazuo Teramoto <kaz <dot> rag <at> gmail <dot> com>
pkgname=vim-spell-pt-vero
pkgver=2013.10.30
pkgrel=1
pkgdesc="VIM spellchecker files for pt using Vero from BrOffice.org."
depends=('vim')
@andresmrm
andresmrm / gist:4c987c28c89d202737dc
Created August 17, 2014 21:31
➜ ~ openssl s_client -starttls smtp -connect smtp.mail.yahoo.com:465
CONNECTED(00000003)
didn't found starttls in server response, try anyway...
139997662770832:error:140790E5:SSL routines:SSL23_WRITE:ssl handshake failure:s23_lib.c:184:
---
no peer certificate available
---
No client certificate CA names sent
---
SSL handshake has read 0 bytes and written 343 bytes
@andresmrm
andresmrm / gist:949a20175d5e29337452
Created June 24, 2014 04:18
import csv
import requests
import time
import ckanapi
APIKEY = 'AAAAAAAAAAAAAAAAAAAAAAAAAAAA'
ckan = ckanapi.RemoteCKAN('http://colab.each.usp.br/ckan', apikey=APIKEY)
fields = [
@andresmrm
andresmrm / gist:156e65d2ae526eabad15
Created May 20, 2014 18:04
➜ ~ mopidy -v
** Message: pygobject_register_sinkfunc is deprecated (GstObject)
INFO 2014-05-20 15:03:31,224 [12902:MainThread] mopidy.__main__
Starting Mopidy 0.18.3
DEBUG 2014-05-20 15:03:31,229 [12902:MainThread] mopidy.ext
Loading entry point: dirble = mopidy_dirble:Extension
DEBUG 2014-05-20 15:03:31,230 [12902:MainThread] mopidy.ext
Loaded extension: Mopidy-Dirble 0.1.0
DEBUG 2014-05-20 15:03:31,230 [12902:MainThread] mopidy.ext
Loading entry point: soundcloud = mopidy_soundcloud:SoundCloudExtension
@andresmrm
andresmrm / gist:2c6c43c8bf3feaf41280
Created May 20, 2014 17:19
➜ ~ mopidy -v
** Message: pygobject_register_sinkfunc is deprecated (GstObject)
INFO 2014-05-20 14:17:51,566 [8583:MainThread] mopidy.__main__
Starting Mopidy 0.18.3
DEBUG 2014-05-20 14:17:51,571 [8583:MainThread] mopidy.ext
Loading entry point: dirble = mopidy_dirble:Extension
DEBUG 2014-05-20 14:17:51,572 [8583:MainThread] mopidy.ext
Loaded extension: Mopidy-Dirble 0.1.0
DEBUG 2014-05-20 14:17:51,572 [8583:MainThread] mopidy.ext
Loading entry point: soundcloud = mopidy_soundcloud:SoundCloudExtension
@andresmrm
andresmrm / gist:9b00cdf3b87421671717
Created May 20, 2014 17:13
INFO Starting Mopidy core
INFO Starting Mopidy frontends: MpdFrontend, HttpFrontend
INFO MPD server running at [::]:6600
[20/May/2014:14:10:55] ENGINE WARNING: Use of engine.autoreload_on is deprecated and will be removed in a future version. Use engine.autoreload.on instead.
INFO HTTP server running at http://127.0.0.1:6680
INFO New MPD connection from [::1]:47197
Traceback (most recent call last):
File "/usr/lib/python2.7/logging/__init__.py", line 851, in emit
msg = self.format(record)
File "/usr/lib/python2.7/logging/__init__.py", line 724, in format
@andresmrm
andresmrm / gist:da9bdb2e0ff944e3bd4e
Created May 9, 2014 11:02
node_modules/express && npm install && npm test
> express@2.5.11 prepublish /home/andres/CartoDB-SQL-API/node_modules/express
> npm prune
> express@2.5.11 test /home/andres/CartoDB-SQL-API/node_modules/express
> make test
find: `docs/*.md': Arquivo ou diretório não encontrado