Creating migrations for SQL views in rails with boolean values?

I found the solution: 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).

I found the solution: # 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).

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.