Rails custom queries without using models

Question

Recently I've been developing a simple website as a learning process, and I've come across a problem. I've separated out the database into two tables, a 'user' tables, and a 'character' table. The problem I'm facing is I need to select all the user's characters from the character table without creating any models for the character (as that's handled elsewhere). Is there any way I could go about solving this?

I do also have a table which has three columns; "id", "user_id", and "character_id"

Help is appreciated!

Thanks, Adil

Erez Rabih · Accepted Answer · 2012-08-09 14:30:45Z

2

You can use ActiveRecord::Base.connection.execute("some sql query here")

answered Aug 9, 2012 at 14:30

Erez Rabih

15.8k3 gold badges49 silver badges67 bronze badges

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

Collectives™ on Stack Overflow

Rails custom queries without using models

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