@shopify/shopify-app-session-storage-prisma

Session Storage Adapter for Prisma

This package implements the SessionStorage interface that works with an instance of Prisma.

Session storage for prisma requires a schema.prisma with a Session table with at-least the following columns:

model Session {
  id          String    @id
  shop        String
  state       String
  isOnline    Boolean   @default(false)
  scope       String?
  expires     DateTime?
  accessToken String
  userId      BigInt?
}

[!WARNING] Some DB adapters adapters may set a maximum length for the String type by default, please ensure your fields allow for long enough strings. See https://www.prisma.io/docs/orm/reference/prisma-schema-reference#string for more information

You can then instantiate and use PrismaSessionStorage like so:

import {shopifyApp} from '@shopify/shopify-app-express';
import {PrismaSessionStorage} from '@shopify/shopify-app-session-storage-prisma';
import {PrismaClient} from '@prisma/client';

const prisma = new PrismaClient();
const storage = new PrismaSessionStorage(prisma);

const shopify = shopifyApp({
  sessionStorage: storage,
  // ...
});

Options

You can also pass in some optional flags to tweak the behavior of the adapter.

Custom table name

You can pass in the tableName option if you want to use a different table name in your schema. For example:

const storage = new PrismaSessionStorage(prisma, {
  tableName: 'MyCustomSession',
});

Note: If you use SQLite with Prisma note that sqlite is a local, file-based SQL database. It persists all tables to a single file on your local disk. As such, it’s simple to set up and is a great choice for getting started with Shopify App development. However, it won’t work when your app getting scaled across multiple instances because they would each create their own database.

If you prefer to use your own implementation of a session storage mechanism that is compatible with the @shopify/shopify-app-express package, see the implementing session storage guide.

Connection retries

When the storage starts up, it will connect to the database during startup so the app can start. If the DB server takes too long to start, the setup may fail.

To avoid that, you can pass in the connectionRetries and connectionRetryIntervalMs options to control how many times to retry, and how long to wait between tries, respectively. For example:

const storage = new PrismaSessionStorage(prisma, {
  // Default values
  connectionRetries: 2,
  connectionRetryIntervalMs: 5000,
});

Updating your database

When updating the type of database you are using, you may need to make some changes to your project for Prisma to work correctly. Please review the prisma documentation for your specific database type for configuration.

• MongoDB
• MySQL
• PostgreSQL

Troubleshooting

MissingSessionTableError error is thrown

Some common reasons for that are:

1. The database was not migrated.
2. The Session table above was not added to the schema.
3. The table is in the schema, but isn't named Session.

Here are some possible solutions for this issue:

1. Ensure you've run the migrate command to apply the schema.
2. Ensure you've copied the schema above into your prisma.schema file.
3. If you've made changes to the table, make sure it's still called Session.

Error: The "mongodb" provider is not supported with this command

MongoDB does not support the prisma migrate command. If you are using MongoDB please see the Prisma documentation for configuring your database.