From ed1b747b85876122e0b7b11aaabcc877c6f819b9 Mon Sep 17 00:00:00 2001
From: Yves Senn <yves.senn@gmail.com>
Date: Tue, 3 Jun 2014 13:46:32 +0200
Subject: pg test, examples for default values and schema dumping of point
 types.

/cc @sgrif
---
 .../cases/adapters/postgresql/geometric_test.rb     | 21 +++++++++++++++++++++
 activerecord/test/support/schema_dumping_helper.rb  | 11 +++++++++++
 2 files changed, 32 insertions(+)
 create mode 100644 activerecord/test/support/schema_dumping_helper.rb

diff --git a/activerecord/test/cases/adapters/postgresql/geometric_test.rb b/activerecord/test/cases/adapters/postgresql/geometric_test.rb
index 775b1d2d69..89a72f08b4 100644
--- a/activerecord/test/cases/adapters/postgresql/geometric_test.rb
+++ b/activerecord/test/cases/adapters/postgresql/geometric_test.rb
@@ -1,11 +1,13 @@
 # -*- coding: utf-8 -*-
 require "cases/helper"
 require 'support/connection_helper'
+require 'support/schema_dumping_helper'
 require 'active_record/base'
 require 'active_record/connection_adapters/postgresql_adapter'
 
 class PostgresqlPointTest < ActiveRecord::TestCase
   include ConnectionHelper
+  include SchemaDumpingHelper
 
   class PostgresqlPoint < ActiveRecord::Base; end
 
@@ -14,6 +16,8 @@ class PostgresqlPointTest < ActiveRecord::TestCase
     @connection.transaction do
       @connection.create_table('postgresql_points') do |t|
         t.column :x, :point
+        t.column :y, :point, default: [12.2, 13.3]
+        t.column :z, :point, default: "(14.4,15.5)"
       end
     end
   end
@@ -32,6 +36,23 @@ class PostgresqlPointTest < ActiveRecord::TestCase
     assert_not column.array
   end
 
+  def test_default
+    column = PostgresqlPoint.columns_hash["y"]
+    assert_equal [12.2, 13.3], column.default
+    assert_equal [12.2, 13.3], PostgresqlPoint.new.y
+
+    column = PostgresqlPoint.columns_hash["z"]
+    assert_equal [14.4, 15.5], column.default
+    assert_equal [14.4, 15.5], PostgresqlPoint.new.z
+  end
+
+  def test_schema_dumping
+    output = dump_table_schema("postgresql_points")
+    assert_match %r{t\.string\s+"x"$}, output
+    assert_match %r{t\.string\s+"y",\s+default: \[12\.2, 13\.3\]$}, output
+    assert_match %r{t\.string\s+"z",\s+default: \[14\.4, 15\.5\]$}, output
+  end
+
   def test_roundtrip
     PostgresqlPoint.create! x: [10, 25.2]
     record = PostgresqlPoint.first
diff --git a/activerecord/test/support/schema_dumping_helper.rb b/activerecord/test/support/schema_dumping_helper.rb
new file mode 100644
index 0000000000..2ae8d299e5
--- /dev/null
+++ b/activerecord/test/support/schema_dumping_helper.rb
@@ -0,0 +1,11 @@
+module SchemaDumpingHelper
+  def dump_table_schema(table, connection = ActiveRecord::Base.connection)
+    old_ignore_tables = ActiveRecord::SchemaDumper.ignore_tables
+    ActiveRecord::SchemaDumper.ignore_tables = connection.tables - [table]
+    stream = StringIO.new
+    ActiveRecord::SchemaDumper.dump(ActiveRecord::Base.connection, stream)
+    stream.string
+  ensure
+    ActiveRecord::SchemaDumper.ignore_tables = old_ignore_tables
+  end
+end
-- 
cgit v1.2.3