Skip to content

Instantly share code, notes, and snippets.

@gerep
gerep / clock2.go
Last active November 18, 2017 02:10
// Execution example: TZ=US/Eastern ./clock2 --port 8000
package main
import (
"flag"
"io"
"log"
"net"
"os"
@gerep
gerep / spinner.go
Created November 18, 2017 00:34
Loading animation for terminal
func spinner(delay time.Duration) {
for {
for _, r := range `-\|/` {
fmt.Printf("\r%c", r)
time.Sleep(delay)
}
}
}
@gerep
gerep / postgres_queries_and_commands.sql
Created November 14, 2017 19:36 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(query_start, clock_timestamp()), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
@gerep
gerep / append-zeroes.txt
Created November 14, 2017 13:27
Append zeroes to CPF numbers with < 11 characters on LibreOffice
=IF(LEN(A1) < 11,CONCAT(REPT(0,11 - LEN(A1)), A1),A1)
=IF(LEN(A1) < 11,
CONCAT(
REPT(0,11 - LEN(A1)
),
A1),
A1)
@gerep
gerep / oci8.pc
Created November 9, 2017 19:27
/usr/lib/pkgconfig/oci8.pc
prefix=/opt/oracle/instantclient
libdir=${prefix}
includedir=${prefix}/sdk/include/
Name: OCI
Description: Oracle database engine
Version: 11.2
Libs: -L${libdir} -lclntsh
Libs.private:
Cflags: -I${includedir}
@gerep
gerep / placeholder.go
Created October 4, 2017 15:44
Placeholder
package main
import (
"fmt"
"strconv"
"strings"
)
func main() {
x := generateMessage("Hello {0}, you have {1} new messages!", "Gerep", "12")
@gerep
gerep / coh-piah.py
Last active January 21, 2022 20:21
import re
def le_assinatura():
'''A funcao le os valores dos tracos linguisticos do modelo e devolve uma assinatura a ser comparada com os textos fornecidos'''
print("Bem-vindo ao detector automático de COH-PIAH.")
wal = float(input("Entre o tamanho medio de palavra:"))
ttr = float(input("Entre a relação Type-Token:"))
hlr = float(input("Entre a Razão Hapax Legomana:"))
sal = float(input("Entre o tamanho médio de sentença:"))
@gerep
gerep / nim.py
Created September 8, 2017 02:03
def main():
print("Bem-vindo ao jogo do NIM! Escolha:")
print("1 - para jogar uma partida isolada")
print("2 - para jogar um campeonato")
o = input()
if o == "1":
print("Você escolheu partida isolada!")
partida()
elif o == "2":
def maior_primo(n):
cont = 1
maior = 0
while cont <= n:
if primo(cont):
if cont > maior:
maior = cont
cont += 1
return maior
@gerep
gerep / pg-dates.sql
Created August 22, 2017 13:28
PostgreSQL: yesterday, today, tomorrow
select TIMESTAMP 'yesterday';
select DATE 'yesterday';
select TIMESTAMP 'today';
select DATE 'today';
select TIMESTAMP 'tomorrow';
select DATE 'tomorrow';
select TIME 'allballs';
select now();
select TIMESTAMP 'now';
select DATE 'now';