Interface Row

Indexable

• [key: string]: unknown

  Each column has a property with the same name as the column name. The value of the property contains the value of the given column in the current row.

  The value of the property is automatically mapped to the corresponding JavaScript type.

  Example

   import sql from "k6/x/sql";
  
   // the actual database driver should be used instead of ramsql
   import driver from "k6/x/sql/driver/ramsql";
  
   const db = sql.open(driver, "roster_db");
  
   export default function () {
     let rows = db.query("SELECT * FROM roster WHERE given_name = $1;", "Peter");
     for (const row of results) {
       console.log(`${row.family_name}, ${row.given_name}`);
     }
   }
  Copy