require 'spec_helper'

describe "SET datatype" do

  describe "schema dump" do
    before { load_schema "set_old" }
    subject { dumped_schema }

    it "dumps native format" do
      subject.should match %r{t\.set\s+"gadgets",\s+:limit => \["propeller", "tail gun", "gps"\]}
    end

    it "dumps default option" do
      subject.should match %r{t\.set\s+"gadgets",.+:default => \["propeller", "gps"\]}
    end

    it "dumps null option" do
      subject.should match %r{t\.set\s+"gadgets",.+:null => false$}
    end
  end

  describe "schema loading" do
    before { load_schema "set_new" }
    subject { ActiveRecord::Base.connection.select_one "SHOW FIELDS FROM balloons WHERE Field='ribbons'" }

    it "loads native format" do
      subject[ "Type" ].should == "set('red','green','gold')"
    end

    it "loads default option" do
      subject[ "Default" ].should == "green,gold"
    end

    it "loads null option" do
      subject[ "Null" ].should == "NO"
    end

    it "loads native column format" do
      subject = ActiveRecord::Base.connection.select_one "SHOW FIELDS FROM balloons WHERE Field='gasses'"
      subject[ "Type" ].should == "set('helium','hydrogen')"
    end
  end

  describe "assignment" do
    before { load_schema "set_new" }
    it "accepts single value" do
      b = Balloon.create :gasses => "helium"
      b.should be_valid
      b.reload.gasses.should == "helium"
    end
    it "accepts array of values" do
      b = Balloon.create :gasses => [ "helium", "hydrogen" ]
      b.should be_valid
      b.reload.gasses.should == "helium,hydrogen"
    end
    it "accepts comma-separated values" do
      b = Balloon.create :gasses => "helium,hydrogen"
      b.should be_valid
      b.reload.gasses.should == "helium,hydrogen"
    end
    it "accepts empty list" do
      b = Balloon.create :gasses => [ ]
      b.should be_valid
      b.reload.gasses.should == ""
    end
  end

  describe "getter" do
    before do
      load_schema "set_new"
      ActiveRecord::Base.connection.execute "INSERT INTO balloons (gasses) VALUES ('helium,hydrogen')"
      @b = Balloon.first
    end
    it "returns comma-separated values by default" do
      @b.gasses.should == "helium,hydrogen"
    end
    it "returns array of values when config option is set"
  end
end

class Balloon < ActiveRecord::Base; end