Contents

require 'pathname'
require Pathname(__FILE__).dirname.expand_path.parent + 'spec_helper'

unless JRUBY
  require 'date'

  describe DataObjects::Mysql::Command, "Quoting" do
    include MysqlSpecHelpers

    before :each do
      setup_test_environment
    end

    after :each do
      teardown_test_environment
    end

    it "should escape strings properly" do
      command = @connection.create_command("SELECT * FROM widgets WHERE name = ?")
      command.quote_string("Willy O'Hare & Johnny O'Toole").should == "'Willy O\\'Hare & Johnny O\\'Toole'".dup
      command.quote_string("The\\Backslasher\\Rises\\Again").should == "'The\\\\Backslasher\\\\Rises\\\\Again'"
      command.quote_string("Scott \"The Rage\" Bauer").should == "'Scott \\\"The Rage\\\" Bauer'"
    end

    it "should quote DateTime instances properly" do
      command = @connection.create_command("SELECT * FROM widgets WHERE release_datetime >= ?")
      dt = DateTime.now
      command.quote_datetime(dt).should == "'#{dt.strftime('%Y-%m-%d %H:%M:%S')}'"
    end

    it "should quote Time instances properly" do
      command = @connection.create_command("SELECT * FROM widgets WHERE release_timestamp >= ?")
      dt = Time.now
      command.quote_time(dt).should == "'#{dt.strftime('%Y-%m-%d %H:%M:%S')}'"
    end

    it "should quote Date instances properly" do
      command = @connection.create_command("SELECT * FROM widgets WHERE release_date >= ?")
      dt = Date.today
      command.quote_date(dt).should == "'#{dt.strftime('%Y-%m-%d')}'"
    end

  end

end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
do_mysql-0.9.10	spec/integration/quoting_spec.rb
do_mysql-0.9.10.1	spec/integration/quoting_spec.rb
do_mysql-0.9.11	spec/integration/quoting_spec.rb