Skip to content

Instantly share code, notes, and snippets.

View sergio's full-sized avatar

Sergio Acosta sergio

View GitHub Profile
@sergio
sergio / pkcs11-tls-proxy.go
Created September 27, 2022 02:27 — forked from korc/pkcs11-tls-proxy.go
PKCS11-authenticated TLS socket proxy
package main
import (
"crypto/tls"
"flag"
"fmt"
"io"
"log"
"net"
"net/textproto"
@sergio
sergio / summary-from-xmls.ps1
Last active June 16, 2021 06:48
[Sumarize CFDIs] Extract CSV summary from CFDI xmls in folder #PowerShell
gci xmls | % { [xml]$x = gc $_; $c = $x.Comprobante; New-Object PSObject -Property @{Folio=$c.Folio;Serie=$c.Serie;RfcEmisor=$c.Emisor.Rfc;RfcReceptor=$c.Receptor.Rfc;UUID=$c.Complemento.TimbreFiscalDigital.UUID;FormaPago=$c.FormaPago;Total=$c.Total;Fecha=$c.Fecha;Tipo=$c.TipoDeComprobante}} | export-csv -Path cfdis.csv
@sergio
sergio / parse-cfdis.ps1
Last active November 18, 2020 08:53
[ParseCfdis] Parse several xml CFDI files to a CSV containing header fields #PowerShell #cfdi
Get-ChildItem *.xml | ForEach-Object {
[xml]$x = (Get-Content $_)
$c = $x.Comprobante
New-Object -TypeName PSObject -Property @{
Emisor = $c.Emisor.Rfc
Receptor = $c.Receptor.Rfc
Cliente = $c.Receptor.Nombre
Total = $c.Total
FormaPago = $c.FormaPago
Moneda = $c.Moneda
@sergio
sergio / query.sql
Created February 14, 2020 01:26
select Catalogo código postal #advantage
SELECT LOC.c_CodigoPostal,
LOC.InicioVigencia,
LOC.FinVigencia,
TZ.TimeZoneName,
TZ.SystemTimeZoneId,
RHH.*
FROM (
SELECT CP.c_CodigoPostal,
CP.c_Estado,
CP.c_Municipio,
@sergio
sergio / validate.sh
Created January 9, 2020 19:10
Validate if key and cer match #openssl #x509
openssl pkey -in privateKey.key -pubout -outform pem | sha256sum
openssl x509 -in certificate.crt -pubkey -noout -outform pem | sha256sum
@sergio
sergio / fmap.go
Created November 20, 2019 07:31
[fmap golang] Non-generic fmap implementation in Go #go #golang
// Replace T with the desired type
func fmap(input []*T, f func(*T) *T) []*T {
result := make([]*T, len(input))
for i, v := range input {
result[i] = f(v)
}
return result
}
@sergio
sergio / reset-dns.sh
Created August 20, 2019 17:07
[reset-dns] Reset DNS Responder #macos #unix #dns
#!/bin/bash
sudo killall -HUP mDNSResponder
@sergio
sergio / main.go
Created July 18, 2019 16:30
Read string from aws SecretsManager #go #golang #aws
package main
import (
"fmt"
"github.com/aws/aws-sdk-go/aws"
"github.com/aws/aws-sdk-go/aws/session"
"github.com/aws/aws-sdk-go/service/secretsmanager"
)
@sergio
sergio / set-permissions.bat
Last active June 30, 2019 17:43
Assign Windows port url permissions to avoid Access is Denied #windows
rem Run in elevated command prompt
netsh http add urlacl url=http://+:8050/metrics user=sacosta
@sergio
sergio / linux-tunnel.sh
Last active June 28, 2019 02:05
SSH to linux via tunnel #linux #ssh
LOCAL_PORT=2266
TARGET_PRIVATE_IP=172.100.6.108
TARGET_SSH_PORT=22
TARGET_SSH_KEY=~/.ssh/desarrollo_key.pem
TARGET_USER=ec2-user
PASSTHROUGH_PUBLIC_IP=54.68.190.33
PASSTHROUGH_SSH_PORT=2224
PASSTHROUGH_SSH_KEY=~/.ssh/rc-oregon-keypair.pem