ORM2 на практике

CREATE TABLE  `articles` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `text` text collate utf8_unicode_ci NOT NULL,
  `author_id` int(10) unsigned NOT NULL,
  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`),
  KEY `FK_articles_users` (`author_id`),
  KEY `FK_articles_redactors` (`redactor_id`),
  CONSTRAINT `FK_articles_redactors` FOREIGN KEY (`redactor_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_articles_users` FOREIGN KEY (`author_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='InnoDB free: 7168 kB; (`author_id`) REFER `users`(`id`)';
 
CREATE TABLE  `comments` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `text` varchar(255) NOT NULL default '',
  `author_id` int(10) unsigned NOT NULL,
  `article_id` int(10) unsigned NOT NULL,
  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`),
  KEY `FK_comments_articles` (`article_id`),
  KEY `FK_comments_users` (`author_id`),
  CONSTRAINT `FK_comments_articles` FOREIGN KEY (`article_id`) REFERENCES `articles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_comments_users` FOREIGN KEY (`author_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
 
CREATE TABLE  `users` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `email` varchar(127) NOT NULL,
  `username` varchar(32) NOT NULL default '',
  `password` char(50) NOT NULL,
  `logins` int(10) unsigned NOT NULL default '0',
  `last_login` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `uniq_username` (`username`),
  UNIQUE KEY `uniq_email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
insert into articles(title, text, author_id) values
('Статья 1', 'Текст статьи 1', 2),
('Статья 2', 'Текст статьи 2', 3),
('Статья 3', 'Текст статьи 3', 1),
('Статья 4', 'Текст статьи 4', 2);
 
insert into comments(text, author_id, article_id) values
('Комментарий 1', 1,3),
('Комментарий 2', 2,2),
('Комментарий 3', 3,1),
('Комментарий 4', 2,2),
('Комментарий 5', 1,1);

// models/article.php
class Article_Model extends ORM {
	protected $has_many = array('comments');
	protected $belongs_to = array('author');
}
// models/comment.php
class Comment_Model extends ORM {
	protected $belongs_to = array('article', 'author');
}
// models/author.php
class Author_Model extends ORM {
	protected $has_many = array('articles', 'comments');
	protected $table_name = 'users';
	protected $foreign_key = array('comments'=>'author_id', 'articles'=>'author_id');
}

class Test_Controller extends Controller {
 
	public function __construct() {
		parent::__construct();
		$this->profiler = new Profiler;
	}
 
	public function authors($id = NULL) {
		$id AND ctype_digit($id) AND url::redirect('test/author/'.$id);
		$authors = ORM::factory('author')->find_all();
		$this->template = new View('test/authors');
		$this->template->authors = $authors->as_array();
		$this->template->render(TRUE);
	}
 
	public function author($id = NULL) {
		is_null($id) OR !ctype_digit($id) AND url::redirect('test/authors');
		$author = ORM::factory('author', intval($id));
		$this->template = new View('test/author');
		$this->template->author = $author->as_array();
		$this->template->articles = $author->articles->as_array();
		$this->template->comments = $author->comments->as_array();
		$this->template->render(TRUE);
	}
 
	public function article($id = NULL) {
		is_null($id) OR !ctype_digit($id) AND url::redirect('test/articles');
		$this->template = new View('test/article');
		$article = ORM::factory('article')->where('articles.id', intval($id))->with('author')->find();
		$this->template->article = $article->as_array();
		$this->template->author = $article->author->as_array();
		$this->template->comments = $article->comments->as_array();
		$this->template->render(TRUE);
	}
 
	public function articles($id = NULL) {
		$id AND ctype_digit($id) AND url::redirect('test/article/'.$id);
		$articles = ORM::factory('article')->with('author')->find_all();
		$this->template = new View('test/articles');
		$this->template->articles = $articles->as_array();
		$this->template->render(TRUE);
	}
 
	public function comments($id = NULL) {
		$id AND ctype_digit($id) AND url::redirect('test/comment/'.$id);
		$comments = ORM::factory('comment')->with('author')->with('article')->find_all();
		$this->template = new View('test/comments');
		$this->template->comments = $comments->as_array();
		$this->template->render(TRUE);
	}

$article = ORM::factory('article')->where('articles.id', intval($id))->with('author')->find();
$article = ORM::factory('article')->with('author')->find(intval($id));