Skip to Content

Changes for page Your First Rest Project

Last modified by Steve Peery on 2013/09/06 11:02
From version 2.1
edited by Pascal Robert
on 2011/12/27 07:16
Change comment: There is no comment for this version
To version 9.1
edited by Pascal Robert
on 2011/12/27 11:18
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,4 +1,32 @@
1 -* Database (H2, ready out of the box with Wonder)
2 -* Create Your Model (Person and BlogEntry)
3 -* Implement Migrations
4 -* Rest
1 += Introduction =
2 +
3 +In the first part of the Blog tutorial, you will learn:
4 +
5 +* How to create a EOModel for the database (we will use H2)
6 +* How to use migrations to create the database tables
7 +* How to use ERRest to create blog posts with JSON format and how to display the blog posts in HTML for readers
8 +
9 += Create the database model =
10 +
11 +We will build a small database model for the blog. The database will have two tables: BlogEntry and Author.
12 +
13 +BlogEntry will have the following columns:
14 +
15 +|= Column name |= Type |= Constraints
16 +| id | integer | primary key
17 +| title | string(255) |
18 +| content | string(4000) |
19 +| lastModified | timestamp |
20 +| creationDate | timestamp |
21 +| author | integer | relation with Author
22 +
23 +Author will have the following columns:
24 +
25 +|= Column name |= Type |= Constraints
26 +| id | integer | primary key
27 +| firstName | string(100) |
28 +| lastName | string(100) |
29 +| email | string(150) | unique
30 +| passwd | string(16) |
31 +
32 +To create the database, we will first create a EOModel and use migrations to build the database on the file system (H2 will take care of creating the database file).