From ff32eed01f783ee33caeacb0f7315612f0994f8f Mon Sep 17 00:00:00 2001 From: xue <> Date: Sun, 8 Apr 2007 21:33:23 +0000 Subject: Added Day 2 tutorial. --- .../protected/pages/Day2/CreateAR.page | 2 +- .../protected/pages/Day2/CreateDB.page | 12 ++++++------ demos/blog-tutorial/protected/pages/Day2/ER.gif | Bin 4919 -> 5172 bytes demos/blog-tutorial/protected/pages/Day2/ER.vsd | Bin 73216 -> 73216 bytes 4 files changed, 7 insertions(+), 7 deletions(-) (limited to 'demos/blog-tutorial/protected/pages/Day2') diff --git a/demos/blog-tutorial/protected/pages/Day2/CreateAR.page b/demos/blog-tutorial/protected/pages/Day2/CreateAR.page index d8b8b8ce..00ac1166 100644 --- a/demos/blog-tutorial/protected/pages/Day2/CreateAR.page +++ b/demos/blog-tutorial/protected/pages/Day2/CreateAR.page @@ -61,7 +61,7 @@ Here we used the " /> +

If we check the PostRecord class file, we should see the following content. diff --git a/demos/blog-tutorial/protected/pages/Day2/CreateDB.page b/demos/blog-tutorial/protected/pages/Day2/CreateDB.page index 291b20e4..eebda4c1 100644 --- a/demos/blog-tutorial/protected/pages/Day2/CreateDB.page +++ b/demos/blog-tutorial/protected/pages/Day2/CreateDB.page @@ -10,7 +10,7 @@ Most Web applications use database to keep data. Our blog system is not an excep For tutorial purpose, we have simplified the requirements of our blog system so that it only needs to deal with user and post data. We thus create two database tables, users and posts, as shown in the following entity-relationship (ER) diagram.

- +

We use a SQLite 3 database to keep our data. We first convert the ER diagram into the following SQL statements and save them in the file protected/schema.sql. @@ -20,8 +20,8 @@ We use a SQLite 3 database to keep our data. We first convert the ER diagram int /* create users table */ CREATE TABLE users ( username VARCHAR(128) NOT NULL PRIMARY KEY, - email VARCHAR(128) NOT NULL UNIQUE, - password VARCHAR(128) NOT NULL, /* plain text password */ + email VARCHAR(128) NOT NULL, + password VARCHAR(128) NOT NULL, /* in plain text */ role INTEGER NOT NULL, /* 0: normal user, 1: administrator */ first_name VARCHAR(128), last_name VARCHAR(128) @@ -33,13 +33,13 @@ CREATE TABLE posts ( author VARCHAR(128) NOT NULL, /* references users.username */ create_time INTEGER NOT NULL, /* UNIX timestamp */ title VARCHAR(256) NOT NULL, /* title of the post */ - content TEXT NOT NULL /* content of the post */ + status INTEGER NOT NULL /* 0: published; 1: draft; 2: pending; 2: denied */ ); /* insert some initial data records for testing */ INSERT INTO users VALUES ('admin', 'admin@example.com', 'demo', 1, 'Qiang', 'Xue'); INSERT INTO users VALUES ('demo', 'demo@example.com', 'demo', 0, 'Wei', 'Zhuo'); -INSERT INTO posts VALUES (NULL, 'admin', 1175708482, 'first post', 'this is my first post'); +INSERT INTO posts VALUES (NULL, 'admin', 1175708482, 'first post', 'this is my first post', 0); @@ -58,7 +58,7 @@ sqlite3 blog.db < ../schema.sql The database has been created as protected/data/blog.db and we shall see the following directories and files:

- + It is required by SQLite that both the directory protected/data and the database file protected/data/blog.db be set writable by the Web server process. diff --git a/demos/blog-tutorial/protected/pages/Day2/ER.gif b/demos/blog-tutorial/protected/pages/Day2/ER.gif index 13e2d15b..90e4c1ea 100644 Binary files a/demos/blog-tutorial/protected/pages/Day2/ER.gif and b/demos/blog-tutorial/protected/pages/Day2/ER.gif differ diff --git a/demos/blog-tutorial/protected/pages/Day2/ER.vsd b/demos/blog-tutorial/protected/pages/Day2/ER.vsd index 2b59897a..95cf7f32 100644 Binary files a/demos/blog-tutorial/protected/pages/Day2/ER.vsd and b/demos/blog-tutorial/protected/pages/Day2/ER.vsd differ -- cgit v1.2.3