Various fixes and improvements

1 files changed, 5 insertions, 3 deletions

diff --git a/tests/functionals/ApiTest.php b/tests/functionals/ApiTest.php
index eb1e0cd1..f778d1ca 100644
--- a/tests/functionals/ApiTest.php
+++ b/tests/functionals/ApiTest.php
@@ -26,10 +26,12 @@ class Api extends PHPUnit_Framework_TestCase
         }
 
         $service = new ServiceProvider\DatabaseProvider;
-        $service->getInstance();
 
-        $pdo->exec("UPDATE settings SET value='".API_KEY."' WHERE option='api_token'");
-        $pdo->exec("UPDATE settings SET value='Europe/Paris' WHERE option='application_timezone'");
+        $db = $service->getInstance();
+        $db->table('settings')->eq('option', 'api_token')->update(array('value' => API_KEY));
+        $db->table('settings')->eq('option', 'application_timezone')->update(array('value' => 'Europe/Paris'));
+        $db->closeConnection();
+
         $pdo = null;
     }