package journalsDBIC;
use Data::Dumper;

#insert entry by hashref
my $journalentry = $schema->resultset('Journals')->create({
  date => time(),
  fulltext => "Hello world",
  image_url => "http://something/"
});


#delete by id
my $journalentry = $schema->resultset('Journals')->find({ id => 1 });
$journalentry->delete();

#update by hashref
my $journalentry = $schema->resultset('Journals')->find({ id => 1 });
$journalentry->update({
  fulltext => "New text here",
});

#select by date
my $res = $schema->resultset('Journals')->search({
  -and => [
    date => [ '>', DateTime->now()->subtract({days => 2}) ],
    date => [ '<', DateTime->now() ],
  ]
});
foreach my $row ($res->all){
  print Dumper $row;
}

#select *
#select * from journals basically dump the whole table
my $res = $schema->resultset('Journals')
foreach my $row ($res->all){
  print Dumper { $row->get_columns };
}
1;