Use ‘exec’ instead of ‘query’ for transaction commands in sqlite

The ‘query’ method will try and return a ‘SQLite3Result’ object, which will be
meaningless because it won't contain any fetched data. The ‘exec’ method instead
returns a boolean indicating the success or failure of the query.

1 files changed, 3 insertions, 3 deletions

diff --git a/src/SemanticScuttle/db/sqlite.php b/src/SemanticScuttle/db/sqlite.php
index 49de59c..4531d17 100644
--- a/src/SemanticScuttle/db/sqlite.php
+++ b/src/SemanticScuttle/db/sqlite.php
@@ -86,17 +86,17 @@ class sql_db
 		{
 			case 'begin':
 				$this->transaction = true;
-				$result = $this->db_connection->query('BEGIN');
+				$result = $this->db_connection->exec('BEGIN');
 				break;
 
 			case 'commit':
 				$this->transaction = false;
-				$result = $this->db_connection->query('COMMIT');
+				$result = $this->db_connection->exec('COMMIT');
 				break;
 
 			case 'rollback':
 				$this->transaction = false;
-				$result = $this->db_connection->query('ROLLBACK');
+				$result = $this->db_connection->exec('ROLLBACK');
 				break;
 
 			default: