4 * @file src/Model/ItemDeliveryData.php
7 namespace Friendica\Model;
9 use Friendica\Database\DBA;
11 class ItemDeliveryData
13 const LEGACY_FIELD_LIST = [
14 // Legacy fields moved from item table
20 // New delivery fields with virtual field name in item fields
21 'queue_count' => 'delivery_queue_count',
22 'queue_done' => 'delivery_queue_done',
26 * Extract delivery data from the provided item fields
28 * @param array $fields
31 public static function extractFields(array &$fields)
34 foreach (ItemDeliveryData::FIELD_LIST as $key => $field) {
35 if (is_int($key) && isset($fields[$field])) {
36 // Legacy field moved from item table
37 $delivery_data[$field] = $fields[$field];
38 $fields[$field] = null;
39 } elseif (isset($fields[$field])) {
40 // New delivery field with virtual field name in item fields
41 $delivery_data[$key] = $fields[$field];
42 unset($fields[$field]);
46 return $delivery_data;
50 * Increments the queue_done for the given item ID.
52 * Avoids racing condition between multiple delivery threads.
54 * @param integer $item_id
57 public static function incrementQueueDone($item_id)
59 return DBA::e('UPDATE `item-delivery-data` SET `queue_done` = `queue_done` + 1 WHERE `iid` = ?', $item_id);
63 * Insert a new item delivery data entry
65 * @param integer $item_id
66 * @param array $fields
69 public static function insert($item_id, array $fields)
71 if (empty($item_id)) {
72 throw new \BadMethodCallException('Empty item_id');
75 $fields['iid'] = $item_id;
77 return DBA::insert('item-delivery-data', $fields);
81 * Update/Insert item delivery data
83 * If you want to update queue_done, please use incrementQueueDone instead.
85 * @param integer $item_id
86 * @param array $fields
89 public static function update($item_id, array $fields)
91 if (empty($item_id)) {
92 throw new \BadMethodCallException('Empty item_id');
96 // Nothing to do, update successful
100 return DBA::update('item-delivery-data', $fields, ['iid' => $item_id], true);
104 * Delete item delivery data
106 * @param integer $item_id
109 public static function delete($item_id)
111 if (empty($item_id)) {
112 throw new \BadMethodCallException('Empty item_id');
115 return DBA::delete('item-delivery-data', ['iid' => $item_id]);