module CsvImportAnalyzer::PgQueryHelper

Public Instance Methods

form_query_for_datatype(args) click to toggle source
# File lib/csv-import-analyzer/query_builder/pg_query_helper.rb, line 5
def form_query_for_datatype(args)
  unless args[:datatype].nil? || args[:header].nil?
    if args[:datatype] == :string
      return args[:header].to_s + " varchar(255)"
    else
      return args[:header].to_s + " " + args[:datatype].to_s
    end
  else
    MissingRequiredArguments.new("Required arguments missing for form_query_for_datatype")
  end
end
import_csv(args) click to toggle source
# File lib/csv-import-analyzer/query_builder/pg_query_helper.rb, line 17
def import_csv(args)
  unless args[:tablename].nil? || args[:filename].nil? || args[:delimiter].nil?
    pg_import_statement = "COPY #{args[:tablename]} FROM '#{args[:filename]}' HEADER DELIMITER '#{args[:delimiter]}' CSV NULL AS 'NULL';"
  else
    MissingRequiredArguments.new("Required arguments missing for import_csv")
  end
end