Swedbank bank statement parser

bank-statement-parser.sh

#! /usr/bin/env zsh

#! /usr/bin/env nix-shell
#! nix-shell -i bash -p python36Packages.csvkit

# map <f9> :%!./parse 2>/dev/null <CR>

summer() {
    (echo "Saņēmējs/Maksātājs,Summa,Datums"; grep -v "Summa,Datums") | \
        csvsql --tables input --query 'SELECT SUM("Summa")/100.0 FROM input'
}

SQL='
SELECT "Saņēmējs/Maksātājs", "Summa", "Datums"
FROM input
WHERE "Debets/Kredīts" = "D"
AND "Ieraksta tips" = "20"
AND "Maksājuma veids" = "CTX"
ORDER BY "Saņēmējs/Maksātājs" ASC
'

csvsql --tables input --query "$SQL" < karte-2020-01.csv

# SQL='SELECT * FROM input WHERE "Maksājuma veids" <> "CTX"'
# CTX = payment with card, KOM = commission, INB/PRV = money received/money sent to account

# CREATE TABLE input (
# 	"Klienta konts" VARCHAR NOT NULL,
# 	"Ieraksta tips" DECIMAL NOT NULL,
# 	"Datums" VARCHAR NOT NULL,
# 	"Saņēmējs/Maksātājs" VARCHAR,
# 	"Informācija saņēmējam" VARCHAR NOT NULL,
# 	"Summa" DECIMAL NOT NULL,
# 	"Valūta" VARCHAR NOT NULL,
# 	"Debets/Kredīts" VARCHAR NOT NULL,
# 	"Arhīva kods" DECIMAL,
# 	"Maksājuma veids" VARCHAR NOT NULL,
# 	"Refernces numurs" BOOLEAN,
# 	"Dokumenta numurs" BOOLEAN,
# 	m BOOLEAN
# );