search

mike-works / sql-fundamentals

Mike North's SQL Fundamentals and Professional SQL Courses
https://frontendmasters.com/courses/sql-fundamentals/
BSD 3-Clause "New" or "Revised" License
169 stars 108 forks source link

cant run tests..... #300

Open gjames5355 opened 4 years ago

gjames5355 commented 4 years ago

Git Branch: master Test Filter: EX00 Applying Test Filter: EX00 /Users/garrettjames/Desktop/thinkful-projects/sql/node_modules/pg-packet-stream/src/inbound-parser.test.ts:1 import buffers from './testing/test-buffers' ^^^^^^^

SyntaxError: Unexpected identifier at Module._compile (internal/modules/cjs/loader.js:723:23) at Module._extensions..js (internal/modules/cjs/loader.js:789:10) at Object.require.extensions.(anonymous function) [as .ts] (/Users/garrettjames/Desktop/thinkful-projects/sql/node_modules/ts-node/src/index.ts:392:14) at Module.load (internal/modules/cjs/loader.js:653:32) at tryModuleLoad (internal/modules/cjs/loader.js:593:12) at Function.Module._load (internal/modules/cjs/loader.js:585:3) at Module.require (internal/modules/cjs/loader.js:692:17) at require (internal/modules/cjs/helpers.js:25:18) at /Users/garrettjames/Desktop/thinkful-projects/sql/node_modules/mocha/lib/mocha.js:334:36 at Array.forEach () at Mocha.loadFiles (/Users/garrettjames/Desktop/thinkful-projects/sql/node_modules/mocha/lib/mocha.js:331:14) at Mocha.run (/Users/garrettjames/Desktop/thinkful-projects/sql/node_modules/mocha/lib/mocha.js:809:10) at Object.exports.singleRun (/Users/garrettjames/Desktop/thinkful-projects/sql/node_modules/mocha/lib/cli/run-helpers.js:108:16) at exports.runMocha (/Users/garrettjames/Desktop/thinkful-projects/sql/node_modules/mocha/lib/cli/run-helpers.js:142:13) at Object.exports.handler.argv [as handler] (/Users/garrettjames/Desktop/thinkful-projects/sql/node_modules/mocha/lib/cli/run.js:292:3) at Object.runCommand (/Users/garrettjames/Desktop/thinkful-projects/sql/node_modules/mocha/node_modules/yargs/lib/command.js:242:26) at Object.parseArgs [as _parseArgs] (/Users/garrettjames/Desktop/thinkful-projects/sql/node_modules/mocha/node_modules/yargs/yargs.js:1096:28) at Object.parse (/Users/garrettjames/Desktop/thinkful-projects/sql/node_modules/mocha/node_modules/yargs/yargs.js:575:25) at Object.exports.main (/Users/garrettjames/Desktop/thinkful-projects/sql/node_modules/mocha/lib/cli/cli.js:68:6) at Object. (/Users/garrettjames/Desktop/thinkful-projects/sql/node_modules/mocha/bin/mocha:162:29) at Module._compile (internal/modules/cjs/loader.js:778:30) at Object.Module._extensions..js (internal/modules/cjs/loader.js:789:10) at Module.load (internal/modules/cjs/loader.js:653:32) at tryModuleLoad (internal/modules/cjs/loader.js:593:12) at Function.Module._load (internal/modules/cjs/loader.js:585:3) at Function.Module.runMain (internal/modules/cjs/loader.js:831:12) at startup (internal/bootstrap/node.js:283:19) at bootstrapNodeJSCore (internal/bootstrap/node.js:623:3) npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! @mikeworks/sql-fundamentals@0.0.0-development test: scripty "EX00" npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the @mikeworks/sql-fundamentals@0.0.0-development test script. npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in: npm ERR! /Users/garrettjames/.npm/_logs/2020-05-14T16_30_06_295Z-debug.log

IamRKG commented 4 years ago

@mike-north I think version compatible issue.

ianlavapiez commented 4 years ago

Same issue here. Did anyone find a solution out of this?

IamRKG commented 4 years ago

No.

namiduru commented 4 years ago

I have faced the same issue. The problem could be happening from the DB version - DB driver match or node version.

namiduru commented 4 years ago

Guys try to install with npm install --no-optional if you have only SQLite in your system

If you don't have all DB systems mentioned in the course it throws that error.

Code is now working properly in my system with the following versions SQLite 3.28.0 Node Version is: v12.14.1

IamRKG commented 4 years ago

is this working without --no-optional?

juanmarin97 commented 4 years ago

Guys try to install with npm install --no-optional if you have only SQLite in your system

If you don't have all DB systems mentioned in the course it throws that error.

Code is now working properly in my system with the following versions SQLite 3.28.0 Node Version is: v12.14.1

It works do rm -rf node_modules/ and later npm install --no-optional

Wennlys commented 4 years ago

Guys try to install with npm install --no-optional if you have only SQLite in your system

If you don't have all DB systems mentioned in the course it throws that error.

Code is now working properly in my system with the following versions SQLite 3.28.0 Node Version is: v12.14.1

I'm getting the same issue and it didn't work. :( I already tried to change node's vesion, dababase version and so on... Does anyone have any other shot?

juanmarin97 commented 4 years ago

Guys try to install with npm install --no-optional if you have only SQLite in your system If you don't have all DB systems mentioned in the course it throws that error. Code is now working properly in my system with the following versions SQLite 3.28.0 Node Version is: v12.14.1

I'm getting the same issue and it didn't work. :( I already tried to change node's vesion, dababase version and so on... Does anyone have any other shot?

In command line do 

rm -rf node_modules/ 
npm install --no-optional
mgpeters commented 4 years ago

Anyway to make this work with psql?

sunteago commented 4 years ago

having same problem with mysql, npm install --no-optional seems to make tests work, but breaks the app

ericArbour commented 3 years ago

I was on node v14 and was getting esm build errors. I was able to get the app and the tests to run with the following:

SQLite 3.28.0 Node Version is: v12.14.1

If you previously did an npm install:

rm -rf node_modules/ 
npm install --no-optional

Note, I was only able to get this to work with sqlite.

bananaspy commented 3 years ago

is this working without --no-optional?

After setting up all databases try to checkout tag v1.0.21 using Node v9.11.2 - it worked for me without --no-optional

halian-vilela commented 3 years ago

is this working without --no-optional?

After setting up all databases try to checkout tag v1.0.21 using Node v9.11.2 - it worked for me without --no-optional

Node 9 seems so ancient...

I'm wondering if this app aged so badly that it wouldn't be compatible kind of 2 years later.

BTW, I've tried this combination and did no good, the error message just changed a little bit:

(function (exports, require, module, __filename, __dirname) { import buffers from './testing/test-buffers'
                                                              ^^^^^^

SyntaxError: Unexpected token import
    at new Script (vm.js:51:7)
    at createScript (vm.js:136:10)
    at Object.runInThisContext (vm.js:197:10)
    at Module._compile (internal/modules/cjs/loader.js:618:28)
    at Module._extensions..js (internal/modules/cjs/loader.js:665:10)
    at Object.require.extensions.(anonymous function) [as .ts] (/Users/aurus/--Cursos/FrontEndMasters/sql/node_modules/ts-node/src/index.ts:392:14)
    at Module.load (internal/modules/cjs/loader.js:566:32)
    at tryModuleLoad (internal/modules/cjs/loader.js:506:12)
    at Function.Module._load (internal/modules/cjs/loader.js:498:3)
    at Module.require (internal/modules/cjs/loader.js:598:17)
    at require (internal/modules/cjs/helpers.js:11:18)
    at /Users/aurus/--Cursos/FrontEndMasters/sql/node_modules/mocha/lib/mocha.js:334:36
    at Array.forEach (<anonymous>)
    at Mocha.loadFiles (/Users/aurus/--Cursos/FrontEndMasters/sql/node_modules/mocha/lib/mocha.js:331:14)
    at Mocha.run (/Users/aurus/--Cursos/FrontEndMasters/sql/node_modules/mocha/lib/mocha.js:809:10)
    at Object.exports.singleRun (/Users/aurus/--Cursos/FrontEndMasters/sql/node_modules/mocha/lib/cli/run-helpers.js:108:16)
    at exports.runMocha (/Users/aurus/--Cursos/FrontEndMasters/sql/node_modules/mocha/lib/cli/run-helpers.js:142:13)
    at Object.exports.handler.argv [as handler] (/Users/aurus/--Cursos/FrontEndMasters/sql/node_modules/mocha/lib/cli/run.js:292:3)
    at Object.runCommand (/Users/aurus/--Cursos/FrontEndMasters/sql/node_modules/mocha/node_modules/yargs/lib/command.js:242:26)
    at Object.parseArgs [as _parseArgs] (/Users/aurus/--Cursos/FrontEndMasters/sql/node_modules/mocha/node_modules/yargs/yargs.js:1096:28)
    at Object.parse (/Users/aurus/--Cursos/FrontEndMasters/sql/node_modules/mocha/node_modules/yargs/yargs.js:575:25)
    at Object.exports.main (/Users/aurus/--Cursos/FrontEndMasters/sql/node_modules/mocha/lib/cli/cli.js:68:6)
    at Object.<anonymous> (/Users/aurus/--Cursos/FrontEndMasters/sql/node_modules/mocha/bin/mocha:162:29)
    at Module._compile (internal/modules/cjs/loader.js:654:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:665:10)
    at Module.load (internal/modules/cjs/loader.js:566:32)
    at tryModuleLoad (internal/modules/cjs/loader.js:506:12)
    at Function.Module._load (internal/modules/cjs/loader.js:498:3)
    at Function.Module.runMain (internal/modules/cjs/loader.js:695:10)
    at startup (internal/bootstrap/node.js:201:19)
    at bootstrapNodeJSCore (internal/bootstrap/node.js:516:3)
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! @mikeworks/sql-fundamentals@0.0.0-development test: `scripty "EX00"`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the @mikeworks/sql-fundamentals@0.0.0-development test script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

My stack is:

$ git status
HEAD detached at v1.0.21
$ node -v
v9.11.2

Does anyone have another idea?

christian-bravo7 commented 3 years ago

It works for me

$ git branch
On branch femasters/begin

$ node -v
v9.11.1

during the installation with npm I had the following error.

Error 
npm ERR! code E404
npm ERR! 404 Not Found - GET https://registry.npmjs.org/@types/node/-/node-9.4.3.tgz
npm ERR! 404
npm ERR! 404  '@types/node@9.4.3' is not in the npm registry.
npm ERR! 404 You should bug the author to publish it (or use the name yourself!)
npm ERR! 404 It was specified as a dependency of '@types/fs-extra'
npm ERR! 404
npm ERR! 404 Note that you can also install from a
npm ERR! 404 tarball, folder, http url, or git url.

npm ERR! A complete log of this run can be found in:
npm ERR!     /home/christian/.npm/_logs/2020-12-28T21_23_26_121Z-debug.log

And it is because the @types/node version 9.4.3 is not found in the npm registry

Not found: https://registry.npmjs.org/@types/node/-/node-9.4.3.tgz

then I fix with the following...

Into package.lock.json change all references of @types/node with version 9.4.3 to 9.4.4. Including other dependencies that require that version (Make sure to add the correct integrity checksum for 9.4.4)

Example 
{
     "@types/node": {
      "version": "9.4.4",
      "resolved": "https://registry.npmjs.org/@types/node/-/node-9.4.4.tgz",
      "integrity": "sha512-pTi6f79uELOTQ2TtXxWcjmJ+iZa1C3ypm6pGNU/viOQX/VfBXLmsZEcJPk1rm+lia+GP6GpgFGUkCvLJ7JOKDA==",
      "dev": true
    },
    "other-dependency": {
      "version": "...",
      "resolved": "...",
      "integrity": "...",
      "dev": true,
      "requires": {
        "@types/node": "9.4.4",
      }
    }
}

Run 

npm install --no-optional