RunSQLScript

java.lang.Object
- com.identityworksllc.iiq.common.tools.RunSQLScript

All Implemented Interfaces:

Callable<Integer>
```
public class RunSQLScript
extends Object
implements Callable<Integer>
```
A command-line entry point to run one or more SQL scripts via the internal IIQ utility that runs your SQL scripts when you install or update a plugin.
You need to use this via IIQ’s Launcher entry point, aka the ‘iiq’ command. This command typically takes one of the built-in entry points, such as ‘console’, but can be supplied with any number of others. The Launcher automatically loads command classes from WEB-INF, so it’s sufficient for this library (iiq-common-public.jar) to be there, along with picocli.

Usage: ./iiq com.identityworksllc.iiq.common.tools.RunSQLScript path/to/script1.sql path/to/script2.sql ...

Field Summary

Fields
Modifier and Type	Field	Description
`String`	`password`	The password, which can be provided at the command line, or can be interactively entered if not present.
`boolean`	`pluginSchema`	If present, specifies that the commands ought to be run against the plugin schema, not the identityiq schema.
`List<File>`	`sqlScripts`	The command line arguments, parsed as File locations
`String`	`username`	The username provided at the command line

Constructor Summary

Constructors
Constructor Description

RunSQLScript()

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`Integer`	`call()`	The main action, invoked by picocli after populating the parameters.
`static void`	`main(String[] args)`	Main method, to be invoked by the Sailpoint Launcher.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - password
```
public String password
```
    The password, which can be provided at the command line, or can be interactively entered if not present.
  - pluginSchema
```
public boolean pluginSchema
```
    If present, specifies that the commands ought to be run against the plugin schema, not the identityiq schema.
  - sqlScripts
```
public List<File> sqlScripts
```
    The command line arguments, parsed as File locations
  - username
```
public String username
```
    The username provided at the command line
- Constructor Detail
  - RunSQLScript
```
public RunSQLScript()
```
- Method Detail
  - main
```
public static void main(String[] args)
```
    Main method, to be invoked by the Sailpoint Launcher.
    Defers immediately to picocli to handle the inputs.
    
    Parameters:
    
    args - The command line arguments
  - call
```
public Integer call()
             throws Exception
```
    The main action, invoked by picocli after populating the parameters.
    
    Specified by:
    
    call in interface Callable<Integer>
    
    Returns:
    
    The exit code
    
    Throws:
    
    Exception - on failures