Oracle "FROM all_tables WHERE owner = (select user from dual)" query

[Ginden]

Problem:

typeorm-model-generator run following query:

 SELECT 
   NULL AS TABLE_SCHEMA,
   TABLE_NAME
FROM all_tables 
WHERE  owner = (select user from dual)

This returns 0 results for me, because these tables owner's is not equal to current user - these tables are owned by DBA and I'm working with read-only user.

Solution: add option to specify owner(s).

Workaround: hardcode correct value in node_modules/typeorm-model-generator/dist/src/drivers/OracleDriver.js (replace (select user from dual) with 'YOUR_OWNER').

[Ginden]

from user_constraints should be replaced with from all_contraints owner (...) WHERE owner.owner = 'YOUR_OWNER' .

Changes are required throughrough whole file.

[goughjo02]

@Ginden can you please clarify. I am trying to get this package working for an oracle database.

user_constraints is also used in many joins, should we change user_constraints to all_constraints owner (...) where owner.owner = 'YOUR_NAME' in every join also?

Also what should replace the ellipsis inside the parenthesis?

TIA

[goughjo02]

ok I got it working. I had to change four SQL strings in OracleDriver.js. They start at lines 25, 40, 174, and 205.

[liudonghua123]

@goughjo02 Hi, could you provided which files you changed, maybe a pr or diff links will helpful.