<%
  def fixture_data(name)
    render_binary("#{RAILS_ROOT}/test/fixtures/#{name}")
  end
  
  class ActiveRecord::ConnectionAdapters::PostgreSQLAdapter < ActiveRecord::ConnectionAdapters::AbstractAdapter
    def quote(value, column = nil)
      if (value.kind_of?(String) && column && column.type == :binary) || (value.kind_of?(String) && value.include?(0))
        "'#{escape_bytea(value)}'"
      else
        super
      end
    end
  end
  
  def render_binary(filename)
    "!binary | #{[File.open(filename,'rb').read].pack('m').gsub(/\n/,"\n    ")}\n"
  end
%>
picture_data_1:
  id: 1
  picture_id: 1
  data: <%= fixture_data("picture_data_1.jpg") %>
picture_data_2:
  id: 2
  picture_id: 2
  data: <%= fixture_data("picture_data_2.gif") %>
<% 3.upto(15) do |index| %>
picture_data_<%= index %>:
  id: <%= index %>
  picture_id: <%= index %>
  data: <%= fixture_data("picture_data_#{(index%2) + 1}.#{(((index%2) + 1) == 1) ? 'jpg' : 'gif'}") %>
<% end %>
<% 16.upto(40) do |index| %>
picture_data_<%= index %>:
  id: <%= index %>
  picture_id: <%= index %>
  data: <%= fixture_data("picture_data_#{(index%2) + 1}.#{(((index%2) + 1) == 1) ? 'jpg' : 'gif'}") %>
<% end %>