Scripting Bugs/Enhancements

03.29.13

  • Add a method call AddVisTable(tableName, role, username ) to scripting facades so that the ingestor doesn’t need to be called.

03.21.13

  • Visibility Scripting
    • Add a column for the variables in the query table. This replaces the variables flag, and will store the variables as key/value pairs in XML. Note that this will always be <String>:<String>. Each query is allowed only one variable object.
    • The python script is able to use new facade methods to write the variables into the slot.
      • varClear() // clears the HashMap
      • varSet(key:String, val:String); // sets a key value pair
      • set(queryName:String); // finds the appropriate query in the query table.
    • The variable object must be set() before the sql is called.
    • When editing the SQL in the SQL editor, the “raw” query with the substitution tags is shown if the “variables” checkbox is FALSE. The state of the “submit” button tracks the variables checkbox. If the checkbox is TRUE, then the macro substition is run that the query can be submitted.
    • When running a scheduled query, there needs to be logic to perform macro substitution if the variable field is NOT NULL
    • Also, the list of facade methods needs to be made current.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: