/
App.test.js
58 lines (49 loc) · 1.13 KB
/
App.test.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
const SheetFlow = require('..')
const options = {
credentials: require('./creds.json'),
sheet: {
id: '1SmVEJqgPVDu6_0TyusWpAX7xWV7c6GGrTyv72aY38ac',
name: 'Sheet1',
range: 'A:C'
}
}
const db = new SheetFlow(options)
async function main() {
await db.connect()
let response;
// Read data
response = await db.read()
/*
Response:
[
{ id: '1', name: 'Richard', age: '20' },
{ id: '2', name: 'Eddie ', age: '21' },
{ id: '3', name: 'Ruth', age: '32' },
{ id: '4', name: 'Gerard ', age: '19' },
{ id: '5', name: 'Paul', age: '25' }
]
*/
// Write data
response = await db.write(['6', 'James', '43'])
// Update data
const data = {
name: "Eddie",
age: "22"
}
response = await db.update(data) // sets Eddie's age to 22
// Delete data
response = await db.delete(3) // deletes "Ruth" from database
// Search data
response = await db.search('Gerard')
/*
Response:
[
{
id: '4',
name: 'Gerard',
age: '19'
}
]
*/
}
main()