sql.cr

def insert_into(table, data)
  columns = data.keys.join(", ")
  placeholders = (1..data.size).map { |i| "$#{i}" }.join(", ")
  sql = "INSERT INTO #{table} (#{columns}) VALUES (#{placeholders})"

  db.exec(sql, *data.values)
end

insert_into "users", {
  id:               id,
  signup_time:      Time.now,
  username:         user.username,
  email:            user.email,
  password_bcrypt:  bcrypt(user.password),
  avatar_id:        user.avatar_id,
  usertitle:        user.usertitle,
  signature_bbcode: user.signature_bbcode,
}