def emo_lexicon():
f = open('data/EmoticonSentimentLexicon.txt', 'r', encoding='utf-8')
output_dict = {}
for line in f:
emoti = trim(line[:(len(line) - 3)])
pol = trim(line[len(line)-3:])
output_dict.update({emoti: sent[pol]})
return output_dict
def emo_lexicon():
dirname = os.path.dirname(__file__)
filename = os.path.join(dirname, '../data/EmoticonSentimentLexicon.txt')
f = open(filename, 'r', encoding='utf-8')
output_dict = {}
for line in f:
emoti = trim(line[:(len(line) - 3)])
pol = trim(line[len(line) - 3:])
output_dict.update({emoti: sent[pol]})
return output_dict
def render_css_link(context, path, media=''):
context.caller_stack._push_frame()
try:
context._push_buffer()
self = context.get('self', UNDEFINED)
__M_writer = context.writer()
# SOURCE LINE 2
__M_writer(u'\n')
# SOURCE LINE 3
if path not in self.seen_css:
# SOURCE LINE 4
__M_writer(
u' <link rel="stylesheet" type="text/css" href="')
__M_writer(filters.html_escape(unicode(path)))
__M_writer(u'" media="')
__M_writer(unicode(media))
__M_writer(u'">\n')
pass
# SOURCE LINE 6
__M_writer(u' ')
self.seen_css.add(path)
__M_writer(u'\n')
finally:
__M_buf, __M_writer = context._pop_buffer_and_writer()
context.caller_stack._pop_frame()
__M_writer(filters.trim(__M_buf.getvalue()))
return ''
def render_css_link(context,path,media=''):
__M_caller = context.caller_stack._push_frame()
try:
context._push_buffer()
self = context.get('self', UNDEFINED)
__M_writer = context.writer()
# SOURCE LINE 2
__M_writer(u'\n')
# SOURCE LINE 3
if path not in self.seen_css:
# SOURCE LINE 4
__M_writer(u' <link rel="stylesheet" type="text/css" href="')
__M_writer(filters.html_escape(unicode(path)))
__M_writer(u'" media="')
__M_writer(unicode(media))
__M_writer(u'">\n')
# SOURCE LINE 6
__M_writer(u' ')
self.seen_css.add(path)
__M_writer(u'\n')
finally:
__M_buf, __M_writer = context._pop_buffer_and_writer()
context.caller_stack._pop_frame()
__M_writer(filters.trim(__M_buf.getvalue()))
return ''
def render_pre(context):
__M_caller = context.caller_stack._push_frame()
try:
context._push_buffer()
__M_writer = context.writer()
__M_writer(u'\n')
finally:
__M_buf, __M_writer = context._pop_buffer_and_writer()
context.caller_stack._pop_frame()
__M_writer(filters.trim(__M_buf.getvalue()))
return ''
def render_post(context):
__M_caller = context.caller_stack._push_frame()
try:
context._push_buffer()
__M_writer = context.writer()
__M_writer(u'\n<div>\n <div class="footer">\n <p>© Copyright 2014 Umeå Universitet </p>\n </div>\n</div>\n')
finally:
__M_buf, __M_writer = context._pop_buffer_and_writer()
context.caller_stack._pop_frame()
__M_writer(filters.trim(__M_buf.getvalue()))
return ''
def render_post(context):
__M_caller = context.caller_stack._push_frame()
try:
context._push_buffer()
__M_writer = context.writer()
__M_writer(u'\n<div>\n <div class="footer">\n <p>© Copyright 2014 Umeå Universitet </p>\n </div>\n</div>\n')
finally:
__M_buf, __M_writer = context._pop_buffer_and_writer()
context.caller_stack._pop_frame()
__M_writer(filters.trim(__M_buf.getvalue()))
return ''
def render_post(context):
__M_caller = context.caller_stack._push_frame()
try:
context._push_buffer()
__M_writer = context.writer()
__M_writer('\n<div>\n <div class="footer">\n </div>\n</div>\n')
finally:
__M_buf, __M_writer = context._pop_buffer_and_writer()
context.caller_stack._pop_frame()
__M_writer(filters.trim(__M_buf.getvalue()))
return ''
def render_pre(context):
__M_caller = context.caller_stack._push_frame()
try:
context._push_buffer()
__M_writer = context.writer()
__M_writer(u'\n')
finally:
__M_buf, __M_writer = context._pop_buffer_and_writer()
context.caller_stack._pop_frame()
__M_writer(filters.trim(__M_buf.getvalue()))
return ''
def render_pre(context):
__M_caller = context.caller_stack._push_frame()
try:
context._push_buffer()
__M_writer = context.writer()
__M_writer(u'\n <div class="header">\n <h1><a href="/">Login</a></h1>\n </div>\n')
finally:
__M_buf, __M_writer = context._pop_buffer_and_writer()
context.caller_stack._pop_frame()
__M_writer(filters.trim(__M_buf.getvalue()))
return ''
def render_pre(context):
__M_caller = context.caller_stack._push_frame()
try:
context._push_buffer()
__M_writer = context.writer()
__M_writer(
u'\n <div class="header">\n <h1><a href="/">Login</a></h1>\n </div>\n'
)
finally:
__M_buf, __M_writer = context._pop_buffer_and_writer()
context.caller_stack._pop_frame()
__M_writer(filters.trim(__M_buf.getvalue()))
return ''
def getDespesaTipo(nome,cursor=None):
print "Nome Antes" + nome
if nome[0:6] == 'ASSINATURA'[0:6]:
nome='ASSINATURA DE PUBLICACOES'
if nome[0:6] == 'COMBUSTIVEIS E LUBRIFICANTES'[0:6]:
nome='COMBUSTIVEIS E LUBRIFICANTES'
if nome[0:6] == 'CONSULTORIAS'[0:6]:
nome='CONSULTORIAS'
if trim(nome)[8:12] == 'SERVICOS POSTAIS'[7:11]:
nome='SERVICOS POSTAIS'
if nome[0:5].upper() == 'EMISSAO BILHETE AEREO'[0:5]:
nome='EMISSAO BILHETE AEREO'
if nome[0:6] == 'DIVULGACAO'[0:6]:
nome='DIVULGACAO DA ATIVIDADE PARLAMENTAR'
if nome[0:6] == 'MANUTENCAO DE ESCRITORIO DE APOIO A ATIVIDADE'[0:6]:
nome='MANUTENCAO DE ESCRITORIO DE APOIO A ATIVIDADE'
if nome[0:6] == 'FORNECIMENTO DE ALIMENTACAO DO PARLAMENTAR'[0:6]:
nome='FORNECIMENTO DE ALIMENTACAO DO PARLAMENTAR'
if nome[0:4] == 'LOCACAO DE VEICULOS AUTOMOTORES OU FRETAMENTO'[0:4]:
nome='LOCACAO DE VEICULOS AUTOMOTORES OU FRETAMENTO'
if nome[0:6] == 'PASSAGENS AEREAS E FRETAMENTO DE AERONAVES'[0:6]:
nome='PASSAGENS AEREAS E FRETAMENTO DE AERONAVES'
if nome[22:27] == 'SERVICO DE SEGURANCA PRESTADO POR EMPRESA ESPECIALIZADA'[20:25]:
nome='SERVICO DE SEGURANCA PRESTADO POR EMPRESA ESPECIALIZADA'
if nome[30:44]=="ESTACIONAMENTO":
nome='SERVICO DE TAXI, PEDAGIO E ESTACIONAMENTO'
#nome = applyCoding(nome,depara)
print "Nome Depois" + nome
query="select * from despesatipo where nome_despesatipo = '"+str(nome)+ "'"
print query
cursor.execute(query )
rows = cursor.fetchall()
for row in rows:
return row
query="insert into despesatipo (nome_despesatipo) values ('"+str(nome)+"');"
print "Inserido DESPESAS " +query
cursor.execute(query)
return getDespesaTipo(nome,cursor=cursor)
def render_css(context):
__M_caller = context.caller_stack._push_frame()
try:
context._push_buffer()
def css_link(path,media=''):
return render_css_link(context,path,media)
__M_writer = context.writer()
__M_writer(u'\n ')
__M_writer(unicode(css_link('/css/main.css', 'screen')))
__M_writer(u'\n')
finally:
__M_buf, __M_writer = context._pop_buffer_and_writer()
context.caller_stack._pop_frame()
__M_writer(filters.trim(__M_buf.getvalue()))
return ''
def render_css(context):
__M_caller = context.caller_stack._push_frame()
try:
context._push_buffer()
def css_link(path,media=''):
return render_css_link(context,path,media)
__M_writer = context.writer()
__M_writer(u'\n ')
__M_writer(unicode(css_link('/css/main.css', 'screen')))
__M_writer(u'\n')
finally:
__M_buf, __M_writer = context._pop_buffer_and_writer()
context.caller_stack._pop_frame()
__M_writer(filters.trim(__M_buf.getvalue()))
return ''
def render_css(context):
__M_caller = context.caller_stack._push_frame()
try:
context._push_buffer()
def css_link(path,media=''):
return render_css_link(context,path,media)
__M_writer = context.writer()
__M_writer('\n ')
__M_writer(str(css_link('/static/bootstrap/css/bootstrap.min.css', 'screen')))
__M_writer('\n ')
__M_writer(str(css_link('/static/bootstrap/css/style.css', 'screen')))
__M_writer('\n')
finally:
__M_buf, __M_writer = context._pop_buffer_and_writer()
context.caller_stack._pop_frame()
__M_writer(filters.trim(__M_buf.getvalue()))
return ''
def runDespesas(cursor=None,anoFilter=None, semanaFilter=None):
csv_reader = utils.openCSV('data/ExpDespesas.csv')
despesasSQL=""
max=100
i=0
for line in csv_reader:
i=i+1
Despesas_semanaInicio = line[2]
ano= trim(Despesas_semanaInicio[-4:])
#print semanaFilter
if (line[1] and len(line)>=5 and ((anoFilter is None or anoFilter==ano) and (semanaFilter is None or semanaFilter==Despesas_semana))):
#if i > max:
# break
Despesas_semana = line[1]
Despesas_semanaFim = line[3]
#addRodada(semana=Despesas_semana,ano=ano,inicio=Despesas_semanaInicio,fim=Despesas_semanaFim)
rodadaRetorno=rodada.addRodada(semana=Despesas_semana,ano=ano,cursor=cursor)
if isinstance(rodadaRetorno, tuple):
rodadaRetorno=int(rodadaRetorno[0])
ideCadastro = line[0]
politicoRetorno = politico.getCandidatura(id_original=ideCadastro,cursor=cursor)
Despesas_txtDescricao = line[4]
Despesas_txtDescricao=getDespesaTipo(Despesas_txtDescricao,cursor=cursor)
#Despesas_txtDescricao = Despesas_txtDescricao.decode("utf-8")
Despesas_vlrLiquido= line[5]
Despesas_vlrLiquido = Despesas_vlrLiquido.replace(",",".")
if politicoRetorno is not None:
despesasSQL=addDespesas(candidatura=politicoRetorno,categoria=Despesas_txtDescricao,
valor=Despesas_vlrLiquido,rodada=rodadaRetorno,despesasSQL=despesasSQL,cursor=cursor)
def propostaVinculada(sigla):
sigla = trim(sigla)
siglas = sigla.split("=>")
for sig in siglas:
sigla=trim(sig)
return sigla
help="define o ano que deseja processar, descartando dados dos demais ", metavar="ANO")
parser.add_option("-s", "--semana", dest="semana",
help="define a semana que deseja processar, descartando dados dos demais ", metavar="SEMANA")
(options, args) = parser.parse_args()
opcao=None
rodadaOption=None
ambiente=None
ano="2014"
semana=None
if options.opcao is not None:
opcao=trim(options.opcao)
if options.rodada is not None:
rodadaOption=trim(options.rodada)
if options.ambiente is not None:
ambiente=trim(options.ambiente)
if options.ano is not None:
ano=trim(options.ano)
if options.semana is not None:
ambiente=trim(options.semana)
''' Connect to DB '''
cursor = utils.getCursorConnection(ambiente)
depara=utils.runCoding()
logflag=True
def separaSiglaNumeroAnoProposicao(entrada):
#PL 6025/2005
entrada=trim(entrada)
