--- trunk/lib/Strix/User.pm 2008/07/06 11:59:58 56 +++ trunk/lib/Strix/User.pm 2008/07/06 18:00:54 57 @@ -1,14 +1,28 @@ package Strix::User; -use strict; -use warnings; - use Strix::Schema; use Fey::ORM::Table; use Data::Dump qw/dump/; -my $schema = Strix::Schema->Schema(); -has_table( $schema->table('users') ); +my $users_table = Strix::Schema->Schema()->table('users'); + +has_table( $users_table ); + +my $select = + Strix::Schema->SQLFactoryClass()->new_select() + ->select( $users_table ) + ->from( $users_table ) +# ->where( $users_table->column('parent_message_id'), '=', Fey::Placeholder->new() ) + ->order_by( $users_table->column('id'), 'DESC' ) + ->limit(3) + ; + + +has_many 'rows' => ( + table => $users_table, + select => $select, +# bind_params => sub { $_[0]->message_id() }, +); 1;