trying to connect to postgres w/ next.js

[start]
cmd = 'py -m http.server'

[start]
cmd = 'py -m http.server'

 

#9 DONE 0.2s

 

#10 [stage-0  6/10] RUN --mount=type=cache,id=s/bc3c0308-8834-4245-a622-39de5792aafa-/root/npm,target=/root/.npm npm ci

 

#10 0.666 npm WARN config production Use `--omit=dev` instead.

 

#10 2.004

#10 2.004 added 76 packages, and audited 77 packages in 1s

#10 2.004

#10 2.004 11 packages are looking for funding

#10 2.004   run `npm fund` for details

#10 2.006

#10 2.006 found 0 vulnerabilities

#10 DONE 2.0s

 

#11 [stage-0  7/10] COPY . /app/.

 

#11 DONE 0.3s

 

#12 [stage-0  8/10] RUN --mount=type=cache,id=s/bc3c0308-8834-4245-a622-39de5792aafa-node_modules/cache,target=/app/node_modules/.cache CI=false npm run build

 

#12 0.677 npm

WARN config production Use `--omit=dev` instead.

 

#12 0.890 npm ERR! Missing script: "build"

#12 0.890 npm ERR!

#12 0.890 npm ERR! To see a list of scripts, run:

#12 0.891 npm ERR!   npm run

#12 0.893
#12 0.893 npm ERR! A complete log of this run can be found in: /root/.npm/_logs/2024-01-17T15_50_03_083Z-debug-0.log
#12 ERROR: process "/bin/bash -ol pipefail -c CI=false npm run build" did not complete successfully: exit code: 1
-----
> [stage-0  8/10] RUN --mount=type=cache,id=s/bc3c0308-8834-4245-a622-39de5792aafa-node_modules/cache,target=/app/node_modules/.cache CI=false npm run build:
WARN config production Use `--omit=dev` instead.
0.890 npm ERR! Missing script: "build"
0.890 npm ERR!
0.890 npm ERR! To see a list of scripts, run:
0.891 npm ERR!   npm run
0.893
0.893 npm ERR! A complete log of this run can be found in: /root/.npm/_logs/2024-01-17T15_50_03_083Z-debug-0.log
-----
Dockerfile:24
-------------------
22 |     # build phase
23 |     COPY . /app/.
24 | >>> RUN --mount=type=cache,id=s/bc3c0308-8834-4245-a622-39de5792aafa-node_modules/cache,target=/app/node_modules/.cache CI=false npm run build
25 |
26 |
-------------------
ERROR: failed to solve: process "/bin/bash -ol pipefail -c CI=false npm run build" did not complete successfully: exit code: 1
Error: Docker build failed

 

#9 DONE 0.2s

 

#10 [stage-0  6/10] RUN --mount=type=cache,id=s/bc3c0308-8834-4245-a622-39de5792aafa-/root/npm,target=/root/.npm npm ci

 

#10 0.666 npm WARN config production Use `--omit=dev` instead.

 

#10 2.004

#10 2.004 added 76 packages, and audited 77 packages in 1s

#10 2.004

#10 2.004 11 packages are looking for funding

#10 2.004   run `npm fund` for details

#10 2.006

#10 2.006 found 0 vulnerabilities

#10 DONE 2.0s

 

#11 [stage-0  7/10] COPY . /app/.

 

#11 DONE 0.3s

 

#12 [stage-0  8/10] RUN --mount=type=cache,id=s/bc3c0308-8834-4245-a622-39de5792aafa-node_modules/cache,target=/app/node_modules/.cache CI=false npm run build

 

#12 0.677 npm

WARN config production Use `--omit=dev` instead.

 

#12 0.890 npm ERR! Missing script: "build"

#12 0.890 npm ERR!

#12 0.890 npm ERR! To see a list of scripts, run:

#12 0.891 npm ERR!   npm run

#12 0.893
#12 0.893 npm ERR! A complete log of this run can be found in: /root/.npm/_logs/2024-01-17T15_50_03_083Z-debug-0.log
#12 ERROR: process "/bin/bash -ol pipefail -c CI=false npm run build" did not complete successfully: exit code: 1
-----
> [stage-0  8/10] RUN --mount=type=cache,id=s/bc3c0308-8834-4245-a622-39de5792aafa-node_modules/cache,target=/app/node_modules/.cache CI=false npm run build:
WARN config production Use `--omit=dev` instead.
0.890 npm ERR! Missing script: "build"
0.890 npm ERR!
0.890 npm ERR! To see a list of scripts, run:
0.891 npm ERR!   npm run
0.893
0.893 npm ERR! A complete log of this run can be found in: /root/.npm/_logs/2024-01-17T15_50_03_083Z-debug-0.log
-----
Dockerfile:24
-------------------
22 |     # build phase
23 |     COPY . /app/.
24 | >>> RUN --mount=type=cache,id=s/bc3c0308-8834-4245-a622-39de5792aafa-node_modules/cache,target=/app/node_modules/.cache CI=false npm run build
25 |
26 |
-------------------
ERROR: failed to solve: process "/bin/bash -ol pipefail -c CI=false npm run build" did not complete successfully: exit code: 1
Error: Docker build failed

[phases.setup]
nixPkgs = ['...', 'python3']

[phases.setup]
nixPkgs = ['...', 'python3']

[phases.setup]
nixPkgs = ['...', 'python3']

[start]
cmd = 'python http.server $PORT'
PORT = 8080

[phases.setup]
nixPkgs = ['...', 'python3']

[start]
cmd = 'python http.server $PORT'
PORT = 8080

 
node_modules

 
node_modules

{
  "dependencies": {
    "express.js": "^1.0.0",
    "fs": "^0.0.1-security",
    "mariadb": "^3.2.3",
    "mysql": "^2.18.1"
  }
}

{
  "dependencies": {
    "express.js": "^1.0.0",
    "fs": "^0.0.1-security",
    "mariadb": "^3.2.3",
    "mysql": "^2.18.1"
  }
}

The main field is a module ID that is the primary entry point to your program. That is, if your package is named foo, and a user installs it, and then does require("foo"), then your main module's exports object will be returned.

This should be a module relative to the root of your package folder.

For most modules, it makes the most sense to have a main script and often not much else.

If main is not set, it defaults to index.js in the package's root folder.

The main field is a module ID that is the primary entry point to your program. That is, if your package is named foo, and a user installs it, and then does require("foo"), then your main module's exports object will be returned.

This should be a module relative to the root of your package folder.

For most modules, it makes the most sense to have a main script and often not much else.

If main is not set, it defaults to index.js in the package's root folder.

.
├── backend/
│   └── <node code here>
├── frontend/
│   └── <create react app code here>
└── .gitignore

.
├── backend/
│   └── <node code here>
├── frontend/
│   └── <create react app code here>
└── .gitignore

const express = require("express");
const app = express();

app.get("/", (req, res) => {
  res.send("Hello, World!");
});

const PORT = process.env.PORT || 3001;
app.listen(PORT, () => {
  console.log(`Server running on port ${PORT}`);
});

const express = require("express");
const app = express();

app.get("/", (req, res) => {
  res.send("Hello, World!");
});

const PORT = process.env.PORT || 3001;
app.listen(PORT, () => {
  console.log(`Server running on port ${PORT}`);
});

const { Pool } = require("pg");

// The secret connection string you copied earlier
const connectionString =
  "OOPS";

const pool = new Pool({
  connectionString,
});

module.exports = pool;

const { Pool } = require("pg");

// The secret connection string you copied earlier
const connectionString =
  "OOPS";

const pool = new Pool({
  connectionString,
});

module.exports = pool;

const { Pool } = require("pg");

// The secret connection string you copied earlier
const dbURL = process.env.DATABASE_URL;

const pool = new Pool({
    dbURL,
});

module.exports = pool;

const { Pool } = require("pg");

// The secret connection string you copied earlier
const dbURL = process.env.DATABASE_URL;

const pool = new Pool({
    dbURL,
});

module.exports = pool;

const { Pool } = require("pg");

// The secret connection string you copied earlier
const dbURL = process.env.DATABASE_URL;

const pool = new Pool({
    dbURL,
});

module.exports = pool;

const { Pool } = require("pg");

// The secret connection string you copied earlier
const dbURL = process.env.DATABASE_URL;

const pool = new Pool({
    dbURL,
});

module.exports = pool;

const express = require("express");
const app = express();

app.get("/", (req, res) => {
    res.send("Hello, World!");
});

const PORT = process.env.PORT || 3001;
app.listen(PORT, () => {
    console.log(`Server running on port ${PORT}`);
});

const express = require("express");
const app = express();

app.get("/", (req, res) => {
    res.send("Hello, World!");
});

const PORT = process.env.PORT || 3001;
app.listen(PORT, () => {
    console.log(`Server running on port ${PORT}`);
});

const Pool = require("pg").Pool;
const pool = new Pool({
    user: "my_user",
    host: "localhost",
    database: "my_database",
    password: "root",
    port: 5432,
});

const Pool = require("pg").Pool;
const pool = new Pool({
    user: "my_user",
    host: "localhost",
    database: "my_database",
    password: "root",
    port: 5432,
});

//wordeditor.js
import pool from "./db.js";

const getWords = async() => {
    try {
        return await new Promise(function (resolve, reject) {
          pool.query("SELECT * FROM words_diacritics", (error, results) => {
            if (error) {
              reject(error);
            }
            if (results && results.rows) {
              resolve(results.rows);
            } else {
              reject(new Error("No results found"));
            }
          });
        });
      } catch (error_1) {
        console.error(error_1);
        throw new Error("Internal server error");
      } 
};
//other functions

module.exports = {
    getWords,
    addWord,
    deleteWord,
    updateWord,
};

//wordeditor.js
import pool from "./db.js";

const getWords = async() => {
    try {
        return await new Promise(function (resolve, reject) {
          pool.query("SELECT * FROM words_diacritics", (error, results) => {
            if (error) {
              reject(error);
            }
            if (results && results.rows) {
              resolve(results.rows);
            } else {
              reject(new Error("No results found"));
            }
          });
        });
      } catch (error_1) {
        console.error(error_1);
        throw new Error("Internal server error");
      } 
};
//other functions

module.exports = {
    getWords,
    addWord,
    deleteWord,
    updateWord,
};

app.use(function (req, res, next) {
  res.setHeader("Access-Control-Allow-Origin", "http://localhost:3000");
  res.setHeader("Access-Control-Allow-Methods", "GET,POST,PUT,DELETE,OPTIONS");
  res.setHeader(
    "Access-Control-Allow-Headers",
    "Content-Type, Access-Control-Allow-Headers"
  );
  next();
});

app.use(function (req, res, next) {
  res.setHeader("Access-Control-Allow-Origin", "http://localhost:3000");
  res.setHeader("Access-Control-Allow-Methods", "GET,POST,PUT,DELETE,OPTIONS");
  res.setHeader(
    "Access-Control-Allow-Headers",
    "Content-Type, Access-Control-Allow-Headers"
  );
  next();
});