在具有布尔值的Rails中为SQL视图创建迁移

我找到了解决方案:

# First create the sql needed with the parameters, this way
# the query will change depeding on the database
sql = Marca.send(:construct_finder_sql, 
                  :select => "fecha_importacion, 0 AS total, id AS errores, estado",
                  :conditions => { :valido => false, :parent_id => 0}
                  :group => "marcas.fecha_importacion"
                 )

# Add the sql where needed
sql = "CREATE VIEW view_importaciones AS
  SELECT fecha_importacion, COUNT(DISTINCT(total)) - 1 AS total, COUNT(DISTINCT(errores)) -1 AS errores, estado FROM
    (
      SELECT fecha_importacion, id AS total, 0 as errores, estado FROM marcas WHERE parent_id = 0
      UNION
      #{sql}
    ) AS importaciones GROUP BY fecha_importacion ORDER BY fecha_importacion"
# Run the sql
execute(sql)