Home
last modified time | relevance | path

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

12

/plugin/davcal/vendor/sabre/dav/bin/
H A Dmigrateto20.php221 $pdo->exec("
266 $pdo->exec("
285 $pdo->exec("
322 $pdo->exec("
330 $pdo->exec("
335 $pdo->exec("
343 $pdo->exec("
388 $pdo->exec("
404 $pdo->exec("
421 $pdo->exec("
[all …]
H A 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('
109 $pdo->exec('
140 $pdo->exec('ALTER TABLE propertystorage ADD valuetype INT UNSIGNED');
143 $pdo->exec('ALTER TABLE propertystorage ADD valuetype INT');
[all …]
H A 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');
147 $result = $pdo->query('SELECT id, calendardata FROM calendarobjects');
181 $row = $pdo->query("SELECT * FROM calendars LIMIT 1")->fetch();
191 switch($pdo->getAttribute(PDO::ATTR_DRIVER_NAME)) {
[all …]
H A 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');
146 $pdo->exec('CREATE TABLE IF NOT EXISTS schedulingobjects
161 $pdo->exec('CREATE TABLE IF NOT EXISTS schedulingobjects (
[all …]
/plugin/davcal/vendor/sabre/dav/tests/Sabre/DAVACL/PrincipalBackend/
H A 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();
79 $pdo = $this->getPDO();
89 $pdo = $this->getPDO();
108 $pdo = $this->getPDO();
[all …]
H A 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;
H A 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/webdav/vendor/sabre/dav/lib/CalDAV/Backend/
H A 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…
242 …$stmt = $this->pdo->prepare('INSERT INTO simple_calendarobjects (calendarid, uri, calendardata) VA…
[all …]
H A 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
264 $calendarId = $this->pdo->lastInsertId(
521 $stmt = $this->pdo->prepare($query);
847 $stmt = $this->pdo->prepare($query);
900 $stmt = $this->pdo->prepare($query);
1170 return $this->pdo->lastInsertId(
1354 $insertStmt = $this->pdo->prepare('
[all …]
/plugin/webdav/vendor/sabre/dav/lib/CardDAV/Backend/
H A DPDO.php24 protected $pdo; variable in Sabre\\CardDAV\\Backend\\PDO
48 function __construct(\PDO $pdo) { argument
50 $this->pdo = $pdo;
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 = ?');
288 $stmt = $this->pdo->prepare($query);
487 $stmt = $this->pdo->prepare($query);
[all …]
/plugin/davcal/vendor/sabre/dav/lib/CardDAV/Backend/
H A DPDO.php24 protected $pdo; variable in Sabre\\CardDAV\\Backend\\PDO
48 function __construct(\PDO $pdo) { argument
50 $this->pdo = $pdo;
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 = ?');
284 $stmt = $this->pdo->prepare($query);
482 $stmt = $this->pdo->prepare($query);
[all …]
/plugin/davcal/vendor/sabre/dav/tests/Sabre/CalDAV/Backend/
H A 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;
H A 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/
H A 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/tests/Sabre/DAV/Auth/Backend/
H A 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/lib/DAVACL/PrincipalBackend/
H A 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);
355 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->groupMembersTableName . ' WHERE principal_id =…
360 …$stmt = $this->pdo->prepare('INSERT INTO ' . $this->groupMembersTableName . ' (principal_id, membe…
[all …]
/plugin/davcal/vendor/sabre/dav/tests/Sabre/DAV/PropertyStorage/Backend/
H A 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;
H A 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/
H A 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/
H A 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/Locks/Backend/
H A 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/davcal/vendor/sabre/dav/lib/DAV/PropertyStorage/Backend/
H A 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/dbquery/
H A Dhelper.php12 protected $pdo = []; variable in helper_plugin_dbquery
48 if (isset($this->pdo[$conid])) return $this->pdo[$conid];
56 $this->pdo[$conid] = new PDO($dsn, $user, $pass, $opts);
57 return $this->pdo[$conid];
74 $pdo = $this->getPDO();
76 $sth = $this->prepareStatement($pdo, $query, $params);
87 * @param PDO $pdo
92 public function prepareStatement(\PDO $pdo, $sql, $parameters) argument
105 $sth = $pdo->prepare($sql);
/plugin/webdav/vendor/sabre/dav/lib/DAVACL/PrincipalBackend/
H A 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);
400 …$stmt = $this->pdo->prepare('DELETE FROM ' . $this->groupMembersTableName . ' WHERE principal_id =…
405 …$stmt = $this->pdo->prepare('INSERT INTO ' . $this->groupMembersTableName . ' (principal_id, membe…
[all …]
/plugin/davcal/vendor/sabre/dav/tests/Sabre/
H A DTestUtil.php41 $pdo = new \PDO(SABRE_MYSQLDSN,SABRE_MYSQLUSER,SABRE_MYSQLPASS);
42 $pdo->setAttribute(\PDO::ATTR_ERRMODE,\PDO::ERRMODE_EXCEPTION);
43 return $pdo;
52 $pdo = new \PDO('sqlite:'.SABRE_TEMPDIR.'/pdobackend');
53 $pdo->setAttribute(\PDO::ATTR_ERRMODE,\PDO::ERRMODE_EXCEPTION);
54 return $pdo;

12