Client

In order to make any Prisma Client Python queries you need to create and connect to a Client instance, for example:

from prisma import Prisma

db = Prisma()
await db.connect()
await db.user.create(
    data={
        'name': 'Robert',
    },
)

You can also query directly from model classes, see Model Actions for more information.

from prisma.models import User

user = await User.prisma().create(
    data={
        'name': 'Robert',
    },
)

Datasource Overriding

It is possible to override the default URL used to connect to the database:

db = Prisma(
    datasource={
        'url': 'file:./tmp.db',
    },
)

Context Manager

To make running small scripts as easy as possible, Prisma Client Python supports connecting and disconnecting from the database using a context manager.

For example:

from prisma import Prisma

async with Prisma() as db:
    await db.user.create(
        data={
            'name': 'Robert',
        },
    )

Which is functionally equivalent to:

from prisma import Prisma

db = Prisma()

try:
    await db.connect()
    await db.user.create(
        data={
            'name': 'Robert',
        },
    )
finally:
    if db.is_connected():
        await db.disconnect()

HTTP Options

Some of the methods that Prisma Client Python uses to communicate with the underlying Prisma binaries make use of HTTPX to communicate over HTTP. As such, some HTTPX Client options are configurable on a per-client basis.

The HTTPX options can be passed to client using the http parameter, for example:

db = Prisma(
    http={
        'timeout': 10,
    },
)

Will then use a 10 second timeout for all http operations.

You can also remove the timeout by passing None, for example:

db = Prisma(
    http={
        'timeout': None,
    },
)

Not all options that HTTPX support are supported by Prisma Client Python, a full list can be found below:

class HttpConfig(TypedDict, total=False):
    app: Callable[[Mapping[str, Any], Any], Any]
    http1: bool
    http2: bool
    limits: httpx.Limits
    timeout: Union[None, float, httpx.Timeout]
    trust_env: bool
    max_redirects: int

The documentation behind these options can be found here