-
Notifications
You must be signed in to change notification settings - Fork 576
/
mysql2-example.js
67 lines (64 loc) · 1.9 KB
/
mysql2-example.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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
// Copyright 2018-2022 the Deno authors. All rights reserved. MIT license.
const mysql = require("mysql2/promise");
const assert = require("assert");
async function main() {
// create the connection to database
const connection = await mysql.createConnection({
host: "localhost",
user: "root",
password: "root",
database: "test",
});
await connection.execute(`DROP TABLE IF EXISTS pet;`);
await connection.execute(
`CREATE TABLE pet (name VARCHAR(20), species VARCHAR(20), age INT);`,
);
await connection.execute(
`INSERT INTO pet (name, species, age) values
("Max", "dog", 3),
("Charlie", "dog", 2),
("Cooper", "dog", 1),
("Buddy", "dog", 4),
("Milo", "dog", 5),
("Bear", "dog", 1),
("Rocky", "dog", 4),
("Duke", "dog", 3),
("Tucker", "dog", 2),
("Jack", "dog", 9),
("Bella", "dog", 3),
("Luna", "dog", 4),
("Lucy", "dog", 3),
("Daisy", "dog", 1),
("Zoe", "dog", 2),
("Lily", "dog", 7),
("Lola", "dog", 11),
("Bailey", "dog", 8),
("Stella", "dog", 9),
("Molly", "dog", 3);
`,
);
let results;
[results] = await connection.query(
'SELECT * FROM `pet` WHERE `name` = "Max" AND `age` > 1',
);
assert.deepStrictEqual(results, [
{ name: "Max", species: "dog", age: 3 },
]);
[results] = await connection.query("SELECT * FROM `pet` WHERE `age` > 5");
assert.deepStrictEqual(results, [
{ name: "Jack", species: "dog", age: 9 },
{ name: "Lily", species: "dog", age: 7 },
{ name: "Lola", species: "dog", age: 11 },
{ name: "Bailey", species: "dog", age: 8 },
{ name: "Stella", species: "dog", age: 9 },
]);
[results] = await connection.query(
"SELECT * FROM `pet` WHERE `name` = ? AND `age` > ?",
["Max", 1],
);
assert.deepStrictEqual(results, [
{ name: "Max", species: "dog", age: 3 },
]);
connection.close();
}
main();