Get node details from Drupal
Currently I'm trying to migrate my blog from drupal to something must lighter, migrating data is indeed the first step!
A simple SQL statement was very useful to get the node details, which will be very useful in making a custom made CMS.
This is very tiny entry in my blog to remind me that the migration is still pending!
THE SQL CODE TO GET DRUPAL NODE DETAILS :
"SELECT node.nid as id,
node.status as status,
revision.title as title,
revision.body as body
FROM node_revisions as revision
JOIN node as node
ON node.nid = revision.nid
WHERE node.status = 1
ORDER BY node.nid
DESC ";
The above got simple does the below :
Gets the id and status from node table.
Gets Title and body from revisions table.
For all linked node and revisions which is published (i.e status = 1 and ids are same).
Orders them by node id from the latest to oldest entries.
Hope this helps the one who is pawing at some raw Drupal data!
![Share this](/sites/all/modules/addtoany/images/share_save_171_16.png)
Recent blog posts
- watir-webdriver web inspector
- gem list to gemfile
- Packing ruby2.0 on debian.
- Made it into The Guinness Book!
- to_h in ruby 2.0
- Filter elements by pattern jQuery.
- Better HTML password fields for mobile ?
- Grayscale image when user offline
- nth-child CSS pseudo-class Christmas colors
- EventEmitter in nodejs