X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FManual%2FExample.pod;h=2fa0492d8b7a09d99a758e1e15b7ba6f648bc92f;hb=2486df86df6c28d8305ae777acdac19ba6faebcf;hp=8df51fced43e473c2711c6de2bf307880617fc8c;hpb=e8cc984cb3ebc976928d93bb0c6a8a3a626ad5d5;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/lib/DBIx/Class/Manual/Example.pod b/lib/DBIx/Class/Manual/Example.pod index 8df51fc..2fa0492 100644 --- a/lib/DBIx/Class/Manual/Example.pod +++ b/lib/DBIx/Class/Manual/Example.pod @@ -33,11 +33,13 @@ First make and change the directory: mkdir app cd app + mkdir db + cd db This example uses SQLite which is a dependency of DBIx::Class, so you shouldn't have to install extra software. -Save the following into a example.sql +Save the following into a example.sql in the directory db CREATE TABLE artist ( artistid INTEGER PRIMARY KEY, @@ -62,7 +64,11 @@ sqlite3 example.db < example.sql =head3 Set up DBIx::Class::Schema -First, create some dirs and change working directory: +Change directory back from db to the directory app: + + cd ../ + +Now create some more directories: mkdir MyDatabase mkdir MyDatabase/Main @@ -127,7 +133,7 @@ insertdb.pl use MyDatabase::Main; use strict; - my $schema = MyDatabase::Main->connect('dbi:SQLite:example.db'); + my $schema = MyDatabase::Main->connect('dbi:SQLite:db/example.db'); # here's some of the sql that is going to be generated by the schema # INSERT INTO artist VALUES (NULL,'Michael Jackson'); @@ -191,7 +197,7 @@ testdb.pl: use MyDatabase::Main; use strict; - my $schema = MyDatabase::Main->connect('dbi:SQLite: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. @@ -341,6 +347,10 @@ It should output: =head1 Notes +A reference implentation of the database and scripts in this example +are available in the main distribution for DBIx::Class under the +directory t/examples/Schema + With these scripts we're relying on @INC looking in the current working directory. You may want to add the MyDatabase namespaces to @INC in a different way when it comes to deployment.