Contents

require "spec_helper"

describe "Simple::SQL.ask" do
  def expects(expected_result, sql, *args)
    expect(SQL.ask(sql, *args)).to eq(expected_result)
  end

  let!(:users) { 1.upto(USER_COUNT).map { create(:user) } }

  it "calls the database" do
    expect(User.count).to eq(2)

    expects 2, "SELECT COUNT(*) FROM users"
    expects 1, "SELECT COUNT(*) FROM users WHERE id=$1", users.first.id
    expects 0, "SELECT COUNT(*) FROM users WHERE id=$1", -1
    expects nil, "SELECT id FROM users WHERE FALSE"
  end
end

Version data entries

88 entries across 88 versions & 1 rubygems

Version	Path
simple-sql-0.5.37	spec/simple/sql/ask_spec.rb
simple-sql-0.5.36	spec/simple/sql/ask_spec.rb
simple-sql-0.5.35	spec/simple/sql/ask_spec.rb
simple-sql-0.5.34	spec/simple/sql/ask_spec.rb
simple-sql-0.5.33	spec/simple/sql/ask_spec.rb
simple-sql-0.5.32	spec/simple/sql/ask_spec.rb
simple-sql-0.5.31	spec/simple/sql/ask_spec.rb
simple-sql-0.5.30	spec/simple/sql/ask_spec.rb
simple-sql-0.5.29	spec/simple/sql/ask_spec.rb
simple-sql-0.5.28	spec/simple/sql/ask_spec.rb
simple-sql-0.5.27	spec/simple/sql/ask_spec.rb
simple-sql-0.5.26	spec/simple/sql/ask_spec.rb
simple-sql-0.5.25	spec/simple/sql/ask_spec.rb
simple-sql-0.5.24	spec/simple/sql/ask_spec.rb
simple-sql-0.5.23	spec/simple/sql/ask_spec.rb
simple-sql-0.5.22	spec/simple/sql/ask_spec.rb
simple-sql-0.5.21	spec/simple/sql/ask_spec.rb
simple-sql-0.5.20	spec/simple/sql/ask_spec.rb
simple-sql-0.5.19	spec/simple/sql/ask_spec.rb
simple-sql-0.5.18	spec/simple/sql/ask_spec.rb