prisma

Encore + Prisma TypeScript Example

This is a RESTful API Starter with Prisma as ORM to handle database CRUD operations.

Developing locally

When you have installed Encore, you can create a new Encore application and clone this example with this command.

encore app create --example=ts/prisma

Running locally

encore run

While encore run is running, open http://localhost:9400/ to view Encore's local developer dashboard.

Configure Prisma

Get the connection string to the shadow database by running:

encore db conn-uri encore_prisma_test --shadow

Then edit users/prisma/schema.prisma replace <paste shadow db connection string here> with the output of the above command.

Using the API

Counts and returns the number of existing users

curl 'http://localhost:4000/count/users'

Create a new user

curl 'http://localhost:4000/users' -d '{"name":"John","surname":"Doe"}'

Get all users data

curl 'http://localhost:4000/users'

# for paginated data:
curl 'http://localhost:4000/users?page=1&limit=10'

Get user data by id

curl 'http://localhost:4000/users/:id'

Update user data

# partial update
curl -XPATCH 'http://localhost:4000/users/:id' -d '{"data":{"name":"Johnny"}}'

# update complete data
curl -XPATCH 'http://localhost:4000/users/:id' -d '{"data":{"name":"Mary","surname":"Jane"}}'

Delete an user by id

curl -X DELETE 'http://localhost:4000/users/:id'

Deployment

Deploy your application to a staging environment in Encore's free development cloud:

git add -A .
git commit -m 'Commit message'
git push encore

Then head over to the Cloud Dashboard to monitor your deployment and find your production URL.

From there you can also connect your own AWS or GCP account to use for deployment.

Now off you go into the clouds!