X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=examples%2FSchema%2Ftestdb.pl;h=2a1061a5181a37a8283b06375199000100a356e8;hb=db2b35cc74e1128b2bb612caf771c5df9c4b636e;hp=c608f459d750a295742fb48cecf5436d631f86c3;hpb=f54428abf9cc7d7e5604745335694eaf558f6820;p=dbsrgits%2FDBIx-Class.git diff --git a/examples/Schema/testdb.pl b/examples/Schema/testdb.pl old mode 100644 new mode 100755 index c608f45..2a1061a --- a/examples/Schema/testdb.pl +++ b/examples/Schema/testdb.pl @@ -3,11 +3,14 @@ use warnings; use strict; -use MyDatabase::Main; +use MyApp::Schema; + +use Path::Class 'file'; +my $db_fn = file($INC{'MyApp/Schema.pm'})->dir->parent->file('db/example.db'); -my $schema = MyDatabase::Main->connect('dbi:SQLite:db/example.db'); # for other DSNs, e.g. MySql, see the perldoc for the relevant dbd # driver, e.g perldoc L. +my $schema = MyApp::Schema->connect("dbi:SQLite:$db_fn"); get_tracks_by_cd('Bad'); get_tracks_by_artist('Michael Jackson'); @@ -55,7 +58,6 @@ sub get_tracks_by_artist { print "\n"; } - sub get_cd_by_track { my $tracktitle = shift; print "get_cd_by_track($tracktitle):\n"; @@ -88,8 +90,6 @@ sub get_cds_by_artist { print "\n"; } - - sub get_artist_by_track { my $tracktitle = shift; print "get_artist_by_track($tracktitle):\n"; @@ -107,7 +107,6 @@ sub get_artist_by_track { print $artist->name . "\n\n"; } - sub get_artist_by_cd { my $cdtitle = shift; print "get_artist_by_cd($cdtitle):\n";