Creating and querying database snapshots

To provide data for the mock API to query, you create database snapshots. Fabricate stores the snapshot data internally.

Creating a snapshot

To create a database snapshot of the current database data:

1. If no snapshots are currently configured, click Create a DB Snapshot.

2. If there are existing snapshots, then:

   1. Click the snapshot dropdown.

   2. In the dropdown, click Create New Snapshot.

Dropdown list of database snapshots

1. On the Create DB Snapshot panel, in the Snapshot Name field, provide a name for the snapshot. Fabricate provides a default value of v<snapshot count>. For example, v1 or v2.

2. Click Create Snapshot. Fabricate generates the snapshot and adds it to the dropdown list.

Querying a snapshot

To verify the snapshot data works as expected, you can run queries against the snapshot.

To query a snapshot:

1. Click the snapshot dropdown.

2. In the dropdown list, select the snapshot to query against.

3. Click SQL.

4. On the SQL Editor panel, enter the query, then either:

   1. Press Enter.

   2. Click Run Query.

Downloading a snapshot

You can download a snapshot. The snapshot is downloaded to a file named <database name>.sqlite.

To download a snapshot:

1. Click the snapshot dropdown.

2. In the dropdown list, click the download icon for the snapshot.

Removing a snapshot

To remove a snapshot:

1. Click the snapshot dropdown.

2. In the dropdown list, click the delete icon for the snapshot.