Home
last modified time | relevance | path

Searched refs:pdo (Results 1 – 25 of 50) sorted by relevance

12

/plugin/davcal/vendor/sabre/dav/bin/
Dmigrateto20.php62 $pdo = new PDO($dsn, $user, $pass); variable
63 $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
64 $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
66 $driver = $pdo->getAttribute(PDO::ATTR_DRIVER_NAME);
90 $row = $pdo->query("SELECT * FROM $tableName LIMIT 1")->fetch();
102 $pdo->exec("RENAME TABLE $tableName TO $tableNameOld");
105 $pdo->exec("
123 $pdo->exec("
139 $pdo->exec("ALTER TABLE $tableName RENAME TO $tableNameOld");
143 $pdo->exec("
[all …]
Dmigrateto30.php62 $pdo = new PDO($dsn, $user, $pass); variable
63 $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
64 $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
66 $driver = $pdo->getAttribute(PDO::ATTR_DRIVER_NAME);
84 $result = $pdo->query('SELECT * FROM propertystorage LIMIT 1');
95 $pdo->exec('RENAME TABLE propertystorage TO propertystorage_old' . $random);
96 $pdo->exec('
105 …$pdo->exec('CREATE UNIQUE INDEX path_property_' . $random . ' ON propertystorage (path(600), name…
108 $pdo->exec('ALTER TABLE propertystorage RENAME TO propertystorage_old' . $random);
109 $pdo->exec('
[all …]
Dmigrateto17.php56 $pdo = new PDO($dsn, $user, $pass); variable
57 $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
58 $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
63 $row = $pdo->query("SELECT * FROM calendarobjects LIMIT 1")->fetch();
105 switch($pdo->getAttribute(PDO::ATTR_DRIVER_NAME)) {
109 $pdo->exec(<<<SQL
120 $pdo->exec('ALTER TABLE calendarobjects ADD etag text');
121 $pdo->exec('ALTER TABLE calendarobjects ADD size integer');
122 $pdo->exec('ALTER TABLE calendarobjects ADD componenttype TEXT');
123 $pdo->exec('ALTER TABLE calendarobjects ADD firstoccurence integer');
[all …]
Dmigrateto21.php63 $pdo = new PDO($dsn, $user, $pass); variable
64 $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
65 $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
67 $driver = $pdo->getAttribute(PDO::ATTR_DRIVER_NAME);
85 $result = $pdo->query('SELECT * FROM calendarobjects LIMIT 1');
108 $pdo->exec('ALTER TABLE calendarobjects ADD uid VARCHAR(200)');
111 $pdo->exec('ALTER TABLE calendarobjects ADD uid TEXT');
115 $result = $pdo->query('SELECT id, calendardata FROM calendarobjects');
116 $stmt = $pdo->prepare('UPDATE calendarobjects SET uid = ? WHERE id = ?');
146 $pdo->exec('CREATE TABLE IF NOT EXISTS schedulingobjects
[all …]
/plugin/davcal/vendor/sabre/dav/tests/Sabre/DAVACL/PrincipalBackend/
DAbstractPDOTest.php15 $pdo = $this->getPDO();
16 $backend = new PDO($pdo);
26 $pdo = $this->getPDO();
27 $backend = new PDO($pdo);
52 $pdo = $this->getPDO();
53 $backend = new PDO($pdo);
69 $pdo = $this->getPDO();
70 $backend = new PDO($pdo);
79 $pdo = $this->getPDO();
80 $backend = new PDO($pdo);
[all …]
DPDOMySQLTest.php16 $pdo = \Sabre\TestUtil::getMySQLDB();
17 if (!$pdo) $this->markTestSkipped('Could not connect to MySQL database');
18 $pdo->query("DROP TABLE IF EXISTS principals");
19 $pdo->query("
29 …$pdo->query("INSERT INTO principals (uri,email,displayname) VALUES ('principals/user','user@exampl…
30 …$pdo->query("INSERT INTO principals (uri,email,displayname) VALUES ('principals/group','group@exam…
31 $pdo->query("DROP TABLE IF EXISTS groupmembers");
32 $pdo->query("CREATE TABLE groupmembers (
39 $pdo->query("INSERT INTO groupmembers (principal_id,member_id) VALUES (2,1)");
41 return $pdo;
DPDOSqliteTest.php23 $pdo = new \PDO('sqlite:'.SABRE_TEMPDIR.'/pdobackend');
24 $pdo->setAttribute(\PDO::ATTR_ERRMODE,\PDO::ERRMODE_EXCEPTION);
25 …$pdo->query('CREATE TABLE principals (id INTEGER PRIMARY KEY ASC, uri TEXT, email VARCHAR(80), dis…
26 … $pdo->query('INSERT INTO principals VALUES (1, "principals/user","user@example.org","User")');
27 … $pdo->query('INSERT INTO principals VALUES (2, "principals/group","group@example.org","Group")');
29 $pdo->query("CREATE TABLE groupmembers (
36 $pdo->query("INSERT INTO groupmembers (principal_id,member_id) VALUES (2,1)");
38 return $pdo;
/plugin/authssocas/vendor/apereo/phpcas/source/CAS/PGTStorage/
DDb.php224 $pdo = $this->_getPdo();
225 $this->_errMode = $pdo->getAttribute(PDO::ATTR_ERRMODE);
226 $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
237 $pdo = $this->_getPdo();
238 $pdo->setAttribute(PDO::ATTR_ERRMODE, $this->_errMode);
313 $pdo = $this->_getPdo();
317 $pdo->beginTransaction();
319 $query = $pdo->query($this->createTableSQL());
322 $pdo->commit();
327 $pdo->rollBack();
[all …]
/plugin/webdav/vendor/sabre/dav/lib/CalDAV/Backend/
DSimplePDO.php41 protected $pdo; variable in Sabre\\CalDAV\\Backend\\SimplePDO
48 function __construct(\PDO $pdo) { argument
50 $this->pdo = $pdo;
81 …$stmt = $this->pdo->prepare("SELECT id, uri FROM simple_calendars WHERE principaluri = ? ORDER BY …
112 … $stmt = $this->pdo->prepare("INSERT INTO simple_calendars (principaluri, uri) VALUES (?, ?)");
115 return $this->pdo->lastInsertId();
127 $stmt = $this->pdo->prepare('DELETE FROM simple_calendarobjects WHERE calendarid = ?');
130 $stmt = $this->pdo->prepare('DELETE FROM simple_calendars WHERE id = ?');
168 …$stmt = $this->pdo->prepare('SELECT id, uri, calendardata FROM simple_calendarobjects WHERE calend…
205 …$stmt = $this->pdo->prepare('SELECT id, uri, calendardata FROM simple_calendarobjects WHERE calend…
[all …]
DPDO.php43 protected $pdo; variable in Sabre\\CalDAV\\Backend\\PDO
126 function __construct(\PDO $pdo) { argument
128 $this->pdo = $pdo;
169 $stmt = $this->pdo->prepare(<<<SQL
261 …$stmt = $this->pdo->prepare("INSERT INTO " . $this->calendarTableName . " (synctoken, components) …
264 $calendarId = $this->pdo->lastInsertId(
278 …$stmt = $this->pdo->prepare("INSERT INTO " . $this->calendarInstancesTableName . " (" . implode(',…
284 $this->pdo->lastInsertId($this->calendarInstancesTableName . '_id_seq')
336 …$stmt = $this->pdo->prepare("UPDATE " . $this->calendarInstancesTableName . " SET " . implode(', '…
361 …$stmt = $this->pdo->prepare('SELECT access FROM ' . $this->calendarInstancesTableName . ' where id…
[all …]
/plugin/webdav/vendor/sabre/dav/lib/CardDAV/Backend/
DPDO.php24 protected $pdo; variable in Sabre\\CardDAV\\Backend\\PDO
48 function __construct(\PDO $pdo) { argument
50 $this->pdo = $pdo;
62 …$stmt = $this->pdo->prepare('SELECT id, uri, displayname, principaluri, description, synctoken FRO…
135 $stmt = $this->pdo->prepare($query);
181 $stmt = $this->pdo->prepare($query);
183 return $this->pdo->lastInsertId(
197 … $stmt = $this->pdo->prepare('DELETE FROM ' . $this->cardsTableName . ' WHERE addressbookid = ?');
200 … $stmt = $this->pdo->prepare('DELETE FROM ' . $this->addressBooksTableName . ' WHERE id = ?');
203 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->addressBookChangesTableName . ' WHERE addressb…
[all …]
/plugin/davcal/vendor/sabre/dav/lib/CardDAV/Backend/
DPDO.php24 protected $pdo; variable in Sabre\\CardDAV\\Backend\\PDO
48 function __construct(\PDO $pdo) { argument
50 $this->pdo = $pdo;
62 …$stmt = $this->pdo->prepare('SELECT id, uri, displayname, principaluri, description, synctoken FRO…
135 $stmt = $this->pdo->prepare($query);
181 $stmt = $this->pdo->prepare($query);
183 return $this->pdo->lastInsertId();
195 … $stmt = $this->pdo->prepare('DELETE FROM ' . $this->cardsTableName . ' WHERE addressbookid = ?');
198 … $stmt = $this->pdo->prepare('DELETE FROM ' . $this->addressBooksTableName . ' WHERE id = ?');
201 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->addressBookChangesTableName . ' WHERE id = ?');
[all …]
/plugin/davcal/vendor/sabre/dav/tests/Sabre/CalDAV/Backend/
DPDOMySQLTest.php14 $pdo = \Sabre\TestUtil::getMySQLDB();
15 if (!$pdo) $this->markTestSkipped('Could not connect to mysql database');
17 …$pdo->query('DROP TABLE IF EXISTS calendarobjects, calendars, calendarchanges, calendarsubscriptio…
27 $pdo->exec($query);
29 $this->pdo = $pdo;
35 $this->pdo = null;
DPDOSqliteTest.php18 $pdo = new \PDO('sqlite:' . SABRE_TEMPDIR . '/testdb.sqlite');
19 $pdo->setAttribute(\PDO::ATTR_ERRMODE,\PDO::ERRMODE_EXCEPTION);
24 $pdo->exec($query);
26 $this->pdo = $pdo;
32 $this->pdo = null;
/plugin/davcal/vendor/sabre/dav/tests/Sabre/CardDAV/Backend/
DPDOSqliteTest.php22 $pdo = new \PDO('sqlite:'.SABRE_TEMPDIR.'/pdobackend');
23 $pdo->setAttribute(\PDO::ATTR_ERRMODE,\PDO::ERRMODE_EXCEPTION);
25 $pdo->query("DROP TABLE IF EXISTS addressbooks");
26 $pdo->query("DROP TABLE IF EXISTS addressbookchanges");
27 $pdo->query("DROP TABLE IF EXISTS cards");
37 $pdo->exec($query);
40 return $pdo;
/plugin/davcal/vendor/sabre/dav/lib/DAVACL/PrincipalBackend/
DPDO.php41 protected $pdo; variable in Sabre\\DAVACL\\PrincipalBackend\\PDO
68 * @param PDO $pdo
70 function __construct(\PDO $pdo) { argument
72 $this->pdo = $pdo;
101 … $result = $this->pdo->query('SELECT ' . implode(',', $fields) . ' FROM ' . $this->tableName);
145 …$stmt = $this->pdo->prepare('SELECT ' . implode(',', $fields) . ' FROM ' . $this->tableName . ' W…
204 $stmt = $this->pdo->prepare($query);
265 $stmt = $this->pdo->prepare($query);
294 …$stmt = $this->pdo->prepare('SELECT principals.uri as uri FROM ' . $this->groupMembersTableName . …
316 …$stmt = $this->pdo->prepare('SELECT principals.uri as uri FROM ' . $this->groupMembersTableName . …
[all …]
/plugin/davcal/vendor/sabre/dav/tests/Sabre/DAV/Auth/Backend/
DPDOMySQLTest.php12 $pdo = \Sabre\TestUtil::getMySQLDB();
13 if (!$pdo) $this->markTestSkipped('Could not connect to MySQL database');
14 $pdo->query("DROP TABLE IF EXISTS users");
15 $pdo->query("
25 …$pdo->query("INSERT INTO users (username,digesta1,email,displayname) VALUES ('user','hash','user@e…
27 return $pdo;
/plugin/davcal/vendor/sabre/dav/tests/Sabre/DAV/PropertyStorage/Backend/
DPDOMysqlTest.php9 $pdo = \Sabre\TestUtil::getMySQLDB();
10 if (!$pdo) $this->markTestSkipped('MySQL is not enabled');
16 $pdo->exec('DROP TABLE IF EXISTS propertystorage');
21 $pdo->exec($sql);
24 …$pdo->exec('INSERT INTO propertystorage (path, name, value) VALUES ("dir", "{DAV:}displayname", "D…
26 return $pdo;
DPDOSqliteTest.php9 $pdo = \Sabre\TestUtil::getSqliteDB();
10 if (!$pdo) $this->markTestSkipped('Sqlite is not enabled');
16 $pdo->exec('DROP TABLE IF EXISTS propertystorage');
21 $pdo->exec($sql);
24 …$pdo->exec('INSERT INTO propertystorage (path, name, value) VALUES ("dir", "{DAV:}displayname", "D…
26 return $pdo;
/plugin/davcal/vendor/sabre/dav/lib/DAV/Auth/Backend/
DPDO.php19 protected $pdo; variable in Sabre\\DAV\\Auth\\Backend\\PDO
34 * @param PDO $pdo
36 function __construct(\PDO $pdo) { argument
38 $this->pdo = $pdo;
51 … $stmt = $this->pdo->prepare('SELECT digesta1 FROM ' . $this->tableName . ' WHERE username = ?');
/plugin/webdav/vendor/sabre/dav/lib/DAV/PropertyStorage/Backend/
DPDO.php43 protected $pdo; variable in Sabre\\DAV\\PropertyStorage\\Backend\\PDO
57 function __construct(\PDO $pdo) { argument
59 $this->pdo = $pdo;
87 $stmt = $this->pdo->prepare($query);
128 if ($this->pdo->getAttribute(\PDO::ATTR_DRIVER_NAME) === 'pgsql') {
146 $updateStmt = $this->pdo->prepare($updateSql);
147 …$deleteStmt = $this->pdo->prepare("DELETE FROM " . $this->tableName . " WHERE path = ? AND name = …
194 …$stmt = $this->pdo->prepare("DELETE FROM " . $this->tableName . " WHERE path = ? OR path LIKE ? E…
225 …$select = $this->pdo->prepare('SELECT id, path FROM ' . $this->tableName . ' WHERE path = ? OR pa…
228 $update = $this->pdo->prepare('UPDATE ' . $this->tableName . ' SET path = ? WHERE id = ?');
/plugin/davcal/vendor/sabre/dav/lib/DAV/PropertyStorage/Backend/
DPDO.php43 protected $pdo; variable in Sabre\\DAV\\PropertyStorage\\Backend\\PDO
50 function __construct(\PDO $pdo) { argument
52 $this->pdo = $pdo;
80 $stmt = $this->pdo->prepare($query);
117 …$updateStmt = $this->pdo->prepare("REPLACE INTO propertystorage (path, name, valuetype, value) VAL…
118 … $deleteStmt = $this->pdo->prepare("DELETE FROM propertystorage WHERE path = ? AND name = ?");
158 …$stmt = $this->pdo->prepare("DELETE FROM propertystorage WHERE path = ? OR path LIKE ? ESCAPE '='"…
189 …$select = $this->pdo->prepare('SELECT id, path FROM propertystorage WHERE path = ? OR path LIKE ?'…
192 $update = $this->pdo->prepare('UPDATE propertystorage SET path = ? WHERE id = ?');
/plugin/davcal/vendor/sabre/dav/lib/DAV/Locks/Backend/
DPDO.php29 * @var pdo
31 protected $pdo; variable in Sabre\\DAV\\Locks\\Backend\\PDO
36 * @param PDO $pdo
38 function __construct(\PDO $pdo) { argument
40 $this->pdo = $pdo;
91 $stmt = $this->pdo->prepare($query);
135 …$stmt = $this->pdo->prepare('UPDATE ' . $this->tableName . ' SET owner = ?, timeout = ?, scope = ?…
146 …$stmt = $this->pdo->prepare('INSERT INTO ' . $this->tableName . ' (owner,timeout,scope,depth,uri,c…
173 … $stmt = $this->pdo->prepare('DELETE FROM ' . $this->tableName . ' WHERE uri = ? AND token = ?');
/plugin/webdav/vendor/sabre/dav/lib/DAVACL/PrincipalBackend/
DPDO.php41 protected $pdo; variable in Sabre\\DAVACL\\PrincipalBackend\\PDO
70 function __construct(\PDO $pdo) { argument
72 $this->pdo = $pdo;
101 … $result = $this->pdo->query('SELECT ' . implode(',', $fields) . ' FROM ' . $this->tableName);
145 …$stmt = $this->pdo->prepare('SELECT ' . implode(',', $fields) . ' FROM ' . $this->tableName . ' W…
204 $stmt = $this->pdo->prepare($query);
264 $stmt = $this->pdo->prepare($query);
309 $stmt = $this->pdo->prepare($query);
339 …$stmt = $this->pdo->prepare('SELECT principals.uri as uri FROM ' . $this->groupMembersTableName . …
361 …$stmt = $this->pdo->prepare('SELECT principals.uri as uri FROM ' . $this->groupMembersTableName . …
[all …]
/plugin/davcal/vendor/sabre/dav/lib/CalDAV/Backend/
DPDO.php37 protected $pdo; variable in Sabre\\CalDAV\\Backend\\PDO
110 function __construct(\PDO $pdo) { argument
112 $this->pdo = $pdo;
152 …$stmt = $this->pdo->prepare("SELECT " . $fields . " FROM " . $this->calendarTableName . " WHERE pr…
236 …$stmt = $this->pdo->prepare("INSERT INTO " . $this->calendarTableName . " (" . implode(', ', $fiel…
239 return $this->pdo->lastInsertId();
285 …$stmt = $this->pdo->prepare("UPDATE " . $this->calendarTableName . " SET " . implode(', ', $values…
305 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->calendarObjectTableName . ' WHERE calendarid =…
308 $stmt = $this->pdo->prepare('DELETE FROM ' . $this->calendarTableName . ' WHERE id = ?');
311 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->calendarChangesTableName . ' WHERE calendarid …
[all …]

12