Method: Sequel::Database#fetch

Defined in:
lib/sequel/database/dataset.rb

#fetch(sql, *args, &block) ⇒ Object

Fetches records for an arbitrary SQL statement. If a block is given, it is used to iterate over the records:

DB.fetch('SELECT * FROM items'){|r| p r}

The fetch method returns a dataset instance:

DB.fetch('SELECT * FROM items').all

fetch can also perform parameterized queries for protection against SQL injection:

DB.fetch('SELECT * FROM items WHERE name = ?', my_name).all



46
47
48
49
50
 
# File 'lib/sequel/database/dataset.rb', line 46

def fetch(sql, *args, &block)
  ds = @default_dataset.with_sql(sql, *args)
  ds.each(&block) if block
  ds
end