JR-code

A visual studio code extension that provides code snippets and code completion in PHP and Javascript for JobRouter® functions.

Features

This extension provides handy code snippets for working with JobRouter database operations.

Prefix	Name/Description
`jrselect`	JobRouter DB prepared SELECT query with parameters and types
`jrfetchone`	JobRouter DB fetch single value using prepared SELECT
`jrupdate`	JobRouter DB prepared UPDATE query
`jrinsert`	JobRouter DB prepared INSERT query
`dbselect`	External DB prepared SELECT query with parameters and types
`dbfetchone`	External DB fetch single value using prepared SELECT
`dbupdate`	External DB prepared UPDATE query
`dbinsert`	External DB prepared INSERT query
`loopst`	Loop over subtable rows and process each