Critical error! Wrong SQL syntax on cascade insert about typeorm HOT 9 CLOSED

oh looks like you are building latest typeorm on your own. nice! Looks like this issue is only in the latest version. Thanks for finding it!

I have fixed it, please check.

Maybe it should insert entities in reverse order - user, category, product - which reduce update sql querys.

Regarding this, yes I know about redundant update queries, but they are simplify persist mechanism which is very very complicated. In the future I'll think how to reduce them, and this is totally needed, but for now its not a priority.

from typeorm.

I have fixed it, please check.

Now works ok, thanks for quick fix :)

oh looks like you are building latest typeorm on your own. nice!

I had to because the version from npm is outdated and even doesn't match with docs - missing @PrimaryGeneratedColumn(), etc. It took me some time to get rid of tsc error but now i can only git pull, tsc and copy \build\es5\src\ to node_modules\typeorm folder (remembering of typeorm dependencies).

There's also a problem with typings - you use npm @types for node.js typings, I had it already installed via typings and I had duplicated error on compile. But I think it's not your fault, typings now have inconsistent repositories and we have duplicated typings 😢

from typeorm.

Right now build process looks like this:

• pull latest commits
• run npm i
• remove node_modules/@types/chai and node_modules/@types/chai-as-promised directories
• run gulp package
• it will generate you are publish-ready package in ./build/package
• copy ./build/package into your own node_modules/typeorm

from typeorm.

The gulp package had error during compile:

e:\#Programowanie\#GitHub\typeorm\node_modules\ts-node\src\index.ts:253
          throw new TSError(diagnosticList)
                ^
TSError: ⨯ Unable to compile TypeScript
gulpfile.ts (3,14): Cannot find name 'require'. (2304)
gulpfile.ts (4,13): Cannot find name 'require'. (2304)
gulpfile.ts (5,15): Cannot find name 'require'. (2304)
gulpfile.ts (6,17): Cannot find name 'require'. (2304)
gulpfile.ts (7,15): Cannot find name 'require'. (2304)
gulpfile.ts (8,14): Cannot find name 'require'. (2304)
gulpfile.ts (9,16): Cannot find name 'require'. (2304)
gulpfile.ts (10,17): Cannot find name 'require'. (2304)
gulpfile.ts (11,12): Cannot find name 'require'. (2304)
gulpfile.ts (12,20): Cannot find name 'require'. (2304)
gulpfile.ts (13,18): Cannot find name 'require'. (2304)
gulpfile.ts (14,23): Cannot find name 'require'. (2304)
gulpfile.ts (60,75): Cannot find name 'require'. (2304)
gulpfile.ts (178,18): Cannot find name 'require'. (2304)
gulpfile.ts (179,18): Cannot find name 'require'. (2304)

There was missing node typings, I had to install it. I don't know why it didn't use the @types/node.

from typeorm.

can you try install ts-node globally?

from typeorm.

It didn't help. The ts-node works, there're just missing node.d.ts - it doesn't look for in node_modules/@types/node only typings folder.

The newest version can't compile:

e:\#Programowanie\#GitHub\typeorm\node_modules\oracledb\src\dpi\src\dpiEnvImpl.h(30): fatal error C1083: Cannot open in
clude file: 'oci.h': No such file or directory (compiling source file ..\src\dpi\src\dpiEnv.cpp) [e:\#Programowanie\#Gi
tHub\typeorm\node_modules\oracledb\build\oracledb.vcxproj]

There are many more this type of missing file errors.

from typeorm.

Maybe updating typescript globally can help? Regarding oracle errors you need to follow oracle instractions how to install their driver. Or its easier to you to exclude oracle driver from package json and re-run installation since you don't need it

from typeorm.

I just have to typings i dt~node --global and all is ok 😉
Removing unnecessary drivers helped, thanks.

from typeorm.

0.0.2-alpha.63 is released

from typeorm.