Catalyst::Manual::Tutorial::10_Appendices - Catalyst Tutorial - Chapter 10: Appendices
-
=head1 OVERVIEW
This is B<Chapter 10 of 10> for the Catalyst tutorial.
=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).
indent-region or pressing the default keybinding C-M-\ in cperl-mode.
Additional details can be found here:
-L<http://www.gnu.org/software/emacs/manual/html_node/emacs/Indentation-Commands.html>
+L<https://www.gnu.org/software/emacs/manual/html_node/emacs/Indentation-Commands.html>
=head1 APPENDIX 2: USING POSTGRESQL AND MYSQL
The main database used in this tutorial is the very simple yet powerful
-L<SQLite|http://www.sqlite.org>. This section provides information
+L<SQLite|https://www.sqlite.org>. This section provides information
that can be used to "convert" the tutorial to use
-L<PostgreSQL|http://www.postgresql.org> and
-L<MySQL|http://dev.mysql.com>. However, note that part of
+L<PostgreSQL|https://www.postgresql.org> and
+L<MySQL|https://dev.mysql.com>. 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
-- 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
-- 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
Copyright 2006-2011, Kennedy Clark, under the
Creative Commons Attribution Share-Alike License Version 3.0
-(L<http://creativecommons.org/licenses/by-sa/3.0/us/>).
+(L<https://creativecommons.org/licenses/by-sa/3.0/us/>).