test_pragmas.rb

require "helper"

module SQLite3
  class TestPragmas < SQLite3::TestCase
    BIGENDIAN = ([1].pack("I") == [1].pack("N"))

    class DatabaseTracker < SQLite3::Database
      attr_reader :test_statements

      def initialize(...)
        @test_statements = []
        super
      end

      def execute(sql, bind_vars = [], &block)
        @test_statements << sql
        super
      end
    end

    def setup
      super
      @db = DatabaseTracker.new(":memory:")
    end

    def teardown
      @db.close
    end

    def test_temp_store_mode
      @db.temp_store = "memory"
      assert_equal 2, @db.temp_store
      @db.temp_store = 1
      assert_equal 1, @db.temp_store
    end

    def test_encoding
      @db.encoding = "utf-16le"
      assert_equal Encoding.find("utf-16le"), @db.encoding
    end

    def test_pragma_errors
      assert_raises(SQLite3::Exception) do
        @db.set_enum_pragma("foo", "bar", [])
      end

      assert_raises(SQLite3::Exception) do
        @db.set_boolean_pragma("read_uncommitted", "foo")
      end

      assert_raises(SQLite3::Exception) do
        @db.set_boolean_pragma("read_uncommitted", 42)
      end
    end

    def test_invalid_pragma
      assert_raises(SQLite3::Exception) do
        @db.journal_mode = 0
      end
    end

    def test_get_boolean_pragma
      refute(@db.get_boolean_pragma("read_uncommitted"))
    end

    def test_set_boolean_pragma
      @db.set_boolean_pragma("read_uncommitted", 1)

      assert(@db.get_boolean_pragma("read_uncommitted"))
    ensure
      @db.set_boolean_pragma("read_uncommitted", 0)
    end

    def test_optimize_with_no_args
      @db.optimize

      assert_equal(["PRAGMA optimize"], @db.test_statements)
    end

    def test_optimize_with_args
      @db.optimize(Constants::Optimize::DEFAULT)
      @db.optimize(Constants::Optimize::ANALYZE_TABLES | Constants::Optimize::LIMIT_ANALYZE)
      @db.optimize(Constants::Optimize::ANALYZE_TABLES | Constants::Optimize::DEBUG)
      @db.optimize(Constants::Optimize::DEFAULT | Constants::Optimize::CHECK_ALL_TABLES)

      assert_equal(
        [
          "PRAGMA optimize=18",
          "PRAGMA optimize=18",
          "PRAGMA optimize=3",
          "PRAGMA optimize=65554"
        ],
        @db.test_statements
      )
    end

    def test_encoding_uppercase
      assert_equal(Encoding::UTF_8, @db.encoding)

      @db.encoding = "UTF-16"
      native = BIGENDIAN ? Encoding::UTF_16BE : Encoding::UTF_16LE
      assert_equal(native, @db.encoding)

      @db.encoding = "UTF-16LE"
      assert_equal(Encoding::UTF_16LE, @db.encoding)

      @db.encoding = "UTF-16BE"
      assert_equal(Encoding::UTF_16BE, @db.encoding)

      @db.encoding = "UTF-8"
      assert_equal(Encoding::UTF_8, @db.encoding)
    end

    def test_encoding_lowercase
      assert_equal(Encoding::UTF_8, @db.encoding)

      @db.encoding = "utf-16"
      native = BIGENDIAN ? Encoding::UTF_16BE : Encoding::UTF_16LE
      assert_equal(native, @db.encoding)

      @db.encoding = "utf-16le"
      assert_equal(Encoding::UTF_16LE, @db.encoding)

      @db.encoding = "utf-16be"
      assert_equal(Encoding::UTF_16BE, @db.encoding)

      @db.encoding = "utf-8"
      assert_equal(Encoding::UTF_8, @db.encoding)
    end

    def test_encoding_objects
      assert_equal(Encoding::UTF_8, @db.encoding)

      @db.encoding = Encoding::UTF_16
      native = BIGENDIAN ? Encoding::UTF_16BE : Encoding::UTF_16LE
      assert_equal(native, @db.encoding)

      @db.encoding = Encoding::UTF_16LE
      assert_equal(Encoding::UTF_16LE, @db.encoding)

      @db.encoding = Encoding::UTF_16BE
      assert_equal(Encoding::UTF_16BE, @db.encoding)

      @db.encoding = Encoding::UTF_8
      assert_equal(Encoding::UTF_8, @db.encoding)
    end
  end
end