<?php
/**
 * One greeting, stored in the table mysite_hello_greeting.
 */
class mysiteHelloGreeting extends eZPersistentObject
{
    public static function definition()
    {
        return array(
            'fields' => array(
                'id'      => array( 'name' => 'ID', 'datatype' => 'integer', 'default' => 0, 'required' => true ),
                'name'    => array( 'name' => 'Name', 'datatype' => 'string', 'default' => '', 'required' => true ),
                'user_id' => array( 'name' => 'UserID', 'datatype' => 'integer', 'default' => 0, 'required' => true ),
                'created' => array( 'name' => 'Created', 'datatype' => 'integer', 'default' => 0, 'required' => true )
            ),
            'keys' => array( 'id' ),
            'increment_key' => 'id',
            'function_attributes' => array( 'user' => 'user' ),
            'class_name' => 'mysiteHelloGreeting',
            'sort' => array( 'created' => 'desc' ),
            'name' => 'mysite_hello_greeting'
        );
    }

    /** Creates an unsaved greeting for the current user. */
    public static function create( $name )
    {
        return new self( array( 'name' => (string)$name,
                                'user_id' => eZUser::currentUserID(),
                                'created' => time() ) );
    }

    public static function fetch( $id )
    {
        return eZPersistentObject::fetchObject( self::definition(), null, array( 'id' => (int)$id ) );
    }

    /** The newest greetings, newest first. */
    public static function fetchNewest( $limit = 10, $offset = 0 )
    {
        return eZPersistentObject::fetchObjectList( self::definition(), null, null,
                                                    array( 'created' => 'desc' ),
                                                    array( 'offset' => (int)$offset, 'length' => (int)$limit ) );
    }

    public static function countByUser( $userID )
    {
        return eZPersistentObject::count( self::definition(), array( 'user_id' => (int)$userID ) );
    }

    /** function attribute "user": the user who greeted */
    public function user()
    {
        return eZUser::fetch( $this->attribute( 'user_id' ) );
    }
}

<?php
$db = eZDB::instance();
$db->begin();
$greeting = mysiteHelloGreeting::create( 'Ada' );
$greeting->store();                         // INSERT; $greeting->attribute( 'id' ) is now set
$greeting->setAttribute( 'name', 'Ada L.' );
$greeting->store();                         // UPDATE
$db->commit();

$latest = mysiteHelloGreeting::fetchNewest( 5 );
$mine = mysiteHelloGreeting::countByUser( eZUser::currentUserID() );
$greeting->remove();                        // DELETE