fix: golangci-lint and gosec warnings

.drone.yml

@@ -13,21 +13,17 @@ steps:
     - pull_request
     - tag
 
-# - name: golangci-lint
+- name: trigger
-#   image: docker.io/golangci/golangci-lint:v1.40.1-alpine
+  image: plugins/downstream
-#   commands:
+  settings:
-#   - golangci-lint run --concurrency $(nproc --ignore=1)
+    server: https://drone.cryptic.systems
-#   when:
+    token:
-#     event:
+      from_secret: drone_token
-#     - push
+    params:
-#     - pull_request
+    - VERSION=${DRONE_COMMIT_HASH}
-
+    fork: true
-# - name: gosec
+    repositories:
-#   image: docker.io/securego/gosec:v2.8.0
+    - flucky/PKGBUILD@master
-#   when:
-#     event:
-#     - push
-#     - pull_request
 
 # steps:
 # - name: test-unit

.gitignore

@@ -1,8 +1,7 @@
 # absolute files
+bin
 .env
 
-flucky*
-
 # directories
 .vscode/
 

Makefile

@@ -7,9 +7,42 @@ PREFIX?=/usr/local
 
 # BINARIES
 # ==============================================================================
-all: ${EXECUTABLE}
+EXECUTABLE_TARGETS:= \
+	bin/linux/amd64/${EXECUTABLE} \
+	bin/linux/arm/5/${EXECUTABLE} \
+	bin/linux/arm/7/${EXECUTABLE} \
+	bin/tmp/${EXECUTABLE}
 
-${EXECUTABLE}:
+${EXECUTABLE}: bin/tmp/${EXECUTABLE}
+
+bin/linux/amd64/${EXECUTABLE}:
+	CGO_ENABLED=1 \
+	GOOS=linux \
+	GOARCH=amd64 \
+	GOPROXY=$(shell go env GOPROXY) \
+	GOPRIVATE=$(shell go env GOPRIVATE) \
+		go build -ldflags "-X main.version=${VERSION:v%=%}" -o ${@}
+
+bin/linux/arm/5/${EXECUTABLE}:
+	CGO_ENABLED=1 \
+	GOOS=linux \
+	GOARCH=arm \
+	GOARM=5 \
+	GOPROXY=$(shell go env GOPROXY) \
+	GOPRIVATE=$(shell go env GOPRIVATE) \
+		go build -ldflags "-X main.version=${VERSION:v%=%}" -o ${@}
+
+bin/linux/arm/7/${EXECUTABLE}:
+	CC=arm-linux-gnueabihf-gcc \
+	CGO_ENABLED=1 \
+	GOOS=linux \
+	GOARCH=arm \
+	GOARM=7 \
+	GOPROXY=$(shell go env GOPROXY) \
+	GOPRIVATE=$(shell go env GOPRIVATE) \
+		go build -ldflags "-X main.version=${VERSION:v%=%}" -o ${@}
+
+bin/tmp/${EXECUTABLE}:
 	CGO_ENABLED=1 \
 	GOPROXY=$(shell go env GOPROXY) \
 	GOPRIVATE=$(shell go env GOPRIVATE) \
@@ -17,48 +50,48 @@ ${EXECUTABLE}:
 
 # COMPLETIONS
 # ==============================================================================
-${EXECUTABLE}.sh: ${EXECUTABLE}
+bin/tmp/${EXECUTABLE}.sh: bin/tmp/${EXECUTABLE}
-	${EXECUTABLE} completion bash > ${@}
+	bin/tmp/${EXECUTABLE} completion bash > ${@}
 
-${EXECUTABLE}.fish: ${EXECUTABLE}
+bin/tmp/${EXECUTABLE}.fish: bin/tmp/${EXECUTABLE}
-	${EXECUTABLE} completion fish > ${@}
+	bin/tmp/${EXECUTABLE} completion fish > ${@}
 
-${EXECUTABLE}.zsh: ${EXECUTABLE}
+bin/tmp/${EXECUTABLE}.zsh: bin/tmp/${EXECUTABLE}
-	${EXECUTABLE} completion zsh > ${@}
+	bin/tmp/${EXECUTABLE} completion zsh > ${@}
 
 # UN/INSTALL
 # ==============================================================================
 PHONY+=install
-install: ${EXECUTABLE} ${EXECUTABLE}.sh ${EXECUTABLE}.fish ${EXECUTABLE}.zsh
+install: bin/tmp/${EXECUTABLE} bin/tmp/${EXECUTABLE}.sh bin/tmp/${EXECUTABLE}.fish bin/tmp/${EXECUTABLE}.zsh
 	install --directory ${DESTDIR}${PREFIX}/bin
-	install --mode 755 ${EXECUTABLE} ${DESTDIR}${PREFIX}/bin/${EXECUTABLE}
+	install --mode 755 bin/tmp/${EXECUTABLE} ${DESTDIR}${PREFIX}/bin/${EXECUTABLE}
+
+	install --directory ${DESTDIR}/etc/bash_completion.d
+	install --mode 755 bin/tmp/${EXECUTABLE}.sh ${DESTDIR}/etc/bash_completion.d/${EXECUTABLE}.sh
+
+	install --directory ${DESTDIR}/usr/share/fish/vendor_completions.d
+	install --mode 644 bin/tmp/${EXECUTABLE}.fish ${DESTDIR}/usr/share/fish/vendor_completions.d/${EXECUTABLE}.fish
 
 	install --directory ${DESTDIR}/usr/lib/systemd/system
 	install --mode 644 systemd/${EXECUTABLE}.service ${DESTDIR}/usr/lib/systemd/system/${EXECUTABLE}.service
 
-	install --directory ${DESTDIR}${PREFIX}/share/bash-completion/completions/
+	install --directory ${DESTDIR}/usr/share/licenses/${EXECUTABLE}
-	install --mode 644 ${EXECUTABLE}.sh ${DESTDIR}${PREFIX}/share/bash-completion/completions/${EXECUTABLE}.sh
+	install --mode 644 LICENSE ${DESTDIR}/usr/share/licenses/${EXECUTABLE}/LICENSE
-
-	install --directory ${DESTDIR}${PREFIX}/fish/vendor_completions.d
-	install --mode 644 ${EXECUTABLE}.fish ${DESTDIR}${PREFIX}/fish/vendor_completions.d/${EXECUTABLE}.fish
-
-	install --directory ${DESTDIR}${PREFIX}/licenses/${EXECUTABLE}
-	install --mode 644 LICENSE ${DESTDIR}${PREFIX}/licenses/${EXECUTABLE}/LICENSE
 
 PHONY+=uninstall
 uninstall:
 	-rm --recursive --force \
 		${DESTDIR}${PREFIX}/bin/${EXECUTABLE} \
+		${DESTDIR}/etc/bash_completion.d/${EXECUTABLE}.sh \
 		${DESTDIR}/usr/lib/systemd/system/${EXECUTABLE}.service \
-		${DESTDIR}${PREFIX}/share/bash-completion/completions/${EXECUTABLE}.sh \
+		${DESTDIR}/usr/share/fish/vendor_completions.d/${EXECUTABLE}.fish \
-		${DESTDIR}${PREFIX}/fish/vendor_completions.d/${EXECUTABLE}.fish \
+		${DESTDIR}/usr/share/licenses/${EXECUTABLE}/LICENSE
-		${DESTDIR}${PREFIX}/licenses/${EXECUTABLE}/LICENSE
 
 # CLEAN
 # ==============================================================================
 PHONY+=clean
 clean:
-	rm --force --recursive ${EXECUTABLE}* || true
+	rm --force --recursive bin/ || true
 
 # TEST
 # ==============================================================================

go.mod

@@ -11,9 +11,9 @@ require (
 	github.com/d2r2/go-logger v0.0.0-20181221090742-9998a510495e
 	github.com/golang-migrate/migrate/v4 v4.14.2-0.20201125065321-a53e6fc42574
 	github.com/johejo/golang-migrate-extra v0.0.0-20210217013041-51a992e50d16
-	github.com/lib/pq v1.10.2
+	github.com/lib/pq v1.9.0
 	github.com/mattn/go-sqlite3 v2.0.3+incompatible
 	github.com/satori/go.uuid v1.2.0
-	github.com/spf13/cobra v1.1.3
+	github.com/spf13/cobra v1.1.1
 	github.com/stretchr/testify v1.7.0
 )

go.sum

@@ -297,8 +297,6 @@ github.com/lib/pq v1.2.0/go.mod h1:5WUZQaWbwv1U+lTReE5YruASi9Al49XbQIvNi/34Woo=
 github.com/lib/pq v1.8.0/go.mod h1:AlVN5x4E4T544tWzH6hKfbfQvm3HdbOxrmggDNAPY9o=
 github.com/lib/pq v1.9.0 h1:L8nSXQQzAYByakOFMTwpjRoHsMJklur4Gi59b6VivR8=
 github.com/lib/pq v1.9.0/go.mod h1:AlVN5x4E4T544tWzH6hKfbfQvm3HdbOxrmggDNAPY9o=
-github.com/lib/pq v1.10.2 h1:AqzbZs4ZoCBp+GtejcpCpcxM3zlSMx29dXbUSeVtJb8=
-github.com/lib/pq v1.10.2/go.mod h1:AlVN5x4E4T544tWzH6hKfbfQvm3HdbOxrmggDNAPY9o=
 github.com/magiconair/properties v1.8.1/go.mod h1:PppfXfuXeibc/6YijjN8zIbojt8czPbwD3XqdrwzmxQ=
 github.com/markbates/pkger v0.15.1/go.mod h1:0JoVlrol20BSywW79rN3kdFFsE5xYM+rSCQDXbLhiuI=
 github.com/mattn/go-colorable v0.0.9/go.mod h1:9vuHe8Xs5qXnSaW/c/ABM9alt+Vo+STaOChaDxuIBZU=
@@ -390,8 +388,6 @@ github.com/spf13/afero v1.1.2/go.mod h1:j4pytiNVoe2o6bmDsKpLACNPDBIoEAkihy7loJ1B
 github.com/spf13/cast v1.3.0/go.mod h1:Qx5cxh0v+4UWYiBimWS+eyWzqEqokIECu5etghLkUJE=
 github.com/spf13/cobra v1.1.1 h1:KfztREH0tPxJJ+geloSLaAkaPkr4ki2Er5quFV1TDo4=
 github.com/spf13/cobra v1.1.1/go.mod h1:WnodtKOvamDL/PwE2M4iKs8aMDBZ5Q5klgD3qfVJQMI=
-github.com/spf13/cobra v1.1.3 h1:xghbfqPkxzxP3C/f3n5DdpAbdKLj4ZE4BWQI362l53M=
-github.com/spf13/cobra v1.1.3/go.mod h1:pGADOWyqRD/YMrPZigI/zbliZ2wVD/23d+is3pSWzOo=
 github.com/spf13/jwalterweatherman v1.0.0/go.mod h1:cQK4TGJAtQXfYWX+Ddv3mKDzgVb68N+wFjFa4jdeBTo=
 github.com/spf13/pflag v1.0.3/go.mod h1:DYY7MBk1bdzusC3SYhjObp+wFpr4gzcvqqNjLnInEg4=
 github.com/spf13/pflag v1.0.5 h1:iy+VFUOCP1a+8yFto/drg2CJ5u0yRoB7fZw3DKv/JXA=
@@ -399,7 +395,6 @@ github.com/spf13/pflag v1.0.5/go.mod h1:McXfInJRrz4CZXVZOBLb0bTZqETkiAhM9Iw0y3An
 github.com/spf13/viper v1.7.0/go.mod h1:8WkrPz2fc9jxqZNCJI/76HCieCp4Q8HaLFoCha5qpdg=
 github.com/stretchr/objx v0.1.0/go.mod h1:HFkY916IF+rwdDfMAkV7OtwuqBVzrE8GR6GFx+wExME=
 github.com/stretchr/objx v0.1.1/go.mod h1:HFkY916IF+rwdDfMAkV7OtwuqBVzrE8GR6GFx+wExME=
-github.com/stretchr/objx v0.2.0 h1:Hbg2NidpLE8veEBkEZTL3CvlkUIVzuU9jDplZO54c48=
 github.com/stretchr/objx v0.2.0/go.mod h1:qt09Ya8vawLte6SNmTgCsAVtYtaKzEcn8ATUoHMkEqE=
 github.com/stretchr/testify v1.2.0/go.mod h1:a8OnRcib4nhh0OaRAV+Yts87kKdq0PP7pXfy6kDkUVs=
 github.com/stretchr/testify v1.2.2/go.mod h1:a8OnRcib4nhh0OaRAV+Yts87kKdq0PP7pXfy6kDkUVs=
@@ -750,7 +745,6 @@ gopkg.in/yaml.v2 v2.2.2/go.mod h1:hI93XBmqTisBFMUTm0b8Fm+jr3Dg1NNxqwp+5A1VGuI=
 gopkg.in/yaml.v2 v2.2.4/go.mod h1:hI93XBmqTisBFMUTm0b8Fm+jr3Dg1NNxqwp+5A1VGuI=
 gopkg.in/yaml.v2 v2.2.7/go.mod h1:hI93XBmqTisBFMUTm0b8Fm+jr3Dg1NNxqwp+5A1VGuI=
 gopkg.in/yaml.v2 v2.2.8/go.mod h1:hI93XBmqTisBFMUTm0b8Fm+jr3Dg1NNxqwp+5A1VGuI=
-gopkg.in/yaml.v2 v2.4.0/go.mod h1:RDklbk79AGWmwhnvt/jBztapEOGDOx6ZbXqjP6csGnQ=
 gopkg.in/yaml.v3 v3.0.0-20200313102051-9f266ea9e77c h1:dUUwHk2QECo/6vqA44rthZ8ie2QXMNeKRTHCNY2nXvo=
 gopkg.in/yaml.v3 v3.0.0-20200313102051-9f266ea9e77c/go.mod h1:K4uyk7z7BCEPqu6E+C64Yfv1cQ7kz7rIZviUmN+EgEM=
 gotest.tools v2.2.0+incompatible h1:VsBPFP1AI068pPrMxtb/S8Zkgf9xEmTLJjfM+P5UIEo=