Build a Simple CRUD Node.js App with CockroachDB and Prisma

const { PrismaClient } = require('@prisma/client')
const { v4: uuidv4 } = require('uuid')

const prisma = new PrismaClient({
  datasources: {
    db: {
      url: process.env.DATABASE_URL + "&application_name=$ docs_simplecrud_node-prisma",
    },
  },
})

const main = async () => {
  const customerIds = Array(10).fill().map(() => ({ id: uuidv4() }))
  const accountValues = Array(10).fill().map((_, index) => ({
    id: uuidv4(),
    customer_id: customerIds[index].id,
    balance: Math.floor(Math.random() * 1000)
  }))

  const insertCustomerRows = await prisma.customer.createMany({
    data: customerIds
  })

  console.log('Customer rows inserted.', insertCustomerRows)

  const insertAccountRows = await prisma.account.createMany({
    data: accountValues
  })

  console.log('Account rows inserted.', insertAccountRows)
  console.log('Initial Account row values:\n', await prisma.account.findMany())

  const updateRows = await prisma.account.updateMany({
    where: {
      balance: {
        gt: 100
      }
    },
    data: {
      balance: {
        decrement: 5
      }
    }
  })

  console.log('Account rows updated.', updateRows)
  console.log('Updated Account row values:\n', await prisma.account.findMany())

  const deleteAllRows = await prisma.customer.deleteMany()

  console.log('All Customer rows deleted.', deleteAllRows)
}

main()
  .catch((e) => {
    throw e
  })
  .finally(async () => {
    await prisma.$disconnect()
  })

$ node index.js

Customer rows inserted. { count: 10 }
Account rows inserted. { count: 10 }
Initial Account row values:
 [
  {
    id: '1961432f-f93e-4568-b2a5-ba08f73afde5',
    customer_id: '079daee3-ecf2-4a0f-980b-4c3ea4c8b6a3',
    balance: 914n
  },
  {
    id: '4ccd7eea-eb47-4aa9-9819-30b5aae58bf8',
    customer_id: 'c0eeb465-ab60-4f02-9bf3-3451578d400d',
    balance: 176n
  },
  {
    id: '53ed4f7d-72ee-4390-9487-9bf318357c77',
    customer_id: 'a4c9e26e-f9d8-4c1b-ac20-1aa8611b134f',
    balance: 54n
  },
  {
    id: '79a1f1b2-4050-4329-bf52-5df53fec749e',
    customer_id: '392c7d15-5ab2-4149-9eee-8a3a44b36e9d',
    balance: 482n
  },
  {
    id: '7e30f1e0-e873-4565-9ea3-3079a48a4886',
    customer_id: '12cb3406-264a-417c-b0e6-86593e60dc18',
    balance: 478n
  },
  {
    id: '94f461d5-3985-46c1-98f4-1896f15f0a16',
    customer_id: 'e4c909a4-6683-429d-9831-dfcf792f4fb0',
    balance: 240n
  },
  {
    id: 'a0c081f5-fb15-47cc-8dbb-85c6f15677d2',
    customer_id: '91ece5f2-df03-4023-b112-2b4d5677981b',
    balance: 520n
  },
  {
    id: 'a45b7c41-2f62-4620-be69-57d5d61186e4',
    customer_id: 'c1824327-d6a1-4916-a666-ea157ef2a409',
    balance: 50n
  },
  {
    id: 'dbe0dec5-257b-42ff-9d36-1b5a57e1a4ac',
    customer_id: '6739eb2f-bcb1-4074-aab4-5860b04d227d',
    balance: 468n
  },
  {
    id: 'ebc520b4-8df0-4e2f-8426-104594f6341c',
    customer_id: 'f83e02cb-77cf-4347-9e0c-28cad65fac34',
    balance: 336n
  }
]
Account rows updated. { count: 8 }
Updated Account row values:
 [
  {
    id: '1961432f-f93e-4568-b2a5-ba08f73afde5',
    customer_id: '079daee3-ecf2-4a0f-980b-4c3ea4c8b6a3',
    balance: 909n
  },
  {
    id: '4ccd7eea-eb47-4aa9-9819-30b5aae58bf8',
    customer_id: 'c0eeb465-ab60-4f02-9bf3-3451578d400d',
    balance: 171n
  },
  {
    id: '53ed4f7d-72ee-4390-9487-9bf318357c77',
    customer_id: 'a4c9e26e-f9d8-4c1b-ac20-1aa8611b134f',
    balance: 54n
  },
  {
    id: '79a1f1b2-4050-4329-bf52-5df53fec749e',
    customer_id: '392c7d15-5ab2-4149-9eee-8a3a44b36e9d',
    balance: 477n
  },
  {
    id: '7e30f1e0-e873-4565-9ea3-3079a48a4886',
    customer_id: '12cb3406-264a-417c-b0e6-86593e60dc18',
    balance: 473n
  },
  {
    id: '94f461d5-3985-46c1-98f4-1896f15f0a16',
    customer_id: 'e4c909a4-6683-429d-9831-dfcf792f4fb0',
    balance: 235n
  },
  {
    id: 'a0c081f5-fb15-47cc-8dbb-85c6f15677d2',
    customer_id: '91ece5f2-df03-4023-b112-2b4d5677981b',
    balance: 515n
  },
  {
    id: 'a45b7c41-2f62-4620-be69-57d5d61186e4',
    customer_id: 'c1824327-d6a1-4916-a666-ea157ef2a409',
    balance: 50n
  },
  {
    id: 'dbe0dec5-257b-42ff-9d36-1b5a57e1a4ac',
    customer_id: '6739eb2f-bcb1-4074-aab4-5860b04d227d',
    balance: 463n
  },
  {
    id: 'ebc520b4-8df0-4e2f-8426-104594f6341c',
    customer_id: 'f83e02cb-77cf-4347-9e0c-28cad65fac34',
    balance: 331n
  }
]
All Customer rows deleted. { count: 10 }