Class: M4DBI::Statement

Inherits:
Object show all
Defined in:
lib/m4dbi/statement.rb

Instance Method Summary collapse

Constructor Details

#initialize(rdbi_statement) ⇒ Statement

Returns a new instance of Statement.



3
4
5
 
# File 'lib/m4dbi/statement.rb', line 3

def initialize( rdbi_statement )
  @st = rdbi_statement
end

Instance Method Details

#execute(*args) ⇒ Object Also known as: update, u, insert, i, delete, d 



7
8
9
 
# File 'lib/m4dbi/statement.rb', line 7

def execute( *args )
  @st.execute *args
end

#select(*bindvars) ⇒ Object Also known as: select_all, s 



11
12
13
 
# File 'lib/m4dbi/statement.rb', line 11

def select( *bindvars )
  @st.execute( *bindvars ).fetch( :all, RDBI::Result::Driver::Struct )
end

#select_column(*bindvars) ⇒ Object Also known as: sc 



19
20
21
22
23
24
25
26
 
# File 'lib/m4dbi/statement.rb', line 19

def select_column( *bindvars )
  rows = @st.execute( *bindvars ).fetch( 1, RDBI::Result::Driver::Array )
  if rows.any?
    rows[0][0]
  else
    raise RDBI::Error.new( "Query returned no rows." )
  end
end

#select_one(*bindvars) ⇒ Object Also known as: s1 



15
16
17
 
# File 'lib/m4dbi/statement.rb', line 15

def select_one( *bindvars )
  select( *bindvars )[0]
end