magicanded

magicanded / algosqlite / 0.2.4

README.md

algosqlite - SQLite Database for Algorithmia

algosqlite provides SQLite JDBC driver which is from xerial/sqlite-jdbc allowing algorithms using SQLite databases on Algorithmia.

Usage

Input

algosqlite receives JSON object with following attributes:

ParameterDescription
dbFileSQLite database file
sqlListList of sql statements
sqlList[].sqlSQL string
sqlList[].action'query' for retrieving data only, 'execute' for insert/update database
sqlList[].parametersList of parameters of statement
sqlList[].parameters[].typeType: 'boolean', 'byte', 'date', 'double', 'float', 'integer', 'long', 'short', 'string', 'time', 'timestamp'
sqlList[].parameters[].valueValue of parameter

Output

algosqlite returns JSON object with following attributes:

ParameterDescription
isError'true' if error occurs, 'false' if success
errorCodeCode name of error
errorMessageMessage of error
resultsResults data
results.outputFileResults file
results.outputFileUrlDownload URL of results file