Posted
by jamesmoorecode
on Stack Overflow
See other posts from Stack Overflow
or by jamesmoorecode
Published on 2010-04-06T20:44:36Z
Indexed on
2010/04/19
3:23 UTC
Read the original article
Hit count: 463
If you build a projection like this:
t = Arel::Table.new(:projects)
ps = t.project(t[:id].as(:snark))
How do you get the result column that's named :snark?
© Stack Overflow or respective owner
as seen on Stack Overflow
- Search for 'Stack Overflow'
Ok I followed the steps for setting up ruby and rails on my Vista machine and I am having a problem connecting to the database.
Contents of database.yml
development:
adapter: sqlserver
database: APPS_SETUP
Host: WindowsVT06\SQLEXPRESS
Username: se
Password: paswd
Run rake db:migrate…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
My application requires to keep large data objects in session. There are like 3-4 data objects each created by parsing a csv containing 150 X 20 cells having strings of 3-4 characters.
My application shows this error- "marshal data too short".
I tried this-
Deleting the old session table.
Deleting…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I don't know is it my mistake or no. So i have that code:
<code>
post '/singin/get_token' do
content_type :xml
puts request.body.read
puts xmlRequest
xmlRequest = REXML::Document.new(request.body.read)
...
</code>
And when i post something like that:
<code>
<?xml…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
reading around the various ruby install tutorials it's required to change path from /usr/bin/ruby to /usr/local/bin/ruby but i cant seem to be able to do it. Ultimately i want to install Ruby 1.9.2, should i uninstall 1.8.7 or what? i tried to install Ruby 1.9.2 with macports, the installation seemed…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
i am getting a strange bundler error when running
bundle pack
with bundler 0.9.12
any ideas? (see pastie for a better formatted code: http://pastie.org/881328 )
/opt/ruby-enterprise-1.8.7-2010.01/lib/ruby/site_ruby/1.8/rubygems/package/tar_input.rb:49:in `initialize': not in gzip format (Zlib::GzipFile::Error)
…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I've looked over the Arel sources, and some of the activerecord sources for Rails 3.0, but I can't seem to glean a good answer for myself as to whether Arel will be changing our ability to use includes(), when constructing queries, for the better.
There are instances when one might want to modify…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Simple task: given that an article has many comments, be able to display in a long list of articles how many comments each article has. I'm trying to work out how to preload this data with Arel.
The "Complex Aggregations" section of the README file seems to discuss that type of situation, but it…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
If you build a projection like this:
t = Arel::Table.new(:projects)
ps = t.project(t[:id].as(:snark))
How do you get the result column that's named :snark?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I understand that it is a replacement for ActiveRecord and that it uses objects instead of queries.
But...
why is this better?
will objects/queries be "easier" to create?
will it lead to more efficient SQL queries?
will it be compatible with all major DB's? - I assume it will.
will it be easier/harder…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am trying to build this query in ARel:
SELECT FLOOR(AVG(num)) FROM (
SELECT COUNT(attendees.id) AS num, meetings.club_id FROM `meetings` INNER JOIN `attendees` ON `attendees`.`meeting_id` = `meetings`.`id` WHERE (`meetings`.club_id = 1) GROUP BY meetings.id) tmp
GROUP BY tmp.club_id
It returns…
>>> More
