From a12584736a36dca44dde6a34f56255e67ee09010 Mon Sep 17 00:00:00 2001
From: Sina Ghaderi <32870524+Sina-Ghaderi@users.noreply.github.com>
Date: Mon, 10 Aug 2020 12:48:47 +0430
Subject: Defer functions

---
 sqlf.go | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

diff --git a/sqlf.go b/sqlf.go
index 5036d91..c873470 100644
--- a/sqlf.go
+++ b/sqlf.go
@@ -63,6 +63,8 @@ func storeItem(db *sql.DB, items map[string]datausage) {
 	`
 	stmt, err := db.Prepare(sqlAdditem)
 	nstmt, err := db.Prepare(sqlSumitem)
+	defer stmt.Close()
+	defer nstmt.Close()
 
 	if err != nil {
 		log.Fatal(err)
@@ -73,13 +75,12 @@ func storeItem(db *sql.DB, items map[string]datausage) {
 			if err != nil {
 				log.Fatal(err)
 			}
-			defer nstmt.Close()
+
 		} else {
 			_, err := stmt.Exec(item.ip, item.rx, item.tx)
 			if err != nil {
 				log.Fatal(err)
 			}
-			defer stmt.Close()
 		}
 	}
 }
-- 
cgit v1.2.3