We will write unit tests as we go along so that we can be confident that as we
refactor to add new functionality, we do not break what we know to be working. The centerpiece of Places is
reviews of places to take children, so we will start there.
There are four main sections to the home page. At the top, there is a header with logo and main navigation
menu. The main content area is in the middle and a right hand column provides space for advertising. The site
also contains a footer, which is not shown in Figure 3.6, to provide contact and copyright information on all
pages.
3.4.1 The initial models
As we know we need a list of reviews on the home page, let??™s start with a database table called reviews
where each row represents a new review of a place. We can also assume that any given place will have more
than one review, so we will need a list of locations in a table called places. The initial database schema is
shown in Figure 3.5 and shows two tables, places and reviews.
Licensed to Menshu You
Please post comments or corrections to the Author Online forum at
http://www.manning-sandbox.com/forum.jspa?forumID=329
Figure 3.6 In order to build the initial pages, the database consists of two tables with a foreign key from Reviews to Places.
Pages:
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105