# error produced, it seems to forget the join?

andreas-marienborgs-computer:saltem-indexer andreas$ ./script/saltem-indexer.pl
indexing: 637
DBIx::Class::ResultSet::update(): DBI Exception: DBD::SQLite::db prepare_cached failed: no such column: string(1) at dbdimp.c line 271 [for Statement "UPDATE Event SET ready_for_index = ? WHERE ( ready_for_index = ? AND string = ? )"] at ./script/saltem-indexer.pl line 30

# saltem-indexer.pl

my $events = $s->resultset('Event')->ready_for_index;

warn "indexing: " . $events->count . "\n";
while (my $e = $events->next) {

    # check that it lives?
    $xap->indexer->index($e);


}
# error happens here:
$events->update({ ready_for_index => 0});


# the rs-method:

sub ready_for_index {
    my ($self) = @_;

    return $self->search({
        ready_for_index => 1,
        'state.string' => 'approved',

    },{
        join => 'state'
    });
}