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
|
<?php
namespace Imagify\Traits;
defined( 'ABSPATH' ) || die( 'Cheatin’ uh?' );
/**
* Trait to use to connect medias and database.
* It also cache the results.
* Classes using that trait must define a protected property $db_class_name (string) containing the media SQL DB class name.
*
* @since 1.9
* @author Grégory Viguier
*/
trait MediaRowTrait {
/**
* The media SQL data row.
*
* @var array
* @since 1.9
* @access protected
* @author Grégory Viguier
*/
protected $row;
/**
* The media ID.
*
* @var int
* @since 1.9
* @access protected
* @author Grégory Viguier
*/
protected $id;
/**
* Get the row.
*
* @since 1.9
* @access public
* @author Grégory Viguier
*
* @return array
*/
public function get_row() {
if ( isset( $this->row ) ) {
return $this->row;
}
if ( ! $this->db_class_name || $this->id <= 0 ) {
return $this->invalidate_row();
}
$this->row = $this->get_row_db_instance()->get( $this->id );
if ( ! $this->row ) {
return $this->invalidate_row();
}
return $this->row;
}
/**
* Update the row.
*
* @since 1.9
* @access public
* @author Grégory Viguier
*
* @param array $data The data to update.
*/
public function update_row( $data ) {
if ( ! $this->db_class_name || $this->id <= 0 ) {
return;
}
$this->get_row_db_instance()->update( $this->id, $data );
$this->reset_row_cache();
}
/**
* Delete the row.
*
* @since 1.9
* @access public
* @author Grégory Viguier
*/
public function delete_row() {
if ( ! $this->db_class_name || $this->id <= 0 ) {
return;
}
$this->get_row_db_instance()->delete( $this->id );
$this->invalidate_row();
}
/**
* Shorthand to get the DB table instance.
*
* @since 1.9
* @access public
* @author Grégory Viguier
*
* @return \Imagify\DB\DBInterface The DB table instance.
*/
public function get_row_db_instance() {
return call_user_func( [ $this->db_class_name, 'get_instance' ] );
}
/**
* Invalidate the row, by setting it to an empty array.
*
* @since 1.9
* @access public
* @author Grégory Viguier
*
* @return array The row.
*/
public function invalidate_row() {
$this->row = [];
return $this->row;
}
/**
* Reset the row cache.
*
* @since 1.9
* @access public
* @author Grégory Viguier
*
* @return null The row.
*/
public function reset_row_cache() {
$this->row = null;
return $this->row;
}
}
|