#--
###############################################################################
#
# DBD::SQLite - a DBD for SQLite for versions < 3
#
# Uses Jamis Buck's 'sqlite-ruby' driver to interface with SQLite directly
#
# (c) 2008 Erik Hollensbe & Christopher Maujean.
#
# TODO
#
# fetch_scroll implementation?
# columns and column_info differ too much and have too much copied code, refactor
# there are probably some edge cases with transactions
#
################################################################################
#++

begin
    require 'rubygems'
    gem 'sqlite-ruby'
    gem 'dbi'
rescue Exception => e
end

require 'dbi'
require 'sqlite'

module DBI
    module DBD
        #
        # DBD::SQLite - Database Driver for SQLite versions 2.x and lower.
        #
        # Requires DBI and the 'sqlite-ruby' gem to work.
        #
        # Only things that extend DBI's results are documented.
        #
        class SQLite
            VERSION = "0.1.2"
            DESCRIPTION = "SQLite 2.x DBI DBD"

            #
            # returns 'SQLite'
            #
            # See DBI::TypeUtil#convert for more information.
            #
            def self.driver_name
                "SQLite"
            end

            #
            # Validates that the SQL has no literal NUL characters. (ASCII 0)
            #
            # SQLite apparently really hates it when you do that.
            #
            # It will raise DBI::DatabaseError should it find any.
            #
            def self.check_sql(sql)
                # XXX I'm starting to think this is less of a problem with SQLite
                # and more with the old C DBD
                raise DBI::DatabaseError, "Bad SQL: SQL cannot contain nulls" if sql =~ /\0/
            end

            #
            # Split a type definition into parts via String#match and return the whole result.
            #
            def self.parse_type(type_name)
                type_name.match(/^([^\(]+)(\((\d+)(,(\d+))?\))?$/)
            end

            #
            # See DBI::BaseDriver.
            #
            class Driver < DBI::BaseDriver
                def initialize
                    super "0.4.0"
                end

                def connect(dbname, user, auth, attr_hash)
                    return Database.new(dbname, user, auth, attr_hash)
                end
            end
        end
    end
end

require 'dbd/sqlite/database'
require 'dbd/sqlite/statement'

DBI::TypeUtil.register_conversion(DBI::DBD::SQLite.driver_name) do |obj|
    case obj
    when ::NilClass
        ["NULL", false]
    else 
        [obj, true]
    end
end