我正在导入 CSV 并使用 ActiveRecord 创建行。CSV是:
first_name,middle_name,last_name,degrees,email,induction_year (ie 2017),"induction_type (options: alumni, associate, faculty, honorary, student)"
John,Middle,Doe,"BA, MPH",[email protected],2017,alumni
我的导入方法如下所示:
def import
CSV.foreach(@file.path, headers: true, header_converters: lambda {|field| field.partition(" ").first }, col_sep: ',') do |row|
member_params = row.to_hash
Member.create!(member_params)
end
end
但它抛出ActiveModel::UnknownAttributeError: unknown attribute 'first_name' for Member.
编辑:这不是会员的问题我可以像你期望的那样创建会员Member.create!(first_name: 'test')
打开撬,我得到了这个反馈:
[1] pry(#<InducteesUpload>)> member_params
=> {"first_name"=>"John",
"middle_name"=>"Middle",
"last_name"=>"Doe",
"degrees"=>"BA, MPH",
"email"=>"[email protected]",
"induction_year"=>"2017",
"induction_type"=>"alumni"}
[2] pry(#<InducteesUpload>)> member_params.keys.first == "first_name"
=> false
[3] pry(#<InducteesUpload>)> member_params.keys.first.encoding
=> #<Encoding:UTF-8>
添加更多:
[1] pry(#<InducteesUpload>)> member_params.keys
=> ["first_name",
"middle_name",
"last_name",
"degrees",
"email",
"induction_year",
"induction_type"]
[2] pry(#<InducteesUpload>)> member_params["first_name"] = "test"
=> "test"
[3] pry(#<InducteesUpload>)> member_params
=> {"first_name"=>"John",
"middle_name"=>"Middle",
"last_name"=>"Doe",
"degrees"=>"BA, MPH",
"email"=>"[email protected]",
"induction_year"=>"2017",
"induction_type"=>"alumni",
"first_name"=>"test"}
您可以从上面的怪异中看到,这不是会员的问题。但如果你真的想要它会发布。
所以问题暴露在这里:
[6] pry(#<InducteesUpload>)> member_params.keys.first.bytes
=> [239, 187, 191, 102, 105, 114, 115, 116, 95, 110, 97, 109, 101]
[7] pry(#<InducteesUpload>)> "first_name".bytes
=> [102, 105, 114, 115, 116, 95, 110, 97, 109, 101]
我打赌 unicode 魔法。比较member_params.keys.first.bytes
和"first_name".bytes
。你很可能会发现不同之处。
Unicode 有很多符号看起来很像,但彼此并不相等。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句