X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?p=catagits%2FCatalyst-Manual.git;a=blobdiff_plain;f=lib%2FCatalyst%2FManual%2FTutorial%2F10_Appendices.pod;h=e78a56291850ec77c21c906e13715af5fca6c492;hp=d53afe81bc054fa8ccec3dbab2e9cff50dd68f53;hb=HEAD;hpb=f4e9de4a3171fd75d04fa8e294fd9a0ae367bc18 diff --git a/lib/Catalyst/Manual/Tutorial/10_Appendices.pod b/lib/Catalyst/Manual/Tutorial/10_Appendices.pod index d53afe8..e78a562 100644 --- a/lib/Catalyst/Manual/Tutorial/10_Appendices.pod +++ b/lib/Catalyst/Manual/Tutorial/10_Appendices.pod @@ -2,7 +2,6 @@ Catalyst::Manual::Tutorial::10_Appendices - Catalyst Tutorial - Chapter 10: Appendices - =head1 OVERVIEW This is B for the Catalyst tutorial. @@ -77,28 +76,28 @@ regex patterns). I: =item * -":0,$s/^ " +C<":0,$s/^ "> Removes four leading spaces from the entire file (from the first line, C<0>, to the last line, C<$>). =item * -"%s/^ " +C<"%s/^ "> A shortcut for the previous item (C<%> specifies the entire file; so this removes four leading spaces from every line). =item * -":.,$s/^ " +C<":.,$s/^ "> Removes the first four spaces from the line the cursor is on at the time the regex command is executed (".") to the last line of the file. =item * -":.,44s/^ " +C<":.,44s/^ "> Removes four leading space from the current line through line 44 (obviously adjust the C<44> to the appropriate value in your example). @@ -133,16 +132,16 @@ current major mode). You can run the command by typing M-x indent-region or pressing the default keybinding C-M-\ in cperl-mode. Additional details can be found here: -L +L =head1 APPENDIX 2: USING POSTGRESQL AND MYSQL The main database used in this tutorial is the very simple yet powerful -L. This section provides information +L. This section provides information that can be used to "convert" the tutorial to use -L and -L. However, note that part of +L and +L. However, note that part of the beauty of the MVC architecture is that very little database-specific code is spread throughout the system (at least when MVC is "done right"). Consequently, converting from one database to another is @@ -536,7 +535,7 @@ The MySQL database server and client utility. =item * -The Perl C module +The Perl L module =back @@ -616,23 +615,23 @@ Open the F in your editor and enter: -- Create a very simple database to hold book and author information -- CREATE TABLE IF NOT EXISTS `books` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `title` text CHARACTER SET utf8, - `rating` int(11) DEFAULT NULL, - PRIMARY KEY (`id`) + `id` int(11) NOT NULL AUTO_INCREMENT, + `title` text CHARACTER SET utf8, + `rating` int(11) DEFAULT NULL, + PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 'book_authors' is a many-to-many join table between books & authors CREATE TABLE IF NOT EXISTS `book_authors` ( - `book_id` int(11) NOT NULL DEFAULT '0', - `author_id` int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (`book_id`,`author_id`), - KEY `author_id` (`author_id`) + `book_id` int(11) NOT NULL DEFAULT '0', + `author_id` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`book_id`,`author_id`), + KEY `author_id` (`author_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `authors` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `first_name` text CHARACTER SET utf8, - `last_name` text CHARACTER SET utf8, - PRIMARY KEY (`id`) + `id` int(11) NOT NULL AUTO_INCREMENT, + `first_name` text CHARACTER SET utf8, + `last_name` text CHARACTER SET utf8, + PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --- --- Load some sample data @@ -729,7 +728,7 @@ Delete the existing model: Regenerate the model using the Catalyst "_create.pl" script: script/myapp_create.pl model DB DBIC::Schema MyApp::Schema create=static \ - dbi:mysql:myapp 'tutorial' 'yourpassword' '{ AutoCommit => 1 }' + dbi:mysql:myapp 'tutorial' 'yourpassword' '{ AutoCommit => 1 }' =back @@ -751,25 +750,25 @@ Open F in your editor and enter: -- Add users and roles tables, along with a many-to-many join table -- CREATE TABLE IF NOT EXISTS `roles` ( - `id` int(11) NOT NULL, - `role` text CHARACTER SET utf8, - PRIMARY KEY (`id`) + `id` int(11) NOT NULL, + `role` text CHARACTER SET utf8, + PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `users` ( - `id` int(11) NOT NULL, - `username` text CHARACTER SET utf8, - `password` text CHARACTER SET utf8, - `email_address` text CHARACTER SET utf8, - `first_name` text CHARACTER SET utf8, - `last_name` text CHARACTER SET utf8, - `active` int(11) DEFAULT NULL, - PRIMARY KEY (`id`) + `id` int(11) NOT NULL, + `username` text CHARACTER SET utf8, + `password` text CHARACTER SET utf8, + `email_address` text CHARACTER SET utf8, + `first_name` text CHARACTER SET utf8, + `last_name` text CHARACTER SET utf8, + `active` int(11) DEFAULT NULL, + PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `user_roles` ( - `user_id` int(11) NOT NULL DEFAULT '0', - `role_id` int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (`user_id`,`role_id`), - KEY `role_id` (`role_id`) + `user_id` int(11) NOT NULL DEFAULT '0', + `role_id` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`user_id`,`role_id`), + KEY `role_id` (`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Load up some initial test data @@ -810,7 +809,7 @@ Update the model: Regenerate the model using the Catalyst "_create.pl" script: script/myapp_create.pl model DB DBIC::Schema MyApp::Schema create=static \ - components=TimeStamp,PassphraseColumn dbi:mysql:myapp 'tutorial' 'yourpassword' '{ AutoCommit => 1 }' + components=TimeStamp,PassphraseColumn dbi:mysql:myapp 'tutorial' 'yourpassword' '{ AutoCommit => 1 }' =back @@ -848,4 +847,4 @@ L. Copyright 2006-2011, Kennedy Clark, under the Creative Commons Attribution Share-Alike License Version 3.0 -(L). +(L).