Prismaを数ヶ月使ってみた感想

// schema.prisma
model user{
	id      Int    @id @default(autoincrement())
	user_id String @unique
	name    String
}

const client = new PrismaClient();

async function upsertUser(userId: string, name: string): Promise<void> {
  try {
    await client.user.upsert({
      where: {
        user_id: userId,
      },
      create: {
        user_id: userId,
        name: name,
      },
      udpate: {
        name: name,
      },
    });
  } catch (err) {
    console.error(err);
  }
}

await Promise.all([
  upsertUser("user-1", "foga"),
  upsertUser("user-2", "hoge"),
  upsertUser("user-2", "hoge"),
  upsertUser("user-1", "foga"),
]);

{"message":"ERROR: \"prisma error occurred, prisma error code: P2002\"","severity":"ERROR","stack":"Error: \nInvalid `prisma.user.upsert()` invocation:\n\n\n  Unique constraint failed on the field: `user_id`\n    at Object.request (/Users/my_dir/node_modules/@prisma/client/runtime/index.js:39809:15)\n    at DatasourceClient._request (/Users/my_dir/node_modules/@prisma/client/runtime/index.js:40637:18)\n    at UserDatasource.upsertUser (/Users/my_dir/webpack:/hogehoge)","timestamp":"2022-08-25T00:20:52.201Z"}
{"message":"ERROR: \"prisma error occurred, prisma error code: P2002\"","severity":"ERROR","stack":"Error: \nInvalid `prisma.user.upsert()` invocation:\n\n\n  Unique constraint failed on the field: `user_id`\n    at Object.request (/Users/my_dir/node_modules/@prisma/client/runtime/index.js:39809:15)\n    at DatasourceClient._request (/Users/my_dir/node_modules/@prisma/client/runtime/index.js:40637:18)\n    at UserDatasource.upsertUser (/Users/my_dir/webpack:/hogehoge)","timestamp":"2022-08-25T00:20:52.219Z"}

async function upsertUser(
  userId: string,
  name: string,
  retryCounter = 3
): Promise<void> {
  try {
    await client.user.upsert({
      where: {
        user_id: userId,
      },
      create: {
        user_id: userId,
        name: name,
      },
      udpate: {
        name: name,
      },
    });
  } catch (err) {
    if (retryCounter > 0) {
      retryCounter--;
      upsertUser(userId, name, retryCounter);
    }
    console.error(err);
  }
}

// Before
enum place {
  INDOOR
}
model activity {
...
  place place @default(INDOOR)
...
}

// After
enum place {
  INDOOR
	OUTDOOR
}
model activity {
...
  place place @default(OUTDOOR)
...
}

Error: P3018

A migration failed to apply. New migrations cannot be applied before the error is recovered from. Read more about how to resolve migration issues in a production database: https://pris.ly/d/migrate-resolve

Migration name: 20220825080309_add_new_place

Database error code: 55P04

Database error:
ERROR: unsafe use of new value "OUTDOOR" of enum type "place"
HINT: New enum values must be committed before they can be used.

DbError { severity: "ERROR", parsed_severity: Some(Error), code: SqlState("55P04"), message: "unsafe use of new value \"OUTDOOR\" of enum type \"place\"", detail: None, hint: Some("New enum values must be committed before they can be used."), position: None, where_: None, schema: None, table: None, column: None, datatype: None, constraint: None, file: Some("enum.c"), line: Some(103), routine: Some("check_safe_enum_use") }

// Before
enum place {
  INDOOR
}
model activity {
...
  place place @default(INDOOR)
...
}

// After(１回目のmigrationを行う)
enum place {
  INDOOR
	OUTDOOR
}
model activity {
...
  place place @default(INDOOR)
...
}

// After(２回目のmigrationを行う)
enum place {
  INDOOR
	OUTDOOR
}
model activity {
...
  place place @default(OUTDOOR)
...
}

warn(prisma-client) Already 10 Prisma Clients are actively running.

export class Client extends PrismaClient {
  private static _instance: PrismaClient;

  private constructor() {
    super();
  }

  static getInstance() {
    if (!Client._instance) {
      QueryService._instance = new QueryService();
    }
    return QueryService._instance;
  }
}

// schema.prisma
model product {
	parts    String[]
}

// product.parts sample record
parts: ['AAA-1000', 'AAA-2000', 'ABC-1000', 'DEF-1000']