hectorsq

hectorsq

App generated UUID primary key

I am working on a legacy database and the primary keys on the tables are a kind of UUID which we call OID.

This OIDs are 32 char strings generated by the application.

When I create a record, I generate a new OID and assign it to the corresponding field like this.

  def create_document(attrs \\ %{}) do
    oid =
      Ecto.UUID.generate()
      |> String.upcase()
      |> String.replace("-", "")

    attrs = Map.put(attrs, "oid", oid)

    %Document{}
    |> Document.changeset(attrs)
    |> Repo.insert()
  end

Since I have to do this for every table I am wondering if there is a better way.

Marked As Solved

axelson

axelson

Scenic Core Team

Yes there is! I was looking into this the other day because I want to generate repeatable UUID’s for doc generation.

It works by setting the @primary_key module attribute :autogenerate option to a MFA. Here’s a short example:

defmodule MyApp.ExampleSchema do
  @primary_key {:id, Ecto.UUID, autogenerate: {MyApp.OIDGenerator, :generate_oid, []}}
  schema "example_schema" do
    # ... schema fields
  end
end

defmodule MyApp.OIDGenerator do
  def generate_oid do
    Ecto.UUID.generate()
    |> String.upcase()
    |> String.replace("-", "")
  end
end

And you could even put your @primary_key definition in a module and then use MyApp.Data to bring it in.

Also Liked

hectorsq

hectorsq

Thank you Jason. It worked perfectly!

axelson

axelson

Scenic Core Team

Thanks! I’m glad it was helpful! I haven’t been able to make actual use of that code myself yet :joy:

Last Post!

axelson

axelson

Scenic Core Team

Thanks! I’m glad it was helpful! I haven’t been able to make actual use of that code myself yet :joy:

Where Next?

Popular in Questions Top

rms.mrcs
Hi, I need to transform a list of numbers into a map where the keys are the indexes and the values are the original values of the list. ...
New
vonH
In asking this question I am more interested about the expressiveness of the language itself and less concerned about the availability of...
New
openscript
Hello! Sorry for this astonishing simple question, but I’m really stuck. I try to set up the intellij-elixir plugin, but I don’t know ho...
New
9mm
I am constructing a JSON object (map) and I need to conditionally set a field. I’m trying to write proper elixir-way code… and I’m at a l...
New
belgoros
I’m not a pro in using Regex and can’t figure out why the following behaviour happens, especially if we take into account the difference ...
New
jerry
Good day to you all. I have been struggling to get a query involving like and ilike to work. Can anyone assist me on this, please? pro...
New
vrod
I am using the Starship cross-shell prompt – it seems pretty nice, but I get some errors: [WARN] - (starship::utils): Executing command ...
New

Other popular topics Top

Qqwy
Update: How to use the Blogs & Podcasts section You can post links to your blog posts or podcasts either in one of the Official Blog...
3271 130286 1222
New
vertexbuffer
Hello, can anybody help here..? I have a list of players and I what to delete an element, but every for loop the list is reverting to ori...
New
grych
Hi folks, Few months ago I have announced the proof-of-concept of the library to manipulate the browsers DOM objects directly from Elixi...
639 54006 488
New
jononomo
I am trying to figure out how Mix knows whether the environment is test, dev, or prod – where is this set? Thanks.
New
nsuchy
Hi. I’ve noticed that Windows Powershell has it’s own IEX command and you cannot access Elixir’s IEX due to the conflict. This isn’t a cr...
New
gshaw
What is the idiomatic way of matching for not nil in Elixir? E.g., First way: defp halt_if_not_signed_in(conn, signed_in_account) when...
New

We're in Beta

About us Mission Statement