Revision 50143
Added by Claudio Atzori over 6 years ago
| dnet_dsm.sql | ||
|---|---|---|
| 153 | 153 |
eissn character varying(20), |
| 154 | 154 |
lissn character varying(20), |
| 155 | 155 |
registeredby character varying(255), |
| 156 |
registrationdate date, |
|
| 156 | 157 |
subjects text DEFAULT ARRAY[]::character varying[], |
| 157 | 158 |
managed boolean DEFAULT false |
| 158 | 159 |
); |
| ... | ... | |
| 298 | 299 |
GROUP BY a.typology |
| 299 | 300 |
ORDER BY count(*) DESC; |
| 300 | 301 |
|
| 302 |
CREATE OR REPLACE VIEW dsm_datasource_api AS ( |
|
| 303 |
SELECT |
|
| 304 |
row_number() OVER (ORDER BY a.id) AS rowid, |
|
| 305 |
d.officialname, |
|
| 306 |
d.englishname, |
|
| 307 |
d.websiteurl, |
|
| 308 |
d.contactemail, |
|
| 309 |
d.registeredby, |
|
| 310 |
d.typology, |
|
| 311 |
d.platform, |
|
| 312 |
d.managed, |
|
| 313 |
a.protocol, |
|
| 314 |
a.contentdescription, |
|
| 315 |
a.active, |
|
| 316 |
a.removable, |
|
| 317 |
a.typology AS apitypology, |
|
| 318 |
a.compatibility, |
|
| 319 |
a.baseurl |
|
| 320 |
FROM dsm_datasources d LEFT OUTER JOIN dsm_api a ON (d.id = a.datasource)); |
|
| 321 |
grant select on dsm_datasource_api to dnetapi ; |
|
Also available in: Unified diff
huge update: swagger documentation, alignment of methods with the service trunk