package AppName::Model::DBIxResultSet;
use Moose;
use namespace::autoclean;

extends 'Catalyst::Model::DBIxResultSet';

__PACKAGE__->config(
        dsn => 'dbi:SQLite:data/appname.db',
        user => '',
        password => '',
        on_connect_do => q{PRAGMA foreign_keys = ON},
);

__PACKAGE__->meta->make_immutable;
1;

##</code><code>##

my $model = $c->model('DBIxResultSet');
my $rs = $model->resultset('users')->search({}, {order_by => 'num DESC', rows => 10, result_class => 'DBIx::Class::ResultClass::HashRefInflator'});

while (my $user = $rs->next) {
    # code
}