3 require_once 'Sabre/TestUtil.php';
5 class Sabre_CardDAV_Backend_PDOMySQLTest extends Sabre_CardDAV_Backend_AbstractPDOTest {
10 public function getPDO() {
12 if (!SABRE_HASMYSQL) $this->markTestSkipped('MySQL driver is not available, or not properly configured');
14 $pdo = Sabre_TestUtil::getMySQLDB();
15 if (!$pdo) $this->markTestSkipped('Could not connect to MySQL database');
17 $pdo->query("DROP TABLE IF EXISTS addressbooks");
18 $pdo->query("DROP TABLE IF EXISTS cards");
20 CREATE TABLE addressbooks (
21 id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
22 principaluri VARCHAR(255),
23 displayname VARCHAR(255),
26 ctag INT(11) UNSIGNED NOT NULL DEFAULT '1'
31 INSERT INTO addressbooks
32 (principaluri, displayname, uri, description, ctag)
34 ('principals/user1', 'book1', 'book1', 'addressbook 1', 1);
39 id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
40 addressbookid INT(11) UNSIGNED NOT NULL,
43 lastmodified INT(11) UNSIGNED
49 (addressbookid, carddata, uri, lastmodified)
51 (1, 'card1', 'card1', 0);