Changes for page Your First Rest Project

Last modified by Steve Peery on 2013/09/06 11:02

From version 46.1
edited by Filippo Laurìa
on 2013/07/22 12:55
Change comment: There is no comment for this version
To version 45.1
edited by skcodes
on 2013/05/13 12:53
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.filippolauria
1 +XWiki.skcodes
Content
... ... @@ -1,7 +1,5 @@
1 +{{toc}}{{/toc}}
1 1  
2 -
3 -{{toc/}}
4 -
5 5  = Introduction =
6 6  
7 7  In the first part of the Blog tutorial, you will learn:
... ... @@ -22,93 +22,21 @@
22 22  
23 23  BlogEntry will have the following columns:
24 24  
25 -|=(((
26 -Column name
27 -)))|=(((
28 -Type
29 -)))|=(((
30 -Constraints
31 -)))
32 -|(((
33 -id
34 -)))|(((
35 -integer
36 -)))|(((
37 -primary key
38 -)))
39 -|(((
40 -title
41 -)))|(((
42 -string(255)
43 -)))|(((
44 -
45 -)))
46 -|(((
47 -content
48 -)))|(((
49 -string(4000)
50 -)))|(((
51 -
52 -)))
53 -|(((
54 -creationDate
55 -)))|(((
56 -timestamp
57 -)))|(((
58 -
59 -)))
60 -|(((
61 -lastModified
62 -)))|(((
63 -timestamp
64 -)))|(((
65 -
66 -)))
67 -|(((
68 -author
69 -)))|(((
70 -integer
71 -)))|(((
72 -relation with Author
73 -)))
23 +|= Column name |= Type |= Constraints
24 +| id | integer | primary key
25 +| title | string(255) |
26 +| content | string(4000) |
27 +| creationDate | timestamp |
28 +| lastModified | timestamp |
29 +| author | integer | relation with Author
74 74  
75 75  Author will have the following columns:
76 76  
77 -|=(((
78 -Column name
79 -)))|=(((
80 -Type
81 -)))|=(((
82 -Constraints
83 -)))
84 -|(((
85 -id
86 -)))|(((
87 -integer
88 -)))|(((
89 -primary key
90 -)))
91 -|(((
92 -firstName
93 -)))|(((
94 -string(50)
95 -)))|(((
96 -
97 -)))
98 -|(((
99 -lastName
100 -)))|(((
101 -string(50)
102 -)))|(((
103 -
104 -)))
105 -|(((
106 -email
107 -)))|(((
108 -string(100)
109 -)))|(((
110 -unique
111 -)))
33 +|= Column name |= Type |= Constraints
34 +| id | integer | primary key
35 +| firstName | string(50) |
36 +| lastName | string(50) |
37 +| email | string(100) | unique
112 112  
113 113  == Creating the EOModel ==
114 114  
... ... @@ -116,24 +116,16 @@
116 116  
117 117  An EOModel consists of entities, attributes and relationships. When using it in a RDBMS context, an entity is a table (or a view), an attribute is a table column and a relationship is a join between two tables.
118 118  
119 -To create the EOModel, in the project right-click on the project name and select **New** -> **EOModel**.
45 +To create the EOModel, in the project right-click on the project name and select **New** > **EOModel**.
120 120  
121 121  Name it **BlogModel** and in the plugin list, select **H2**. Click **Finish**.
122 122  
123 123  The model should show up in a window that looks like this:
124 124  
125 -[[image:attach:EOModeler.png]]
126 -
127 127  If it didn't show up, the window might have opened behind the main Eclipse window. If that's the case, open the **Window** menu and select the windows that have //Entity Modeler// in its name.
128 128  
129 -In the Entity Modeler window, click on **Default**, and for the **URL** field, type
53 +In the Entity Modeler window, click on **Default**, and for the **URL** field, type {{code}}jdbc:h2:~/BlogTutorial{{/code}}. When the database will be created, it will be stored in your home directory (/Users/youruser/ on OS X).
130 130  
131 -{{code}}
132 -jdbc:h2:~/BlogTutorial
133 -{{/code}}
134 -
135 -. When the database will be created, it will be stored in your home directory (/Users/youruser/ on OS X).
136 -
137 137  Now, right-click on **BlogModel** and select **New Entity**.
138 138  
139 139  Type the following details in the **Basic** tab:
... ... @@ -154,97 +154,36 @@
154 154  
155 155  Now, repeat the last two steps to create the other attributes for the **BlogEntry** entity, with the following values:
156 156  
157 -|=(((
158 -Attribute name
159 -)))|=(((
160 -Column
161 -)))|=(((
162 -Prototype
163 -)))
164 -|(((
165 -content
166 -)))|(((
167 -content
168 -)))|(((
169 -longtext
170 -)))
171 -|(((
172 -creationDate
173 -)))|(((
174 -creationDate
175 -)))|(((
176 -dateTime
177 -)))
178 -|(((
179 -lastModified
180 -)))|(((
181 -lastModified
182 -)))|(((
183 -dateTime
184 -)))
75 +|= Attribute name |= Column |= Prototype
76 +| content | content | longtext
77 +| creationDate | creationDate | dateTime
78 +| lastModified | lastModified | dateTime
185 185  
186 186  If you did everything well, the list of attributes should look like this:
187 187  
188 -[[image:attach:list_wlock.png]]
189 -
190 190  You will notice that the attributes have a column with a lock in it. When a lock is present, it will use the value of that attribute for //UPDATE ... WHERE attribute = ''// statement. This is to do optimistic locking, aka to prevent data conflict when the data object was modified by two different users. Using timestamps for optimistic locking is not a good idea because for certain RDBMS, the value can be different because of milliseconds, so remove the locks on the **creationDate** attribute. The final list should look like this:
191 191  
192 -[[image:attach:list.png]]
193 -
194 194  Next step is to create the **Author** entity. Create a new entity with **Author** at its name (and also as the table name), and for the class name, use **your.app.model.Author**. The attributes for this entity are:
195 195  
196 -|=(((
197 -Attribute name
198 -)))|=(((
199 -Column
200 -)))|=(((
201 -Prototype
202 -)))
203 -|(((
204 -firstName
205 -)))|(((
206 -firstName
207 -)))|(((
208 -varchar50
209 -)))
210 -|(((
211 -lastName
212 -)))|(((
213 -lastName
214 -)))|(((
215 -varchar50
216 -)))
217 -|(((
218 -email
219 -)))|(((
220 -email
221 -)))|(((
222 -varchar100
223 -)))
86 +|= Attribute name |= Column |= Prototype
87 +| firstName | firstName | varchar50
88 +| lastName | lastName | varchar50
89 +| email | email | varchar100
224 224  
225 225  Final list of attributes should look like this:
226 226  
227 -[[image:attach:author_list.png]]
228 -
229 229  Now, it's time to link the two entities together. An Author can have multiple blog entries, and a BlogEntry can only have one author. To create the relationship (the join), right-click on **Author** and select **New Relationship**. On your right, select **BlogEntry** in the list. On your left, select **to many BlogEntries**, and on your right, select **to one Author**. Now, in BlogEntry, we need to store the primary key of the author so that we can make the join. The relationship builder allow us to add that attribute, so make sure **and a new foreign key named** is checked (it is checked by default). The **Create Relationship** pane should look like this:
230 230  
231 -[[image:attach:relationship.png]]
232 -
233 233  If you check in the **Outline** tab, you should see that **Author** now have a **blogEntries** relationship, and **BlogEntry** have a **author** relationship.
234 234  
235 -[[image:attach:outline_tab.png]]
97 +You are now ready to save the model. Save it (File > Save) and close the **Entity Modeler** window. If you open the **Sources** in the main Eclipse window, you will notice that the **Sources** folder contains a package named **your.app.model**. (If this folder doesn't appear, you may need to set your preferences to automatically generate these source files; see the second suggestion on http:~/~/wiki.wocommunity.org/display/documentation/Useful+Eclipse+or+WOLips+Preferences.)
236 236  
237 -You are now ready to save the model. Save it (File -> Save) and close the **Entity Modeler** window. If you open the **Sources** in the main Eclipse window, you will notice that the **Sources** folder contains a package named **your.app.model**. (If this folder doesn't appear, you may need to set your preferences to automatically generate these source files; see the second suggestion on [[http:~~/~~/wiki.wocommunity.org/display/documentation/Useful+Eclipse+or+WOLips+Preferences>>url:http://wiki.wocommunity.org/display/documentation/Useful+Eclipse+or+WOLips+Preferences||rel="nofollow" shape="rect" class="external-link"]].)
99 +That package have four Java classes: **Author**, **Author**, **BlogEntry** and **BlogEntry**. Those classes were generated by Veogen, a templating engine build on Velocity. The two classes that starts with a underscore are recreated every time you change the EOModel, so if you want to change something in those classes, you need to change the template (no need for that right now). But you can change freely the two classes that don't have the underscore, and this is what we will be doing.
238 238  
239 -
240 -
241 -That package have four Java classes: **_Author**, **Author**, **_BlogEntry** and **BlogEntry**. Those classes were generated by Veogen, a templating engine build on Velocity. The two classes that starts with a underscore are recreated every time you change the EOModel, so if you want to change something in those classes, you need to change the template (no need for that right now). But you can change freely the two classes that don't have the underscore, and this is what we will be doing.
242 -
243 -
244 -
245 245  What we are going to do is to write a simple method that returns the full name of an author, e.g. a method that simply concatenate the first name, a space and the last name of the author. To do so, double-click on **Author.java** and add the following methods:
246 246  
247 247  {{code}}
104 +
248 248  public String fullName() {
249 249   return this.firstName() + " " + this.lastName();
250 250   }
... ... @@ -254,6 +254,7 @@
254 254  Nothing fancy here. Now open **BlogEntry.java** and add the following method:
255 255  
256 256  {{code}}
114 +
257 257   @Override
258 258   public void awakeFromInsertion(EOEditingContext editingContext) {
259 259   super.awakeFromInsertion(editingContext);
... ... @@ -283,6 +283,7 @@
283 283  Remove the pound char in front of those two properties:
284 284  
285 285  {{code}}
144 +
286 286  #er.migration.migrateAtStartup=true
287 287  #er.migration.createTablesIfNecessary=true
288 288  
... ... @@ -291,14 +291,16 @@
291 291  After removing the pound char, the two properties should look like this:
292 292  
293 293  {{code}}
153 +
294 294  er.migration.migrateAtStartup=true
295 295  er.migration.createTablesIfNecessary=true
296 296  
297 297  {{/code}}
298 298  
299 -You are now ready to start the application so that it creates the database! To do so, right-click on **Application.java** (in the **your.app** folder) and select **Run As** -> **WOApplication**. In Eclipse's Console tab, you should see some output, including something similar to:
159 +You are now ready to start the application so that it creates the database To do so, right-click on **Application.java** (in the **your.app** folder) and select **Run As** > **WOApplication**. In Eclipse's Console tab, you should see some output, including something similar to:
300 300  
301 301  {{code}}
162 +
302 302  BlogRest[62990] INFO er.extensions.migration.ERXMigrator - Upgrading BlogModel to version 0 with migration 'your.app.model.migrations.BlogModel0@4743bf3d'
303 303  BlogRest[62990] INFO er.extensions.jdbc.ERXJDBCUtilities - Executing CREATE TABLE Author(email VARCHAR(100) NOT NULL, firstName VARCHAR(50) NOT NULL, id INTEGER NOT NULL, lastName VARCHAR(50) NOT NULL)
304 304  BlogRest[62990] INFO er.extensions.jdbc.ERXJDBCUtilities - Executing ALTER TABLE Author ADD PRIMARY KEY (id)
... ... @@ -309,7 +309,7 @@
309 309  
310 310  {{/code}}
311 311  
312 -If you see this and that the application is running (it should open a window in your favorite browser), migration worked and your database have been created, congratulations! You can now stop the application (click the square red button in Eclipse's Console tab) and continue to the next step.
173 +If you see this and that the application is running (it should open a window in your favorite browser), migration worked and your database have been created, congratulations You can now stop the application (click the square red button in Eclipse's Console tab) and continue to the next step.
313 313  
314 314  = Creating REST controllers and routes =
315 315  
... ... @@ -346,14 +346,15 @@
346 346  * **indexAction**: to list all (or a sublist) of the objects.
347 347  
348 348  {{info}}
349 -In Project Wonder, **Action** at the end of a method is a convention for REST and Direct Actions, when you call those methods from certain components, you don't need to add the **Action** part.
210 +In Project Wonder, *Action* at the end of a method is a convention for REST and Direct Actions, when you call those methods from certain components, you don't need to add the *Action* part.
350 350  {{/info}}
351 351  
352 -For this tutorial, we will implement the **createAction** and **indexAction** methods. But first, we need to create a key filter. A key filter will... filter the input and the output of REST request so that you don't have to send all attributes for a blog entry. For example, we want to show the details for an author, but we don't want to show the password for the author (in real-life, the password would be encrypted)!
213 +For this tutorial, we will implement the **createAction** and **indexAction** methods. But first, we need to create a key filter. A key filter will... filter the input and the output of REST request so that you don't have to send all attributes for a blog entry. For example, we want to show the details for an author, but we don't want to show the password for the author (in real-life, the password would be encrypted)
353 353  
354 354  Add this method in **BlogEntryController**:
355 355  
356 356  {{code}}
218 +
357 357  protected ERXKeyFilter filter() {
358 358   ERXKeyFilter personFilter = ERXKeyFilter.filterWithAttributes();
359 359   personFilter.setAnonymousUpdateEnabled(true);
... ... @@ -370,6 +370,7 @@
370 370  Now, let's implement the **createAction** method:
371 371  
372 372  {{code}}
235 +
373 373  public WOActionResults createAction() throws Throwable {
374 374   BlogEntry entry = create(filter());
375 375   editingContext().saveChanges();
... ... @@ -383,6 +383,7 @@
383 383  Last step in the controller: implementing the **indexAction** method. Again, the code is simple:
384 384  
385 385  {{code}}
249 +
386 386  public WOActionResults indexAction() throws Throwable {
387 387   NSArray<BlogEntry> entries = BlogEntry.fetchAllBlogEntries(editingContext());
388 388   return response(entries, filter());
... ... @@ -399,6 +399,7 @@
399 399  A route in ERRest is simply a way to define the URL for the entities and to specify which controller the route should use. When your controller extends from **ERXDefaultRouteController**, it's easy to register a controller and a route. In **Application.java**, in the **Application** constructor, add the following code:
400 400  
401 401  {{code}}
266 +
402 402  ERXRouteRequestHandler restRequestHandler = new ERXRouteRequestHandler();
403 403   restRequestHandler.addDefaultRoutes(BlogEntry.ENTITY_NAME);
404 404   ERXRouteRequestHandler.register(restRequestHandler);
... ... @@ -408,13 +408,13 @@
408 408  
409 409  The **addDefaultRoutes** method do all of the required magic, and use convention. That's why we had to name the controller **BlogEntryController**, because the convention is <EntityName>Controller.
410 410  
411 -We are now reading to add and list blog postings! Start the application and take notice of the URL. It should be something like _[[http:~~/~~/yourip:someport/cgi-bin/WebObjects/BlogRest.woa_>>url:http://youripsomeport||shape="rect"]]
276 +We are now reading to add and list blog postings Start the application and take notice of the URL. It should be something like //[[http:~~/~~/yourip:someport/cgi-bin/WebObjects/BlogRest.woa>>http://yourip:someport/cgi-bin/WebObjects/BlogRest.woa_]]//
412 412  
413 413  == Adding posts and authors with curl ==
414 414  
415 415  Since we didn't implement any HTML for our REST routes, we will create blog entries with //curl//, an open source HTTP client that is bundled with Mac OS X (you can use another client, like wget, if you like too). So let's create a blog entry.
416 416  
417 -To create a blog entry, you need to use the POST HTTP method. We will use JSON as the format since it's a bit less chatty than XML. So if the URL to the application is //[[http:~~/~~/192.168.0.102:52406/cgi-bin/WebObjects/BlogRest.woa_>>url:http://192.168.0.102:52406/cgi-bin/WebObjects/BlogRest.woa_||shape="rect"]], the full _curl// command will be:
282 +To create a blog entry, you need to use the POST HTTP method. We will use JSON as the format since it's a bit less chatty than XML. So if the URL to the application is //[[http:~~/~~/192.168.0.102:52406/cgi-bin/WebObjects/BlogRest.woa>>http://192.168.0.102:52406/cgi-bin/WebObjects/BlogRest.woa_]], the full curl// command will be:
418 418  
419 419  {{code}}
420 420  curl -X POST -v -d '{ "title": "First post", "content": "Some text", "author": { "firstName": "Pascal", "lastName": "Robert", "email": "probert@macti.ca" } }' http://192.168.0.102:52406/cgi-bin/WebObjects/BlogRest.woa/ra/blogEntries.json
... ... @@ -423,6 +423,7 @@
423 423  The response should look this:
424 424  
425 425  {{code}}
291 +
426 426  HTTP/1.0 201 Apple WebObjects
427 427  Content-Length: 249
428 428  x-webobjects-loadaverage: 0
... ... @@ -435,6 +435,7 @@
435 435  To get a list of blog entries:
436 436  
437 437  {{code}}
304 +
438 438  curl -X GET http://192.168.0.102:52406/cgi-bin/WebObjects/BlogRest.woa/ra/blogEntries.json
439 439  
440 440  {{/code}}
... ... @@ -446,6 +446,7 @@
446 446  Now, let's build a HTML view for blog posts (you don't want your readers to get your posts by JSON, right?). Again, we will use convention to make it work easily. Open up **BlogEntryController** and add the following method:
447 447  
448 448  {{code}}
316 +
449 449  @Override
450 450   protected boolean isAutomaticHtmlRoutingEnabled() {
451 451   return true;
... ... @@ -453,11 +453,12 @@
453 453  
454 454  {{/code}}
455 455  
456 -Switching the return value of this method says that we will follow a certain convention for HTML components. The convention for automatic HTML routing is that the component should be named <EntityName><Action>Page.wo. So in our case, the component will be **BlogEntryIndexPage**. Right-click on the project name in Eclipse and select **New** -> **WOComponent**. Change the name to **BlogEntryIndexPage** and check the **Create HTML contents** button. Click **Finish**.
324 +Switching the return value of this method says that we will follow a certain convention for HTML components. The convention for automatic HTML routing is that the component should be named <EntityName><Action>Page.wo. So in our case, the component will be **BlogEntryIndexPage**. Right-click on the project name in Eclipse and select **New** > **WOComponent**. Change the name to **BlogEntryIndexPage** and check the **Create HTML contents** button. Click **Finish**.
457 457  
458 458  The next step to get it to work is to make **BlogEntryIndexPage** to implement the **er.rest.routes.IERXRouteComponent** interface.
459 459  
460 460  {{code}}
329 +
461 461  import er.rest.routes.IERXRouteComponent;
462 462  
463 463  public class BlogEntryIndexPage extends WOComponent implements IERXRouteComponent {
... ... @@ -467,6 +467,7 @@
467 467  So now, the automatic HTML routing will send the request for **ra/blogEntries.html** to the **BlogEntryIndexPage** component. But we don't have any content in this component, so let's make a method to fetch all blog entries per creation date in descending order. So in **BlogEntryIndexPage.java**, add the following method:
468 468  
469 469  {{code}}
339 +
470 470  public NSArray<BlogEntry> entries() {
471 471   EOEditingContext ec = ERXEC.newEditingContext();
472 472   return BlogEntry.fetchAllBlogEntries(ec, BlogEntry.CREATION_DATE.descs());
... ... @@ -477,6 +477,7 @@
477 477  We need to use that method in a WORepetition, and for that loop, we need a BlogEntry variable to iterate in the list, so add the following code to **BlogEntryIndexPage.java**:
478 478  
479 479  {{code}}
350 +
480 480  private BlogEntry entryItem;
481 481  
482 482   public BlogEntry entryItem() {
... ... @@ -492,6 +492,7 @@
492 492  The Java part is done, so let's add the loop inside the component. Open **BlogEntryIndexPage.wo** (it's located in the **Component** folder) and right after the <body> tag, add:
493 493  
494 494  {{code}}
366 +
495 495  <wo:loop list="$entries" item="$entryItem">
496 496   <p><wo:str value="$entryItem.title" /></p>
497 497   <p><wo:str value="$entryItem.author.fullName" /></p>
... ... @@ -501,13 +501,14 @@
501 501  
502 502  That component code will loop over the blog entries and display the title of the entry + the name of the author. Save everything and run the application.
503 503  
504 -If you go to [[http:~~/~~/192.168.0.102:52406/cgi-bin/WebObjects/BlogRest.woa/ra/blogEntries.html>>url:http://192.168.0.102:52406/cgi-bin/WebObjects/BlogRest.woa/ra/blogEntries.html||shape="rect"]], you will see the list of blog entries!
376 +If you go to [[http://192.168.0.102:52406/cgi-bin/WebObjects/BlogRest.woa/ra/blogEntries.html]], you will see the list of blog entries
505 505  
506 506  Now that we have a list of blog entries, let's make a page to show the content of a blog entry. Create a new component named **BlogEntryShowPage**.
507 507  
508 -Open **BlogEntryShowPage.java** and make sure the class implements **er.rest.routes.IERXRouteComponent**.
380 +Open **BlogEntryShowPage.java** and make sure the class implements&nbsp;**er.rest.routes.IERXRouteComponent**.
509 509  
510 510  {{code}}
383 +
511 511  import er.rest.routes.IERXRouteComponent;
512 512  
513 513  public class BlogEntryShowPage extends WOComponent implements IERXRouteComponent {
... ... @@ -517,6 +517,7 @@
517 517  We need to add other methods to receive the BlogEntry object from the controller. In **BlogEntryShowPage.java**, add:
518 518  
519 519  {{code}}
393 +
520 520  private BlogEntry blogEntry;
521 521  
522 522   @ERXRouteParameter
... ... @@ -535,6 +535,7 @@
535 535  The Java part of the work is done, so save the Java class. It's time to work on the component part. Open **BlogEntryShowPage.wo** and between the <body></body> part, add:
536 536  
537 537  {{code}}
412 +
538 538  <h1><wo:str value="$blogEntry.title" /></h1>
539 539   <p><wo:str value="$blogEntry.content" /></p>
540 540   <p>Created on: <wo:str value="$blogEntry.creationDate" dateformat="%Y/%m/%d" /></p>
... ... @@ -545,6 +545,7 @@
545 545  Our view component is done, the only thing remaining is a link for the blog entry list (BlogEntryIndexPage) to the view page (BlogEntryShowPage). Save **BlogEntryShowPage.wo** and open **BlogEntryIndexPage.wo**. We are going to add a link on the title, you will replace to replace this:
546 546  
547 547  {{code}}
423 +
548 548  <p><wo:str value="$entryItem.title" /></p>
549 549  
550 550  {{/code}}
... ... @@ -552,10 +552,11 @@
552 552  with:
553 553  
554 554  {{code}}
431 +
555 555  <p><wo:ERXRouteLink entityName="BlogEntry" record="$entryItem" action="show"><wo:str value="$entryItem.title" /></wo:ERXRouteLink></p>
556 556  
557 557  {{/code}}
558 558  
559 -Save the component and run the app. Go to [[http:~~/~~/192.168.0.102:52406/cgi-bin/WebObjects/BlogRest.woa/ra/blogEntries.html>>url:http://192.168.0.102:52406/cgi-bin/WebObjects/BlogRest.woa/ra/blogEntries.html||shape="rect"]] to get the list of posts, and you should see a link on the title. Click on it, and now you get the full details of the blog entry!
436 +Save the component and run the app. Go to [[http://192.168.0.102:52406/cgi-bin/WebObjects/BlogRest.woa/ra/blogEntries.html]] to get the list of posts, and you should see a link on the title. Click on it, and now you get the full details of the blog entry
560 560  
561 -The REST part of this tutorial is now complete, [[you can now move to the next part of the tutorial>>doc:Your First Framework]].
438 +The REST part of this tutorial is now complete, [[you can now move to the next part of the tutorial>>Your First Framework]].