Scripts

Owned by
Jonathan Muse
Last updated: Mar 10, 2021
2 min read

Default

SQL that will be used when not using individual operations like get, insert, update, etc.

Example:

SELECT id, year, make, model FROM auto_info WHERE year = {:2} AND make = {:3} AND model = {:4}

Get

SQL used to determine how data will be retrieved from the database.

Example:

SELECT id, year, make, model FROM auto_info WHERE year = {:2} AND make = {:3} AND model = {:4}

Set

SQL code used to determine how data will be set in Jira, not the database.

Insert

SQL code used to determine how data will be inserted into the database.

Example:

INSERT INTO auto_info(id, year, make, model) VALUES ({:1}, {:2}, {:3}, {:4})

Update

SQL code used to determine how data will be updated in the database.

Example:

Delete

SQL code used to determine how data will be deleted from the database.

Example:

SQL code used to determine how data will be searched in the database.

Example:

Seq

SQL code used to determine a sequence value for the ID when inserting new values into the database. If not specified, it will try to use the value provided in the inputs, and if that does not exist, it will rely on the database to have a mechanism for the ID.

Example: