Contents

require 'spec_helper'
require 'libsql/sqlite3'
require 'rbconfig'

describe "::Libsql::SQLite3" do
  it "is threadsafe is ruby is compiled with pthread support, in this case that is (#{RbConfig::CONFIG['configure_args'].include?( "--enable-pthread" )})" do
    ::Libsql::SQLite3.threadsafe?.should eql(RbConfig::CONFIG['configure_args'].include?( "--enable-pthread" ))
  end

  it "knows if an SQL statement is complete" do
    ::Libsql::SQLite3.complete?("SELECT * FROM sometable;").should eql(true)
    #::Libsql::SQLite3.complete?("SELECT * FROM sometable;", :utf16 => true).should eql(true)
  end
  
  it "knows if an SQL statement is not complete" do
    ::Libsql::SQLite3.complete?("SELECT * FROM sometable ").should eql(false)
    #::Libsql::SQLite3.complete?("SELECT * FROM sometable WHERE ", :utf16 => true).should eql(false)
  end

  it "can produce random data" do
    ::Libsql::SQLite3.randomness( 42 ).size.should eql(42)
  end

  it "has nil for the default sqlite temporary directory" do
    ::Libsql::SQLite3.temp_directory.should eql(nil)
  end

  it "can set the temporary directory" do
    ::Libsql::SQLite3.temp_directory.should eql(nil)
    ::Libsql::SQLite3.temp_directory = "/tmp/testing"
    ::Libsql::SQLite3.temp_directory.should eql("/tmp/testing")
    ::Libsql::SQLite3.temp_directory = nil
    ::Libsql::SQLite3.temp_directory.should eql(nil)
  end

  it "can escape quoted strings" do
    ::Libsql::SQLite3.escape( "It's a happy day!" ).should eql("It''s a happy day!")
  end

  it "can escape a symble into a string" do
    ::Libsql::SQLite3.escape( :stuff ).should eql("stuff")
    ::Libsql::SQLite3.escape( :"stuff'n" ).should eql("stuff''n")
  end

  it "can quote and escape single quoted strings" do
    ::Libsql::SQLite3.quote( "It's a happy day!" ).should eql("'It''s a happy day!'")
  end

  it "can quote and escape symbols" do
    ::Libsql::SQLite3.quote( :stuff ).should eql("'stuff'")
    ::Libsql::SQLite3.quote( :"stuff'n" ).should eql("'stuff''n'")
  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
libsql-0.1.0-x64-mingw-ucrt	spec/sqlite3_spec.rb
libsql-0.1.0-x64-mingw32	spec/sqlite3_spec.rb
libsql-0.1.0-x86-mingw32	spec/sqlite3_spec.rb
libsql-0.1.0	spec/sqlite3_spec.rb