Differences

This shows you the differences between two versions of the page.

--- drupal:databank [2025/01/28 18:58] – admin
+++ drupal:databank [2025/02/18 18:35] (current) – [alle dagboekbladen die nog niet werden afgeprint] admin
@@ Line 5: / Line 5: @@
 dit document beschrijft de databank in Drupal
 ===== tabellen=====
-  - nid: unieke node_id
+  - node: unieke node_id (nid)
   - node_field_data: metadata over node (aanmaak-, wijzigingsdatum, ...)
   - <nowiki>node_body</nowiki>: inhoud
@@ Line 14: / Line 14: @@
   - users_field_data: detail over gebruikers (naam, email, userid, ...)
   - <nowiki>node_field_<naam></nowiki>: velden die je gebruikt binnen je node.
+elke node heeft data in onderstaande tabellen
+  * node: nid, type (content type)
+  * node_body: eigenlijke inhoud van de node
+  * node_field_data: metadata over node: oa titel
+  * node_revision: info over revisies
+  * node_revision_body: inhoud van elke revisie
+  * node_field_revision: metadata over revisies
 ===== queries =====
@@ Line 69: / Line 77: @@
 ====alle dagboekbladen die nog niet werden afgeprint====
-<code>SELECT title AS "Entries in schrift" FROM l7gh_node_field_data LEFT JOIN l7gh_node__field_geprint_ ON l7gh_node_field_data.nid = entity_id WHERE field_geprint__value IS NULL AND type = 'dagboek';</code>
+<code>SELECT title AS "Entries in schrift" FROM l7gh_node_field_data LEFT JOIN l7gh_node__field_geprint_ ON l7gh_node_field_data.nid = entity_id WHERE field_geprint__value = 0 AND type = 'dagboek';</code>
 ====idem maar de dit keer met de node ID====
@@ Line 79: / Line 87: @@
 ====alle nodes van type verslag====
-SELECT f.title, FROM_UNIXTIME(f.created), b.body_value FROM `l7gh_node__body` b INNER JOIN l7gh_node_field_data f ON f.nid = b.entity_id WHERE b.bundle = 'verslag'
+<code>SELECT f.title, FROM_UNIXTIME(f.created), b.body_value FROM `l7gh_node__body` b INNER JOIN l7gh_node_field_data f ON f.nid = b.entity_id WHERE b.bundle = 'verslag'
+</code>