module Insert

Public Instance Methods

create_insert_lambda(obj) click to toggle source
# File lib/yaml2sql.rb, line 45
def create_insert_lambda(obj)
  table = obj['name']
  names = obj['columns'].map{ |x| x["name"] }

  lambda do |*args|
    "insert into #{table} VALUES (#{args.join(",")});"
  end
end
create_lambdas(obj) click to toggle source
# File lib/yaml2sql.rb, line 62
def create_lambdas(obj)
  obj["tables"].map do |x|
    {
      name: x["name"],
      insert: create_insert_lambda(x),
      select: create_select_id_lambda(x)
    }
  end
end
create_select_id_lambda(obj) click to toggle source
# File lib/yaml2sql.rb, line 54
def create_select_id_lambda(obj)
  table = obj['name']
  select_on = obj['select_on']
  lambda do |key|
    "select id from  #{table} where #{select_on} = #{key};"
  end
end