From 05c6a7a2ef0d6be3a02b8e1a3e2bd2b6afacf799 Mon Sep 17 00:00:00 2001 From: xue <> Date: Fri, 6 Apr 2007 03:06:36 +0000 Subject: Finished blog tutorial day 2. --- demos/blog-tutorial/protected/common/TopicList.tpl | 18 +++-- .../protected/pages/Day2/ConnectDB.page | 2 +- .../protected/pages/Day2/CreateAR.page | 78 +++++++++++++++++++++ .../protected/pages/Day2/CreateDB.page | 6 +- .../protected/pages/Day2/directories2.gif | Bin 0 -> 6795 bytes demos/blog-tutorial/samples/day2/blog/index.php | 23 ++++++ .../samples/day2/blog/protected/.htaccess | 1 + .../samples/day2/blog/protected/application.xml | 44 ++++++++++++ .../samples/day2/blog/protected/data/blog.db | Bin 0 -> 5120 bytes .../day2/blog/protected/database/PostRecord.php | 25 +++++++ .../day2/blog/protected/database/UserRecord.php | 27 +++++++ .../day2/blog/protected/layouts/MainLayout.php | 7 ++ .../day2/blog/protected/layouts/MainLayout.tpl | 20 ++++++ .../samples/day2/blog/protected/pages/Contact.page | 47 +++++++++++++ .../samples/day2/blog/protected/pages/Contact.php | 30 ++++++++ .../samples/day2/blog/protected/pages/Home.page | 7 ++ .../samples/day2/blog/protected/schema.sql | 23 ++++++ 17 files changed, 350 insertions(+), 8 deletions(-) create mode 100644 demos/blog-tutorial/protected/pages/Day2/CreateAR.page create mode 100644 demos/blog-tutorial/protected/pages/Day2/directories2.gif create mode 100644 demos/blog-tutorial/samples/day2/blog/index.php create mode 100644 demos/blog-tutorial/samples/day2/blog/protected/.htaccess create mode 100644 demos/blog-tutorial/samples/day2/blog/protected/application.xml create mode 100644 demos/blog-tutorial/samples/day2/blog/protected/data/blog.db create mode 100644 demos/blog-tutorial/samples/day2/blog/protected/database/PostRecord.php create mode 100644 demos/blog-tutorial/samples/day2/blog/protected/database/UserRecord.php create mode 100644 demos/blog-tutorial/samples/day2/blog/protected/layouts/MainLayout.php create mode 100644 demos/blog-tutorial/samples/day2/blog/protected/layouts/MainLayout.tpl create mode 100644 demos/blog-tutorial/samples/day2/blog/protected/pages/Contact.page create mode 100644 demos/blog-tutorial/samples/day2/blog/protected/pages/Contact.php create mode 100644 demos/blog-tutorial/samples/day2/blog/protected/pages/Home.page create mode 100644 demos/blog-tutorial/samples/day2/blog/protected/schema.sql (limited to 'demos') 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 @@
-To further reduce the dependency on the actual database tables, we will also use the Active Record 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 Active Record (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.
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 @@
+
+We need to create two Active Record classes, UserRecord and PostRecord, to represent data records in the users and posts tables, respectively. Active Record classes must extend from the base class ActiveRecord, and their properties must match exactly to the fields of the corresponding tables. To better organize our directories, we create a new directory protected/database to hold the class files.
+
+Instead of writing the classes manually, we will use the PRADO command line tool again to generate the classes for us.
+
+Under the blog directory, run the following command to enter into the interactive mode of the command line tool:
+
+We should see
+
+At the prompt, enter the following two commands to create UserRecord and PostRecord classes:
+
+Here we used the namespace format again to specify the classes to be created. The path Application.database.UserRecord indicates that we want the UserRecord class file to be protected/database/UserRecord.php.
+
+We should see the following directory structure with two new files under protected/database:
+
+If we check the UserRecord class file, we should see the following content. As we see, for each field in the users table, the class has a corresponding data member. The constant TABLE specifies the table name for the UserRecord. The static method finder() allows us to perform query and retrieve users data in terms of UserRecord objects, as we will see in later sections.
+
-We use the SQLite command line tool to create the SQLite database. We first create a directory protected/data 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 protected/data:
+We then use the SQLite command line tool to create the SQLite database. We create a directory protected/data to hold the SQLite database file. We now execute the following command under the directory protected/data:
Please fill out the following form to let me know your feedback on my blog. Thanks!Creating Active Record Classes
+
+
+
+
+
My PRADO Blog
+Contact
+
+
+
+Your Email:
+
+
+
+Feedback:
+
+
+
+Welcome to PRADO!
+
+