StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to get Ruby MySQL returning PHP like DB SELECT result
primarykey
Id
7896478
data
AcceptedAnswerId
0
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-10-25T22:06:59.800
FavoriteCount
0
LastActivityDate
2011-10-25T23:17:04.567
LastEditDate
LastEditorUserId
0
OwnerUserId
922568
ParentId
0
PostTypeId
1
Score
0
ViewCount
782
LastEditorDisplayName
text
Body
So I use the PDO for a DB connection like this: <pre><code>$this->dsn[$key] = array('mysql:host=' . $creds['SRVR'] . ';dbname=' . $db, $creds['USER'], $creds['PWD']); $this->db[$key] = new PDO($this->dsn[$key]); </code></pre> Using PDO I can then execute a MySQL SELECT using something like this: <pre><code>$sql = "SELECT * FROM table WHERE id = ?"; $st = $db->prepare($sql); $st->execute($id); $result = $st->fetchAll(); </code></pre> The $result variable will then return an array of arrays where each row is given a incremental key - the first row having the array key 0. And then that data will have an array the DB data like this: <pre><code>$result (array(2) [0]=>[0=>1, "id"=>1, 1=>"stuff", "field1"=>"stuff", 2=>"more stuff", "field2"=>"more stuff" ...], [1]=>[0=>2, "id"=>2, 1=>"yet more stuff", "field1"=>"yet more stuff", 2=>"even more stuff", "field2"=>"even more stuff"]); </code></pre> In this example the DB table's field names would be id, field1 and field2. And the result allows you to spin through the array of data rows and then access the data using either a index (0, 1, 2) or the field name ("id", "field1", "field2"). Most of the time I prefer to access the data via the field names but access via both means is useful. So I'm learning the ruby-mysql gem right now and I can retrieve the data from the DB. However, I cannot get the field names. I could probably extract it from the SQL statement given but that requires a fair bit of coding for error trapping and only works so long as I'm not using SELECT * FROM ... as my SELECT statement. So I'm using a table full of State names and their abbreviations for my testing. When I use "SELECT State, Abbr FROM states" with the following code <pre><code>st = @db.prepare(sql) if empty(where) st.execute() else st.execute(where) end rows = [] while row = st.fetch do rows << row end st.close return rows </code></pre> I get a result like this: <pre><code>[["Alabama", "AL"], ["Alaska", "AK"], ...] </code></pre> And I'm wanting a result like this: <pre><code>[[0=>"Alabama", "State"=>"Alabama", 1=>"AL", "Abbr"=>"AL"], ...] </code></pre> I'm guessing I don't have the way inspect would display it quite right but I'm hoping you get the idea by now. Anyway to do this? I've seen some reference to doing this type of thing but it appears to require the DBI module. I guess that isn't the end of the world but is that the only way? Or can I do it with ruby-mysql alone? I've been digging into all the methods I can find without success. Hopefully you guys can help. Thanks Gabe
Tags
<mysql><ruby><prepared-statement>
Title
How to get Ruby MySQL returning PHP like DB SELECT result
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USGabe Spradlin
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.