Fetching data with Pomm

author.php

<?php

use Pomm\Connection\Database;

$loader = require __DIR__."/vendor/.composer/autoload.php";
$loader->add('YourDb', __DIR__."/model");

$database = new Database(array('dsn' => 'pgsql://user:pass@host:port/your_db'));

$book = $database
    ->getConnection()
    ->getMapFor('YourDb\Test\Book')
    ->findByPk(array('id' => 1));

print_r($book);

author_table_structure.txt

                                         Table "test.book"
     Column      |            Type             |                     Modifiers                     
-----------------+-----------------------------+---------------------------------------------------
 id              | integer                     | not null default nextval('book_id_seq'::regclass)
 name            | character varying           | not null
 authors         | character varying[]         | not null
 is_lent         | boolean                     | not null default false
 created_at      | timestamp without time zone | not null default now()
 xml_description | xml                         | 
Indexes:
    "book_pkey" PRIMARY KEY, btree (id)

output.txt

YourDb\Test\Book Object
(
    [fields:protected] => Array
        (
            [id] => 1
            [name] => Hyperion
            [authors] => Array
                (
                    [0] => Dan Simmons
                )

            [is_lent] =>
            [created_at] => DateTime Object
                (
                    [date] => 2012-03-08 12:52:22
                    [timezone_type] => 3
                    [timezone] => Europe/Berlin
                )

            [xml_description] => <book_description>This is a really nice SF book.</book_description>
        )

    [status:protected] => 1
)

short_author.php

<?php

// ...

$book = $database
    ->getConnection()
    ->getMapFor('YourDb\Test\Book')
    ->findByPk(array('id' => 1));

print_r($book);