X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=examples%2FSchema%2Ftestdb.pl;h=2a1061a5181a37a8283b06375199000100a356e8;hb=777738d07cfd6055a4f40b944a69329c6995df9a;hp=9ca3e3984c80bdfeaa7d6b459c9554e17ac1faa1;hpb=50891152d0b24649bfd67bdba97feec86b11c064;p=dbsrgits%2FDBIx-Class.git diff --git a/examples/Schema/testdb.pl b/examples/Schema/testdb.pl old mode 100644 new mode 100755 index 9ca3e39..2a1061a --- a/examples/Schema/testdb.pl +++ b/examples/Schema/testdb.pl @@ -1,11 +1,16 @@ -#!/usr/bin/perl -w +#!/usr/bin/env perl -use MyDatabase::Main; +use warnings; use strict; -my $schema = MyDatabase::Main->connect('dbi:SQLite:db/example.db'); +use MyApp::Schema; + +use Path::Class 'file'; +my $db_fn = file($INC{'MyApp/Schema.pm'})->dir->parent->file('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'); @@ -53,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"; @@ -86,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"; @@ -105,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";