class Row

Copyright 2012 C3 Business Solutions

This file is part of dbexpect.

dbexpect is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

dbexpect is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with dbexpect.  If not, see <http://www.gnu.org/licenses/>.

Attributes

row[RW]

Public Class Methods

new(row,column_order) click to toggle source
# File lib/dbexpect/row.rb, line 19
def initialize(row,column_order)
  @row = row
  @column_order = column_order
end

Public Instance Methods

columns() click to toggle source
# File lib/dbexpect/row.rb, line 39
def columns
  @column_order.join(',')
end
insert_stmt(schema,name) click to toggle source
# File lib/dbexpect/row.rb, line 24
  def insert_stmt(schema,name)
      stmt = <<SQL
INSERT INTO #{schema}.#{name} (#{columns})
VALUES #{row_values}
SQL
  end
row_values() click to toggle source
# File lib/dbexpect/row.rb, line 31
def row_values
  '(' + @column_order.map {|col| row[col].db_str }.join(',') + ')'
end
where_clause() click to toggle source
# File lib/dbexpect/row.rb, line 35
def where_clause
  @column_order.map {|col| "#{col} #{row[col].equality_test}" }.join(' AND ')
end