Module: Sequel::JDBC::Derby::DatabaseMethods

Extended by:
Database::ResetIdentifierMangling
Includes:
Transactions
Defined in:
lib/sequel/adapters/jdbc/derby.rb

Overview

Instance methods for Derby Database objects accessed via JDBC.

Constant Summary collapse

PRIMARY_KEY_INDEX_RE = 
/\Asql\d+\z/i.freeze

Constants included from Transactions

Transactions::TRANSACTION_BEGIN, Transactions::TRANSACTION_COMMIT, Transactions::TRANSACTION_RELEASE_SP, Transactions::TRANSACTION_ROLLBACK, Transactions::TRANSACTION_ROLLBACK_SP, Transactions::TRANSACTION_SAVEPOINT

Instance Method Summary collapse

Methods included from Database::ResetIdentifierMangling

extended

Methods included from Transactions

#supports_savepoints?, #supports_transaction_isolation_levels?

Instance Method Details

#cast_type_literal(type) ⇒ Object

Derby doesn’t support casting integer to varchar, only integer to char, and char(254) appears to have the widest support (with char(255) failing). This does add a bunch of extra spaces at the end, but those will be trimmed elsewhere.



29
30
31
 
# File 'lib/sequel/adapters/jdbc/derby.rb', line 29

def cast_type_literal(type)
  (type == String) ? 'CHAR(254)' : super
end

#database_type ⇒ Object

Derby uses the :derby database type.



34
35
36
 
# File 'lib/sequel/adapters/jdbc/derby.rb', line 34

def database_type
  :derby
end

#serial_primary_key_options ⇒ Object

Derby uses an IDENTITY sequence for autoincrementing columns.



39
40
41
 
# File 'lib/sequel/adapters/jdbc/derby.rb', line 39

def serial_primary_key_options
  {:primary_key => true, :type => :integer, :identity=>true, :start_with=>1}
end

#supports_transactional_ddl? ⇒ Boolean

Derby supports transaction DDL statements.

Returns:

  • (Boolean) 


53
54
55
 
# File 'lib/sequel/adapters/jdbc/derby.rb', line 53

def supports_transactional_ddl?
  true
end

#svn_version ⇒ Object

The SVN version of the database.



44
45
46
47
48
49
50
 
# File 'lib/sequel/adapters/jdbc/derby.rb', line 44

def svn_version
  @svn_version ||= begin
    v = synchronize{|c| c.get_meta_data.get_database_product_version}
    v =~ /\((\d+)\)\z/
    $1.to_i
  end
end