Sha256: b6f9026c60b02def5ac8f461f0b3205b6bca1a619e11abd57724730fd9a7a598
Contents?: true
Size: 1.13 KB
Versions: 9
Compression:
Stored size: 1.13 KB
Contents
require File.join(File.dirname(File.expand_path(__FILE__)), "spec_helper")
describe "sql_comments extension" do
before do
@ds = Sequel.mock[:t].extension(:sql_comments)
end
it "should not add a comment if one is not set for the dataset" do
@ds.select_sql.must_equal 'SELECT * FROM t'
@ds.insert_sql(:a=>1).must_equal 'INSERT INTO t (a) VALUES (1)'
@ds.delete_sql.must_equal 'DELETE FROM t'
@ds.update_sql(:a=>1).must_equal 'UPDATE t SET a = 1'
end
it "should add a comment if one is set for the dataset" do
ds = @ds.comment("Some\nComment\r\n Here")
ds.select_sql.must_equal "SELECT * FROM t -- Some Comment Here\n"
ds.insert_sql(:a=>1).must_equal "INSERT INTO t (a) VALUES (1) -- Some Comment Here\n"
ds.delete_sql.must_equal "DELETE FROM t -- Some Comment Here\n"
ds.update_sql(:a=>1).must_equal "UPDATE t SET a = 1 -- Some Comment Here\n"
end
it "should handle comments used in nested datasets" do
ds = @ds.comment("Some\nComment\r\n Here")
ds.where(:id=>ds).select_sql.must_equal "SELECT * FROM t WHERE (id IN (SELECT * FROM t -- Some Comment Here\n)) -- Some Comment Here\n"
end
end
Version data entries
9 entries across 9 versions & 2 rubygems