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');
$pdo->query('CREATE TABLE calendarobjects (
id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
calendardata TEXT,
uri VARCHAR(100),
calendarid INTEGER UNSIGNED NOT NULL,
lastmodified DATETIME
);');
$pdo->query('CREATE TABLE calendars (
id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
principaluri VARCHAR(100),
displayname VARCHAR(100),
uri VARCHAR(100),
ctag INTEGER UNSIGNED NOT NULL DEFAULT \'0\',
description TEXT,
calendarorder INTEGER UNSIGNED NOT NULL DEFAULT \'0\',
calendarcolor VARCHAR(10),
timezone TEXT,
components VARCHAR(20)
);');
$this->pdo = $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 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\tunique(username)\n);");
$pdo->query("INSERT INTO users (username,digesta1,email) VALUES ('user','hash','*****@*****.**')");
return $pdo;
}
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 Sabre_DAV_Locks_Backend_PDO($pdo);
return $backend;
}
/**
* @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\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 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');
$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;
}
function setUp()
{
Sabre_TestUtil::clearTempDir();
}
function tearDown()
{
Sabre_TestUtil::clearTempDir();
}
