Creating mysql views from class in rails

[rchawdhari]

Hi ,

I want to create a class in lib folder , from that class want to create mysql view .
such as in mysql

CREATE VIEW rocket_current_activities AS
    SELECT rocket_activities.status  AS status from rocket_activities....

This can be do in mysql but how to do from rails.
I dont want in migration file.
Please help!!!

[cereal]

Hi,

I haven't used Rails for ages, but I think you probably need execute to run a raw query, for example:

def up
    execute <<-SQL
      CREATE VIEW rocket_current_activities AS
        SELECT rocket_activities.status  AS status from rocket_activities....
    SQL
end

Docs: http://edgeguides.rubyonrails.org/active_record_migrations.html#using-the-up-down-methods

[Taywin]

The question is why do you need to create view in Rails? You should not need to be manipulating with database schema at all but rather use Rails' object to do that for you. Weird...

[rchawdhari]

Thank you,

you solved my problem