hectorsq

hectorsq

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.

Showing Posts 1 to 5

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.

factoryd

factoryd

Yes there is.

UUID.uuid4(:hex) |> String.upcase

hectorsq

hectorsq OP

Thank you Jason. It worked perfectly!

hectorsq

hectorsq OP

Great tip, Christopher, thank you

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:

— All posts loaded —

Where Next? Top

Trending in Questions Top

RSP87
I’m working on a project that simulates the bumbl example in the programming phoenix book. It acts almost like an email client. We have a...
New
kszambelanczyk
Hello! Could someone please give me a help/sample code, how to delete a file from s3 using waffle/waffle_ecto from Phoenix app. I creat...
New
RemyXRenard
I’m seeing that a list inside a Kino.DataTable will be interpreted as a charlist, even if the Kino.configure() is set to charlists: :as_l...
New
velrest
So my question is quite simple and i have found no conclusive answer on forum, google or AI. Should we use :erlang.float for Integer to ...
New
samoloth
Hi, I’ve just set up an application with ash_authentication. There is only magic link strategy for now, so there is no confirmation add o...
New
FlyingNoodle
If a change or preparation module uses Ash.Changeset.get_argument/2 or Ash.Query.get_argument/2 (or any of the other get_argument functio...
New
psy-q
I’m trying to set up Emacs with elixir-ls via lsp-mode and credo via Flycheck. This should mostly be preconfigured as Flycheck picks up c...
New

Other Trending Topics Top

mudasobwa
I am happy to introduce the very α version of the new programming language compiled to BEAM. Welcome Cure. It has literally three kille...
New
garrison
Hobbes is a low-level distributed database for the Elixir programming language. Hobbes provides a simple, safe, and scalable storage lay...
New
marciok
Hi there! We created Gust: A task orchestrator inspired by Airflow. For those who have never heard about Aiflow, it’s a Python-based wor...
New
jimsynz
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
Dmk
Xamal is a deployment tool for Elixir apps that deploys native releases to bare metal servers over SSH. It’s a port of GitHub - basecamp/...
New
Damirados
Hello everyone. After busy few months I am happy to announce v0.1.0 of Emerge & Solve. They are GUI (Emerge) and State management (S...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews