Module: CsvImportAnalyzer::MysqlQueryHelper

Defined in:
lib/csv-import-analyzer/query_builder/mysql_query_helper.rb

Instance Method Summary collapse

Instance Method Details

#form_query_for_datatype(args) ⇒ Object 



6
7
8
9
10
11
12
13
14
15
16
 
# File 'lib/csv-import-analyzer/query_builder/mysql_query_helper.rb', line 6

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) ⇒ Object 



18
19
20
21
22
23
24
25
26
27
28
 
# File 'lib/csv-import-analyzer/query_builder/mysql_query_helper.rb', line 18

def import_csv(args)
  unless args[:tablename].nil? || args[:filename].nil? || args[:delimiter].nil?
    import_statement = "LOAD DATA INFILE #{args[:filename]} INTO TABLE #{args[:tablename]} "+
          "FIELDS TERMINATED BY '#{args[:delimiter]}' "+
          "ENCLOSED BY '\"' "+
          "LINES TERMINATED BY '\\n' "+
          "IGNORE 1 LINES;"
  else
    MissingRequiredArguments.new("Required arguments missing for import_csv")
  end
end