JsonSQL

tableName

String

The name of the table to put into the SQL statements.

MyTable

dbType

String

One of the valid database type (same as used in the SQL Adapter).

SQLServer

Use an SQL Server database (default).

MySQL

Use a MySQL database.

whereColumns

Array of String

An array of strings containing the names of columns to be used in the WHERE clause when creating UPDATE, SELECT, and COUNT statements.

columnTypes

Array of String

An optional array of strings defining the names and types of specific columns.

The library uses JSON type information and pattern matching to derive the column types

• JSON distinguishes number, string, and boolean types

• The library detects DateTime and Blob values (both JSON string type) by pattern matching.

• Blob types are detected only if the value has more than 50 characters. In general you should indicate Blob columns to be safe.

However, you may want to store a DateTime value into a String type column, or the guessing and pattern matching may fail to work. In these cases you can provide the correct type information for such columns.

• The Strings going into the columnTypes Array are of the form "<column name>:<bridge type>", e.g. "myDateColumn:DateTime"

• Supported base types are String, Boolean, Float, Integer, DateTime, and Blob.

createInsert(json, config)

Creates an INSERT statement based on an object's JSON representation and a config. keyColumns in the configuration are ignored.

createUpdateFromVersions(oldVersion, newVersion, config)

Creates an UPDATE statement based on the row currently stored in the DB (oldVersion) and the row after some changes have been made (newVersion).

createUpdateFromDiff(oldVersion, diff, config)

Creates an UPDATE statement based on the row currently stored in the DB (oldVersion) and the JSON diff to the row after some changes have been applied.

set sql = jsonSql:createCount(obj.classToJson(), config);

set sql = jsonSql:createSelect(obj.classToJson(), config);