Re: DBD::Google " SELECT * " does not return URL.

[dakkar]

in reply to DBD::Google " SELECT * " does not return URL.

It's a funny bug in DBD::Google. If you look at the parser you'll see that @default_columns contains URL, but a few lines later it gets changed in this for loop:

for my $dc (@default_columns) {
    $dc =~ s/([A-Z])/_\l$1/g;
    $allowed_columns{$dc} = 1;
}

so that URL becomes _u_r_l.

I am not going to test it, but I'd change the loop to:

for my $dc (@default_columns) {
    my $t;
    ($t=$dc) =~ s/([A-Z])/_\l$1/g;
    $allowed_columns{$t} = 1;
}

[superfrink]

Ah, interesting. So the loop is there to change "cachedSize" to "cached_size" but because "URL" is all uppercase it comes out "_u_r_l".

The recommended change does indeed cause the result to include a key named "URL" which points to the URL string.

Changeing the default column list to include "url" instead of "URL" also seems to work and the result includes a key with the lowercase name "url".

I have not read google's API or most of the DBD::Google code so I'm not sure if there are any other side effects. I think I'll send the author an email and see what he thinks is the best fix. (Maybe just specifying the URL in the query.)

Thanks, Chad