lib/Strix/Schema.pm

package Strix::Schema;

use Fey::DBIManager;
use Fey::DBIManager::Source;
use Fey::Loader;
use Fey::ORM::Schema;

use Storable;
use Data::Dump qw/dump/;
use URI::Escape;

my $dsn = 'dbi:Pg:dbname=new';
$dsn = 'dbi:SQLite:dbname=./var/strix.sqlite';

my $schema_file = 'var/schema.' . uri_escape( $dsn );

warn "Database $dsn schema cache $schema_file\n";

my $source = Fey::DBIManager::Source->new( dsn => $dsn );

my $schema;
if ( -e $schema_file ) {
        $schema = retrieve $schema_file or die "can't read schema from $schema_file: $!";
} else {
        $schema= Fey::Loader->new( dbh => $source->dbh() )->make_schema();
        store $schema, $schema_file or warn "can't store schema into $schema_file: $!";
}

has_schema $schema;

__PACKAGE__->DBIManager()->add_source($source);
1	dpavlin	2	package Strix::Schema;
2
3			use Fey::DBIManager;
4			use Fey::DBIManager::Source;
5			use Fey::Loader;
6			use Fey::ORM::Schema;
7
8	dpavlin	15	use Storable;
9			use Data::Dump qw/dump/;
10	dpavlin	35	use URI::Escape;
11	dpavlin	15
12	dpavlin	35	my $dsn = 'dbi:Pg:dbname=new';
13			$dsn = 'dbi:SQLite:dbname=./var/strix.sqlite';
14	dpavlin	15
15	dpavlin	35	my $schema_file = 'var/schema.' . uri_escape( $dsn );
16	dpavlin	2
17	dpavlin	35	warn "Database $dsn schema cache $schema_file\n";
18
19			my $source = Fey::DBIManager::Source->new( dsn => $dsn );
20
21	dpavlin	15	my $schema;
22			if ( -e $schema_file ) {
23			$schema = retrieve $schema_file or die "can't read schema from $schema_file: $!";
24			} else {
25			$schema= Fey::Loader->new( dbh => $source->dbh() )->make_schema();
26			store $schema, $schema_file or warn "can't store schema into $schema_file: $!";
27			}
28	dpavlin	2
29			has_schema $schema;
30
31			__PACKAGE__->DBIManager()->add_source($source);