Module: Format

Included in:
CSVR::App
Defined in:
lib/csvr/format.rb

Class Method Summary collapse

Class Method Details

.headers(headers, types) ⇒ Object 



6
7
8
9
 
# File 'lib/csvr/format.rb', line 6

def headers(headers, types)
  headers = headers.map { |h| "#{h} #{type(h, types)}" }.join(",")
  return headers
end

.row(row) ⇒ Object 



26
27
28
29
30
31
32
 
# File 'lib/csvr/format.rb', line 26

def row(row)
  if row.is_a? Hash
    values = row.values.map { |r| "'#{r}'"}.join(",")
    keys = row.keys.join(",")
  end
  return "(#{keys}) VALUES(#{values})"
end

.type(header, types) ⇒ Object 



11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
# File 'lib/csvr/format.rb', line 11

def type(header, types)
  case types[header]
  when Fixnum
    return "INTEGER"
  when Float
    return "REAL"
  when nil
    return "NULL"
  when String
    return "TEXT"
  else
    return "TEXT"
  end
end