ruby on rails - Modifying the returned value of find_by_sql -


so pulling hair on issue / gotcha. used find_by_sql fetch data database. did because query has lots of columns , table joins , think using activerecord , associations slow down.

i managed pull data , wanted modify returned values. did looping through result ,for example.

a = project.find_by_sql("select mycolumn, mycolumn2 my_table").each |project| project['mycolumn'] = project['mycolumn'].split('_').first end

what found out project['mycolumn'] not changed @ all.

so question:

does find_by_sql return array hashes? possible modify value of 1 of attributes of hash stated above?

here code : http://pastie.org/4213454 . if can have @ summarize_roles2() that's action taking place.

thank you. im using rails 2.1.1 , ruby 1.8. can't upgrade because of legacy codes.

just change method above access values, print value of project , can check object property.

the results returned array columns requested encapsulated attributes of model call method from.if call product.find_by_sql results returned in product object attributes specified in sql query. if call complicated sql query spans multiple tables columns specified select attributes of model, whether or not columns of corresponding table. 
post.find_by_sql "select p.title, c.author posts p, comments c p.id = c.post_id" > [#<post:0x36bff9c @attributes={"title"=>"ruby meetup", "first_name"=>"quentin"}>, ...]

source: http://api.rubyonrails.org/v2.3.8/


Comments

Post a Comment

Popular posts from this blog

javascript - backbone.js Collection.add() doesn't `construct` (`initialize`) an object -

<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> <script src="http://documentcloud.github.com/backbone/backbone-min.js"></script> </head> <body> <button id="cmd_create_event" name="cmd_create_event" type="button">create new `event`</button> <script type="text/javascript"> var eventmodel = backbone.model.extend({ initialize : function() { console.log("`event` initialized. id: " + this.cid); this.bind("change:status", function() { console.log(this.get("status") + " value `status`"); }); this.bind("error", function(model, e...
Read more

php - Get uncommon values from two or more arrays -

is there function in php give array of uncommon values 2 or more arrays? for example: $array1 = array( "green", "red", "blue"); $array2 = array( "green", "yellow", "red"); .... $result = function_needed($array1, $array2,...); print_r($result); should give output: array("blue", "yellow", ...); use array_diff , array_merge : $result = array_merge(array_diff($array1, $array2), array_diff($array2, $array1)); here's demo. for multiple arrays, combine callback , array_reduce : function unique(&$a, $b) { return $a ? array_merge(array_diff($a, $b), array_diff($b, $a)) : $b; } $arrays = array( array('green', 'red', 'blue'), array('green', 'yellow', 'red') ); $result = array_reduce($arrays, 'unique'); and here's demo of that.
Read more

Adding duplicate array rows in Php -

i create function in php adds rows of array shared column value. so input. $test = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); and output. $testduplicatefree = array( array("c", 7, 9), array("test", 5, 6) ) ); i'm thinking function combine_duplicates($array,$col){ ... ... return $duplicatefreearray; } where $col duplicate free array. so, in case, combine_duplicates($test,0); would me desired output. this. <?php function combine_duplicates($array,$col) { $index = array(); foreach ($array $row) { $key = $row[$col]; if (!isset($index[$key])) { $index[$key] = $row; } else { ($i = 0; $i < count($row); ++$i) { if ($i != $col) { $index[$key][$i] += $row[$i]; } } } } return array_values($index); } $array = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); print_r(combine_duplicates($array, 0)); try here: http://codepad.org/mdhesqhi
Read more