-
Notifications
You must be signed in to change notification settings - Fork 0
/
dal.js
120 lines (101 loc) · 2.89 KB
/
dal.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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
import mysql from 'mysql2/promise'
class Dal {
async connect() {
try {
return await mysql.createConnection({
host: '0.0.0.0',
user: 'root',
password: 'root',
database: 'db_alteredCarbon'
})
} catch (err) {
console.error('Unable to connect to alteredCarbon database')
throw err
}
}
async getAllStacksAsync() {
const connection = await this.connect()
try {
const [result] = await connection.query(`SELECT * FROM CorticalStacks`)
return result
} catch (err) {
console.error(err.message)
} finally {
connection.end()
}
}
async getAllEnvelopesAsync() {
const connection = await this.connect()
try {
const [result] = await connection.query(`SELECT * FROM Envelopes`)
return result
} catch (err) {
console.error(err.message)
} finally {
connection.end()
}
}
async createAsync(realGender, name, age) {
const connection = await this.connect()
try {
const [resultStack] = await connection.query(
`INSERT INTO CorticalStacks (realGender, name, age) VALUES ('${realGender}', '${name}', '${age}')`
)
const [resultEnvelope] = await connection.query(
`INSERT INTO Envelopes (gender, age, idStack) VALUES ('${realGender}', '${age}', '${resultStack.insertId}')`
)
await connection.query(
`UPDATE CorticalStacks SET idEnvelope='${resultEnvelope.insertId}' WHERE id=${resultStack.insertId}`
)
return {
corticalStackId: resultStack.insertId,
envelopeId: resultEnvelope.insertId
}
} catch (err) {
console.error(err.message)
} finally {
connection.end()
}
}
async updateEnvelopeIdFromStackAsync(stackId, envelopeId) {
const connection = await this.connect()
try {
await connection.query(`UPDATE CorticalStacks SET idEnvelope=${envelopeId} WHERE id=${stackId}`)
} catch (err) {
console.error(err.message)
} finally {
connection.end()
}
}
async updateStackIdFromEnvelopeAsync(stackId, envelopeId) {
const connection = await this.connect()
try {
await connection.query(`UPDATE Envelopes SET idStack=${stackId} WHERE id=${envelopeId}`)
} catch (err) {
console.error(err.message)
} finally {
connection.end()
}
}
async removeStackByIdAsync(idStack) {
const connection = await this.connect()
try {
await connection.query(`DELETE FROM CorticalStacks WHERE id=${idStack}`)
} catch (err) {
console.error(err.message)
} finally {
connection.end()
}
}
async removeEnvelopeByIdAsync(idEnvelope) {
const connection = await this.connect()
try {
await connection.query(`DELETE FROM Envelopes WHERE id=${idEnvelope}`)
} catch (err) {
console.error(err.message)
} finally {
connection.end()
}
}
}
export default Dal