class SqlGenerator

Public Class Methods

generate_db_create(db_name) click to toggle source
# File lib/ruby_feed/sql_generator.rb, line 28
def self.generate_db_create(db_name)
  "create database #{db_name}"
end
generate_drop(db_name) click to toggle source
# File lib/ruby_feed/sql_generator.rb, line 20
def self.generate_drop(db_name)
  "drop database #{db_name}"
end
generate_rename(to, from) click to toggle source
# File lib/ruby_feed/sql_generator.rb, line 24
def self.generate_rename(to, from)
  "rename database '#{from}' to '#{to}'"
end
generate_table_create_string(table_name) click to toggle source
# File lib/ruby_feed/sql_generator.rb, line 5
def self.generate_table_create_string(table_name)

  create_string = "create table #{table_name} ("
  headers = Parser.parse_headers(table_name)

  headers.each { |header|
    create_string << header << " varchar(255), "
  }

  create_string.sub!(/, $/, "")
  create_string << ")"

  create_string
end