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(); }