1 files changed, 69 insertions, 0 deletions
diff --git a/vendor/sabre/dav/tests/Sabre/CardDAV/Backend/PDOSqliteTest.php b/vendor/sabre/dav/tests/Sabre/CardDAV/Backend/PDOSqliteTest.php
new file mode 100644
index 000000000..a9bbb0bd1
--- /dev/null
+++ b/vendor/sabre/dav/tests/Sabre/CardDAV/Backend/PDOSqliteTest.php
@@ -0,0 +1,69 @@
+<?php
+
+namespace Sabre\CardDAV\Backend;
+
+require_once 'Sabre/TestUtil.php';
+
+class PDOSqliteTest extends AbstractPDOTest {
+
+    function tearDown() {
+
+        if (file_exists(SABRE_TEMPDIR . '/pdobackend')) unlink(SABRE_TEMPDIR . '/pdobackend');
+        if (file_exists(SABRE_TEMPDIR . '/pdobackend2')) unlink(SABRE_TEMPDIR . '/pdobackend2');
+
+    }
+
+    /**
+     * @return PDO
+     */
+    function getPDO() {
+
+        if (!SABRE_HASSQLITE) $this->markTestSkipped('SQLite driver is not available');
+        $pdo = new \PDO('sqlite:'.SABRE_TEMPDIR.'/pdobackend');
+        $pdo->setAttribute(\PDO::ATTR_ERRMODE,\PDO::ERRMODE_EXCEPTION);
+
+        $pdo->query("DROP TABLE IF EXISTS addressbooks");
+        $pdo->query("DROP TABLE IF EXISTS cards");
+        $pdo->query("
+CREATE TABLE addressbooks (
+    id integer primary key asc,
+    principaluri text,
+    displayname text,
+    uri text,
+    description text,
+	ctag integer
+);
+
+");
+
+        $pdo->query("
+INSERT INTO addressbooks
+    (principaluri, displayname, uri, description, ctag)
+VALUES
+    ('principals/user1', 'book1', 'book1', 'addressbook 1', 1);
+");
+
+        $pdo->query("
+
+CREATE TABLE cards (
+	id integer primary key asc,
+    addressbookid integer,
+    carddata text,
+    uri text,
+    lastmodified integer
+);
+
+");
+        $pdo->query("
+INSERT INTO cards
+    (addressbookid, carddata, uri, lastmodified)
+VALUES
+    (1, 'card1', 'card1', 0);
+");
+
+        return $pdo;
+
+    }
+
+}
+