Child pages
  • Your First Rest Project
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

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)

 

email

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).

  • No labels