/usr/share/php/sabre21/Sabre/DAV/PropertyStorage/Backend/PDO.php is in php-sabre-dav-2.1 2.1.10-1ubuntu1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 | <?php
namespace Sabre\DAV\PropertyStorage\Backend;
use Sabre\DAV\PropFind;
use Sabre\DAV\PropPatch;
/**
* PropertyStorage PDO backend.
*
* This backend class uses a PDO-enabled database to store webdav properties.
* Both sqlite and mysql have been tested.
*
* The database structure can be found in the examples/sql/ directory.
*
* @copyright Copyright (C) fruux GmbH (https://fruux.com/)
* @author Evert Pot (http://evertpot.com/)
* @license http://sabre.io/license/ Modified BSD License
*/
class PDO implements BackendInterface {
/**
* PDO
*
* @var \PDO
*/
protected $pdo;
/**
* Creates the PDO property storage engine
*
* @param \PDO $pdo
*/
function __construct(\PDO $pdo) {
$this->pdo = $pdo;
}
/**
* Fetches properties for a path.
*
* This method received a PropFind object, which contains all the
* information about the properties that need to be fetched.
*
* Ususually you would just want to call 'get404Properties' on this object,
* as this will give you the _exact_ list of properties that need to be
* fetched, and haven't yet.
*
* @param string $path
* @param PropFind $propFind
* @return void
*/
function propFind($path, PropFind $propFind) {
$propertyNames = $propFind->get404Properties();
if (!$propertyNames) {
return;
}
$query = 'SELECT name, value FROM propertystorage WHERE path = ?';
$stmt = $this->pdo->prepare($query);
$stmt->execute([$path]);
while($row = $stmt->fetch(\PDO::FETCH_ASSOC)) {
$propFind->set($row['name'], $row['value']);
}
}
/**
* Updates properties for a path
*
* This method received a PropPatch object, which contains all the
* information about the update.
*
* Usually you would want to call 'handleRemaining' on this object, to get;
* a list of all properties that need to be stored.
*
* @param string $path
* @param PropPatch $propPatch
* @return void
*/
function propPatch($path, PropPatch $propPatch) {
$propPatch->handleRemaining(function($properties) use ($path) {
$updateStmt = $this->pdo->prepare("REPLACE INTO propertystorage (path, name, value) VALUES (?, ?, ?)");
$deleteStmt = $this->pdo->prepare("DELETE FROM propertystorage WHERE path = ? AND name = ?");
foreach($properties as $name=>$value) {
if (!is_null($value)) {
$updateStmt->execute([$path, $name, $value]);
} else {
$deleteStmt->execute([$path, $name]);
}
}
return true;
});
}
/**
* This method is called after a node is deleted.
*
* This allows a backend to clean up all associated properties.
*
* The delete method will get called once for the deletion of an entire
* tree.
*
* @param string $path
* @return void
*/
function delete($path) {
$stmt = $this->pdo->prepare("DELETE FROM propertystorage WHERE path = ? OR path LIKE ? ESCAPE '='");
$childPath = strtr(
$path,
[
'=' => '==',
'%' => '=%',
'_' => '=_'
]
) . '/%';
$stmt->execute([$path, $childPath]);
}
/**
* This method is called after a successful MOVE
*
* This should be used to migrate all properties from one path to another.
* Note that entire collections may be moved, so ensure that all properties
* for children are also moved along.
*
* @param string $source
* @param string $destination
* @return void
*/
function move($source, $destination) {
// I don't know a way to write this all in a single sql query that's
// also compatible across db engines, so we're letting PHP do all the
// updates. Much slower, but it should still be pretty fast in most
// cases.
$select = $this->pdo->prepare('SELECT id, path FROM propertystorage WHERE path = ? OR path LIKE ?');
$select->execute([$source, $source . '/%']);
$update = $this->pdo->prepare('UPDATE propertystorage SET path = ? WHERE id = ?');
while($row = $select->fetch(\PDO::FETCH_ASSOC)) {
// Sanity check. SQL may select too many records, such as records
// with different cases.
if ($row['path'] !== $source && strpos($row['path'], $source . '/')!==0) continue;
$trailingPart = substr($row['path'], strlen($source)+1);
$newPath = $destination;
if ($trailingPart) {
$newPath.='/' . $trailingPart;
}
$update->execute([$newPath, $row['id']]);
}
}
}
|