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