NextJS connect to My SQL db connection wrapper

gistfile1.txt

import mysql from "mysql2/promise";

export async function query({ query, values = [] }) {
  // PlanetScale;
  const dbconnection = await mysql.createConnection(
    process.env.MYSQL_DATABASE_URL
  );

  //Digital ocean ubuntu
  // const dbconnection = await mysql.createConnection({
  //   host: process.env.MYSQL_HOST,
  //   database: process.env.MYSQL_DATABASE,
  //   user: process.env.MYSQL_USER,
  //   password: process.env.MYSQL_PASSWORD,
  // });

  try {
    const [results] = await dbconnection.execute(query, values);
    dbconnection.end();
    return results;
  } catch (error) {
    throw Error(error.message);
    return { error };
  }
}


//in a separate node js file you can use this wrapper like this:
  // const productName = req.body.product_name;
    // const addProducts = await query({
    //   query: "INSERT INTO products (product_name) VALUES (?)",
    //   values: [productName],
    // });

big thanks!