Sha256: 317c9129e3ddc3a6437908e9213f092c3dea545f6e662afc7790c72425c5c2fb
Contents?: true
Size: 1.96 KB
Versions: 2
Compression:
Stored size: 1.96 KB
Contents
Sequel.require 'adapters/shared/sqlite' module Sequel module JDBC # Database and Dataset support for SQLite databases accessed via JDBC. module SQLite # Instance methods for SQLite Database objects accessed via JDBC. module DatabaseMethods include Sequel::SQLite::DatabaseMethods LAST_INSERT_ROWID = 'SELECT last_insert_rowid()'.freeze FOREIGN_KEY_ERROR_RE = /query does not return ResultSet/.freeze # Swallow pointless exceptions when the foreign key list pragma # doesn't return any rows. def foreign_key_list(table, opts={}) super rescue Sequel::DatabaseError => e raise unless e.message =~ FOREIGN_KEY_ERROR_RE [] end # Swallow pointless exceptions when the index list pragma # doesn't return any rows. def indexes(table, opts={}) super rescue Sequel::DatabaseError => e raise unless e.message =~ FOREIGN_KEY_ERROR_RE {} end private # 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 # 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 # 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 end # Dataset class for SQLite datasets accessed via JDBC. class Dataset < JDBC::Dataset include Sequel::SQLite::DatasetMethods end end end end
Version data entries
2 entries across 2 versions & 1 rubygems
Version | Path |
---|---|
sequel-3.34.1 | lib/sequel/adapters/jdbc/sqlite.rb |
sequel-3.34.0 | lib/sequel/adapters/jdbc/sqlite.rb |