-
Notifications
You must be signed in to change notification settings - Fork 1
/
github_issues_comments.body.sql
141 lines (97 loc) · 2.68 KB
/
github_issues_comments.body.sql
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
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
create or replace package body github_issues_comments
as
function list_issue_comments (
git_account varchar2
, repos_name varchar2
, issue_id number
)
return github.call_result
as
begin
github.init_talk('/repos/' || git_account || '/' || repos_name || '/issues/' || issue_id || '/comments', 'GET');
github.talk(
github_account => git_account
);
return github.github_response_result;
end list_issue_comments;
function list_repository_comments (
git_account varchar2
, repos_name varchar2
, sort varchar2 default 'created'
, direction varchar2 default 'asc'
, since varchar2 default null
)
return github.call_result
as
begin
github.init_talk('/repos/' || git_account || '/' || repos_name || '/issues/comments', 'GET');
if sort is not null then
github.github_call_request.call_json.put('sort', sort);
end if;
if direction is not null then
github.github_call_request.call_json.put('direction', direction);
end if;
if since is not null then
github.github_call_request.call_json.put('since', since);
end if;
github.talk(
github_account => git_account
);
return github.github_response_result;
end list_repository_comments;
function get_comment (
git_account varchar2
, repos_name varchar2
, comment_id number
)
return github.call_result
as
begin
github.init_talk('/repos/' || git_account || '/' || repos_name || '/issues/comments/' || comment_id, 'GET');
github.talk(
github_account => git_account
);
return github.github_response_result;
end get_comment;
procedure create_comment (
git_account varchar2
, repos_name varchar2
, issue_id number
, body varchar2
)
as
begin
github.init_talk('/repos/' || git_account || '/' || repos_name || '/issues/' || issue_id || '/comments', 'POST');
github.github_call_request.call_json.put('body', body);
github.talk(
github_account => git_account
);
end create_comment;
procedure edit_comment (
git_account varchar2
, repos_name varchar2
, comment_id number
, body varchar2
)
as
begin
github.init_talk('/repos/' || git_account || '/' || repos_name || '/issues/comments/' || comment_id, 'PATCH');
github.github_call_request.call_json.put('body', body);
github.talk(
github_account => git_account
);
end edit_comment;
procedure delete_comment (
git_account varchar2
, repos_name varchar2
, comment_id number
)
as
begin
github.init_talk('/repos/' || git_account || '/' || repos_name || '/issues/comments/' || comment_id, 'DELETE');
github.talk(
github_account => git_account
);
end delete_comment;
end github_issues_comments;
/