prisma

import asyncio import os from prisma import Prisma # --- First, define your schema in a file named `schema.prisma` --- # datasource db { # provider = "sqlite" # url = "file:./dev.db" # } # # generator client { # provider = "prisma-client-py" # interface = "asyncio" # or "sync" # } # # model User { # id Int @id @default(autoincrement()) # email String @unique # name String? # } # ------------------------------------------------------------------ # --- Second, run `prisma db push` in your terminal to generate the client and apply schema --- # You might need to set DATABASE_URL environment variable if using a remote DB # os.environ['DATABASE_URL'] = os.environ.get('DATABASE_URL', 'sqlite:///dev.db') # Run: `prisma db push` # --- Third, use the generated client in your Python code --- async def main(): db = Prisma() await db.connect() # Create a user user = await db.user.create( data={ 'email': 'test@example.com', 'name': 'Test User' } ) print(f"Created user: {user.email}") # Find the user found_user = await db.user.find_unique( where={'email': 'test@example.com'} ) if found_user: print(f"Found user: {found_user.name}") else: print("User not found.") await db.disconnect() if __name__ == '__main__': # Example of setting DATABASE_URL if you're not using file:./dev.db in schema # os.environ['DATABASE_URL'] = os.environ.get('DATABASE_URL', 'sqlite:///dev.db') asyncio.run(main())