Skip to content

Instantly share code, notes, and snippets.

@nikolasburk
Last active January 18, 2019 15:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nikolasburk/1bef06e6539ad9e7cbca0fa68384b2aa to your computer and use it in GitHub Desktop.
Save nikolasburk/1bef06e6539ad9e7cbca0fa68384b2aa to your computer and use it in GitHub Desktop.

Get Your Own Prisma Client Explorer

This project uses a hosted database that has writes disabled. Follow these steps to set up your own demo database that lets you perform database writes:

1. Fork the CodeSandbox

To get your own version of this sandbox, click the Fork button in the top-left corner (then wait until the embedded browser in the new Sandbox ):

2. Open new Terminal tab

Once the forking succeeded and you have your own version of the sandbox available, you can open a new terminal tab by clicking the little + button:

3. Deploy datamodel & re-generate Prisma client

The next step connects the Prisma client code in in the scripts with a fresh demo database that will be set up for you. In the terminal, run:

yarn prisma deploy

Then, follow these steps in the interactive CLI wizard:

  1. Select Demo server
  2. Open the URL that's printed by the CLI in your browser
  3. Authenticate with Prisma Cloud in your browser
  4. Back in the CodeSandbox terminal, confirm all suggested values

After prisma deploy has terminated, the Prisma client in src/generated/prisma-client is re-generated. This means any script you're running now will read or write data in your own demo database.

4. Explore the Prisma client API

Run the following command to start exploring:

yarn demo

You can also run the scripts defined in package.json directly, e.g.:

yarn filtering-and-sorting # executes `src/reading-data/filterting-and-sorting.ts`

IMPORTANT: Most of the scripts contain calls with hardcoded IDs (e.g. here). Once you've forked the project and connected it to your own demo database, these IDs won't be valid any more. You can run $ yarn load-ids to print a list of the new IDs that were generated for your project and replace the hardcoded ones.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment