Introduction
In the first part of the Blog tutorial, you will learn:
- How to create a EOModel for the database (we will use H2)
- How to use migrations to create the database tables
- How to use ERRest to create blog posts with JSON format and how to display the blog posts in HTML for readers
Create the database model
We will build a small database model for the blog. The database will have two tables: BlogEntry and Author.
BlogEntry will have the following columns:
Column name |
Type |
Constraints |
|---|---|---|
id |
integer |
primary key |
title |
string(255) |
|
content |
string(4000) |
|
lastModified |
timestamp |
|
creationDate |
timestamp |
|
author |
integer |
relation with Author |
Author will have the following columns:
Column name |
Type |
Constraints |
|---|---|---|
id |
integer |
primary key |
firstName |
string(100) |
|
lastName |
string(100) |
|
string(150) |
unique |
|
passwd |
string(16) |
|
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).