I am sorry I don’t follow " It’s :binary in the migration. " Do you mean that I run binary ?
shansiddiqui94
0
kokolegorille
No, sorry I am not explicit… like this, in the migration file, located in /priv/repo/migrations
add :summary, :binary
and in the schema…
field :summary, :text
And replace text_input with textarea
0
shansiddiqui94
You are referring to the Change func
def change do
create table(:delish_foods) do
add :title, :string
add :ingredients, :string
add :summary, :binary
add :date, :integer
timestamps()
end
0
shansiddiqui94
kokolegorille
shansiddiqui94
shansiddiqui94
I went ahead and made the corrections
1, Both the migration and schema :summary was changed to binary
<%= textarea f, :summary %>
The argument error went away. But a new postgrex error came
ERROR 22001 (string_data_right_truncation) value too long for type character varying(255)
0
kokolegorille
Text is the type in the db, :binary is the Ecto and Elixir type.
It’s an unlimited field of char.
0
shansiddiqui94
Hey,
I looked at the Hex docs, could I take the same steps as what he did here to change :date type to :date this way I could use that as a format for writing dates, rather than just integers?
0
kokolegorille
I am not sure You want to store a date…
In fact, it looks like a duration. I would use integer, to express seconds, or any units for a period.
What You need is a good function to transform this unit into something human readable. (HH:MM:SS)
But if it is really a date, use a date field, and the appropriate input.
0