test/functional/sql.rb in mosql-0.3.1 vs test/functional/sql.rb in mosql-0.3.2

@@ -5,25 +5,28 @@
     sequel.drop_table?(:test_upsert)
     sequel.create_table?(:test_upsert) do
       column :_id, 'INTEGER'
       column :color, 'TEXT'
       column :quantity, 'INTEGER'
+      column :numbers, 'INTEGER ARRAY'
       primary_key [:_id]
     end
 
     @adapter = MoSQL::SQLAdapter.new(nil, sql_test_uri)
     @table = sequel[:test_upsert]
   end
 
   describe 'upsert' do
     it 'inserts new items' do
-      @adapter.upsert!(@table, '_id', {'_id' => 0, 'color' => 'red', 'quantity' => 10})
-      @adapter.upsert!(@table, '_id', {'_id' => 1, 'color' => 'blue', 'quantity' => 5})
+      @adapter.upsert!(@table, '_id', {'_id' => 0, 'color' => 'red', 'quantity' => 10, 'numbers' => Sequel.pg_array([1, 2, 3], :integer)})
+      @adapter.upsert!(@table, '_id', {'_id' => 1, 'color' => 'blue', 'quantity' => 5, 'numbers' => Sequel.pg_array([], :integer)})
       assert_equal(2, @table.count)
       assert_equal('red',  @table[:_id => 0][:color])
       assert_equal(10,     @table[:_id => 0][:quantity])
       assert_equal('blue', @table[:_id => 1][:color])
       assert_equal(5,      @table[:_id => 1][:quantity])
+      assert_equal([1, 2, 3], @table[:_id => 0][:numbers])
+      assert_equal([], @table[:_id => 1][:numbers])
     end
 
     it 'updates items' do
       @adapter.upsert!(@table, '_id', {'_id' => 0, 'color' => 'red', 'quantity' => 10})
       assert_equal(1, @table.count)