Sqlite3 to JMP Data table through Python Integration

[#1]

The attached JSL uses JMP's Python integration to create a sqlite3 database file by recursively descending a directory of files.  The directory is chosen using JSL's Pick Directory().  The path is passed through to the Python environment.

A MD5 checksum is computed for each file and that along with the path is inserted into the sqlite3 database, then the sqlite3 table is imported into JMP as a Data Table.

Re-running the script just appends another directory's worth of information into the database.  Also demonstrated is an example of fully specifying dll and sys.path in the Python Init(). 

[Paul_Nelson]

This sample has been updated as a Python script in JMP 18.0's SAMPLE_SCRIPTS/Python/ directory as pyDigest.py.  It provides the same functionality as this JSL script but implemented to take advantage of the JMP 18 Python integration capabilities.  Including creating a data table in Python and populating the columns from the SQL query's result set in Python.