3 require_once 'Sabre/TestUtil.php';
5 class Sabre_CardDAV_Backend_PDOSqliteTest extends Sabre_CardDAV_Backend_AbstractPDOTest {
9 if (file_exists(SABRE_TEMPDIR . '/pdobackend')) unlink(SABRE_TEMPDIR . '/pdobackend');
10 if (file_exists(SABRE_TEMPDIR . '/pdobackend2')) unlink(SABRE_TEMPDIR . '/pdobackend2');
19 if (!SABRE_HASSQLITE) $this->markTestSkipped('SQLite driver is not available');
20 $pdo = new PDO('sqlite:'.SABRE_TEMPDIR.'/pdobackend');
21 $pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
23 $pdo->query("DROP TABLE IF EXISTS addressbooks");
24 $pdo->query("DROP TABLE IF EXISTS cards");
26 CREATE TABLE addressbooks (
27 id integer primary key asc,
38 INSERT INTO addressbooks
39 (principaluri, displayname, uri, description, ctag)
41 ('principals/user1', 'book1', 'book1', 'addressbook 1', 1);
47 id integer primary key asc,
48 addressbookid integer,
57 (addressbookid, carddata, uri, lastmodified)
59 (1, 'card1', 'card1', 0);