Skip to content

Instantly share code, notes, and snippets.

View itarocha's full-sized avatar

Itamar Rocha itarocha

  • NTT Data
  • Contagem, MG, Brazil
View GitHub Profile
@itarocha
itarocha / ExcelCache.java
Created February 2, 2025 20:42
Cache de verificações de Planilha XLS
package br.itarocha.teste.xls;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.*;
@itarocha
itarocha / data-play.py
Created January 30, 2024 00:41
Brincadeiras com datas
from datetime import datetime, timedelta
from dateutil.relativedelta import relativedelta
formato_br = "%d/%m/%Y %H:%M:%S"
formato_db = "%Y-%m-%d %H:%M:%S"
formato_db_date = "%Y-%m-%d"
def agora_local():
return datetime.now()
@itarocha
itarocha / MultipartController.java
Created April 23, 2023 15:02
Upload multipart from aws json event and reposting to spring boot rest application
package com.example.multipart.controller;
import lombok.SneakyThrows;
import org.springframework.http.HttpStatus;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
b'--X-INSOMNIA-BOUNDARY\r\nContent-Disposition: form-data; name="cliente"\r\nContent-Type: application/json\r\n\r\n{
"id": 30,
"nome": "Itamar"
}\r\n--X-INSOMNIA-BOUNDARY\r\nContent-Disposition: form-data; name="arquivo"; filename="Fatura Cart\xc3\xa3o Caixa.xlsx"\r\nContent-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\r\n\r\nPK\x03\x04\n\x00\x00\x00\x00\x00\x87N\xe2@\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\t\x00\x00\x00docProps/PK\x03\x04\x14\x00\x00\x00\x08\x00\x87N\xe2@\xf0\r\x92tW\x01\x00\x00l\x02\x00\x00\x10\x00\x00\x00docProps/app.xml\x9d\x92\xc1J\xc3@\x10\x86\xef\x82\xef\x10\x96^\xdbMC\x08R\x92\x14E\xc4C\xa19T\xf1V\xb6\xc9\xb4]\xd9\xec\x86\xddih}\x16/\x1e\x04\xdf\xc0\x93o\xa3\xe0c8I@S\xf1${\xf9w\xe7\xe7\x9fo\x86\x8d\xa7\xfbRy5X\'\x8dN\xd8x\xe43\x0ftn\n\xa97\t\xbbY\\\r\xcf\x98\xe7P\xe8B(\xa3!a\x07pl\x9a\x9e\x9e\xc4\x995\x15X\x94\xe0<\x8a\xd0.a[\xc4j\xc2\xb9\xcb\xb7P\n7\xa2\xb2\xa6\xca\xda\xd8R ]\xed\x86\x9b\xf5Z\xe6pi\xf2]\t\x1ay\xe0\xfb\x11\x87=\x82.\xa0\x18V\
@itarocha
itarocha / busca.js
Last active May 31, 2017 01:59
Autocomplete javascript de um texto via ajax com delay
var oldValor = "";
var xhr;
function trata(data) {
//var json = JSON.parse(data);
console.log("tratando....");
var options = $("#options");
$(options).empty();
var json = data;
@itarocha
itarocha / application.firebird.properties
Last active October 13, 2022 23:02
Properties file firebird on spring boot
logging.level.root=INFO
spring.datasource.url:jdbc:firebirdsql:localhost/3050:D:\\database\\petra.FDB
spring.datasource.driverClassName:org.firebirdsql.jdbc.FBDriver
spring.datasource.username:SYSDBA
spring.datasource.password:masterkey
spring.jpa.hibernate.ddl-auto:update
spring.jpa.show-sql: true
spring.jpa.properties.hibernate.format_sql=true