-
Notifications
You must be signed in to change notification settings - Fork 1
/
github_issues_labels.spec.sql
156 lines (142 loc) · 4.06 KB
/
github_issues_labels.spec.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
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
create or replace package github_issues_labels
as
/** Interface to Github issues labels API
* @author Morten Egan (github.com/morten-egan)
* @project OracleGit
* @version 0.1.0
*/
/** List all labels for this repository
* @author Morten Egan
* @param git_account The account that owns the repository
* @param repos_name The name of the repository
*/
function list_repos_labels (
git_account varchar2
, repos_name varchar2
)
return github.call_result;
/** Get a single label
* @author Morten Egan
* @param git_account The account that owns the repository
* @param repos_name The name of the repository
* @param label The name of the label to get
*/
function get_label (
git_account varchar2
, repos_name varchar2
, label varchar2
)
return github.call_result;
/** Create a label
* @author Morten Egan
* @param git_account The account that owns the repository
* @param repos_name The name of the repository
* @param label The name of the label
* @param color A 6 character hex code, without the leading #, identifying the color.
*/
procedure create_label (
git_account varchar2
, repos_name varchar2
, label varchar2
, color varchar2
);
/** Update a label
* @author Morten Egan
* @param git_account The account that owns the repository
* @param repos_name The name of the repository
* @param label The name of the label
* @param color A 6 character hex code, without the leading #, identifying the color.
*/
procedure update_label (
git_account varchar2
, repos_name varchar2
, label varchar2
, color varchar2
);
/** Delete a label
* @author Morten Egan
* @param git_account The account that owns the repository
* @param repos_name The name of the repository
* @param label The name of the label
*/
procedure delete_label (
git_account varchar2
, repos_name varchar2
, label varchar2
);
/** List labels on an issue
* @author Morten Egan
* @param git_account The account that owns the repository
* @param repos_name The name of the repository
* @param issue_id The ID of the issue
*/
function list_issue_labels (
git_account varchar2
, repos_name varchar2
, issue_id number
)
return github.call_result;
/** Add labels to an issue
* @author Morten Egan
* @param git_account The account that owns the repository
* @param repos_name The name of the repository
* @param issue_id The ID of the issue
* @param labels A list of labels
*/
procedure add_labels_to_issue (
git_account varchar2
, repos_name varchar2
, issue_id number
, labels json_list
);
/** Remove a label from an issue
* @author Morten Egan
* @param git_account The account that owns the repository
* @param repos_name The name of the repository
* @param issue_id The ID of the issue
* @param label Name of label
*/
procedure remove_label_from_issue (
git_account varchar2
, repos_name varchar2
, issue_id number
, label varchar2
);
/** Replace all labels for an issue
* @author Morten Egan
* @param git_account The account that owns the repository
* @param repos_name The name of the repository
* @param issue_id The ID of the issue
* @param labels A list of labels
*/
procedure replace_all_labels_issue (
git_account varchar2
, repos_name varchar2
, issue_id number
, labels json_list
);
/** Remove all labels from an issue
* @author Morten Egan
* @param git_account The account that owns the repository
* @param repos_name The name of the repository
* @param issue_id The ID of the issue
*/
procedure remove_labels_issue (
git_account varchar2
, repos_name varchar2
, issue_id number
);
/** Get labels for every issue in a milestone
* @author Morten Egan
* @param git_account The account that owns the repository
* @param repos_name The name of the repository
* @param milestone_id The id of the milestone
*/
function labels_from_milestone (
git_account varchar2
, repos_name varchar2
, milestone_id number
)
return github.call_result;
end github_issues_labels;
/