Accessing databases via external tools

Last edited on

Overview

Squish supports accessing databases indirectly through respective modules for the scripting languages (Python, Perl, Tcl, Ruby, except for JavaScript).

Another solution for accessing databases is to use external programs which perform the desired database accesses.

This article demonstrates using two such an external (example) programs.


Accessing databases via external tool and JDBC

JavaScript example

For example:

select
org.hsqldb.jdbc.JDBCDriver
jdbc:hsqldb:file:databases/testdb
administrator
password
input.txt
output.csv
jsqlexec_select_cfg.txt

Python example

For example:

select
org.hsqldb.jdbc.JDBCDriver
jdbc:hsqldb:file:databases/testdb
administrator
password
input.txt
output.csv
jsqlexec_select_cfg.txt

Accessing databases via external tool and Python sqlite3 module

Python example