Mon, 13 Mar 2023 18:27:00 +0000
metadata: Add 'needs_deferral' canned query
0 | 1 | --- |
2 | ||
3 | title: "XMPP ecosystem data" | |
4 | description: "Explore the ecosystem of XMPP extensions and software" | |
5 | source: "XMPP Standards Foundation" | |
6 | source_url: "https://xmpp.org/" | |
7 | ||
8 | databases: | |
9 | xmpp: | |
10 | tables: | |
11 | xeps: | |
12 | label_column: title | |
13 | software: | |
14 | label_column: name | |
15 | compliance_levels: | |
16 | columns: | |
17 | xep_id: XEP | |
18 | implementations: | |
19 | columns: | |
20 | xep_id: XEP | |
21 | xep_version: XEP version | |
22 | software_id: Software | |
23 | queries: | |
24 | outdated_implementations: | |
25 | title: "Implementations: needing updates" | |
26 | description: "Find implementations not on the latest version of a XEP" | |
27 | sql: |- | |
28 | select | |
29 | software.name, | |
30 | xeps.number as xep_num, | |
31 | xeps.title as xep_name, | |
32 | xep_version as implemented_xep_version, | |
33 | xeps.version as latest_xep_version | |
34 | from | |
35 | implementations | |
36 | join xeps on implementations.xep_id == xeps.id | |
37 | join software on implementations.software_id == software.id | |
38 | where | |
39 | xep_version != xeps.version | |
40 | unusual_compliance: | |
41 | title: "XEPs: Unusual compliance requirements" | |
42 | description: "Find XEPs in undesired states that are required by current compliance suites" | |
43 | sql: |- | |
44 | select | |
45 | xeps.number, | |
46 | xeps.title, | |
47 | xeps.status, | |
48 | compliance_levels.category, | |
49 | compliance_levels.level | |
50 | from | |
51 | xeps | |
52 | join compliance_levels on compliance_levels.xep_id = xeps.id | |
53 | where | |
54 | compliance_levels.level not null | |
55 | and xeps.status not in ('Active','Stable','Final'); | |
56 | deferred: | |
57 | title: "XEPs: Deferred with implementations" | |
58 | description: "Show deferred XEPs with implementation counts" | |
59 | sql: |- | |
60 | select | |
61 | xeps.number, | |
62 | xeps.title, | |
63 | xeps.last_updated, | |
64 | count(implementations.xep_id) as implementations | |
65 | from | |
66 | xeps | |
67 | join implementations on implementations.xep_id = xeps.id | |
68 | where | |
69 | status = "Deferred" | |
70 | group by | |
71 | xeps.id | |
72 | order by | |
73 | implementations desc, last_updated desc; | |
74 | expiring: | |
75 | title: "XEPs: Expiring soon" | |
76 | description: "Show XEPs soon to become deferred" | |
77 | sql: |- | |
78 | select | |
79 | xeps.number, | |
80 | xeps.title, | |
81 | xeps.last_updated, | |
82 | count(implementations.xep_id) as implementations | |
83 | from | |
84 | xeps | |
85 | join implementations on implementations.xep_id = xeps.id | |
86 | where | |
87 | status = "Experimental" | |
88 | group by | |
89 | xeps.id | |
90 | order by | |
91 | last_updated asc; | |
92 | last_call: | |
93 | title: "XEPs: Proposed XEPs under Last Call" | |
94 | description: "List open Last Calls" | |
95 | sql: |- | |
96 | select | |
97 | xeps.number, | |
98 | xeps.title, | |
99 | xeps.last_updated | |
100 | from | |
101 | xeps | |
102 | where | |
103 | status = "Proposed" | |
104 | order by | |
105 | last_updated desc; | |
106 | inbox: | |
107 | title: "XEPs: Inbox" | |
108 | description: "All submissions not accepted and assigned a XEP number" | |
109 | sql: |- | |
110 | select | |
111 | xeps.title, | |
112 | xeps.last_updated | |
113 | from | |
114 | xeps | |
115 | where | |
116 | xeps.number is null | |
117 | order by | |
118 | last_updated desc; | |
3
07136e6644cc
metadata: Add 'needs_deferral' canned query
Matthew Wild <mwild1@gmail.com>
parents:
0
diff
changeset
|
119 | needs_deferral: |
07136e6644cc
metadata: Add 'needs_deferral' canned query
Matthew Wild <mwild1@gmail.com>
parents:
0
diff
changeset
|
120 | title: "XEPS: Due deferral" |
07136e6644cc
metadata: Add 'needs_deferral' canned query
Matthew Wild <mwild1@gmail.com>
parents:
0
diff
changeset
|
121 | description: "XEPs that are still Experimental but not updated for over a year" |
07136e6644cc
metadata: Add 'needs_deferral' canned query
Matthew Wild <mwild1@gmail.com>
parents:
0
diff
changeset
|
122 | sql: |- |
07136e6644cc
metadata: Add 'needs_deferral' canned query
Matthew Wild <mwild1@gmail.com>
parents:
0
diff
changeset
|
123 | select |
07136e6644cc
metadata: Add 'needs_deferral' canned query
Matthew Wild <mwild1@gmail.com>
parents:
0
diff
changeset
|
124 | xeps.number, |
07136e6644cc
metadata: Add 'needs_deferral' canned query
Matthew Wild <mwild1@gmail.com>
parents:
0
diff
changeset
|
125 | xeps.title, |
07136e6644cc
metadata: Add 'needs_deferral' canned query
Matthew Wild <mwild1@gmail.com>
parents:
0
diff
changeset
|
126 | xeps.last_updated |
07136e6644cc
metadata: Add 'needs_deferral' canned query
Matthew Wild <mwild1@gmail.com>
parents:
0
diff
changeset
|
127 | from |
07136e6644cc
metadata: Add 'needs_deferral' canned query
Matthew Wild <mwild1@gmail.com>
parents:
0
diff
changeset
|
128 | xeps |
07136e6644cc
metadata: Add 'needs_deferral' canned query
Matthew Wild <mwild1@gmail.com>
parents:
0
diff
changeset
|
129 | where |
07136e6644cc
metadata: Add 'needs_deferral' canned query
Matthew Wild <mwild1@gmail.com>
parents:
0
diff
changeset
|
130 | xeps.status = "Experimental" |
07136e6644cc
metadata: Add 'needs_deferral' canned query
Matthew Wild <mwild1@gmail.com>
parents:
0
diff
changeset
|
131 | and xeps.last_updated <= date('now','-12 months') |
07136e6644cc
metadata: Add 'needs_deferral' canned query
Matthew Wild <mwild1@gmail.com>
parents:
0
diff
changeset
|
132 | order by |
07136e6644cc
metadata: Add 'needs_deferral' canned query
Matthew Wild <mwild1@gmail.com>
parents:
0
diff
changeset
|
133 | xeps.last_updated asc; |