{"_id":"@credenceanalytics/import-oracledb-schema","_rev":"10-6d850202b4063ce66f615a69340ee601","name":"@credenceanalytics/import-oracledb-schema","dist-tags":{"latest":"1.0.5"},"versions":{"1.0.0":{"name":"@credenceanalytics/import-oracledb-schema","version":"1.0.0","keywords":["parse","parser","oracle","oracledb","sql","ddl","json","schema","jsonschema","convert","converter","import","importer","sync"],"author":{"name":"jiteshsuthar@credenceanalytics.com"},"license":"ISC","_id":"@credenceanalytics/import-oracledb-schema@1.0.0","maintainers":[{"name":"jiteshsuthar","email":"jiteshsuthar@credenceanalytics.com"},{"name":"atulknowsme","email":"atulpal@credenceanalytics.com"},{"name":"shruti_shende","email":"shrutishende@credenceanalytics.com"},{"name":"sonalnadkar","email":"sonalnadkar@credenceanalytics.com"},{"name":"cred-shubham","email":"shubhamyadav@credenceanalytics.com"},{"name":"sagarf","email":"sagarfernandes@credenceanalytics.com"},{"name":"prajaktacred","email":"prajaktashinde@credenceanalytics.com"},{"name":"mandakadam","email":"mandakadam@credenceanalytics.com"},{"name":"prabhuvikas","email":"vikasprabhu@credenceanalytics.com"},{"name":"jimmyjammerx","email":"pratiksatardekar@credenceanalytics.com"},{"name":"suraj_chavan","email":"surajchavan@credenceanalytics.com"},{"name":"mohinim18","email":"mohinimemane@credenceanalytics.com"}],"dist":{"shasum":"23c260818e5274bbb13c41a359591f5c4141e75b","tarball":"https://registry.npmjs.org/@credenceanalytics/import-oracledb-schema/-/import-oracledb-schema-1.0.0.tgz","fileCount":5,"integrity":"sha512-PX6GvqxyAI07AGdHgJHqtuiwSUctnb4s6Hgjpns5RSzKj7iXtaWVpxCG3vVTrRTf0Ce3EAKyf6aAK5UU0EoceQ==","signatures":[{"sig":"MEUCIBAP+4o6vqziQrzUD2ZR0AZ3Ua/KSV0oPdZT8oSm56IUAiEA2gLCrAdQe9u+65YW69BhrSqUI/zQWH7B7d/Qwm0Isc0=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":19356},"main":"index.js","gitHead":"49bec593c9066cb6434b222320264bfeca8e279b","scripts":{"dev":"node my-dev-run.js","test":"jest"},"_npmUser":{"name":"jiteshsuthar","email":"jiteshsuthar@credenceanalytics.com"},"repository":{"url":"https://gitlab.credenceanalytics.com/frameworks-and-tools/db-in-git/import-oracledb-schema","type":"git"},"_npmVersion":"6.14.13","description":"Import Schema to Oracle Database","directories":{"test":"test"},"_nodeVersion":"14.17.3","dependencies":{"oracledb":"^6.2.0"},"_hasShrinkwrap":false,"devDependencies":{"jest":"^29.7.0","jest-html-reporter":"^3.10.2"},"_npmOperationalInternal":{"tmp":"tmp/import-oracledb-schema_1.0.0_1703532771692_0.7064187869863741","host":"s3://npm-registry-packages"}},"1.0.1":{"name":"@credenceanalytics/import-oracledb-schema","version":"1.0.1","keywords":["parse","parser","oracle","oracledb","sql","ddl","json","schema","jsonschema","convert","converter","import","importer","sync"],"author":{"name":"jiteshsuthar@credenceanalytics.com"},"license":"ISC","_id":"@credenceanalytics/import-oracledb-schema@1.0.1","maintainers":[{"name":"jiteshsuthar","email":"jiteshsuthar@credenceanalytics.com"},{"name":"atulknowsme","email":"atulpal@credenceanalytics.com"},{"name":"shruti_shende","email":"shrutishende@credenceanalytics.com"},{"name":"sonalnadkar","email":"sonalnadkar@credenceanalytics.com"},{"name":"cred-shubham","email":"shubhamyadav@credenceanalytics.com"},{"name":"sagarf","email":"sagarfernandes@credenceanalytics.com"},{"name":"prajaktacred","email":"prajaktashinde@credenceanalytics.com"},{"name":"mandakadam","email":"mandakadam@credenceanalytics.com"},{"name":"prabhuvikas","email":"vikasprabhu@credenceanalytics.com"},{"name":"jimmyjammerx","email":"pratiksatardekar@credenceanalytics.com"},{"name":"suraj_chavan","email":"surajchavan@credenceanalytics.com"},{"name":"mohinim18","email":"mohinimemane@credenceanalytics.com"}],"dist":{"shasum":"3723217d955f8bebe7139fcb624ea787cf910761","tarball":"https://registry.npmjs.org/@credenceanalytics/import-oracledb-schema/-/import-oracledb-schema-1.0.1.tgz","fileCount":5,"integrity":"sha512-j5TLC7pMtS8zH3tSi/DvPjcf02rBjjhR+M65m3R2ETBsElI5DIh2TDU5BaP+n8Q12BJqDfXhynONrHQA7NTwhw==","signatures":[{"sig":"MEUCIDFSODoQOnNNtcwMh1vkIbCHzp/3zNRJInIGuU0iBF9iAiEAt3/4QWZajOHvd5FeYTr9C3601vYsT4JnL2S7FE9YXzA=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":19370},"main":"index.js","gitHead":"e5ebf3ddfcd7c9fedfe27c9ed2fe109b2cde3a95","scripts":{"dev":"node my-dev-run.js","test":"jest"},"_npmUser":{"name":"jiteshsuthar","email":"jiteshsuthar@credenceanalytics.com"},"repository":{"url":"https://gitlab.credenceanalytics.com/frameworks-and-tools/db-in-git/import-oracledb-schema","type":"git"},"_npmVersion":"6.14.13","description":"Import Schema to Oracle Database","directories":{"test":"test"},"_nodeVersion":"14.17.3","dependencies":{"oracledb":"^6.2.0"},"_hasShrinkwrap":false,"devDependencies":{"jest":"^29.7.0","jest-html-reporter":"^3.10.2"},"_npmOperationalInternal":{"tmp":"tmp/import-oracledb-schema_1.0.1_1703655117825_0.48994034981549883","host":"s3://npm-registry-packages"}},"1.0.2":{"name":"@credenceanalytics/import-oracledb-schema","version":"1.0.2","keywords":["parse","parser","oracle","oracledb","sql","ddl","json","schema","jsonschema","convert","converter","import","importer","sync"],"author":{"name":"jiteshsuthar@credenceanalytics.com"},"license":"ISC","_id":"@credenceanalytics/import-oracledb-schema@1.0.2","maintainers":[{"name":"jiteshsuthar","email":"jiteshsuthar@credenceanalytics.com"},{"name":"atulknowsme","email":"atulpal@credenceanalytics.com"},{"name":"shruti_shende","email":"shrutishende@credenceanalytics.com"},{"name":"sonalnadkar","email":"sonalnadkar@credenceanalytics.com"},{"name":"cred-shubham","email":"shubhamyadav@credenceanalytics.com"},{"name":"sagarf","email":"sagarfernandes@credenceanalytics.com"},{"name":"prajaktacred","email":"prajaktashinde@credenceanalytics.com"},{"name":"mandakadam","email":"mandakadam@credenceanalytics.com"},{"name":"prabhuvikas","email":"vikasprabhu@credenceanalytics.com"},{"name":"jimmyjammerx","email":"pratiksatardekar@credenceanalytics.com"},{"name":"suraj_chavan","email":"surajchavan@credenceanalytics.com"},{"name":"mohinim18","email":"mohinimemane@credenceanalytics.com"}],"dist":{"shasum":"769374ed72ce39a9176735181eb5bd1fd316afa1","tarball":"https://registry.npmjs.org/@credenceanalytics/import-oracledb-schema/-/import-oracledb-schema-1.0.2.tgz","fileCount":5,"integrity":"sha512-fs8hvUy4YCnatKs8LHb13QcagAA5yhlXMPb9cIwmMFYVG+A5awtNpMkGgurmYbyFRK7umWWImvsihHyXqno9Dw==","signatures":[{"sig":"MEUCIAvw0sOh/YCqDcFBGdLo2hUBLPCfatWJParMLDFD/bYVAiEAhndM6N9wC7MXp8nwRBs2PbN10Jz18FoRQxk+Ysh4GYg=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":19370},"main":"index.js","gitHead":"20905fb54a9473ebe941ca86fac9919d38ec9094","scripts":{"dev":"node my-dev-run.js","test":"jest"},"_npmUser":{"name":"jiteshsuthar","email":"jiteshsuthar@credenceanalytics.com"},"repository":{"url":"https://gitlab.credenceanalytics.com/frameworks-and-tools/db-in-git/import-oracledb-schema","type":"git"},"_npmVersion":"6.14.13","description":"Import Schema to Oracle Database","directories":{"test":"test"},"_nodeVersion":"14.17.3","dependencies":{"oracledb":"^5.1.0"},"_hasShrinkwrap":false,"devDependencies":{"jest":"^29.7.0","jest-html-reporter":"^3.10.2"},"_npmOperationalInternal":{"tmp":"tmp/import-oracledb-schema_1.0.2_1704291740785_0.4777560244306205","host":"s3://npm-registry-packages"}},"1.0.3":{"name":"@credenceanalytics/import-oracledb-schema","version":"1.0.3","keywords":["parse","parser","oracle","oracledb","sql","ddl","json","schema","jsonschema","convert","converter","import","importer","sync"],"author":{"name":"jiteshsuthar@credenceanalytics.com"},"license":"ISC","_id":"@credenceanalytics/import-oracledb-schema@1.0.3","maintainers":[{"name":"jiteshsuthar","email":"jiteshsuthar@credenceanalytics.com"},{"name":"atulknowsme","email":"atulpal@credenceanalytics.com"},{"name":"shruti_shende","email":"shrutishende@credenceanalytics.com"},{"name":"sonalnadkar","email":"sonalnadkar@credenceanalytics.com"},{"name":"cred-shubham","email":"shubhamyadav@credenceanalytics.com"},{"name":"sagarf","email":"sagarfernandes@credenceanalytics.com"},{"name":"prajaktacred","email":"prajaktashinde@credenceanalytics.com"},{"name":"mandakadam","email":"mandakadam@credenceanalytics.com"},{"name":"prabhuvikas","email":"vikasprabhu@credenceanalytics.com"},{"name":"jimmyjammerx","email":"pratiksatardekar@credenceanalytics.com"},{"name":"suraj_chavan","email":"surajchavan@credenceanalytics.com"},{"name":"mohinim18","email":"mohinimemane@credenceanalytics.com"}],"dist":{"shasum":"cc45d7b1aa5d6a8cd9c9df3097d8f2b205829ade","tarball":"https://registry.npmjs.org/@credenceanalytics/import-oracledb-schema/-/import-oracledb-schema-1.0.3.tgz","fileCount":5,"integrity":"sha512-F5Mowc/umvxSwCM8uKbtpafW7Avg+l/2SMdf7aVMvmT7KNnelX6tgx4I8SbTYDaCjclFtUSI3xOzzp1JXz5McA==","signatures":[{"sig":"MEUCIQCiXlYHZ/Hd5oB/OkcfGp/JklCs2rTRgEQMmRBvWXX9SAIgEX1U7ggOBSlLxKduWB+qJZAXqxvKNPdVD/O5CAKowRU=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":22545},"main":"index.js","gitHead":"e5a35608701f4a9396b4ac4c0c718bcb439484c1","scripts":{"dev":"node my-dev-run.js","test":"jest"},"_npmUser":{"name":"jiteshsuthar","email":"jiteshsuthar@credenceanalytics.com"},"repository":{"url":"https://gitlab.credenceanalytics.com/frameworks-and-tools/db-in-git/import-oracledb-schema","type":"git"},"_npmVersion":"6.14.13","description":"Import Schema to Oracle Database","directories":{"test":"test"},"_nodeVersion":"14.17.3","dependencies":{"oracledb":"^5.1.0"},"_hasShrinkwrap":false,"devDependencies":{"jest":"^29.7.0","jest-html-reporter":"^3.10.2"},"_npmOperationalInternal":{"tmp":"tmp/import-oracledb-schema_1.0.3_1704636719335_0.056819669524194705","host":"s3://npm-registry-packages"}},"1.0.4":{"name":"@credenceanalytics/import-oracledb-schema","version":"1.0.4","keywords":["parse","parser","oracle","oracledb","sql","ddl","json","schema","jsonschema","convert","converter","import","importer","sync"],"author":{"name":"jiteshsuthar@credenceanalytics.com"},"license":"ISC","_id":"@credenceanalytics/import-oracledb-schema@1.0.4","maintainers":[{"name":"jiteshsuthar","email":"jiteshsuthar@credenceanalytics.com"},{"name":"atulknowsme","email":"atulpal@credenceanalytics.com"},{"name":"shruti_shende","email":"shrutishende@credenceanalytics.com"},{"name":"sonalnadkar","email":"sonalnadkar@credenceanalytics.com"},{"name":"cred-shubham","email":"shubhamyadav@credenceanalytics.com"},{"name":"sagarf","email":"sagarfernandes@credenceanalytics.com"},{"name":"prajaktacred","email":"prajaktashinde@credenceanalytics.com"},{"name":"mandakadam","email":"mandakadam@credenceanalytics.com"},{"name":"prabhuvikas","email":"vikasprabhu@credenceanalytics.com"},{"name":"jimmyjammerx","email":"pratiksatardekar@credenceanalytics.com"},{"name":"suraj_chavan","email":"surajchavan@credenceanalytics.com"},{"name":"mohinim18","email":"mohinimemane@credenceanalytics.com"}],"dist":{"shasum":"e6bfcbda532fedcd14cb3af1f7cc1d51ffeb1f67","tarball":"https://registry.npmjs.org/@credenceanalytics/import-oracledb-schema/-/import-oracledb-schema-1.0.4.tgz","fileCount":5,"integrity":"sha512-l1/JmUCsw2ou5HZ27UhBqEAQP9C6EVQBAuTBh9+dSisf18gIAUf6s0fMy1/ov9e8d8BYdc+00r28N+ck5Vb3bw==","signatures":[{"sig":"MEUCIQCmDnLDq01HoNUTwq0L/O9PtYc79sVh9/VCsqAu6/+IbgIgX34xhRjfGrmDMQS4kmes2EvcDFrjabuAExRw0X9hOjY=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":22738},"main":"index.js","gitHead":"b81d6d8d74b4e76492caa2b2bb1997f6f7517b89","scripts":{"dev":"node my-dev-run.js","test":"jest"},"_npmUser":{"name":"jiteshsuthar","email":"jiteshsuthar@credenceanalytics.com"},"repository":{"url":"https://gitlab.credenceanalytics.com/frameworks-and-tools/db-in-git/import-oracledb-schema","type":"git"},"_npmVersion":"6.14.13","description":"Import Schema to Oracle Database","directories":{"test":"test"},"_nodeVersion":"14.17.3","dependencies":{"oracledb":"^5.1.0"},"_hasShrinkwrap":false,"devDependencies":{"jest":"^29.7.0","jest-html-reporter":"^3.10.2"},"_npmOperationalInternal":{"tmp":"tmp/import-oracledb-schema_1.0.4_1704637269794_0.26496971558032656","host":"s3://npm-registry-packages"}},"1.0.5":{"name":"@credenceanalytics/import-oracledb-schema","version":"1.0.5","keywords":["parse","parser","oracle","oracledb","sql","ddl","json","schema","jsonschema","convert","converter","import","importer","sync"],"author":{"name":"jiteshsuthar@credenceanalytics.com"},"license":"ISC","_id":"@credenceanalytics/import-oracledb-schema@1.0.5","maintainers":[{"name":"prabhuvikas","email":"vikasprabhu@credenceanalytics.com"},{"name":"jimmyjammerx","email":"pratiksatardekar@credenceanalytics.com"},{"name":"suraj_chavan","email":"surajchavan@credenceanalytics.com"},{"name":"cred-shubham","email":"shubhamyadav@credenceanalytics.com"},{"name":"mohinim18","email":"mohinimemane@credenceanalytics.com"},{"name":"jiteshsuthar","email":"jiteshsuthar@credenceanalytics.com"},{"name":"mandakadam","email":"mandakadam@credenceanalytics.com"},{"name":"prajaktacred","email":"prajaktashinde@credenceanalytics.com"},{"name":"sagarf","email":"sagarfernandes@credenceanalytics.com"},{"name":"atulknowsme","email":"atulpal@credenceanalytics.com"},{"name":"shruti_shende","email":"shrutishende@credenceanalytics.com"},{"name":"sonalnadkar","email":"sonalnadkar@credenceanalytics.com"}],"dist":{"shasum":"eb59dcfa94a57f778437ccbb539f8a7ee8137acb","tarball":"https://registry.npmjs.org/@credenceanalytics/import-oracledb-schema/-/import-oracledb-schema-1.0.5.tgz","fileCount":5,"integrity":"sha512-02WqeivdbLBlz1fpvEC0SJMq8ZfZ+K5Slu2Q9mOhUDHstRThd7FbirlkJGpjh+TkQw245SzTNuSUJxnenbTKmg==","signatures":[{"sig":"MEQCIFxEvWr7yfbIeoiFUss9v7Rik4kA3EZ0gBZHues/XGaWAiAfthnWeqcv4YZeEYoZ1xbbvq+yz5yg8uBnXS4WVRQGqg==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":22902},"main":"index.js","gitHead":"8b48b4721cef6fffa5b3521ef6a8226bbb2a5bfb","scripts":{"dev":"node my-dev-run.js","test":"jest"},"_npmUser":{"name":"cred-shubham","email":"shubhamyadav@credenceanalytics.com"},"repository":{"url":"https://gitlab.credenceanalytics.com/frameworks-and-tools/db-in-git/import-oracledb-schema","type":"git"},"_npmVersion":"9.6.7","description":"Import Schema to Oracle Database","directories":{"test":"test"},"_nodeVersion":"18.17.1","dependencies":{"oracledb":"^5.1.0"},"_hasShrinkwrap":false,"devDependencies":{"jest":"^29.7.0","jest-html-reporter":"^3.10.2"},"_npmOperationalInternal":{"tmp":"tmp/import-oracledb-schema_1.0.5_1736336550292_0.6314236587582671","host":"s3://npm-registry-packages-npm-production"}}},"time":{"created":"2023-12-25T19:32:51.601Z","modified":"2026-09-21T10:50:41.505Z","1.0.0":"2023-12-25T19:32:51.864Z","1.0.1":"2023-12-27T05:31:58.011Z","1.0.2":"2024-01-03T14:22:20.973Z","1.0.3":"2024-01-07T14:11:59.539Z","1.0.4":"2024-01-07T14:21:09.989Z","1.0.5":"2025-01-08T11:42:30.467Z"},"author":{"name":"jiteshsuthar@credenceanalytics.com"},"license":"ISC","keywords":["parse","parser","oracle","oracledb","sql","ddl","json","schema","jsonschema","convert","converter","import","importer","sync"],"repository":{"url":"https://gitlab.credenceanalytics.com/frameworks-and-tools/db-in-git/import-oracledb-schema","type":"git"},"description":"Import Schema to Oracle Database","maintainers":[{"email":"vikasprabhu@credenceanalytics.com","name":"prabhuvikas"},{"email":"surajchavan@credenceanalytics.com","name":"suraj_chavan"},{"email":"mohinimemane@credenceanalytics.com","name":"mohinim18"},{"email":"jiteshsuthar@credenceanalytics.com","name":"jiteshsuthar"},{"email":"mandakadam@credenceanalytics.com","name":"mandakadam"},{"email":"sonalnadkar@credenceanalytics.com","name":"sonalnadkar"},{"email":"suhassurwase@credenceanalytics.com","name":"suhas_surwase"}],"readme":"# Import of Oracle Schema to database\r\n\r\nThis Node.js module imports Oracle schema script files to Oracle database.\r\n\r\n## Introduction\r\n\r\nThis module provides a utility to import JSON structure tables & other DDL object types using the provided scripts files.\r\n\r\n## Import Features\r\n\r\n-   Create table structure using JSON schema files\r\n-   Add/Modify table columns by comparing JSON schema files & column definition in oracle database\r\n-   Create/Replace other object types like view, function etc. to Oracle database\r\n-   Selective import of objects\r\n-   Import of all objects from the schema definition folder\r\n-   Recompile invalid database objects like procedures, functions etc.\r\n\r\n## Requirements\r\n\r\n-   Node.js\r\n-   Oracle Database, Client libraries\r\n-   Scheme JSON/Script files exported using NPM Module - [oracledb-to-json-schema](https://www.npmjs.com/package/@credenceanalytics/oracledb-to-json-schema)\r\n\r\n## Installation\r\n\r\n```bash\r\nnpm install @credenceanalytics/import-oracledb-schema\r\n```\r\n\r\n## Usage\r\n\r\n### schemaToDb(dbConnObj, options, configFilePath)\r\n\r\n-   `dbConnObj` - Oracle database connection object created using oracledb.getConnection()\r\n-   `options`: Additional feature based option parameters.\r\n    -   **exportDir** - Path where the `definition` folder is available which contains oracledb schema.\r\n    -   **sql_output** - To generate insert statements as .sql files. Default is **false**\r\n        -   true - Save import script as sql files\r\n        -   false - Import script without saving the script in sql files.\r\n    -   **is_new_setup** - To validate if the import is for new schema or existing schema. Default is **true**\r\n        -   true - Import only if the schema is blank i.e. no object available. Fresh Setup Installation.\r\n        -   false - Import even if schema contains any object. It will overwrite or update the existing objects as per the import schema.\r\n-   `configFilePath` : **Optional**\r\n    - Default: Import of all objects from the schema definition folder\r\n    - Provide list of selective schema objects to import - schemaimport.sample.json\r\n        ```json\r\n        {\r\n            \"procedure\": [\"APP_REFRESH_DATA\", \"WM_LOGPROCESSDETAIL\"],\r\n            \"view\": [\"AUDIT_BANKACCOUNTS\", \"BANK_VIEW\"],\r\n            \"table\": [\"GLOBAL_SECURITY\", \"WORKFLOW_SECURITYDEF\"]\r\n        }\r\n        ```\r\n\r\n#### Options:\r\n\r\n-   Import Schema of all objects\r\n    ```javascript\r\n    schemaToDb(dbConnObj, options);\r\n    ```\r\n-   Import Schema of selective objects\r\n    ```javascript\r\n    schemaToDb(dbConnObj, options, schemaImpConfigFilePath);\r\n    ```\r\n\r\nSample code to import full schema:\r\n\r\n-   index.js\r\n\r\n    ```javascript\r\n    const importSchema = require(\"@credenceanalytics/import-oracledb-schema\");\r\n    const oracledb = require(\"oracledb\");\r\n    const impSchema = new importSchema();\r\n    const dbconfig = {\r\n        username: \"\",\r\n        password: \"\",\r\n        host: \"\",\r\n        database: \"\"\r\n    };\r\n    const options = { exportDir: \"./dbmodel/legacy\", sql_output: true, is_new_setup: true };\r\n\r\n    async function importAllSchemaToDb() {\r\n        console.time(\"importAllSchemaToDb\");\r\n        if (!validateDbConfig(dbconfig)) return;\r\n        const connectString = `${dbconfig.host}/${dbconfig.database}`;\r\n        let dbConnObj;\r\n        try {\r\n            dbConnObj = await oracledb.getConnection({ user: dbconfig.username, password: dbconfig.password, connectString });\r\n            var resp = await impSchema.schemaToDb(dbConnObj, options);\r\n            console.log(\"Result:\", resp);\r\n            console.log(\"Import-status:\", resp.status);\r\n            console.log(\"Import-message:\", resp.message);\r\n            // console.log(\"Import-result:\", resp.import_result);\r\n            console.log(\"Import-summary:\", resp.import_summary);\r\n        } catch (error) {\r\n            console.error(\"Oracle DB execution exception:\", error);\r\n            throw error;\r\n        } finally {\r\n            if (dbConnObj) {\r\n                try {\r\n                    await dbConnObj.close();\r\n                } catch (error) {\r\n                    console.error(\"Error closing connection:\", error);\r\n                    throw error;\r\n                }\r\n            }\r\n        }\r\n        console.timeEnd(\"importAllSchemaToDb\");\r\n    }\r\n    function validateDbConfig(config) {\r\n        const requiredKeys = [\"username\", \"password\", \"host\", \"database\"];\r\n        for (const key of requiredKeys) {\r\n            if (!(key in config) || config[key] === \"\") {\r\n                console.error(`Error: ${key} is missing or empty in dbconfig.`);\r\n                return false;\r\n            }\r\n        }\r\n        return true;\r\n    }\r\n    importAllSchemaToDb();\r\n    ```\r\n\r\n## Additional Resources\r\nPackage to export full oracle database schema : [oracledb-to-json-schema](https://www.npmjs.com/package/@credenceanalytics/oracledb-to-json-schema)","readmeFilename":"README.md"}