Contents

require "spec_helper"

describe "Simple::SQL::Reflection" do
  describe ".columns" do
    it "returns the columns of a table in the public schema" do
      expect(SQL::Reflection.columns("users")).to include("first_name")
    end

    it "returns the columns of a table in a non-'public' schema" do
      expect(SQL::Reflection.columns("information_schema.tables")).to include("table_name")
    end
  end

  describe ".tables" do
    it "returns the tables in the public schema" do
      expect(SQL::Reflection.tables).to include("public.users")
    end

    it "returns tables in a non-'public' schema" do
      expect(SQL::Reflection.tables(schema: "information_schema")).to include("information_schema.tables")
    end
  end
end

Version data entries

30 entries across 30 versions & 1 rubygems

Version	Path
simple-sql-0.4.41	spec/simple/sql/reflection_spec.rb
simple-sql-0.4.40	spec/simple/sql/reflection_spec.rb
simple-sql-0.4.39	spec/simple/sql/reflection_spec.rb
simple-sql-0.4.38	spec/simple/sql/reflection_spec.rb
simple-sql-0.4.37	spec/simple/sql/reflection_spec.rb
simple-sql-0.4.36	spec/simple/sql/reflection_spec.rb
simple-sql-0.4.35	spec/simple/sql/reflection_spec.rb
simple-sql-0.5.0	spec/simple/sql/reflection_spec.rb
simple-sql-0.4.32	spec/simple/sql/reflection_spec.rb
simple-sql-0.4.31	spec/simple/sql/reflection_spec.rb
simple-sql-0.4.30	spec/simple/sql/reflection_spec.rb
simple-sql-0.4.29	spec/simple/sql/reflection_spec.rb
simple-sql-0.4.28	spec/simple/sql/reflection_spec.rb
simple-sql-0.4.27	spec/simple/sql/reflection_spec.rb
simple-sql-0.4.26	spec/simple/sql/reflection_spec.rb
simple-sql-0.4.25	spec/simple/sql/reflection_spec.rb
simple-sql-0.4.24	spec/simple/sql/reflection_spec.rb
simple-sql-0.4.23	spec/simple/sql/reflection_spec.rb
simple-sql-0.4.22	spec/simple/sql/reflection_spec.rb
simple-sql-0.4.21	spec/simple/sql_reflection_spec.rb