prisma-client-pythonでpythonからORMを楽にやる

poetry new prisma-client-python-playground

poetry add -D prisma

% poetry run prisma init --datasource-provider sqlite

✔ Your Prisma schema was created at prisma/schema.prisma
  You can now open it in your favorite editor.

Next steps:
1. Set the DATABASE_URL in the .env file to point to your existing database. If your database has no tables yet, read https://pris.ly/d/getting-started
2. Run prisma db pull to turn your database schema into a Prisma schema.
3. Run prisma generate to generate the Prisma Client. You can then start querying your database.

More information in our documentation:
https://pris.ly/d/getting-started

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "sqlite"
  url      = env("DATABASE_URL")
}

generator client {
  provider             = "prisma-client-py"
  interface            = "asyncio"
}

model User {
  id    Int     @id @default(autoincrement())
  email String  @unique
  name  String?
  posts Post[]
}

model Post {
  id        Int     @id @default(autoincrement())
  title     String
  content   String?
  published Boolean @default(false)
  author    User    @relation(fields: [authorId], references: [id])
  authorId  Int
}

% poetry run prisma migrate dev --name "init"
Environment variables loaded from .env
Prisma schema loaded from prisma/schema.prisma
Datasource "db": SQLite database "dev.db" at "file:./dev.db"

SQLite database dev.db created at file:./dev.db

Applying migration `20230814005333_init`

The following migration(s) have been created and applied from new schema changes:

migrations/
  └─ 20230814005333_init/
    └─ migration.sql

Your database is now in sync with your schema.

Running generate... - Prisma Client Python (v0.9.1)

Some types are disabled by default due to being incompatible with Mypy, it is highly recommended
to use Pyright instead and configure Prisma Python to use recursive types. To re-enable certain types:

generator client {
  provider             = "prisma-client-py"
  recursive_type_depth = -1
}

If you need to use Mypy, you can also disable this message by explicitly setting the default value:

generator client {
  provider             = "prisma-client-py"
  recursive_type_depth = 5
}

For more information see: https://prisma-client-py.readthedocs.io/en/stable/reference/limitations/#default-type-limitations

✔ Generated Prisma Client Python (v0.9.1) to ./.venv/lib/python3.8/site-packages/prisma in 342ms

# main.py
import asyncio
from prisma import Prisma

async def main() -> None:
    db = Prisma()
    await db.connect()

    user = await db.user.upsert(**{
        "where": {
            "email": "test1@test.co.jp",
        },
        "data": {
            'create': {
                "email": "test1@test.co.jp",
                "name": "test1",
            },
            "update": {},
        }
    })
    
    print(f"user: {user.json()}")

    await db.disconnect()

if __name__ == '__main__':
    asyncio.run(main())

% python main.py
user: {"id": 1, "email": "test1@test.co.jp", "name": "test1", "posts": null}

% sqlite3 prisma/dev.db
SQLite version 3.37.2 2022-01-06 13:25:41
Enter ".help" for usage hints.
sqlite> select * from User;
1|test1@test.co.jp|test1

generator client_js {
  provider = "prisma-client-js"
}

% poetry run prisma generate
Environment variables loaded from .env
Prisma schema loaded from prisma/schema.prisma

✔ Generated Prisma Client Python (v0.9.1) to ./.venv/lib/python3.8/site-packages/prisma in 330ms

✔ Generated Prisma Client (4.15.0 | library) to ./node_modules/@prisma/client in 118ms
You can now start using Prisma Client in your code. Reference: https://pris.ly/d/client

% tree -a -L 1 node_modules
node_modules
├── .bin
├── .package-lock.json
├── .prisma
├── @prisma
└── prisma

{
  "name": "my-prisma-project",
  "version": "1.0.0",
  "description": "",
  "main": "index.js",
  "scripts": {
    "test": "echo \"Error: no test specified\" && exit 1"
  },
  "keywords": [],
  "author": "",
  "license": "ISC",
  "devDependencies": {
    "prisma": "^4.15.0"
  },
  "dependencies": {
    "@prisma/client": "^4.15.0"
  }
}

npm i -D prisma-dbml-generator

generator dbml {
  provider = "prisma-dbml-generator"
}

% poetry run prisma generate
Environment variables loaded from .env
Prisma schema loaded from prisma/schema.prisma
Error: Generator "prisma-dbml-generator" failed:

/bin/sh: 1: prisma-dbml-generator: not found