Class: OCI8::Metadata::Database

Inherits:
Base
  • Object
show all
Defined in:
lib/oci8/metadata.rb

Overview

Metadata for a database.

This is returned by:

  • OCI8#describe_database(database_name)

Instance Method Summary collapse

Methods inherited from Base

#obj_id, #obj_link, #obj_name, #obj_schema

Instance Method Details

#autocommit_ddl ⇒ Object

Is autocommit mode required for DDL statements? Values are :ac_ddl and :no_ac_ddl



1856
1857
1858
1859
1860
1861
 
# File 'lib/oci8/metadata.rb', line 1856

def autocommit_ddl
  case attr_get_ub1(OCI_ATTR_AUTOCOMMIT_DDL)
  when 0; :ac_ddl
  when 1; :no_ac_ddl
  end
end

#catalog_location ⇒ Object

Position of the catalog in a qualified table. Values are :cl_start and :cl_end



1829
1830
1831
1832
1833
1834
 
# File 'lib/oci8/metadata.rb', line 1829

def catalog_location
  case attr_get_ub1(OCI_ATTR_CATALOG_LOCATION)
  when 0; :cl_start
  when 1; :cl_end
  end
end

#charset_id ⇒ Object

database character set Id



1783
1784
1785
 
# File 'lib/oci8/metadata.rb', line 1783

def charset_id
  attr_get_ub2(OCI_ATTR_CHARSET_ID)
end

#charset_name ⇒ Object

database character set name



1873
1874
1875
 
# File 'lib/oci8/metadata.rb', line 1873

def charset_name
  __charset_name(charset_id)
end

#cursor_commit_behavior ⇒ Object

How a COMMIT operation affects cursors and prepared statements in the database. Values are:

:cusror_open

preserve cursor state as before the commit operation

:cursor_closed

cursors are closed on COMMIT, but the application can still re-execute the statement without re-preparing it



1815
1816
1817
1818
1819
1820
 
# File 'lib/oci8/metadata.rb', line 1815

def cursor_commit_behavior
  case attr_get_ub1(OCI_ATTR_CURSOR_COMMIT_BEHAVIOR)
  when 0; :cusror_open
  when 1; :cursor_closed
  end
end

#inspect ⇒ Object

:nodoc:



1887
1888
1889
 
# File 'lib/oci8/metadata.rb', line 1887

def inspect # :nodoc:
  "#<#{self.class.name}:(#{obj_id}) #{obj_name} #{version}>"
end

#locking_mode ⇒ Object

Locking mode for the database. Values are :lock_immediate and :lock_delayed



1865
1866
1867
1868
1869
1870
 
# File 'lib/oci8/metadata.rb', line 1865

def locking_mode
  case attr_get_ub1(OCI_ATTR_LOCKING_MODE)
  when 0; :lock_immediate
  when 1; :lock_delayed
  end
end

#max_catalog_namelen ⇒ Object

Maximum length of a catalog (database) name



1823
1824
1825
 
# File 'lib/oci8/metadata.rb', line 1823

def max_catalog_namelen
  attr_get_ub1(OCI_ATTR_MAX_CATALOG_NAMELEN)
end

#max_column_len ⇒ Object

Maximum length of a column name



1804
1805
1806
 
# File 'lib/oci8/metadata.rb', line 1804

def max_column_len
  attr_get_ub4(OCI_ATTR_MAX_COLUMN_LEN)
end

#max_proc_len ⇒ Object

Maximum length of a procedure name



1799
1800
1801
 
# File 'lib/oci8/metadata.rb', line 1799

def max_proc_len
  attr_get_ub4(OCI_ATTR_MAX_PROC_LEN)
end

#ncharset_id ⇒ Object

database national language support character set Id



1788
1789
1790
 
# File 'lib/oci8/metadata.rb', line 1788

def ncharset_id
  attr_get_ub2(OCI_ATTR_NCHARSET_ID)
end

#ncharset_name ⇒ Object

database national language support character set name



1878
1879
1880
 
# File 'lib/oci8/metadata.rb', line 1878

def ncharset_name
  __charset_name(ncharset_id)
end

#nowait_support ⇒ Object

Does database support the nowait clause? Values are :nw_supported and :nw_unsupported



1847
1848
1849
1850
1851
1852
 
# File 'lib/oci8/metadata.rb', line 1847

def nowait_support
  case attr_get_ub1(OCI_ATTR_NOWAIT_SUPPORT)
  when 0; :nw_supported
  when 1; :nw_unsupported
  end
end

#savepoint_support ⇒ Object

Does database support savepoints? Values are :sp_supported and :sp_unsupported



1838
1839
1840
1841
1842
1843
 
# File 'lib/oci8/metadata.rb', line 1838

def savepoint_support
  case attr_get_ub1(OCI_ATTR_SAVEPOINT_SUPPORT)
  when 0; :sp_supported
  when 1; :sp_unsupported
  end
end

#schemas ⇒ Object

array of Schema objects in the database



1883
1884
1885
 
# File 'lib/oci8/metadata.rb', line 1883

def schemas
  @schemas ||= list_schemas.to_a
end

#version ⇒ Object

database version



1778
1779
1780
 
# File 'lib/oci8/metadata.rb', line 1778

def version
  attr_get_string(OCI_ATTR_VERSION)
end