Finished blog tutorial day 2.

5 files changed, 96 insertions, 8 deletions

diff --git a/demos/blog-tutorial/protected/common/TopicList.tpl b/demos/blog-tutorial/protected/common/TopicList.tpl
index 555b0efe..b6174985 100644
--- a/demos/blog-tutorial/protected/common/TopicList.tpl
+++ b/demos/blog-tutorial/protected/common/TopicList.tpl
@@ -18,18 +18,24 @@
 </div>

 

 <div class="topic">

-<div>Day 2: Using Database</div>

+<div>Day 2: Working with Database - Part I</div>

 <ul>

     <li><a href="?page=Day2.CreateDB">Creating Database</a></li>

     <li><a href="?page=Day2.ConnectDB">Establishing DB Connection</a></li>

-    <li><a href="?page=Day2.CreateDAO">Creating DAOs</a></li>

+    <li><a href="?page=Day2.CreateAR">Creating AR Classes</a></li>

+</ul>

+</div>

+

+<div class="topic">

+<div>Day 3: Working with Database - Part II</div>

+<ul>

     <li><a href="?page=">Creating NewPost Page</a></li>

     <li><a href="?page=">Creating ListPost Page</a></li>

 </ul>

 </div>

 

 <div class="topic">

-<div>Day 3: Authentication and Authorization</div>

+<div>Day 4: Authentication and Authorization</div>

 <ul>

     <li><a href="?page=">Creating Login Page</a></li>

     <li><a href="?page=">Using PRADO Auth Framework</a></li>

@@ -38,13 +44,13 @@
 </div>

 

 <div class="topic">

-<div>Day 4: Developing and Using Components</div>

+<div>Day 5: Developing and Using Components</div>

 <ul>

 </ul>

 </div>

 

 <div class="topic">

-<div>Day 5: Customization and Refactoring</div>

+<div>Day 6: Customization and Refactoring</div>

 <ul>

     <li><a href="?page=">Using Themes and Skins</a></li>

     <li><a href="?page=">Customizing Error Handling</a></li>

@@ -53,7 +59,7 @@
 </div>

 

 <div class="topic">

-<div>Day 6: Performance Tuneup and Deployment</div>

+<div>Day 7: Performance Tuneup and Deployment</div>

 <ul>

     <li><a href="?page=">Caching</a></li>

 </ul>

diff --git a/demos/blog-tutorial/protected/pages/Day2/ConnectDB.page b/demos/blog-tutorial/protected/pages/Day2/ConnectDB.page
index 232ceb98..90db11ef 100644
--- a/demos/blog-tutorial/protected/pages/Day2/ConnectDB.page
+++ b/demos/blog-tutorial/protected/pages/Day2/ConnectDB.page
@@ -19,7 +19,7 @@ extension=php_pdo_sqlite.dll
 </com:NoteBox>

 

 <p>

-To further reduce the dependency on the actual database tables, we will also use the <a href="http://www.pradosoft.com/demos/quickstart/?page=Database.ActiveRecord">Active Record</a> feature which is based on PDO. Each data record will be represented as an Active Record object, which saves us from writing repetitive SQL statements.

+To further abstract the actual database tables, we will also use the <a href="http://www.pradosoft.com/demos/quickstart/?page=Database.ActiveRecord">Active Record</a> (AR) feature. Each data record will be represented as an Active Record object which is capable of performing query, saving and deletion without writing SQL statements.

 </p>

 

 <p>

diff --git a/demos/blog-tutorial/protected/pages/Day2/CreateAR.page b/demos/blog-tutorial/protected/pages/Day2/CreateAR.page
new file mode 100644
index 00000000..bf2c05aa
--- /dev/null
+++ b/demos/blog-tutorial/protected/pages/Day2/CreateAR.page
@@ -0,0 +1,78 @@
+<com:TContent ID="Main">

+

+<h1>Creating Active Record Classes</h1>

+

+<p>

+We need to create two <a href="http://www.pradosoft.com/demos/quickstart/?page=Database.ActiveRecord">Active Record</a> classes, <tt>UserRecord</tt> and <tt>PostRecord</tt>, to represent data records in the <tt>users</tt> and <tt>posts</tt> tables, respectively. Active Record classes must extend from the base class <tt>ActiveRecord</tt>, and their properties must match exactly to the fields of the corresponding tables. To better organize our directories, we create a new directory <tt>protected/database</tt> to hold the class files.

+</p>

+

+<p>

+Instead of writing the classes manually, we will use the <a href="http://www.pradosoft.com/demos/quickstart/?page=GettingStarted.CommandLine">PRADO command line tool</a> again to generate the classes for us.

+</p>

+

+<p>

+Under the <tt>blog</tt> directory, run the following command to enter into the interactive mode of the command line tool:

+</p>

+

+<com:TTextHighlighter CssClass="source">

+php path/to/prado-cli.php shell .

+</com:TTextHighlighter>

+

+<p>

+We should see

+</p>

+

+<com:TTextHighlighter CssClass="source" Language="text">

+Command line tools for Prado 3.1.0.

+** Loaded PRADO appplication in directory "protected".

+PHP-Shell - Version 0.3.1

+(c) 2006, Jan Kneschke <jan@kneschke.de>

+

+>> use '?' to open the inline help

+

+>>

+</com:TTextHighlighter>

+

+<p>

+At the prompt, enter the following two commands to create <tt>UserRecord</tt> and <tt>PostRecord</tt> classes:

+</p>

+

+<com:TTextHighlighter CssClass="source" Language="text">

+>> generate users Application.database.UserRecord

+

+>> generate posts Application.database.PostRecord

+</com:TTextHighlighter>

+

+<p>

+Here we used the <a href="http://www.pradosoft.com/demos/quickstart/?page=Fundamentals.Components">namespace format</a> again to specify the classes to be created. The path <tt>Application.database.UserRecord</tt> indicates that we want the <tt>UserRecord</tt> class file to be <tt>protected/database/UserRecord.php</tt>.

+</p>

+

+<p>

+We should see the following directory structure with two new files under <tt>protected/database</tt>:

+</p>

+

+<img src="<%~ directories2.gif %>" />

+

+<p>

+If we check the <tt>UserRecord</tt> class file, we should see the following content. As we see, for each field in the <tt>users</tt> table, the class has a corresponding data member. The constant <tt>TABLE</tt> specifies the table name for the <tt>UserRecord</tt>. The static method <tt>finder()</tt> allows us to perform query and retrieve users data in terms of <tt>UserRecord</tt> objects, as we will see in later sections.

+</p>

+

+<com:TTextHighlighter CssClass="source" Language="php">

+class UserRecord extends TActiveRecord

+{

+	const TABLE='users';

+	public $username;

+	public $email;

+	public $password;

+	public $role;

+	public $first_name;

+	public $last_name;

+

+	public static function finder($className=__CLASS__)

+	{

+		return parent::finder($className);

+	}

+}

+</com:TTextHighlighter>

+

+</com:TContent>
\ No newline at end of file
diff --git a/demos/blog-tutorial/protected/pages/Day2/CreateDB.page b/demos/blog-tutorial/protected/pages/Day2/CreateDB.page
index 0d45ba50..291b20e4 100644
--- a/demos/blog-tutorial/protected/pages/Day2/CreateDB.page
+++ b/demos/blog-tutorial/protected/pages/Day2/CreateDB.page
@@ -47,7 +47,7 @@ SQLite does not support <a href="http://www.sqlite.org/omitted.html">foreign key
 </com:NoteBox>

 

 <p>

-We use the <a href="http://www.sqlite.org/download.html">SQLite command line tool</a> to create the SQLite database. We first create a directory <tt>protected/data</tt> to hold the SQLite database file. Per SQLite's requirement, this directory and the database file to be created must be set writable by the Web server process. We now execute the following command under the directory <tt>protected/data</tt>:

+We then use the <a href="http://www.sqlite.org/download.html">SQLite command line tool</a> to create the SQLite database. We create a directory <tt>protected/data</tt> to hold the SQLite database file. We now execute the following command under the directory <tt>protected/data</tt>:

 </p>

 

 <com:TTextHighlighter CssClass="source">

@@ -60,4 +60,8 @@ The database has been created as <tt>protected/data/blog.db</tt> and we shall se
 

 <img src="<%~ directories.gif %>" />

 

+<com:NoteBox>

+It is required by SQLite that both the directory <tt>protected/data</tt> and the database file <tt>protected/data/blog.db</tt> be set writable by the Web server process.

+</com:NoteBox>

+

 </com:TContent>
\ No newline at end of file
diff --git a/demos/blog-tutorial/protected/pages/Day2/directories2.gif b/demos/blog-tutorial/protected/pages/Day2/directories2.gif
new file mode 100644
index 00000000..b053b4c6
--- /dev/null
+++ b/demos/blog-tutorial/protected/pages/Day2/directories2.gif