2 // This file is part of Moodle - http://moodle.org/
4 // Moodle is free software: you can redistribute it and/or modify
5 // it under the terms of the GNU General Public License as published by
6 // the Free Software Foundation, either version 3 of the License, or
7 // (at your option) any later version.
9 // Moodle is distributed in the hope that it will be useful,
10 // but WITHOUT ANY WARRANTY; without even the implied warranty of
11 // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 // GNU General Public License for more details.
14 // You should have received a copy of the GNU General Public License
15 // along with Moodle. If not, see <http://www.gnu.org/licenses/>.
18 * Abstract class for objects saved to the DB.
21 * @copyright 2015 Damyon Wiese
22 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
25 defined('MOODLE_INTERNAL') ||
die();
28 use invalid_parameter_exception
;
35 * Abstract class for core objects saved to the DB.
37 * @copyright 2015 Damyon Wiese
38 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
40 abstract class persistent
{
42 /** The table name. */
45 /** @var array The model data. */
46 private $data = array();
48 /** @var array The list of validation errors. */
49 private $errors = array();
51 /** @var boolean If the data was already validated. */
52 private $validated = false;
55 * Create an instance of this class.
57 * @param int $id If set, this is the id of an existing record, used to load the data.
58 * @param stdClass $record If set will be passed to {@link self::from_record()}.
60 public function __construct($id = 0, stdClass
$record = null) {
64 $this->raw_set('id', $id);
67 if (!empty($record)) {
68 $this->from_record($record);
70 if ($CFG->debugdeveloper
) {
71 $this->verify_protected_methods();
76 * This function is used to verify that custom getters and setters are declared as protected.
78 * Persistent properties should always be accessed via get('property') and set('property', 'value') which
79 * will call the custom getter or setter if it exists. We do not want to allow inconsistent access to the properties.
81 final protected function verify_protected_methods() {
82 $properties = static::properties_definition();
84 foreach ($properties as $property => $definition) {
85 $method = 'get_' . $property;
86 if (method_exists($this, $method)) {
87 $reflection = new ReflectionMethod($this, $method);
88 if (!$reflection->isProtected()) {
89 throw new coding_exception('The method ' . get_class($this) . '::'. $method . ' should be protected.');
92 $method = 'set_' . $property;
93 if (method_exists($this, $method)) {
94 $reflection = new ReflectionMethod($this, $method);
95 if (!$reflection->isProtected()) {
96 throw new coding_exception('The method ' . get_class($this) . '::'. $method . ' should be protected.');
105 * This is the main setter for all the properties. Developers can implement their own setters (set_propertyname)
106 * and they will be called by this function. Custom setters should call internal_set() to finally set the value.
107 * Internally this is not used {@link self::to_record()} or
108 * {@link self::from_record()} because the data is not expected to be validated or changed when reading/writing
109 * raw records from the DB.
111 * @param string $property The property name.
114 final public function set($property, $value) {
115 if (!static::has_property($property)) {
116 throw new coding_exception('Unexpected property \'' . s($property) .'\' requested.');
118 $methodname = 'set_' . $property;
119 if (method_exists($this, $methodname)) {
120 $this->$methodname($value);
123 return $this->raw_set($property, $value);
129 * This is the main getter for all the properties. Developers can implement their own getters (get_propertyname)
130 * and they will be called by this function. Custom getters can use raw_get to get the raw value.
131 * Internally this is not used by {@link self::to_record()} or
132 * {@link self::from_record()} because the data is not expected to be validated or changed when reading/writing
133 * raw records from the DB.
135 * @param string $property The property name.
138 final public function get($property) {
139 if (!static::has_property($property)) {
140 throw new coding_exception('Unexpected property \'' . s($property) .'\' requested.');
142 $methodname = 'get_' . $property;
143 if (method_exists($this, $methodname)) {
144 return $this->$methodname();
146 return $this->raw_get($property);
150 * Internal Data getter.
152 * This is the main getter for all the properties. Developers can implement their own getters
153 * but they should be calling {@link self::get()} in order to retrieve the value. Essentially
154 * the getters defined by the developers would only ever be used as helper methods and will not
155 * be called internally at this stage. In other words, do not expect {@link self::to_record()} or
156 * {@link self::from_record()} to use them.
158 * This is protected because it is only for raw low level access to the data fields.
159 * Note this function is named raw_get and not get_raw to avoid naming clashes with a property named raw.
161 * @param string $property The property name.
164 final protected function raw_get($property) {
165 if (!static::has_property($property)) {
166 throw new coding_exception('Unexpected property \'' . s($property) .'\' requested.');
168 if (!array_key_exists($property, $this->data
) && !static::is_property_required($property)) {
169 $this->raw_set($property, static::get_property_default_value($property));
171 return isset($this->data
[$property]) ?
$this->data
[$property] : null;
177 * This is the main setter for all the properties. Developers can implement their own setters
178 * but they should always be calling {@link self::set()} in order to set the value. Essentially
179 * the setters defined by the developers are helper methods and will not be called internally
180 * at this stage. In other words do not expect {@link self::to_record()} or
181 * {@link self::from_record()} to use them.
183 * This is protected because it is only for raw low level access to the data fields.
185 * @param string $property The property name.
186 * @param mixed $value The value.
189 final protected function raw_set($property, $value) {
190 if (!static::has_property($property)) {
191 throw new coding_exception('Unexpected property \'' . s($property) .'\' requested.');
193 if (!array_key_exists($property, $this->data
) ||
$this->data
[$property] != $value) {
194 // If the value is changing, we invalidate the model.
195 $this->validated
= false;
197 $this->data
[$property] = $value;
203 * Return the custom definition of the properties of this model.
205 * Each property MUST be listed here.
207 * The result of this method is cached internally for the whole request.
209 * The 'default' value can be a Closure when its value may change during a single request.
210 * For example if the default value is based on a $CFG property, then it should be wrapped in a closure
211 * to avoid running into scenarios where the true value of $CFG is not reflected in the definition.
212 * Do not abuse closures as they obviously add some overhead.
217 * 'property_name' => array(
218 * 'default' => 'Default value', // When not set, the property is considered as required.
219 * 'message' => new lang_string(...), // Defaults to invalid data error message.
220 * 'null' => NULL_ALLOWED, // Defaults to NULL_NOT_ALLOWED. Takes NULL_NOW_ALLOWED or NULL_ALLOWED.
221 * 'type' => PARAM_TYPE, // Mandatory.
222 * 'choices' => array(1, 2, 3) // An array of accepted values.
227 * 'dynamic_property_name' => array(
228 * 'default' => function() {
229 * return $CFG->something;
231 * 'type' => PARAM_INT,
235 * @return array Where keys are the property names.
237 protected static function define_properties() {
242 * Get the properties definition of this model..
246 final public static function properties_definition() {
254 $def = static::define_properties();
259 $def['timecreated'] = array(
263 $def['timemodified'] = array(
267 $def['usermodified'] = array(
272 // List of reserved property names. Mostly because we have methods (getters/setters) which would confict with them.
273 // Think about backwards compability before adding new ones here!
274 $reserved = array('errors', 'formatted_properties', 'records', 'records_select', 'property_default_value',
275 'property_error_message', 'sql_fields');
277 foreach ($def as $property => $definition) {
279 // Ensures that the null property is always set.
280 if (!array_key_exists('null', $definition)) {
281 $def[$property]['null'] = NULL_NOT_ALLOWED
;
284 // Warn the developers when they are doing something wrong.
285 if ($CFG->debugdeveloper
) {
286 if (!array_key_exists('type', $definition)) {
287 throw new coding_exception('Missing type for: ' . $property);
289 } else if (isset($definition['message']) && !($definition['message'] instanceof lang_string
)) {
290 throw new coding_exception('Invalid error message for: ' . $property);
292 } else if (in_array($property, $reserved)) {
293 throw new coding_exception('This property cannot be defined: ' . $property);
303 * Gets all the formatted properties.
305 * Formatted properties are properties which have a format associated with them.
307 * @return array Keys are property names, values are property format names.
309 final public static function get_formatted_properties() {
310 $properties = static::properties_definition();
312 $formatted = array();
313 foreach ($properties as $property => $definition) {
314 $propertyformat = $property . 'format';
315 if (($definition['type'] == PARAM_RAW ||
$definition['type'] == PARAM_CLEANHTML
)
316 && array_key_exists($propertyformat, $properties)
317 && $properties[$propertyformat]['type'] == PARAM_INT
) {
318 $formatted[$property] = $propertyformat;
326 * Gets the default value for a property.
328 * This assumes that the property exists.
330 * @param string $property The property name.
333 final protected static function get_property_default_value($property) {
334 $properties = static::properties_definition();
335 if (!isset($properties[$property]['default'])) {
338 $value = $properties[$property]['default'];
339 if ($value instanceof \Closure
) {
346 * Gets the error message for a property.
348 * This assumes that the property exists.
350 * @param string $property The property name.
351 * @return lang_string
353 final protected static function get_property_error_message($property) {
354 $properties = static::properties_definition();
355 if (!isset($properties[$property]['message'])) {
356 return new lang_string('invaliddata', 'error');
358 return $properties[$property]['message'];
362 * Returns whether or not a property was defined.
364 * @param string $property The property name.
367 final public static function has_property($property) {
368 $properties = static::properties_definition();
369 return isset($properties[$property]);
373 * Returns whether or not a property is required.
375 * By definition a property with a default value is not required.
377 * @param string $property The property name.
380 final public static function is_property_required($property) {
381 $properties = static::properties_definition();
382 return !array_key_exists('default', $properties[$property]);
386 * Populate this class with data from a DB record.
388 * Note that this does not use any custom setter because the data here is intended to
389 * represent what is stored in the database.
391 * @param \stdClass $record A DB record.
394 final public function from_record(stdClass
$record) {
395 $record = (array) $record;
396 foreach ($record as $property => $value) {
397 $this->raw_set($property, $value);
403 * Create a DB record from this class.
405 * Note that this does not use any custom getter because the data here is intended to
406 * represent what is stored in the database.
410 final public function to_record() {
411 $data = new stdClass();
412 $properties = static::properties_definition();
413 foreach ($properties as $property => $definition) {
414 $data->$property = $this->raw_get($property);
420 * Load the data from the DB.
424 final public function read() {
427 if ($this->get('id') <= 0) {
428 throw new coding_exception('id is required to load');
430 $record = $DB->get_record(static::TABLE
, array('id' => $this->get('id')), '*', MUST_EXIST
);
431 $this->from_record($record);
433 // Validate the data as it comes from the database.
434 $this->validated
= true;
440 * Hook to execute before a create.
442 * Please note that at this stage the data has already been validated and therefore
443 * any new data being set will not be validated before it is sent to the database.
445 * This is only intended to be used by child classes, do not put any logic here!
449 protected function before_create() {
453 * Insert a record in the DB.
457 final public function create() {
460 if ($this->raw_get('id')) {
461 // The validation methods rely on the ID to know if we're updating or not, the ID should be
462 // falsy whenever we are creating an object.
463 throw new coding_exception('Cannot create an object that has an ID defined.');
466 if (!$this->is_valid()) {
467 throw new invalid_persistent_exception($this->get_errors());
470 // Before create hook.
471 $this->before_create();
473 // We can safely set those values bypassing the validation because we know what we're doing.
475 $this->raw_set('timecreated', $now);
476 $this->raw_set('timemodified', $now);
477 $this->raw_set('usermodified', $USER->id
);
479 $record = $this->to_record();
482 $id = $DB->insert_record(static::TABLE
, $record);
483 $this->raw_set('id', $id);
485 // We ensure that this is flagged as validated.
486 $this->validated
= true;
488 // After create hook.
489 $this->after_create();
495 * Hook to execute after a create.
497 * This is only intended to be used by child classes, do not put any logic here!
501 protected function after_create() {
505 * Hook to execute before an update.
507 * Please note that at this stage the data has already been validated and therefore
508 * any new data being set will not be validated before it is sent to the database.
510 * This is only intended to be used by child classes, do not put any logic here!
514 protected function before_update() {
518 * Update the existing record in the DB.
520 * @return bool True on success.
522 final public function update() {
525 if ($this->raw_get('id') <= 0) {
526 throw new coding_exception('id is required to update');
527 } else if (!$this->is_valid()) {
528 throw new invalid_persistent_exception($this->get_errors());
531 // Before update hook.
532 $this->before_update();
534 // We can safely set those values after the validation because we know what we're doing.
535 $this->raw_set('timemodified', time());
536 $this->raw_set('usermodified', $USER->id
);
538 $record = $this->to_record();
539 unset($record->timecreated
);
540 $record = (array) $record;
543 $result = $DB->update_record(static::TABLE
, $record);
545 // We ensure that this is flagged as validated.
546 $this->validated
= true;
548 // After update hook.
549 $this->after_update($result);
555 * Hook to execute after an update.
557 * This is only intended to be used by child classes, do not put any logic here!
559 * @param bool $result Whether or not the update was successful.
562 protected function after_update($result) {
566 * Saves the record to the database.
568 * If this record has an ID, then {@link self::update()} is called, otherwise {@link self::create()} is called.
569 * Before and after hooks for create() or update() will be called appropriately.
573 final public function save() {
574 if ($this->raw_get('id') <= 0) {
582 * Hook to execute before a delete.
584 * This is only intended to be used by child classes, do not put any logic here!
588 protected function before_delete() {
592 * Delete an entry from the database.
594 * @return bool True on success.
596 final public function delete() {
599 if ($this->raw_get('id') <= 0) {
600 throw new coding_exception('id is required to delete');
603 // Hook before delete.
604 $this->before_delete();
606 $result = $DB->delete_records(static::TABLE
, array('id' => $this->raw_get('id')));
608 // Hook after delete.
609 $this->after_delete($result);
611 // Reset the ID to avoid any confusion, this also invalidates the model's data.
613 $this->raw_set('id', 0);
620 * Hook to execute after a delete.
622 * This is only intended to be used by child classes, do not put any logic here!
624 * @param bool $result Whether or not the delete was successful.
627 protected function after_delete($result) {
631 * Hook to execute before the validation.
633 * This hook will not affect the validation results in any way but is useful to
634 * internally set properties which will need to be validated.
636 * This is only intended to be used by child classes, do not put any logic here!
640 protected function before_validate() {
644 * Validates the data.
646 * Developers can implement addition validation by defining a method as follows. Note that
647 * the method MUST return a lang_string() when there is an error, and true when the data is valid.
649 * protected function validate_propertyname($value) {
650 * if ($value !== 'My expected value') {
651 * return new lang_string('invaliddata', 'error');
656 * It is OK to use other properties in your custom validation methods when you need to, however note
657 * they might not have been validated yet, so try not to rely on them too much.
659 * Note that the validation methods should be protected. Validating just one field is not
660 * recommended because of the possible dependencies between one field and another,also the
661 * field ID can be used to check whether the object is being updated or created.
663 * When validating foreign keys the persistent should only check that the associated model
664 * exists. The validation methods should not be used to check for a change in that relationship.
665 * The API method setting the attributes on the model should be responsible for that.
666 * E.g. On a course model, the method validate_categoryid will check that the category exists.
667 * However, if a course can never be moved outside of its category it would be up to the calling
668 * code to ensure that the category ID will not be altered.
670 * @return array|true Returns true when the validation passed, or an array of properties with errors.
672 final public function validate() {
675 // Before validate hook.
676 $this->before_validate();
678 // If this object has not been validated yet.
679 if ($this->validated
!== true) {
682 $properties = static::properties_definition();
683 foreach ($properties as $property => $definition) {
685 // Get the data, bypassing the potential custom getter which could alter the data.
686 $value = $this->raw_get($property);
688 // Check if the property is required.
689 if ($value === null && static::is_property_required($property)) {
690 $errors[$property] = new lang_string('requiredelement', 'form');
694 // Check that type of value is respected.
696 if ($definition['type'] === PARAM_BOOL
&& $value === false) {
697 // Validate_param() does not like false with PARAM_BOOL, better to convert it to int.
700 if ($definition['type'] === PARAM_CLEANHTML
) {
701 // We silently clean for this type. It may introduce changes even to valid data.
702 $value = clean_param($value, PARAM_CLEANHTML
);
704 validate_param($value, $definition['type'], $definition['null']);
705 } catch (invalid_parameter_exception
$e) {
706 $errors[$property] = static::get_property_error_message($property);
710 // Check that the value is part of a list of allowed values.
711 if (isset($definition['choices']) && !in_array($value, $definition['choices'])) {
712 $errors[$property] = static::get_property_error_message($property);
716 // Call custom validation method.
717 $method = 'validate_' . $property;
718 if (method_exists($this, $method)) {
720 // Warn the developers when they are doing something wrong.
721 if ($CFG->debugdeveloper
) {
722 $reflection = new ReflectionMethod($this, $method);
723 if (!$reflection->isProtected()) {
724 throw new coding_exception('The method ' . get_class($this) . '::'. $method . ' should be protected.');
728 $valid = $this->{$method}($value);
729 if ($valid !== true) {
730 if (!($valid instanceof lang_string
)) {
731 throw new coding_exception('Unexpected error message.');
733 $errors[$property] = $valid;
739 $this->validated
= true;
740 $this->errors
= $errors;
743 return empty($this->errors
) ?
true : $this->errors
;
747 * Returns whether or not the model is valid.
749 * @return boolean True when it is.
751 final public function is_valid() {
752 return $this->validate() === true;
756 * Returns the validation errors.
760 final public function get_errors() {
762 return $this->errors
;
766 * Extract a record from a row of data.
768 * Most likely used in combination with {@link self::get_sql_fields()}. This method is
769 * simple enough to be used by non-persistent classes, keep that in mind when modifying it.
771 * e.g. persistent::extract_record($row, 'user'); should work.
773 * @param stdClass $row The row of data.
774 * @param string $prefix The prefix the data fields are prefixed with, defaults to the table name followed by underscore.
775 * @return stdClass The extracted data.
777 public static function extract_record($row, $prefix = null) {
778 if ($prefix === null) {
779 $prefix = str_replace('_', '', static::TABLE
) . '_';
781 $prefixlength = strlen($prefix);
783 $data = new stdClass();
784 foreach ($row as $property => $value) {
785 if (strpos($property, $prefix) === 0) {
786 $propertyname = substr($property, $prefixlength);
787 $data->$propertyname = $value;
795 * Load a list of records.
797 * @param array $filters Filters to apply.
798 * @param string $sort Field to sort by.
799 * @param string $order Sort order.
800 * @param int $skip Limitstart.
801 * @param int $limit Number of rows to return.
803 * @return \core\persistent[]
805 public static function get_records($filters = array(), $sort = '', $order = 'ASC', $skip = 0, $limit = 0) {
810 $orderby = $sort . ' ' . $order;
813 $records = $DB->get_records(static::TABLE
, $filters, $orderby, '*', $skip, $limit);
814 $instances = array();
816 foreach ($records as $record) {
817 $newrecord = new static(0, $record);
818 array_push($instances, $newrecord);
824 * Load a single record.
826 * @param array $filters Filters to apply.
827 * @return false|\core\persistent
829 public static function get_record($filters = array()) {
832 $record = $DB->get_record(static::TABLE
, $filters);
833 return $record ?
new static(0, $record) : false;
837 * Load a list of records based on a select query.
839 * @param string $select
840 * @param array $params
841 * @param string $sort
842 * @param string $fields
843 * @param int $limitfrom
844 * @param int $limitnum
845 * @return \core\persistent[]
847 public static function get_records_select($select, $params = null, $sort = '', $fields = '*', $limitfrom = 0, $limitnum = 0) {
850 $records = $DB->get_records_select(static::TABLE
, $select, $params, $sort, $fields, $limitfrom, $limitnum);
852 // We return class instances.
853 $instances = array();
854 foreach ($records as $key => $record) {
855 $instances[$key] = new static(0, $record);
863 * Return the list of fields for use in a SELECT clause.
865 * Having the complete list of fields prefixed allows for multiple persistents to be fetched
866 * in a single query. Use {@link self::extract_record()} to extract the records from the query result.
868 * @param string $alias The alias used for the table.
869 * @param string $prefix The prefix to use for each field, defaults to the table name followed by underscore.
870 * @return string The SQL fragment.
872 public static function get_sql_fields($alias, $prefix = null) {
876 if ($prefix === null) {
877 $prefix = str_replace('_', '', static::TABLE
) . '_';
880 // Get the properties and move ID to the top.
881 $properties = static::properties_definition();
882 $id = $properties['id'];
883 unset($properties['id']);
884 $properties = array('id' => $id) +
$properties;
886 foreach ($properties as $property => $definition) {
887 $as = $prefix . $property;
888 $fields[] = $alias . '.' . $property . ' AS ' . $as;
890 // Warn developers that the query will not always work.
891 if ($CFG->debugdeveloper
&& strlen($as) > 30) {
892 throw new coding_exception("The alias '$as' for column '$alias.$property' exceeds 30 characters" .
893 " and will therefore not work across all supported databases.");
897 return implode(', ', $fields);
901 * Count a list of records.
903 * @param array $conditions An array of conditions.
906 public static function count_records(array $conditions = array()) {
909 $count = $DB->count_records(static::TABLE
, $conditions);
914 * Count a list of records.
916 * @param string $select
917 * @param array $params
920 public static function count_records_select($select, $params = null) {
923 $count = $DB->count_records_select(static::TABLE
, $select, $params);
928 * Check if a record exists by ID.
930 * @param int $id Record ID.
933 public static function record_exists($id) {
935 return $DB->record_exists(static::TABLE
, array('id' => $id));
939 * Check if a records exists.
941 * @param string $select
942 * @param array $params
945 public static function record_exists_select($select, array $params = null) {
947 return $DB->record_exists_select(static::TABLE
, $select, $params);