4 * @file src/Model/Attach.php
5 * @brief This file contains the Attach class for database interface
7 namespace Friendica\Model;
9 use Friendica\BaseObject;
10 use Friendica\Core\StorageManager;
11 use Friendica\Database\DBA;
12 use Friendica\Database\DBStructure;
13 use Friendica\Util\Security;
17 * Class to handle attach dabatase table
19 class Attach extends BaseObject
23 * @brief Return a list of fields that are associated with the attach table
25 * @return array field list
27 private static function getFields()
29 $allfields = DBStructure::definition(false);
30 $fields = array_keys($allfields['attach']['fields']);
31 array_splice($fields, array_search('data', $fields), 1);
36 * @brief Select rows from the attach table
38 * @param array $fields Array of selected fields, empty for all
39 * @param array $conditions Array of fields for conditions
40 * @param array $params Array of several parameters
42 * @return boolean|array
44 * @see \Friendica\Database\DBA::select
46 public static function select(array $fields = [], array $conditions = [], array $params = [])
49 $selected = self::getFields();
52 $r = DBA::select('attach', $fields, $conditions, $params);
53 return DBA::toArray($r);
57 * @brief Retrieve a single record from the attach table
59 * @param array $fields Array of selected fields, empty for all
60 * @param array $conditions Array of fields for conditions
61 * @param array $params Array of several parameters
65 * @see \Friendica\Database\DBA::select
67 public static function selectFirst(array $fields = [], array $conditions = [], array $params = [])
70 $fields = self::getFields();
73 return DBA::selectFirst('attach', $fields, $conditions, $params);
77 * @brief Check if attachment with given conditions exists
79 * @param array $conditions Array of extra conditions
83 public static function exists(array $conditions)
85 return DBA::exists('attach', $conditions);
89 * @brief Retrive a single record given the ID
91 * @param int $id Row id of the record
95 * @see \Friendica\Database\DBA::select
97 public static function getById($id)
99 return self::selectFirst([], ['id' => $id]);
103 * @brief Retrive a single record given the ID
105 * @param int $id Row id of the record
109 * @see \Friendica\Database\DBA::select
111 public static function getByIdWithPermission($id)
113 $r = self::selectFirst(['uid'], ['id' => $id]);
118 $sql_acl = Security::getPermissionsSQLByUserId($r['uid']);
121 '`id` = ?' . $sql_acl,
125 $item = self::selectFirst([], $conditions);
131 * @brief Get file data for given row id. null if row id does not exist
133 * @param array $item Attachment data. Needs at least 'id', 'backend-class', 'backend-ref'
135 * @return string file data
137 public static function getData($item)
139 if ($item['backend-class'] == '') {
140 // legacy data storage in 'data' column
141 $i = self::selectFirst(['data'], ['id' => $item['id']]);
147 $backendClass = $item['backend-class'];
148 $backendRef = $item['backend-ref'];
149 return $backendClass::get($backendRef);