Rack::Rewrite CSV Redirect Map Parsing For Drupal

config.ru

use Rack::Rewrite do
  CSV.read("redirects.csv", headers: true).each do |row|
    # Lol, yes we had redirects of source to destination, yay Drupal!
    if row["source"] != row["destination"]
      r301 row["source"], row["destination"]
    end
  end
end

drupal_marketing_url_redirects.sql

SELECT
  REPLACE(CONCAT('/', REPLACE(REPLACE(alias.alias, ' ', ''), ' ',''), '/'), '//', '/') AS source, # I don't know why there are two different space objects
  REPLACE(CONCAT('/', REPLACE(destination.field_destination_url_value, ' ', ''), '/'), '//', '/') AS destination
FROM node 
INNER JOIN field_data_field_destination_url destination
ON destination.entity_id = node.nid
INNER JOIN url_alias alias
ON alias.source = CONCAT('node/', node.nid)
WHERE type='marketing_url_redirect';

drupal_redirects.sql

SELECT
  REPLACE(CONCAT('/', REPLACE(REPLACE(IF(ISNULL(node.nid), redirect.source, node_alias.alias), ' ', ''), ' ',''), '/'), '//', '/') AS source,
  REPLACE(CONCAT('/', REPLACE(IF(ISNULL(alias.alias), redirect.redirect, REPLACE(REPLACE(alias.alias, ' ', ''), ' ','')),'<front>',''), '/'), '//', '/') AS destination
FROM redirect
LEFT JOIN url_alias alias
ON redirect.redirect = alias.source
LEFT JOIN node
ON redirect.source = CONCAT('node/', node.nid)
LEFT JOIN url_alias node_alias
ON redirect.source = node_alias.source;

redirects.csv

Had to get some urls out of Drupal and into a Rack app, here's how I did it.