BEAR.SundayでDoctrine2のORMを使ってみた ref: http://qiita.com/77web@github/items/7b67e490ac59dcab0ca8

file0.txt

composer create-project bear/skeleton My.NoteApp
cd My.NoteApp
composer install

file1.php

// src/Resource/App/Note.php

namespace My\NoteApp\Resource\App;

use BEAR\Resource\ResourceObject;

class Note extends ResourceObject
{
    public function onGet($id)
    {
        $note = $this->entityManager->find('...', $id);
        $this['note'] = ['body' => $note->getBody()];

        return $this;
    }
}

file2.php

// src/Module/Provider/DoctrineORMProvider

namespace My\NoteApp\Module\Provider;

use Doctrine\ORM\Tools\Setup;
use Doctrine\ORM\EntityManager;
use Ray\Di\ProviderInterface;
use BEAR\Sunday\Inject\AppDirInject;

class DoctrineORMProvider implements ProviderInterface
{
    use AppDirInject;

    public function get()
    {
        $config = Setup::createAnnotationMetadataConfiguration(array(__DIR__."/../Entity"), false);
        $conn = array(
          'driver' => 'pdo_sqlite',
          'path' => $this->appDir . '/var/db/db.sqlite',
        );
        $entityManager = EntityManager::create($conn, $config);

        return $entityManager;
    }
} 

file3.php

// src/Module/AppModule.php
    protected function configure()
    {
        $this->install(...); // 最初から書いてある部分

        $this->bind('Doctrine\ORM\EntityManager')->toProvider('My\NoteApp\Module\Provider\DoctrineORMProvider'); // bind,toProviderともに最初のバックスラッシュは要らなかった
    }

file4.php

// src/Entity/Note.php

namespace My\NoteApp\Entity;

/**
 * @Entity
 * @Table(name="note")
 */
class Note
{
    /**
     * @var int
     * @Id
     * @Column(type="integer")
     * @GeneratedValue
     */
    private $id;

    /**
     * @var string
     * @Column(type="text")
     */
    private $body;

    // getter,setterは省略
}

file5.txt

sqlite3 var/db/db.sqlite
> create table note(id INTEGER PRIMARY AUTOINCREMENT NOT NULL, body TEXT NULL);
> insert into note(body) values('test body1');
> insert into note(body) values('test body2');
> .exit

file6.php

// src/Resource/App/Note.php

namespace My\NoteApp\Resource\App;

use BEAR\Resource\ResourceObject;
use Doctrine\ORM\EntityManager;
use Ray\Di\Di\Inject;

class Note extends ResourceObject
{
    /**
     * @var EntityManager
     */
    private $entityManager;

    /**
     * @param EntityManager $entityManager
     * @Inject
     */
    public function __construct(EntityManager $entityManager)
    {
        $this->entityManager = $entityManager;
    }

    public function onGet($id)
    {
        $note = $this->entityManager->find('\My\NoteApp\Entity\Note', $id);
        $this['note'] = ['body' => $note->getBody()];

        return $this;
    }
}

file7.txt

php bootstrap/contexts/api.php get 'app://self/note?id=1'
[BODY]
note => array(
    body test body1
),

[VIEW]
{
    "note": {
        "body": "test body1"
    },
    "_links": {
        "self": {
            "href": "http://localhost/app/note/?id=1"
        }
    }
}