Hi,
I’m trying to unzip an uploaded file and store the compressed files to my database. I’ve a working process but I’ve just discovered that files with non ascii chars in names are stored weirdly in my postgres database.
How I unzip and save file is :
with {:ok, handle} <- :zip.zip_open(path, [{:cwd, path_name}]),
{:ok, file_names} = :zip.zip_get(handle) do
try do
filter_hidden_files(file_names)
|> to_plug_upload()
|> to_multi(user, kind, Multi.new())
|> Repo.transaction()
after
:zip.zip_close(handle)
end
end
defp filter_hidden_files(_, files \\ [])
defp filter_hidden_files([], files) do
files
end
defp filter_hidden_files([file | tail], files) do
filename = Path.basename(file)
case String.first(filename) === "." do
true -> filter_hidden_files(tail, files)
false -> filter_hidden_files(tail, files ++ [file])
end
end
defp to_plug_upload(_, uploads \\ [])
defp to_plug_upload([], uploads) do
uploads
end
defp to_plug_upload([file | tail], uploads) do
upload = %Plug.Upload{
content_type: MIME.from_path(file),
filename: Path.basename(file),
path: to_string(file)
}
to_plug_upload(tail, uploads ++ [upload])
end
defp to_multi([], %User{}, _kind, multi) do
multi
end
defp to_multi(
[file | tail],
%User{entity_name: entity_name} = user,
kind,
multi
) do
attrs = %{
brand: entity_name,
name: file,
kind: kind,
file_hash: file_hash(file),
file_name: file.filename
}
m =
%Media{}
|> Media.changeset(attrs)
to_multi(tail, user, kind, multi |> Multi.insert(file.filename, m))
end
When I try to upload and save a file called 2809575_xxléàî.jpg
I get the following saved in database 2809575_xxleÌaÌiÌ.jpg?63728256310
I think there is an encoding problem when reading files using erlang :zip
module.
Thanks.