sqlserver

README

xk6-sql-driver-sqlserver

Database driver extension for xk6-sql k6 extension to support Microsoft SQL Server database.

Example

import sql from "k6/x/sql";
import driver from "k6/x/sql/driver/sqlserver";

// The second argument is a MS SQL connection string, e.g.
// Server=127.0.0.1;Database=myDB;User Id=myUser;Password=myPassword;
const db = sql.open(driver, "");

export function setup() {
  db.exec(`IF object_id('keyvalues') is null
            CREATE TABLE keyvalues (
            [id] INT IDENTITY PRIMARY KEY,
            [key] varchar(50) NOT NULL,
            [value] varchar(50));`);
}

export function teardown() {
  db.close();
}

export default function () {
  db.exec("INSERT INTO keyvalues ([key], [value]) VALUES('plugin-name', 'k6-plugin-sql');");

  let results = sql.query(db, "SELECT * FROM keyvalues WHERE [key] = @p1;", "plugin-name");
  for (const row of results) {
    console.log(`key: ${row.key}, value: ${row.value}`);
  }
}

Usage

Check the xk6-sql documentation on how to use this database driver.

Documentation

Overview

Package sqlserver contains Microsoft SQL Server driver registration for xk6-sql.