ariejan

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package nl.kabisa.mgl.rssninja.beans;

import java.io.IOException;
import java.util.Date;
import java.util.logging.Level;

ariejan

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package nl.kabisa.mgl.rssninja.beans;

import java.io.IOException;
import java.util.Date;
import java.util.logging.Level;

ariejan

package suncertify.db;

/**
 * An interface implemented by classes that allow access to the
 * bookings database.
 *
 * @author Sun Microsystems
 * @version 1.0
 */
public interface DBMain {

ariejan

# lib/monkey.rb
module Authlogic
  module ControllerAdapters
    class RailsAdapter 
      def cookie_domain
        #cookie domain can be found in ApplicationController
        controller.cookie_domain
      end
    end
  end

ariejan

# IMPORTANT: This file is generated by cucumber-rails - edit at your own peril.
# It is recommended to regenerate this file in the future when you upgrade to a 
# newer version of cucumber-rails. Consider adding your own code to a new file 
# instead of editing this one. Cucumber will automatically load all features/**/*.rb
# files.

ENV["RAILS_ENV"] ||= "test"
require File.expand_path(File.dirname(__FILE__) + '/../../config/environment')

require 'cucumber/formatter/unicode' # Remove this line if you don't want Cucumber Unicode support

ariejan

$ master ★ $ time rake spec
.

Finished in 0.385567 seconds

1 example, 0 failures

real	2m19.023s
user	0m34.373s
sys	0m5.892s

ariejan

class MagicWorker
  def self.perform(*args)
    logger.info("This is a stub worker.")
  end
end

ariejan

# Use MacPorts, least priority

# For the amazon-ec2 gem
export EC2_URL="https://eu-west-1.ec2.amazonaws.com"

# jEdit with large memory allocation
alias jedit='java -Xms512m -Xmx1024m -jar /Applications/jEdit.app/Contents/Resources/Java/jedit.jar'

## export PATH=/opt/local/bin:/opt/local/sbin:$PATH
export PATH=/Users/ariejan/.homebrew/bin:/opt/local/bin:/opt/local/sbin:$PATH:/usr/local/bin:/usr/local/sbin

ariejan

### SQL
# Use the below query in Sequel Pro => Export to XML
#
# This includes tags, not categories
#
# SELECT p.ID, p.post_date, p.post_content, p.post_title, p.post_name, GROUP_CONCAT(t.name SEPARATOR ', ') AS tags
# FROM wp_posts p
# LEFT JOIN wp_term_relationships tr ON tr.object_id = p.id
# LEFT JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
# LEFT JOIN wp_terms t ON tt.term_id = t.term_id

ariejan

SELECT p.name, t.tag_name
FROM product p
LEFT JOIN tag t ON p.tag_id = t.id

1 | Product A | Ruby
1 | Product A | Rails
2 | Product B | Ruby

How can I change this query to return: