From fe8ee65deda6790f6fd7abc9f88ca58c44e49368 Mon Sep 17 00:00:00 2001
From: Jacek Kowalski <Jacek@jacekk.info>
Date: Fri, 21 Jun 2019 11:25:55 +0000
Subject: [PATCH] Add LICENSE and README.md

---
 lib/database.php |   14 ++++++++++++++
 1 files changed, 14 insertions(+), 0 deletions(-)

diff --git a/lib/database.php b/lib/database.php
index 48ad047..2c86a7b 100644
--- a/lib/database.php
+++ b/lib/database.php
@@ -20,6 +20,18 @@
 		$this->addStatement = $this->pdo->prepare('INSERT OR REPLACE INTO vehicles (id, num, weight) VALUES (?, ?, ?)');
 	}
 	
+	public function beginTransaction() {
+		$this->pdo->beginTransaction();
+	}
+	
+	public function commit() {
+		$this->pdo->commit();
+	}
+	
+	public function rollback() {
+		$this->pdo->rollback();
+	}
+	
 	public function getById($id) {
 		$this->getByIdStatement->execute([$id]);
 		return $this->getByIdStatement->fetch();
@@ -39,9 +51,11 @@
 	}
 	
 	public function addMapping($mapping) {
+		$this->beginTransaction();
 		$weight = count($mapping);
 		foreach($mapping as $id => $vehicle) {
 			$this->add($id, (int)substr($vehicle['num'], 2), $weight);
 		}
+		$this->commit();
 	}
 }

--
Gitblit v1.9.1