PDOMySQLTest.php
No OneTemporary
Actions

Size

1 KB

Subscribers

None

PDOMySQLTest.php
View Options

	<?php

	namespace Sabre\DAVACL\PrincipalBackend;

	use Sabre\DAV;
	use Sabre\HTTP;


	require_once 'Sabre/TestUtil.php';

	class PDOMySQLTest extends AbstractPDOTest {

	function getPDO() {

	if (!SABRE_HASMYSQL) $this->markTestSkipped('MySQL driver is not available, or not properly configured');
	$pdo = \Sabre\TestUtil::getMySQLDB();
	if (!$pdo) $this->markTestSkipped('Could not connect to MySQL database');
	$pdo->query("DROP TABLE IF EXISTS principals");
	$pdo->query("
	create table principals (
	id integer unsigned not null primary key auto_increment,
	uri varchar(50),
	email varchar(80),
	displayname VARCHAR(80),
	vcardurl VARCHAR(80),
	unique(uri)
	);");

	$pdo->query("INSERT INTO principals (uri,email,displayname) VALUES ('principals/user','user@example.org','User')");
	$pdo->query("INSERT INTO principals (uri,email,displayname) VALUES ('principals/group','group@example.org','Group')");
	$pdo->query("DROP TABLE IF EXISTS groupmembers");
	$pdo->query("CREATE TABLE groupmembers (
	id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
	principal_id INTEGER UNSIGNED NOT NULL,
	member_id INTEGER UNSIGNED NOT NULL,
	UNIQUE(principal_id, member_id)
	);");

	$pdo->query("INSERT INTO groupmembers (principal_id,member_id) VALUES (2,1)");

	return $pdo;

	}

	}