Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   Ruby (http://www.velocityreviews.com/forums/f66-ruby.html)
-   -   Processing postgres table (http://www.velocityreviews.com/forums/t853781-processing-postgres-table.html)

Dan Webb 10-22-2008 02:44 PM

Processing postgres table
 
I'm using the ruby-postgres gem as ruby-pg isn't installing & as there
no longer seems to be any tutorials or how-tos I thought I'd ask here.

Basically I'm trying to iterate through each row of data and assign the
values to some variables then print them out to XML (XML output's sorted
thanks to builder)
This is one set of that data, one question with 5 answers. How can I go
about finding out the number of rows that contain the same first column?


"A new question by mbr - option 3 is the correct
option";"afsdfsd";"mbr";"";FALSE;"-0.25";"1";"''"

"A new question by mbr - option 3 is the correct
option";"sdfsdf";"mbr";"";FALSE;"-0.25";"2";"''"

"A new question by mbr - option 3 is the correct
option";"sdfsdf";"mbr";"";TRUE;"1.0";"3";"''"

"A new question by mbr - option 3 is the correct
option";"sdfsdf";"mbr";"";FALSE;"-0.25";"4";"''"

"A new question by mbr - option 3 is the correct
option";"sdfsdaf";"mbr";"";FALSE;"-0.25";"5";"''"



This is the current code I'm using for postgres.
db = PGconn.connect(pghost, pgport,'','',pgtbl,dbname,'')
results = db.exec('SELECT question_stem, option_text, author_id,
module_code, correct, weighting, option_id, feedback FROM RESULTS_JOIN')
results.each do |row|
puts "by position: #{row[0]} #{row[1]} #{row[2]} #{row[3]} #{row[4]}
#{row[5]} #{row[6]} #{row[7]} "
end

any pointers would be great.
Kind Regards,
Dan
--
Posted via http://www.ruby-forum.com/.


Robert Klemme 10-23-2008 12:04 PM

Re: Processing postgres table
 
2008/10/22 Dan Webb <dbw@aber.ac.uk>:
> I'm using the ruby-postgres gem as ruby-pg isn't installing & as there
> no longer seems to be any tutorials or how-tos I thought I'd ask here.
>
> Basically I'm trying to iterate through each row of data and assign the
> values to some variables then print them out to XML (XML output's sorted
> thanks to builder)
> This is one set of that data, one question with 5 answers. How can I go
> about finding out the number of rows that contain the same first column?


SELECT question_stem, count(*)
FROM RESULTS_JOIN
group by question_stem

Cheers

robert

--
remember.guy do |as, often| as.you_can - without end



All times are GMT. The time now is 09:53 AM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.