Add support for passphrase in DBConnection

[gquerret]

It is currently not possible to connect to TDE databases from PCT tasks (in a deployment scenario, TDE doesn't make any sense during a build). The way to connect to a TDE database is to add -Passphrase to the connection string, and this is only required when connection is done in single-user mode. When -Passphrase is used, the ABL session will read from stdin the passphrase.

It should be possible to connect to TDE databases from PCTRun (and inherited tasks), with an additional "passphrase" attribute in the DBConnection class. Stdin should only be modified if the passphrase has to be passed (check singleUser attribute). Additional tasks will also have to handle TDE: IndexRebuild, BinaryDump, BinaryLoad.

The passphrase shouldn't be leaked, so it should never be included in log output. I think the recommendation would be to have the passphrase as an environment variable, and then reference it in the passphrase attribute. Passing the passphrase as an Ant property in the command-line makes it visible in the list of processes, so that wouldn't be a good idea. More on this later...

[gquerret]

PCTRun doesn't connect to databases from the command line, so the -Passphrase and input redirect solution doesn't work in this case. The CONNECT statement only allows -KeyStorePassPhrase followed by the passphrase in double quotes. As the list of connection string is written in the pctinit procedure, including the passphrase in cleartext is not an option. The only way to hide the passphrase will be to use substitute('-db xxx -1 -KeyStorePassPhrase "&1"', os-getenv("passphraseDB1")). Another way would be to read the output of a command line (in parameter).

• In IndexRebuild, Dump and Load will directly pass the passphrase from stdin
• In PCTRun tasks, attribute will be passphraseEnvName ==> name of the environment variable that contains the passphrase. Future version might have passphraseCommandLine. Could use input through to read the phrase.

[gquerret]

DynamicRun also needs to be changed: the connection string is passed in the JSON file, so a separate entry should be prepared for the environment variable or the command line.

[gquerret]

Merged in main:

• New passphraseEnvVar and passphraseCmdLine attribures in DBConnection and IndexRebuild
  • Tested with PCTRun, PCTDynamicRun, PCTCompile, PCTCompileExt and IndexRebuild (they all have a different way of passing parameters or connecting the DB).
• Removed existing passphrase in DBConnection
• Initial tests showed no reference of passphrase in log output even with 4GLTrace:4 (enforced in unit tests)

BinaryDump and BinaryLoad tasks will be done later (if required).

PS: just discovered that Ctrl + E insert backticks around the current selection, or current word in case nothing is selected. Amazing... Especially given where backticks are mapped on a French keyboard.

[gquerret]

Merged in main branch. Removed passphraseEnvName properties.