seven

Section 7 - Database setup

Since Blitz is using prisma as ORM for the database, we have a schema.prisma file in our Blitz app. The file contains the schema that is the basis for both our database structure and the generated Typescript types. Let's go ahead and see what we are going to make:

Explanation of schema

In the end-solution, an admin will be able to create activities. An activity has a name, the points the activity is rewarded with, and an optional description. Here is an example of an activity:

{
	"id": 1,
	"createdAt": "2021-02-10T13:08:38.402Z",
  	"updatedAt": "2021-02-10T13:08:38.403Z",
	"name": "Held a workshop",
	"createdById": 2,
	"description": "",
	"points": 120
}

An action is what connects a user and an activity. Here is an example of an action:

{
	"id": 1,
	"createdAt": "2021-02-10T13:08:38.402Z",
  	"updatedAt": "2021-02-10T13:08:38.403Z",
	"createdById": 1,
	"userId": 2,
	"activityId": 3
}

We'll lookat two different ways of adding features to the app. With a feature, I mean database schema, queries, mutations and pages needed for a specific functionality.

There are two ways we'll have a look at:

1. Manual (good old - create all the files yourself)
2. Using the Blitz CLI generate option

The manual way

Let's create the feature for activity in a manual way

Using the Blitz CLI

Let's create the feature for action using the Blitz CLI

Pritty sweet, right? Continue to next section