vv-mssql-action v0.0.49

Install & Use

npm i vv-mssql-action

const actions = require('vv-mssql-action').create()

actions.add({
    key:'a1',
    query: 'SELECT *, @n2 FROM #t WHERE [nnn] = @n1',
    params: [
        {
            type: 'scalar',
            scalar: {
                name: 'n1',
                type: 'nvarchar',
                len_chars: 'max'
            }
        },
        {
            type: 'scalar',
            scalar: {
                name: 'n2',
                type: 'int',
                nullable: false
            }
        },
        {
            type: 'table',
            table: {
                name: 't',
                column_list: [
                    {name: 'nnn', type: 'nvarchar', len_chars: 300, js_name: 'n1', nullable: false},
                    {name: 'n2', type: 'int'}
                ]
            }
        }
    ]
})

let object_from_external_word = {n1: 'hi', n2: '9', t: [{n1: 'a', n2: '3'}, {n1: 'hi', n2: -88}]}

let action = actions.get('a1')
let queries = actions.query(action, object_from_external_word)
queries.forEach(query => {
    console.log('--=====================')
    console.log(query)
})