require "bundler/inline"

gemfile(true) do
  source "https://rubygems.org/"
  gem "tiny_tds"
  gem "activerecord", "6.1.4"
  gem "activerecord-sqlserver-adapter", "6.1.0.0"
end

require "active_record"
require "minitest/autorun"
require "logger"

ActiveRecord::Base.establish_connection(
  adapter:  "sqlserver",
  timeout:  5000,
  pool:     100,
  encoding: "utf8",
  database: "mydatabase",
  username: "myusername",
  password: "mypassword",
  host:     "myhost",
  port:     1433,
)
ActiveRecord::Base.logger = Logger.new(STDOUT)

ActiveRecord::Schema.define do
  drop_table :bugs rescue nil

  create_table :bugs, force: true do |t|
    t.date :report_date
  end
end

Bug = Class.new(ActiveRecord::Base)

class BugTest < Minitest::Test
  def test_date_range
    date_1 = Date.new(2021, 8, 7)
    date_2 = Date.new(2021, 8, 7)

    Bug.create!(report_date: date_2)

    assert_equal 1, Bug.where(report_date: date_2..Date::Infinity.new).count
  end
end