Add method "getByField"

1 files changed, 17 insertions, 0 deletions

diff --git a/core/namespace/Item.php b/core/namespace/Item.php
index d21a4d6..60f7547 100644
--- a/core/namespace/Item.php
+++ b/core/namespace/Item.php
@@ -167,5 +167,22 @@ abstract class Item implements ItemInterface {
 
 		return 0;
 	}
+
+	#===============================================================================
+	# Return Attribute instance based on field comparison with value
+	#===============================================================================
+	public static function getByField($field, $value, \Database $Database): Attribute {
+		$exception = (new ReflectionClass(get_called_class()))->getNamespaceName().'\\Exception';
+		$attribute = (new ReflectionClass(get_called_class()))->getNamespaceName().'\\Attribute';
+		$Statement = $Database->prepare('SELECT * FROM '.$attribute::TABLE." WHERE {$field} = ?");
+
+		if($Statement->execute([$value])) {
+			if(!$Attribute = $Statement->fetchObject($attribute)) {
+				throw new $exception(sprintf("Item with value %s on field %s does not exist.", $value, $field));
+			}
+
+			return $Attribute;
+		}
+	}
 }
 ?>
\ No newline at end of file