package OpenExodus::Model::Schema;
use strict;
use warnings;

use Fey::DBIManager::Source;
use Fey::Loader;
use YAML qw/LoadFile/;
use Fey::ORM::Schema;
use Moose;
use MooseX::ClassAttribute;

class_has config => (
    isa => 'Hash',
    is => 'ro',
    default => sub {
        my $file = $ENV{'DB_CONF'} || 'dbconf.yaml';
        return LoadFile( $file ) if -e $file;
        return {};
    },
);

sub dbh {
    my $class = shift;
    return $class->DBIManager()->default_source->dbh;
}

__PACKAGE__->DBIManager()->add_source(
    Fey::DBIManager::Source->new(
        dsn      => 'dbi:Pg:dbname=' . ($ENV{DB} || __PACKAGE__->config->{database}),
        username => $ENV{DB_USER} || __PACKAGE__->config->{username},
        password => $ENV{DB_PASS} || __PACKAGE__->config->{password},
    )
);

has_schema( Fey::Loader->new( dbh => __PACKAGE__->dbh() )->make_schema() );