Thread: [Argil-svn] SF.net SVN: argil: [541] branches/experimental (Page 2)

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Revision: 541
          http://argil.svn.sourceforge.net/argil/?rev=541&view=rev
Author:   tswicegood
Date:     2007-05-30 17:00:32 -0700 (Wed, 30 May 2007)

Log Message:
-----------
Add the first pass at a generic Model Locator

Added Paths:
-----------
    branches/experimental/src/Argil/Model/Locator.php
    branches/experimental/tests/Argil/Model/LocatorTest.php

Added: branches/experimental/src/Argil/Model/Locator.php
===================================================================

--- branches/experimental/src/Argil/Model/Locator.php	                        (rev 0)
+++ branches/experimental/src/Argil/Model/Locator.php	2007-05-31 00:00:32 UTC (rev 541)
@@ -0,0 +1,47 @@
+<?php
+
+require_once 'Argil/Model/Container.php';
+require_once 'Argil/Util/Template/CamelCapsToUnderscore.php';
+class Argil_Model_Locator
+{
+	private $_pdo = null;
+	
+	public function __construct(PDO $pdo)
+	{
+		$this->_pdo = $pdo;
+	}
+	
+	public function __call($method, $arguments)
+	{
+		if (preg_match('/^findBy(.+)$/', $method, $matches)) {
+			$property = new Argil_Util_Template_CamelCapsToUnderscore($matches[1]);
+			$value = array_shift($arguments);
+			$model = array_shift($arguments);
+			return $this->_findByGivenProperty((string)$property, $value, $model);
+		}
+	}
+	
+	public function findById($id, $model)
+	{
+		$meta = new Argil_Model_Container($model);
+		return $this->_findByGivenProperty($meta->getPrimaryKey(), $id, $model);
+	}
+	
+	private function _findByGivenProperty($property, $value, $model)
+	{
+		$meta = new Argil_Model_Container($model);
+		$statement = $this->_pdo->prepare(
+			"SELECT * FROM {$meta->getTable()} WHERE {$property} = :value"
+		);
+		
+		$statement->execute(array(
+			':value' => $value
+		));
+		
+		$data = $statement->fetch(PDO::FETCH_ASSOC);
+		foreach ($data as $key => $value) {
+			$model->$key = $value;
+		}
+		return new Argil_Model_Container($model);
+	}
+}
\ No newline at end of file

Added: branches/experimental/tests/Argil/Model/LocatorTest.php
===================================================================
--- branches/experimental/tests/Argil/Model/LocatorTest.php	                        (rev 0)
+++ branches/experimental/tests/Argil/Model/LocatorTest.php	2007-05-31 00:00:32 UTC (rev 541)
@@ -0,0 +1,101 @@
+<?php
+
+require_once dirname(__FILE__) . '/../../config.php';
+require_once 'Argil/Model/Locator.php';
+
+/**
+ * @table person
+ */
+class SimpleArgilPerson
+{
+	
+}
+
+class Argil_Model_LocatorTest extends UnitTestCase
+{
+	private $_pdo = null;
+	private $_random = '';
+	public function setup()
+	{
+		$pdo = new PDO('sqlite::memory:');
+		$this->assertTrue(
+			$pdo->exec('CREATE TABLE person (
+							person_id INT,
+							first_name VARCHAR(50),
+							last_name VARCHAR(100)
+						)'
+					  ) !== false,
+			'sanity check - make sure the table is setup properly'
+		);
+		
+		$this->assertTrue(
+			$pdo->exec(
+				"INSERT INTO person VALUES ('1', 'Travis', 'Swicegood')"
+			) !== false,
+			'sanity check - make sure the rows are inserted'
+		);
+		
+		$this->_random = 'Random, ' . rand(1, 10);
+		$this->assertTrue(
+			$pdo->exec(
+				"INSERT INTO person VALUES ('2', 'Joe', '" . $this->_random . "')"
+			) !== false,
+			'sanity check - make sure the rows are inserted'
+		);
+		$this->_pdo = $pdo;
+	}
+	
+	public function testUsedToLocateModelsInPersistentStorageAndReturnThemInModelContainers()
+	{
+		
+	}
+	
+	public function testRequiresPdoObjectAsFirstParameterAtInstantiation()
+	{
+		$reflection = new ReflectionClass('Argil_Model_Locator');
+		$param = array_shift($reflection->getConstructor()->getParameters());
+		$this->assertFalse($param->isOptional());
+		$this->assertEqual($param->getClass()->getName(), 'PDO');
+	}
+	
+	public function testCanLocateAGivenModel()
+	{
+		$locator = new Argil_Model_Locator($this->_pdo);
+		$model = $locator->findById(1, new SimpleArgilPerson());
+		$this->assertIsA($model, 'Argil_Model_Container');
+		$this->assertTrue($model->is('SimpleArgilPerson'));
+		$this->assertEqual('Travis', $model->first_name);
+		$this->assertEqual('Swicegood', $model->last_name);
+		unset($model);
+		
+		$model = $locator->findById(2, new SimpleArgilPerson());
+		$this->assertIsA($model, 'Argil_Model_Container');
+		$this->assertTrue($model->is('SimpleArgilPerson'));
+		$this->assertEqual('Joe', $model->first_name);
+		$this->assertEqual($this->_random, $model->last_name);
+	}
+	
+	public function testCanUseFindByPropertyNameMethodToFindAnObject()
+	{
+		$locator = new Argil_Model_Locator($this->_pdo);
+		$model = $locator->findByFirstName('Travis', new SimpleArgilPerson());
+		$this->assertIsA($model, 'Argil_Model_Container');
+		$this->assertTrue($model->is('SimpleArgilPerson'));
+		$this->assertEqual('Travis', $model->first_name);
+		$this->assertEqual('Swicegood', $model->last_name);
+		unset($model);
+		
+		$model = $locator->findByLastName('Swicegood', new SimpleArgilPerson());
+		$this->assertIsA($model, 'Argil_Model_Container');
+		$this->assertTrue($model->is('SimpleArgilPerson'));
+		$this->assertEqual('Travis', $model->first_name);
+		$this->assertEqual('Swicegood', $model->last_name);
+		unset($model);
+		
+		$model = $locator->findByLastName($this->_random, new SimpleArgilPerson());
+		$this->assertIsA($model, 'Argil_Model_Container');
+		$this->assertTrue($model->is('SimpleArgilPerson'));
+		$this->assertEqual('Joe', $model->first_name);
+		$this->assertEqual($this->_random, $model->last_name);
+	}
+}


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.




Thread: [Argil-svn] SF.net SVN: argil: [541] branches/experimental (Page 2)

argil-svn