-
Notifications
You must be signed in to change notification settings - Fork 2
/
servers.go
101 lines (90 loc) · 2.67 KB
/
servers.go
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
/*-
* Copyright (c) 2016, Jörg Pernfuß <joerg.pernfuss@1und1.de>
* All rights reserved
*
* Use of this source code is governed by a 2-clause BSD license
* that can be found in the LICENSE file.
*/
package stmt
const SyncServers = `
SELECT server_id,
server_asset_id,
server_datacenter_name,
server_datacenter_location,
server_name,
server_online,
server_deleted
FROM inventory.servers
WHERE server_id != '00000000-0000-0000-0000-000000000000'::uuid;`
const ListServers = `
SELECT server_id,
server_name,
server_asset_id
FROM inventory.servers
WHERE server_online
AND NOT server_deleted
AND NOT server_id = '00000000-0000-0000-0000-000000000000'::uuid;`
const ShowServers = `
SELECT server_id,
server_asset_id,
server_datacenter_name,
server_datacenter_location,
server_name,
server_online,
server_deleted
FROM inventory.servers
WHERE server_id = $1::uuid;`
const SearchServerByName = `
SELECT server_id,
server_name,
server_asset_id
FROM inventory.servers
WHERE server_online
AND NOT server_deleted
AND NOT server_id = '00000000-0000-0000-0000-000000000000'
AND server_name = $1::varchar;`
const SearchServerByAssetId = `
SELECT server_id,
server_name,
server_asset_id
FROM inventory.servers
WHERE server_online
AND NOT server_deleted
AND NOT server_id = '00000000-0000-0000-0000-000000000000'
AND server_asset_id = $1::numeric;`
const AddServers = `
INSERT INTO inventory.servers (
server_id,
server_asset_id,
server_datacenter_name,
server_datacenter_location,
server_name,
server_online,
server_deleted)
SELECT $1::uuid, $2::numeric, $3, $4, $5, $6, $7
WHERE NOT EXISTS(
SELECT server_id
FROM inventory.servers
WHERE server_id = $1::uuid
OR server_asset_id = $2::numeric);`
const UpdateServers = `
UPDATE inventory.servers
SET server_asset_id = $2::numeric,
server_datacenter_name = $3::varchar,
server_datacenter_location = $4::varchar,
server_name = $5::varchar,
server_online = $6::boolean,
server_deleted = $7::boolean
WHERE server_id = $1::uuid;`
const DeleteServers = `
UPDATE inventory.servers
SET server_deleted = 'yes'::boolean,
server_online = 'no'::boolean
WHERE server_id = $1::uuid
AND server_id != '00000000-0000-0000-0000-000000000000'::uuid;`
const PurgeServers = `
DELETE FROM inventory.servers
WHERE server_id = $1::uuid
AND server_deleted
AND server_id != '00000000-0000-0000-0000-000000000000'::uuid;`
// vim: ts=4 sw=4 sts=4 noet fenc=utf-8 ffs=unix