X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=dav%2FSabreDAV%2Ftests%2FSabre%2FCardDAV%2FBackend%2FPDOSqliteTest.php;fp=dav%2FSabreDAV%2Ftests%2FSabre%2FCardDAV%2FBackend%2FPDOSqliteTest.php;h=347eb732452c64e26402cbd3a90826f4c543d0ba;hb=7115197a33ad9141c749a83c454a2f85d9c1290a;hp=0000000000000000000000000000000000000000;hpb=45cc9885fca461335b3e6a10ee46a019c6f75b77;p=friendica-addons.git

diff --git a/dav/SabreDAV/tests/Sabre/CardDAV/Backend/PDOSqliteTest.php b/dav/SabreDAV/tests/Sabre/CardDAV/Backend/PDOSqliteTest.php
new file mode 100644
index 00000000..347eb732
--- /dev/null
+++ b/dav/SabreDAV/tests/Sabre/CardDAV/Backend/PDOSqliteTest.php
@@ -0,0 +1,67 @@
+<?php
+
+require_once 'Sabre/TestUtil.php';
+
+class Sabre_CardDAV_Backend_PDOSqliteTest extends Sabre_CardDAV_Backend_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;
+
+    }
+
+}
+