Skip to content

Instantly share code, notes, and snippets.

View bragil's full-sized avatar

Rogério Bragil bragil

View GitHub Profile
@bragil
bragil / esp8266_dht11_blynk.ino
Created September 27, 2021 11:48
ESP8266 com DHT11 e Blynk
//Programa: Blynk com modulo DHT11 ESP8266
//Autor: Arduino e Cia
#include <DHTesp.h>
#include <BlynkSimpleEsp8266.h>
//Coloque abaixo o token de autorizacao recebido por email
char auth[] = "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX";
//Preencha com os dados da sua rede wifi
@bragil
bragil / GerarDvCpf.cs
Created March 15, 2016 14:33
Cálculo do DV do CPF em C#
public string GeraDvCpf(string cpf)
{
var semDv = cpf.Substring(0, 9);
int mod11 = (semDv.ToCharArray()
.Select((c, i) => Convert.ToInt32(c.ToString()) * (10 - i))
.Sum() * 10) % 11;
// Primeiro dígito
int dig1 = mod11 > 9 ? 0 : mod11;
@bragil
bragil / dv-cpf.clj
Last active March 15, 2016 16:43
Cálculo do DV do CPF em Clojure
(ns bragil.dv-cpf)
; Realiza o cálculo do DV do CPF
(defn calc-dv [cpf-sem-dv]
"Calcula cada dígito do DV do CPF"
(def dv (mod
(*
(reduce +
(map-indexed
@bragil
bragil / i2c_scanner.cpp
Created December 17, 2014 15:52
Arduino I2C scanner.
#include <Wire.h>
void setup()
{
Wire.begin();
Serial.begin(9600);
Serial.println("\nI2C Scanner");
}
-- Haversine Formula based geodistance, calibrated for use in danish latitudes (6371 used as radius)
CREATE OR REPLACE FUNCTION service.geodistance(a point, b point)
RETURNS double precision AS
$BODY$
SELECT acos(
sin(radians($1[0]))*sin(radians($2[0])) +
cos(radians($1[0]))*cos(radians($2[0]))*cos(radians($2[1])-radians($1[1]))
)*6371 AS distance;
$BODY$
LANGUAGE sql IMMUTABLE
@bragil
bragil / sql_server_date_format.sql
Last active August 29, 2015 14:11
[Sql Server] Formatação de datas
-- Exemplo de formatação de datas no Sql Server
SELECT
CONVERT(VARCHAR(12),GETDATE(),101) AS '101', --mm/dd/aaaa
CONVERT(VARCHAR(12),GETDATE(),102) AS '102', --aa.mm.dd
CONVERT(VARCHAR(12),GETDATE(),103) AS '103', --dd/mm/aaaa
CONVERT(VARCHAR(12),GETDATE(),104) AS '104', --dd.mm.aa
CONVERT(VARCHAR(12),GETDATE(),105) AS '105', --dd-mm-aa
CONVERT(VARCHAR(12),GETDATE(),106) AS '106', --dd mês aa
CONVERT(VARCHAR(12),GETDATE(),107) AS '107', --Mês dd, aa
CONVERT(VARCHAR(12),GETDATE(),108) AS '108', --hh:mi:ss
@bragil
bragil / geolocalizacao.py
Created August 25, 2011 18:16
Dado o endereço, obter localização, latitude e longitude
def dados_do_local(endereco):
"""
Dado o endereco, retorna o endereco processado, a latitude e a longitude do local.
Exemplo:
place, (lat, lng) = dados_do_local(endereco)
"""
from geopy import geocoders
if hasattr(settings, "EASY_MAPS_GOOGLE_KEY") and settings.EASY_MAPS_GOOGLE_KEY:
g = geocoders.Google(settings.EASY_MAPS_GOOGLE_KEY)
else: