Skip to content

Instantly share code, notes, and snippets.

View dami-i's full-sized avatar

Dami Izolan dami-i

View GitHub Profile
@dami-i
dami-i / feriados-moveis.js
Created August 23, 2024 21:47
Cálculo de feriados móveis - Terça-Feira de Carnaval, Sexta-Feira Santa, Páscoa e Corpus Christi
// Todos os feriados móveis do calendário brasileiro são calculados a partir da Páscoa.
/**
* Cálculo da data da Páscoa pelo algoritmo de Meeus.
*/
function pascoa(ano) {
const a = ano % 19;
const b = ~~(ano / 100); // Inteiro da divisão
const c = ano % 100;
const d = ~~(b / 4);
@dami-i
dami-i / CPF.java
Last active June 16, 2024 20:28
CPF Value Object
import java.util.stream.IntStream;
public class CPF {
private final String root;
private final String checksum;
private final int regionCode;
private final Region region;
public CPF(String baseValue) {
@dami-i
dami-i / insert_1000_rows_one_transaction.sql
Last active February 4, 2022 15:57
Insert more than 1000 rows on one transaction only (SQL Server - T-SQL)
BEGIN TRANSACTION; -- Whenever possible use transactions when dealing with large amounts of data
INSERT INTO [database].[dbo].[table_name] ([field1], [field2], [field3])
SELECT 'value for row 1 field 1', 'value for row 1 field 2', 'value for row 1 field 3' UNION ALL
SELECT 'value for row 2 field 1', 'value for row 2 field 2', 'value for row 2 field 3' UNION ALL
-- ...N-thousand other rows...
SELECT 'value for row n-1 field 1', 'value for row n-1 field 2', 'value for row n-1 field 3' UNION ALL
SELECT 'value for row n field 1', 'value for row n field 2', 'value for row n field 3'; -- No 'UNION ALL' statement on the last line
COMMIT TRANSACTION;