From 2dd0178229ccd5e7f19f120ded85fd4a80306cac Mon Sep 17 00:00:00 2001 From: Joel Date: Wed, 8 Feb 2012 14:21:10 -0800 Subject: Also support writing the hstore back to the database --- .../lib/active_record/connection_adapters/postgresql_adapter.rb | 5 +++++ activerecord/test/cases/adapters/postgresql/hstore_test.rb | 8 ++++++++ 2 files changed, 13 insertions(+) diff --git a/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb b/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb index 692848d3e5..a5af8a6845 100644 --- a/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb +++ b/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb @@ -476,6 +476,11 @@ module ActiveRecord return super unless column case value + when Hash + case column.sql_type + when 'hstore' then super(PostgreSQLColumn.hstore_to_string(value), column) + else super + end when Float return super unless value.infinite? && column.type == :datetime "'#{value.to_s.downcase}'" diff --git a/activerecord/test/cases/adapters/postgresql/hstore_test.rb b/activerecord/test/cases/adapters/postgresql/hstore_test.rb index 82c52b38a3..1644a58d92 100644 --- a/activerecord/test/cases/adapters/postgresql/hstore_test.rb +++ b/activerecord/test/cases/adapters/postgresql/hstore_test.rb @@ -86,6 +86,14 @@ class PostgresqlHstoreTest < ActiveRecord::TestCase assert_equal({"\"a"=>"q\"w"}, @column.type_cast('\"a=>q"w')) end + def test_rewrite + @connection.execute "insert into hstores (tags) VALUES ('1=>2')" + x = Hstore.find :first + x.tags = { '"a\'' => 'b' } + assert x.save! + end + + def test_select @connection.execute "insert into hstores (tags) VALUES ('1=>2')" x = Hstore.find :first -- cgit v1.2.3