/* POST create comment. */ router.post('/', function (req, res) { var connection = db.createConnection(); var request = db.createRequest("insert into Comments values (@author, @text)", connection); request.addParameter('author', TYPES.NVarChar, req.body.author); request.addParameter('text', TYPES.NVarChar, req.body.text); db.executeRequest(request, connection); });
/* GET single comment. */ router.get('/:id', function (req, res) { var conn = db.createConnection(); var request = db.createRequest("select * from comments where id = @id for json path, without_array_wrapper", conn); request.addParameter('id', TYPES.Int, req.params.id); db.stream(request, conn, res, '{}'); });
agent.endTransaction() }) request.addParameter('value', tedious.TYPES.Int)
}); request.addParameter('aggregateId', TYPES.UniqueIdentifier, aggregateId);
}); request.addParameter('aggregateId', TYPES.UniqueIdentifier, aggregateId); request.addParameter('revision', TYPES.Int, revision); request.addParameter('state', TYPES.NVarChar, JSON.stringify(state), { length: 4000 });
const value = values[i]; request.addParameter(value.key, value.type, value.value, value.options);
}); request.addParameter('aggregateId', TYPES.UniqueIdentifier, aggregateId);
}); request.addParameter('aggregateId', TYPES.UniqueIdentifier, aggregateId); request.addParameter('fromRevision', TYPES.Int, fromRevision); request.addParameter('toRevision', TYPES.Int, toRevision);