How to define custom mysql function in Rails

Question

I need to sort some resources with mysql. It requires of me to handle it like this

scope :sorted_by_source, -> { select("set_name(source) as source_name").order("source_name ASC") }

So as you can see function set_name is gonna return something which will later allow me to do order by. However i dont know how to define this function in Rails? Where should i put it, whats the syntax? (I'm gonna need switch statement)

Using Rails 3 and MySql

Why don't you just order by source? I just don't understand why you're trying to do this — j-dexx
– j-dexx, Commented Mar 20, 2014 at 14:37
its not in the database, trust me its kinda complicated and i really need this custom function — Leo
– Leo, Commented Mar 20, 2014 at 14:42
If it's not in the database you're going to need to sort it in ruby. — j-dexx
– j-dexx, Commented Mar 20, 2014 at 14:46

Konstantin Ilchenko · Accepted Answer · 2014-03-20 16:10:41Z

1

You can try adding migration and executing in up some sql to setup function

def up
  execute <<-SQL
   CREATE FUNCTION ...
  SQL
end

def down
  execute <<-SQL
    DROP FUNCTION ...
  SQL
end

answered Mar 20, 2014 at 16:10

Konstantin Ilchenko

4855 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to define custom mysql function in Rails

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related