3 require_once 'Sabre/TestUtil.php';
5 class Sabre_DAVACL_PrincipalBackend_PDOMySQLTest extends Sabre_DAVACL_PrincipalBackend_AbstractPDOTest {
9 if (!SABRE_HASMYSQL) $this->markTestSkipped('MySQL driver is not available, or not properly configured');
10 $pdo = Sabre_TestUtil::getMySQLDB();
11 if (!$pdo) $this->markTestSkipped('Could not connect to MySQL database');
12 $pdo->query("DROP TABLE IF EXISTS principals");
14 create table principals (
15 id integer unsigned not null primary key auto_increment,
18 displayname VARCHAR(80),
23 $pdo->query("INSERT INTO principals (uri,email,displayname) VALUES ('principals/user','user@example.org','User')");
24 $pdo->query("INSERT INTO principals (uri,email,displayname) VALUES ('principals/group','group@example.org','Group')");
25 $pdo->query("DROP TABLE IF EXISTS groupmembers");
26 $pdo->query("CREATE TABLE groupmembers (
27 id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
28 principal_id INTEGER UNSIGNED NOT NULL,
29 member_id INTEGER UNSIGNED NOT NULL,
30 UNIQUE(principal_id, member_id)
33 $pdo->query("INSERT INTO groupmembers (principal_id,member_id) VALUES (2,1)");