The requested module './modules/data.js' does not provide an export named 'default'
Выдает ошибку, пытаюсь перейти на ECMAScript и делать импорт модулей через import, а не require, но что-то пошло не так и я не понимаю, что именно, помогите пожалуйста.
import mysql from "mysql2"
import mysqlPromise from "mysql2/promise"
import pg from 'pg'
var connection, connectionPromise
function setDataConnection(type, host, port, database, user, password) {
if (type == "mysql") {
connection = mysql.createPool({
host: host || "127.0.0.1",
port: port || 3306,
database: database,
user: user || "root",
password: password || ""
})
connectionPromise = mysqlPromise.createPool({
connectionLimit: 15,
host: host || "127.0.0.1",
port: port || 3306,
database: database,
user: user || "root",
password: password || ""
})
console.log("[MySQL] База данных подключена!")
}
else {
connection = new pg({
host: host || 'localhost',
port: port || 5432,
user: user || 'postgres',
password: password || 'postgres',
});
console.log("[PostgreSQL] База данных подключена!")
}
}
exports.setDataConnection = setDataConnection;
async function tableExists(pool, tableName) {
try {
const query = `SELECT 1 FROM ${tableName} LIMIT 1;`;
await pool.execute(query);
return true;
} catch (err) {
return false;
}
}
var query = async function (sql) {
try {
//? output to the console the query value
let rows = await connectionPromise.execute(
sql,
);
return rows[0]
} catch (error) {
console.log(error);
}
}
exports.query = query
var querySet = async function (sql) {
try {
//? output to the console the query value
let rows = await connectionPromise.execute(
sql,
);
return console.log("Data added succesfully!")
} catch (error) {
console.log(error);
}
}
exports.querySet = querySet

