API: The status is now an object

[friendica.git] / static / dbview.config.php

diff --git a/static/dbview.config.php b/static/dbview.config.php
index 18cdc16e8762cad9eb304fcd23292fac9c469646..3caa7c0877c8d5a505c69310ac4a9a9683cc95bd 100644 (file)
--- a/static/dbview.config.php
+++ b/static/dbview.config.php
@@ -138,7 +138,6 @@
                        "uri-date" => ["contact", "uri-date"],
                        "avatar-date" => ["contact", "avatar-date"],
                        "thumb" => ["contact", "thumb"],
-                       "dfrn-id" => ["contact", "dfrn-id"],
                        "author-id" => ["post-user", "author-id"],
                        "author-link" => ["author", "url"],
                        "author-addr" => ["author", "addr"],
@@ -187,7 +186,6 @@
                        "event-location" => ["event", "location"],
                        "event-type" => ["event", "type"],
                        "event-nofinish" => ["event", "nofinish"],
-                       "event-adjust" => ["event", "adjust"],
                        "event-ignore" => ["event", "ignore"],
                        "signed_text" => ["diaspora-interaction", "interaction"],
                        "parent-guid" => ["parent-item-uri", "guid"],
@@ -195,6 +193,7 @@
                        "parent-author-id" => ["parent-post", "author-id"],
                        "parent-author-link" => ["parent-post-author", "url"],
                        "parent-author-name" => ["parent-post-author", "name"],
+                       "parent-author-nick" => ["parent-post-author", "nick"],
                        "parent-author-network" => ["parent-post-author", "network"],
                        "parent-author-blocked" => ["parent-post-author", "blocked"],
                        "parent-author-hidden" => ["parent-post-author", "hidden"],
@@ -298,7 +297,6 @@
                        "uri-date" => ["contact", "uri-date"],
                        "avatar-date" => ["contact", "avatar-date"],
                        "thumb" => ["contact", "thumb"],
-                       "dfrn-id" => ["contact", "dfrn-id"],
                        "author-id" => ["post-thread-user", "author-id"],
                        "author-link" => ["author", "url"],
                        "author-addr" => ["author", "addr"],
@@ -347,7 +345,6 @@
                        "event-location" => ["event", "location"],
                        "event-type" => ["event", "type"],
                        "event-nofinish" => ["event", "nofinish"],
-                       "event-adjust" => ["event", "adjust"],
                        "event-ignore" => ["event", "ignore"],
                        "signed_text" => ["diaspora-interaction", "interaction"],
                        "parent-guid" => ["parent-item-uri", "guid"],
@@ -443,7 +440,6 @@
                        "uri-date" => ["author", "uri-date"],
                        "avatar-date" => ["author", "avatar-date"],
                        "thumb" => ["author", "thumb"],
-                       "dfrn-id" => ["author", "dfrn-id"],
                        "author-id" => ["post", "author-id"],
                        "author-link" => ["author", "url"],
                        "author-addr" => ["author", "addr"],
@@ -563,7 +559,6 @@
                        "uri-date" => ["author", "uri-date"],
                        "avatar-date" => ["author", "avatar-date"],
                        "thumb" => ["author", "thumb"],
-                       "dfrn-id" => ["author", "dfrn-id"],
                        "author-id" => ["post-thread", "author-id"],
                        "author-link" => ["author", "url"],
                        "author-addr" => ["author", "addr"],
@@ -708,7 +703,6 @@
                        "self" => ["contact", "self"],
                        "remote_self" => ["contact", "remote_self"],
                        "rel" => ["contact", "rel"],
-                       "duplex" => ["contact", "duplex"],
                        "network" => ["contact", "network"],
                        "protocol" => ["contact", "protocol"],
                        "name" => ["contact", "name"],
@@ -716,17 +710,14 @@
                        "location" => ["contact", "location"],
                        "about" => ["contact", "about"],
                        "keywords" => ["contact", "keywords"],
-                       "gender" => ["contact", "gender"],
                        "xmpp" => ["contact", "xmpp"],
+                       "matrix" => ["contact", "matrix"],
                        "attag" => ["contact", "attag"],
                        "avatar" => ["contact", "avatar"],
                        "photo" => ["contact", "photo"],
                        "thumb" => ["contact", "thumb"],
                        "micro" => ["contact", "micro"],
                        "header" => ["contact", "header"],
-                       "site-pubkey" => ["contact", "site-pubkey"],
-                       "issued-id" => ["contact", "issued-id"],
-                       "dfrn-id" => ["contact", "dfrn-id"],
                        "url" => ["contact", "url"],
                        "nurl" => ["contact", "nurl"],
                        "uri-id" => ["contact", "uri-id"],
@@ -740,9 +731,6 @@
                        "poll" => ["contact", "poll"],
                        "confirm" => ["contact", "confirm"],
                        "poco" => ["contact", "poco"],
-                       "aes_allow" => ["contact", "aes_allow"],
-                       "ret-aes" => ["contact", "ret-aes"],
-                       "usehub" => ["contact", "usehub"],
                        "subhub" => ["contact", "subhub"],
                        "hub-verify" => ["contact", "hub-verify"],
                        "last-update" => ["contact", "last-update"],
@@ -771,9 +759,7 @@
                        "sensitive" => ["contact", "sensitive"],
                        "baseurl" => ["contact", "baseurl"],
                        "reason" => ["contact", "reason"],
-                       "closeness" => ["contact", "closeness"],
                        "info" => ["contact", "info"],
-                       "profile-id" => ["contact", "profile-id"],
                        "bdyear" => ["contact", "bdyear"],
                        "bd" => ["contact", "bd"],
                        "notify_new_posts" => ["contact", "notify_new_posts"],
@@ -840,6 +826,7 @@
                        "url" => ["contact", "url"],
                        "nurl" => ["contact", "nurl"],
                        "uri-id" => ["contact", "uri-id"],
+                       "guid" => ["item-uri", "guid"],
                        "addr" => ["contact", "addr"],
                        "alias" => ["contact", "alias"],
                        "name" => ["contact", "name"],
@@ -847,6 +834,7 @@
                        "about" => ["contact", "about"],
                        "keywords" => ["contact", "keywords"],
                        "xmpp" => ["contact", "xmpp"],
+                       "matrix" => ["contact", "matrix"],
                        "avatar" => ["contact", "avatar"],
                        "photo" => ["contact", "photo"],
                        "thumb" => ["contact", "thumb"],
@@ -909,6 +897,7 @@
                        "ap-statuses_count" => ["apcontact", "statuses_count"],
                ],
                "query" => "FROM `contact`
+                       LEFT JOIN `item-uri` ON `item-uri`.`id` = `contact`.`uri-id`
                        LEFT JOIN `apcontact` ON `apcontact`.`uri-id` = `contact`.`uri-id`
                        LEFT JOIN `fcontact` ON `fcontact`.`uri-id` = contact.`uri-id`
                        WHERE `contact`.`uid` = 0"                      
@@ -916,10 +905,12 @@
        "account-user-view" => [
                "fields" => [
                        "id" => ["ucontact", "id"],
+                       "pid" => ["contact", "id"],
                        "uid" => ["ucontact", "uid"],
                        "url" => ["contact", "url"],
                        "nurl" => ["contact", "nurl"],
                        "uri-id" => ["contact", "uri-id"],
+                       "guid" => ["item-uri", "guid"],
                        "addr" => ["contact", "addr"],
                        "alias" => ["contact", "alias"],
                        "name" => ["contact", "name"],
@@ -927,6 +918,7 @@
                        "about" => ["contact", "about"],
                        "keywords" => ["contact", "keywords"],
                        "xmpp" => ["contact", "xmpp"],
+                       "matrix" => ["contact", "matrix"],
                        "avatar" => ["contact", "avatar"],
                        "photo" => ["contact", "photo"],
                        "thumb" => ["contact", "thumb"],
@@ -940,7 +932,7 @@
                        "network" => ["contact", "network"],
                        "protocol" => ["ucontact", "protocol"],
                        "location" => ["contact", "location"],
-                       "attag" => ["contact", "attag"],
+                       "attag" => ["ucontact", "attag"],
                        "pubkey" => ["contact", "pubkey"],
                        "prvkey" => ["contact", "prvkey"],
                        "subscribe" => ["contact", "subscribe"],
@@ -956,7 +948,7 @@
                        "sensitive" => ["contact", "sensitive"],
                        "baseurl" => ["contact", "baseurl"],
                        "gsid" => ["contact", "gsid"],
-                       "info" => ["contact", "info"],
+                       "info" => ["ucontact", "info"],
                        "bdyear" => ["contact", "bdyear"],
                        "bd" => ["contact", "bd"],
                        "poco" => ["contact", "poco"],
@@ -980,12 +972,6 @@
                        "subhub" => ["ucontact", "subhub"],
                        "hub-verify" => ["ucontact", "hub-verify"],
                        "reason" => ["ucontact", "reason"],
-                       "dfrn-duplex" => ["ucontact", "duplex"],
-                       "dfrn-ret-aes" => ["ucontact", "ret-aes"],
-                       "dfrn-site-pubkey" => ["ucontact", "site-pubkey"],
-                       "dfrn-issued-id" => ["ucontact", "issued-id"],
-                       "dfrn-id" => ["ucontact", "dfrn-id"],
-                       "dfrn-aes_allow" => ["ucontact", "aes_allow"],
                        "dfrn-request" => ["contact", "request"],
                        "dfrn-notify" => ["contact", "notify"],
                        "dfrn-poll" => ["contact", "poll"],
@@ -1009,6 +995,7 @@
                ],
                "query" => "FROM `contact` AS `ucontact`
                        INNER JOIN `contact` ON `contact`.`uri-id` = `ucontact`.`uri-id` AND `contact`.`uid` = 0
+                       LEFT JOIN `item-uri` ON `item-uri`.`id` = `ucontact`.`uri-id`
                        LEFT JOIN `apcontact` ON `apcontact`.`uri-id` = `ucontact`.`uri-id`
                        LEFT JOIN `fcontact` ON `fcontact`.`uri-id` = `ucontact`.`uri-id` AND `fcontact`.`network` = 'dspr'"
        ],
@@ -1061,5 +1048,23 @@
                        INNER JOIN `workerqueue` ON `workerqueue`.`pid` = `process`.`pid`
                        WHERE NOT `workerqueue`.`done`"
        ],
+       "profile_field-view" => [
+               "fields" => [
+                       "id" => ["profile_field", "id"],
+                       "uid" => ["profile_field", "uid"],
+                       "label" => ["profile_field", "label"],
+                       "value" => ["profile_field", "value"],
+                       "order" => ["profile_field", "order"],
+                       "psid"=> ["profile_field", "psid"],
+                       "allow_cid" => ["permissionset", "allow_cid"],
+                       "allow_gid" => ["permissionset", "allow_gid"],
+                       "deny_cid" => ["permissionset", "deny_cid"],
+                       "deny_gid" => ["permissionset", "deny_gid"],
+                       "created" => ["profile_field", "created"],
+                       "edited" => ["profile_field", "edited"],
+               ],
+               "query" => "FROM `profile_field`
+                       INNER JOIN `permissionset` ON `permissionset`.`id` = `profile_field`.`psid`"
+       ],
 ];