-
Notifications
You must be signed in to change notification settings - Fork 3
/
script.js
36 lines (28 loc) · 783 Bytes
/
script.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
import { Faker } from "k6/x/faker";
import sql from "k6/x/sql";
const db = sql.open("sqlite3", "./test-users.db");
export function setup() {
db.exec(`
CREATE TABLE IF NOT EXISTS users (
sub varchar PRIMARY KEY,
name varchar NOT NULL,
email varchar NOT NULL
);`);
const faker = new Faker(11);
db.exec(`
INSERT OR REPLACE INTO users (sub, name, email) VALUES (
'${faker.internet.username()}',
'${faker.person.firstName()} ${faker.person.lastName()}',
'${faker.person.email()}'
);`);
}
export function teardown() {
db.close();
}
export default function () {
const results = sql.query(db, "SELECT * FROM users");
for (const row of results) {
const { sub, name, email } = row;
console.log({ sub, name, email });
}
}