import { createPool } from 'mysql2/promise'
import { FunctionName } from './index'
import { successData } from './_data/successData'
import { failData } from './_data/failData'
import { PrismaClient } from '../../../CoreHelpers/Jest/@Prisma'

// Start Prisma & SQL requirements
// So Prisma & SQL pools are closed for each test and dont max out connections
const prisma = new PrismaClient()
const pool = createPool({
  host: process.env.DB_HOSTNAME,
  user: process.env.DB_USER,
  password: process.env.DB_PASSWORD,
  database: process.env.DB_NAME,
  connectionLimit: 5,
})
const db = { prisma, pool }

afterAll(async () => {
  expect(pool).toBeTruthy()
  await pool.end()
  await prisma.$disconnect()
})
// End Prisma & SQL requirements

//
it('Should be successful - FunctionName Basic Test', async () => {
  const { success, data } = await FunctionName({ key: 'testingOnlyFAIL' }, db)
  expect(success).toBeTruthy()
  expect(data).toEqual(successData)
})

it('Should fail - FunctionName Basic Test', async () => {
  // @ts-expect-error
  const test = await FunctionName()
  expect(test.success).toBeFalsy()
  expect(test).toEqual(failData)
})