module Sequel::JDBC::SQLite::DatabaseMethods

def connection_pool_default_options

Default to a single connection for a memory database. 
def connection_pool_default_options
  o = super
  uri == 'jdbc:sqlite::memory:' ? o.merge(:max_connections=>1) : o
end

def last_insert_id(conn, opts={})

Use last_insert_rowid() to get the last inserted id. 
def last_insert_id(conn, opts={})
  statement(conn) do |stmt|
    rs = stmt.executeQuery(LAST_INSERT_ROWID)
    rs.next
    rs.getInt(1)
  end
end

def setup_connection(conn)

Execute the connection pragmas on the connection. 
def setup_connection(conn)
  conn = super(conn)
  statement(conn) do |stmt|
    connection_pragmas.each{|s| log_yield(s){stmt.execute(s)}}
  end
  conn
end