Peter's Blog

Do you have example of the code that you use to scan your post and add the tags?? I think it would be helpful to other people who are interested in doing something similar.

The code is part of a rather hacky python script. I won't post the whole thing but an old version is here. This is executed just after using the metaWeblog api to post or edit the node into drupal. It adds awtags tags by poking the database directly.

Entry conditions:

oNid

node number for post just added/edited. May be a string, may be an int, depends on subtleties of xmlrpc

strBody

body of the post

   1  #
   2  # Search for awtags and add automatically.
   3  #
   4  import MySQLdb
   5  
   6  oConnection = MySQLdb.Connect( 'localhost', 'username', 'password', 'database')
   7  
   8  #
   9  # Get a list of all available tags
  10  #
  11  oCursor = oConnection.cursor()
  12  oCursor.execute( 'SELECT tid, tag FROM awtags')
  13  
  14  #
  15  # Delete existing tags mapped to the node.
  16  #
  17  oCursor2 = oConnection.cursor()
  18  oCursor2.execute( 'DELETE FROM awtags_node WHERE nid = %d;' % int(oNid))
  19  
  20  #
  21  # Go through each tag searching the post for the tag word
  22  #
  23  while 1:
  24      oRow = oCursor.fetchone()
  25      if not oRow:
  26          break
  27  
  28      #
  29      # Use a regular expression to do the searching.
  30      #
  31      oMatch = re.search( r'\b' + oRow[1] + r'\b', strBody, re.IGNORECASE)
  32      if oMatch:
  33          #
  34          # Found tag word so add a mapping from the tad id to the
  35          # node id.
  36          #
  37          oCursor2.execute( '''INSERT INTO awtags_node (nid, tid)
  38                               VALUES( %d, %d);''' % ( int(oNid),
  39                               oRow[0]))

In another script (part of the microblog) I already have code that can add new tags to awtags so sometime I might tidy up the email posting script (depends on finding the time). It's also worth bearing in mind that drupal 4.7 is imminent and it has native free tagging support (at last) so I might be waving awtags bye bye.

Peter