node.js - I get import error every time I try to separate the api calls from the database - Stack Overflow

admin管理员组

文章数量:1405411

index file in root:

import express from 'express';
import sqlite3 from 'sqlite3';
import { getAllProducts } from './src/controllers/products/getAll';
sqlite3.verbose();

const app = express();
const port = process.env.PORT || 3000;

app.use(express.json());

app.get('/products', getAllProducts);

app.listen(port, () => {
  console.log(`Server listening on port ${port}.`);
});

file db connection:

import sqlite3 from 'sqlite3';
sqlite3.verbose();

export const db = new sqlite3.Database('../../products.db', (err) => {
  if (err) {
    console.error(err.message);
  }
  console.log('Connected to the products database.');
});

and getAllProducts

import { db } from "../../db";

export const getAllProducts = (req, res) => {
    db.all('SELECT * FROM products', (err, rows) => {
      if (err) {
        console.error(err.message);
        res.status(500).send('Internal server error');
      } else {
        res.send(rows);
      }
    }
  };

return error to run node index.ts

node:internal/modules/esm/resolve:275
    throw new ERR_MODULE_NOT_FOUND(
          ^
Error [ERR_MODULE_NOT_FOUND]: Cannot find module 'C:\node-sqlite-typescript\src\controllers\products\getAll' imported from C:\node-sqlite-typescript\index.ts
    at finalizeResolution (node:internal/modules/esm/resolve:275:11)
    at moduleResolve (node:internal/modules/esm/resolve:860:10)
    at defaultResolve (node:internal/modules/esm/resolve:984:11)
    at ModuleLoader.defaultResolve (node:internal/modules/esm/loader:736:12)
    at #cachedDefaultResolve (node:internal/modules/esm/loader:660:25)
    at ModuleLoader.resolve `enter code here`(node:internal/modules/esm/loader:643:38)
    at ModuleLoader.getModuleJobForImport (node:internal/modules/esm/loader:279:38)
    at ModuleJob._link (node:internal/modules/esm/module_job:137:49) {
  code: 'ERR_MODULE_NOT_FOUND',
  url: 'file:///C:/node-sqlite-typescript/src/controllers/products/getAll'
}

本文标签： nodejsI get import error every time I try to separate the api calls from the databaseStack Overflow