Re: [Rails] Custom UUID generator

Ruby on Rails Monday, July 10, 2017

My question, if this is my migration:

migration.rb
def change

connection.execute <<-SQL
CREATE OR REPLACE FUNCTION john_uuid_generator() RETURNS uuid
AS $$ SELECT * FROM #{uuid_function} $$
LANGUAGE SQL VOLATILE;
SQL

end


Where do I define john_uuid_generator()?

Thanks!


On Mon, Jul 10, 2017 at 2:10 PM, Matt Hickman <matt.hickman@gmail.com> wrote:
uuid_function is defined - https://github.com/rails/rails/blob/650ea5e5cf50d8a7242499463cf1762922d330a8/activerecord/test/cases/adapters/postgresql/uuid_test.rb#L14 - it just switches on if postgres supports gen_random_uuid() otherwise it uses uuid_generate_v4()

 gen_random_uuid() is part of the pgcrypto module - https://www.postgresql.org/docs/9.5/static/pgcrypto.html

uuid_generate_v4() is part of the uuid-ossp module - https://www.postgresql.org/docs/9.5/static/uuid-ossp.html
July 10, 2017 at 12:39 PM via Postbox
That's what I thought but I wasn't sure where to place the uuid_function that the migration refers to. So that go in a helper file or part of the migration?

On Monday, July 10, 2017 at 4:38:06 AM UTC-7, Matt Hickman wrote:
 --
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
 To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/ea4c0dbb-317d-428a-9534-80ca70b1e2f3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


--
Matt

--
You received this message because you are subscribed to a topic in the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/rubyonrails-talk/5Y-7-LLFKGw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
 To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/5963ED2A.8060808%40gmail.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAKNtY_x1qm_VXqcUdMXQ8pytHQF2tFuLAmgnv%2Bvf-8uZGXBMqw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Posted by Ruby on Rails at 2:36 PM

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)