Creating CRUD flows

When developing a web service with FL0, it's often necessary to create flows that create, read, update, and delete data from a database. In fact, that's what most of the database-specific documentation explains how to do.

But creating flows for these common operations can be tedious, which is why FL0 has a Create CRUD button that does most of the work for you. Specifically, this button creates HTTP Request flows that set up the basic CRUD operations for a database table.

This tutorial uses a to-do list management application as an example to demonstrate how to use the Create CRUD button.

Prerequisites

  • You have a FL0 account.
  • You've read the previous tutorials in this series.

Step 1: Create a project

  1. Log in to FL0.
  2. Click Create a new project.
  3. In the Project Name field, enter a name for the project.
  4. Select a hosting region.
  5. Click Save.

Step 2: Create a database table

  1. In the Explorer pane, click Create new.
  2. Select Table.
  3. Type Tasks.
  4. Tap the Return key.

Step 3: Add fields to the table

  1. Switch to the Configuration tab.
  2. Create a row to store the name of the task.
    1. In the Name field, enter Name.
    2. From the Data type dropdown, select String.
  3. Create a row to store the status of the task.
    1. In the Name field, enter IsComplete.
    2. From the Data type dropdown, select Boolean.
    3. Enable the Nullable option.
  4. Click Save.

Step 4: Create the CRUD flows

  1. Click Create CRUD.
  2. (Optional) From the Auth Policy dropdown, select an auth policy.
  3. In the Plural Entity Name, enter a pluralized name, such as "Tasks".
  4. In the Single Entity Name, enter a singular name, such as "Task".
  5. Click Create.

FL0 creates the following HTTP Request flows in the specified folder:

  • Delete Task
  • Get Task
  • Get Tasks
  • Insert Task
  • Update Task

The names of these flows are based on the configured entity names.