How To Develop

Config

1. Set SQL*Plus/sqlcl tool used

Set sqlTool used to connect and execute SQL*Plus scripts in ./config/env/all.js

Sample:

'use strict';

module.exports = {
   sqlTool : 'sql' // sqlplus
};

2. Set connection strings

Create ./config/env/development.js and define connection string for

• superUserDbConnectString - user with system privileges to create users and grant required privileges
• peteUserDbConnectString - schema, where your pete development/testing environment would be installed

Sample:

'use strict';

module.exports = {
    db: {
        superUserDbConnectString: 'sys/manager@localhost:1521:orcl as sysdba',
        peteUserDbConnectString:  'pete_test/pete_test@lcoalhost:1521:orcl'
    },
};

Grunt

Continues Integration scripts are based on node & grunt. Install required toolchain.

• install node
• install npm
• npm install -g grunt-cli
• npm install

There are already preconfigured Grunt task for Continuous Integration

• grunt install - installs Pete into schema defined by peteUserDbConnectString
• grunt uninstall - uninstalls Pete from that schema
• grunt test - recompiles Pete test packages and runs defined Pete tests
• grunt reinstall - uninstall and reinstall Pete
• grunt ci - reinstalls Pete, runs tests and then watches for changes in application/\*\*/*.sql. If there is any change, it reinstalls Pete and reruns tests.