function getBackend()
{
if (!SABRE_HASMYSQL) {
$this->markTestSkipped('MySQL driver is not available, or it was not properly configured');
}
$pdo = \Sabre\TestUtil::getMySQLDB();
if (!$pdo) {
$this->markTestSkipped('Could not connect to MySQL database');
}
$pdo->query('DROP TABLE IF EXISTS locks;');
$pdo->query("\nCREATE TABLE locks (\n\tid INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,\n\towner VARCHAR(100),\n\ttimeout INTEGER UNSIGNED,\n\tcreated INTEGER,\n\ttoken VARCHAR(100),\n\tscope TINYINT,\n\tdepth TINYINT,\n\turi text\n);");
$backend = new PDO($pdo);
return $backend;
}
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 users");
$pdo->query("\ncreate table users (\n\tid integer unsigned not null primary key auto_increment,\n\tusername varchar(50),\n\tdigesta1 varchar(32),\n email varchar(80),\n displayname varchar(80),\n\tunique(username)\n);");
$pdo->query("INSERT INTO users (username,digesta1,email,displayname) VALUES ('user','hash','*****@*****.**','User')");
return $pdo;
}
/**
* @return PDO
*/
public 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 addressbooks");
$pdo->query("DROP TABLE IF EXISTS cards");
$pdo->query("\nCREATE TABLE addressbooks (\n id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,\n principaluri VARCHAR(255),\n displayname VARCHAR(255),\n uri VARCHAR(100),\n description TEXT,\n ctag INT(11) UNSIGNED NOT NULL DEFAULT '1'\n);\n");
$pdo->query("\nINSERT INTO addressbooks\n (principaluri, displayname, uri, description, ctag)\nVALUES\n ('principals/user1', 'book1', 'book1', 'addressbook 1', 1);\n");
$pdo->query("\nCREATE TABLE cards (\n id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,\n addressbookid INT(11) UNSIGNED NOT NULL,\n carddata TEXT,\n uri VARCHAR(100),\n lastmodified INT(11) UNSIGNED\n);\n");
$pdo->query("\nINSERT INTO cards\n (addressbookid, carddata, uri, lastmodified)\nVALUES\n (1, 'card1', 'card1', 0);\n");
return $pdo;
}
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("\ncreate table principals (\n\tid integer unsigned not null primary key auto_increment,\n\turi varchar(50),\n email varchar(80),\n displayname VARCHAR(80),\n vcardurl VARCHAR(80),\n\tunique(uri)\n);");
$pdo->query("INSERT INTO principals (uri,email,displayname) VALUES ('principals/user','*****@*****.**','User')");
$pdo->query("INSERT INTO principals (uri,email,displayname) VALUES ('principals/group','*****@*****.**','Group')");
$pdo->query("DROP TABLE IF EXISTS groupmembers");
$pdo->query("CREATE TABLE groupmembers (\n id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,\n principal_id INTEGER UNSIGNED NOT NULL,\n member_id INTEGER UNSIGNED NOT NULL,\n UNIQUE(principal_id, member_id)\n );");
$pdo->query("INSERT INTO groupmembers (principal_id,member_id) VALUES (2,1)");
return $pdo;
}
function getPDO()
{
$pdo = \Sabre\TestUtil::getMySQLDB();
if (!$pdo) {
$this->markTestSkipped('MySQL is not enabled');
}
$setupSql = file_get_contents(__DIR__ . '/../../../../../examples/sql/mysql.propertystorage.sql');
// Sloppy multi-query, but it works
$setupSql = explode(';', $setupSql);
$pdo->exec('DROP TABLE IF EXISTS propertystorage');
foreach ($setupSql as $sql) {
if (!trim($sql)) {
continue;
}
$pdo->exec($sql);
}
$pdo->exec('INSERT INTO propertystorage (path, name, value) VALUES ("dir", "{DAV:}displayname", "Directory")');
return $pdo;
}
function setup()
{
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 calendarobjects, calendars, calendarchanges, calendarsubscriptions, schedulingobjects');
$queries = explode(';', file_get_contents(__DIR__ . '/../../../../examples/sql/mysql.calendars.sql'));
foreach ($queries as $query) {
$query = trim($query, " \r\n\t");
if ($query) {
$pdo->exec($query);
}
}
$this->pdo = $pdo;
}
/**
* @return PDO
*/
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 addressbooks, cards, addressbookchanges");
$queries = explode(';', file_get_contents(__DIR__ . '/../../../../examples/sql/mysql.addressbook.sql'));
foreach ($queries as $query) {
$query = trim($query, " \r\n\t");
if ($query) {
$pdo->exec($query);
}
}
return $pdo;
}
public function tearDown()
{
\Sabre\TestUtil::clearTempDir();
}
function tearDown()
{
\Sabre\TestUtil::clearTempDir();
parent::tearDown();
}
function teardown()
{
\Sabre\TestUtil::clearTempDir();
}
function setUp()
{
\Sabre\TestUtil::clearTempDir();
}
