Skip to content

Instantly share code, notes, and snippets.

View jhisse's full-sized avatar

José H. jhisse

View GitHub Profile
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@jhisse
jhisse / pima.csv
Last active February 3, 2020 00:28
Pregnancies Glucose BloodPressure SkinThickness Insulin BMI DiabetesPedigreeFunction Age Outcome
6 148 72 35 0 33.6 0.627 50 1
1 85 66 29 0 26.6 0.351 31 0
8 183 64 0 0 23.3 0.672 32 1
1 89 66 23 94 28.1 0.167 21 0
0 137 40 35 168 43.1 2.288 33 1
5 116 74 0 0 25.6 0.201 30 0
3 78 50 32 88 31 0.248 26 1
10 115 0 0 0 35.3 0.134 29 0
2 197 70 45 543 30.5 0.158 53 1
<appender name="4telegraf" class="ch.qos.logback.core.rolling.RollingFileAppender">
<file>${org.apache.nifi.bootstrap.config.log.dir}/4telegraf.log</file>
<rollingPolicy class="ch.qos.logback.core.rolling.SizeAndTimeBasedRollingPolicy">
<fileNamePattern>${org.apache.nifi.bootstrap.config.log.dir}/4telegraf_%d{yyyy-MM-dd_HH}.%i.log</fileNamePattern>
<maxFileSize>100MB</maxFileSize>
<maxHistory>30</maxHistory>
</rollingPolicy>
<immediateFlush>true</immediateFlush>
<encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
<pattern>%date{'yyyy-MM-dd'T'HH:mm:ssXXX'}; %level; %replace(%replace(%msg){';',','}){'[\s\n\r]',' '}%n</pattern>
CREATE FUNCTION validarcpf(cpf VARCHAR(11)) RETURNS BOOLEAN
RETURN (SELECT SUBSTR(cpf,13,2) = CONCAT(
@dig1:=(
SUBSTR(cpf,1,1) + SUBSTR(cpf,2,1)*2 + SUBSTR(cpf,3,1)*3+
SUBSTR(cpf,4,1)*4 + SUBSTR(cpf,5,1)*5 + SUBSTR(cpf,6,1)*6+
SUBSTR(cpf,7,1)*7 + SUBSTR(cpf,8,1)*8 + SUBSTR(cpf,9,1)*9 ) % 11 % 10
,(
SUBSTR(cpf,2,1) + SUBSTR(cpf,3,1)*2 + SUBSTR(cpf,4,1)*3 +
SUBSTR(cpf,5,1)*4 + SUBSTR(cpf,6,1)*5 + SUBSTR(cpf,7,1)*6 +
SUBSTR(cpf,8,1)*7 + SUBSTR(cpf,9,1)*8 + @dig1 *9 ) % 11 % 10
@jhisse
jhisse / encoding.sh
Last active November 12, 2017 01:08
#!/bin/bash
# busca todos os arquivos csv, CSV, txt, TXT que estejam em uma codificação qualquer
# e converte para utf-8, mantendo um arquivo .bkp como backup
find . -regex ".*\.\(csv\|CSV\|txt\|TXT\)$" -print0 \
| xargs -0 -I % sh -c 'encoding=`file -b --mime-encoding "%"`; \
if \
[ "$encoding" != "binary" ]; \
then \
mv "%" "%.bkp"; \