PostgreSQL query to Rails Console.

Question

The query which i have been trying to formulate is

select array_agg(is_online) , config->> 'external_host' from cameras group by config->> 'external_host';

this is running fine on PostgreSql query console, but not giving any response on Rails console not even error. is there any way to formulate that query in some way that it will be applicable for ActiveRecords?

same as i have pasted here, the same in console, bu the way @Abhi told me results are nill — Junaid Farooq
– Junaid Farooq, Commented Dec 17, 2015 at 6:46

Abhi · Accepted Answer · 2015-12-17 06:31:54Z

1

Try find_by_sql.

Eg:-

ModelName.find_by_sql("sql_query;")

Reference DOC

If you are using rails version above 3.1.x then use a gem gem 'activerecord-deprecated_finders'

edited Dec 17, 2015 at 6:31

answered Dec 17, 2015 at 5:56

Abhi

4,2916 gold badges49 silver badges79 bronze badges

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

Comments

Nitin Srivastava · Accepted Answer · 2015-12-17 07:51:55Z

1

Try select query with model

Camera.select('cameras.column1 AS t_column1, cameras.column2 AS t_column2, , count(*) AS total').group('t_column1, t_column2')

answered Dec 17, 2015 at 7:51

Nitin Srivastava

1,4247 silver badges12 bronze badges

Collectives™ on Stack Overflow

PostgreSQL query to Rails Console.

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related