Trouble with SelectManager#to_a deprecation/removal

[nazgob]

Hello! I have issues with change introduced in this commit d956772

I'm doing something like this using deprecated SelectManager#to_a. How can I achieve similar result without it?

contacts = Arel::Table.new("contacts", db_config)
contacts.project(Arel.star.count.as('count')).to_a
=> [#<struct Arel::SelectManager::Row data={"count"=>42}>]

Is this how it should be done now?

contacts = Arel::Table.new("#{crm_db_name}.contacts", crm_db)
sql = contacts.project(Arel.star.count.as('count')).to_sql
contacts.engine.connection.execute(sql).each {|row| row}

Thanks!

[hkairi]

Hello

I was facing the warning message and i decided to do the following :

contacts = Arel::Table.new("#{crm_db_name}.contacts", crm_db)
sql = contacts.project(Arel.star.count.as('count')).to_sql
contacts.engine.connection.execute(sql).map {|row| row}

I don't know if there is a better way :(

[rafaelfranca]

Yeah, this is the way you should implement it now.