forked from featurist/sworm
-
Notifications
You must be signed in to change notification settings - Fork 0
/
pgDriver.pogo
52 lines (40 loc) · 1.19 KB
/
pgDriver.pogo
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
optionalRequire = require './optionalRequire'
module.exports() =
pg = optionalRequire 'pg'
{
query(query, params) =
paramList = []
if (params)
indexedParams = {}
keys = Object.keys(params)
for (n = 0, n < keys.length, ++n)
key = keys.(n)
value = params.(key)
indexedParams.(key) = {
index = n + 1
value = value
}
paramList.push(value)
query := query.replace (@new RegExp "@([a-zA-Z_0-9]+)\\b" 'g') @(_, paramName)
param = indexedParams.(paramName)
if (@not param)
@throw @new Error "no such parameter @#(paramName)"
"$" + indexedParams.(paramName).index
self.client.query (query, paramList) ^!.rows
connect(config) =
promise @(result, error)
pg.connect(config.url) @(err, client, done)
if (err)
error(err)
else
self.client = client
self.done = done
result()
close() =
if (self.done)
self.done()
outputIdBeforeValues(id) = ''
outputIdAfterValues(id) = "returning #(id)"
insertedId(rows, id) =
rows.0.(id)
}