File Coverage

blib/lib/Biblio/Zotero/DB/Schema/Result/StoredItem.pm

Criterion	Covered	Total	%
statement	9	9	100.0
branch			n/a
condition			n/a
subroutine	3	3	100.0
pod			n/a
total	12	12	100.0

package Biblio::Zotero::DB::Schema::Result::StoredItem;
$Biblio::Zotero::DB::Schema::Result::StoredItem::VERSION = '0.003';
# TODO: document

use strict;
use warnings;
use base qw/Biblio::Zotero::DB::Schema::Result::Item/;

__PACKAGE__->table_class('DBIx::Class::ResultSource::View');
__PACKAGE__->table('storedItems');
__PACKAGE__->result_source_instance->is_virtual(1);

# NOTE: SQL
__PACKAGE__->result_source_instance->view_definition(
	q[
	SELECT * FROM items me
		WHERE ( itemid NOT IN ( SELECT me.itemid FROM deletedItems me ) )
	]
);
# the above view_definition is the same as:
# ----------------------------------------
# my $deleted = $schema->resultset('DeletedItem')
# 	->get_column('itemid')
# 	->as_query
# $schema
# 	->resultset('Item')
# 	->search( { itemid => { 'not in' => $deleted } })
# 	->as_query

1;

__END__