Simple command line YQL executor
Switch branches/tags
Nothing to show
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
help
.gitignore
README.md
help.py
issue.py
pager.py
yql

README.md

Example output

$ ./yql
YQL endpoint http://query.yahooapis.com/v1/public/yql

YQL statements may be on multiple lines.
End your YQL statements with `;' to have the executed.
Send EOF (Unix: Control-D DOS: Control-Z) to quit.

> show tables;
table:
['answers.getbycategory',
 'answers.getbyuser',
 'answers.getquestion',
 'answers.search',
 {'content': 'appdb.application', 'security': 'APP'},
 {'content': 'appdb.application.scopes', 'security': 'APP'},
 'appdb.categories',
 {'content': 'appdb.developer', 'security': 'APP'},
 'appdb.search',
 {'content': 'appdb.user.recent', 'security': 'USER'},
 'atom',
 'avatars.get',
 'csv',
 'data.uri',
 {'content': 'fantasysports.draftresults', 'security': 'USER'},
 {'content': 'fantasysports.games', 'security': 'USER'},
 {'content': 'fantasysports.leagues', 'security': 'USER'},
 {'content': 'fantasysports.leagues.scoreboard', 'security': 'USER'},
 {'content': 'fantasysports.leagues.settings', 'security': 'USER'},
 {'content': 'fantasysports.leagues.standings', 'security': 'USER'},
 {'content': 'fantasysports.players', 'security': 'USER'},
 {'content': 'fantasysports.players.ownership', 'security': 'USER'},
 {'content': 'fantasysports.players.stats', 'security': 'USER'},
 {'content': 'fantasysports.teams', 'security': 'USER'},
 {'content': 'fantasysports.teams.roster', 'security': 'USER'},
 {'content': 'fantasysports.teams.roster.stats', 'security': 'USER'},
 {'content': 'fantasysports.teams.stats', 'security': 'USER'},
 'feed',
 'feednormalizer',
 'flickr.groups.info',
 'flickr.groups.pools.photos',
 'flickr.people.findbyusername',
 'flickr.people.info2',
 'flickr.people.publicphotos',
 'flickr.photos.exif',
 'flickr.photos.info',
 'flickr.photos.interestingness',
 'flickr.photos.recent',
 'flickr.photos.search',
 'flickr.photos.sizes',
 'flickr.photosets.info',
 'flickr.photosets.photos',
 'flickr.places',
 'flickr.places.info',
 'flickr.urls.lookupuser',
 'geo.concordance',
 'geo.continents',
 'geo.counties',
 'geo.countries',
 'geo.districts',
 'geo.oceans',
 'geo.placefinder',
 'geo.placemaker',
 'geo.places',
 'geo.places.ancestors',
 'geo.places.belongtos',
 'geo.places.children',
 'geo.places.common',
 'geo.places.descendants',
 'geo.places.neighbors',
 'geo.places.parent',
 'geo.places.siblings',
 'geo.placetypes',
 'geo.seas',
 'geo.states',
 'html',
 'json',
 'local.search',
 'maps.map',
 'maps.traffic',
 'meme.followers',
 'meme.following',
 'meme.functions',
 'meme.info',
 'meme.memes',
 'meme.people',
 'meme.popular',
 'meme.post.info',
 'meme.posts',
 'meme.posts.featured',
 'meme.recommended',
 'meme.search',
 'meme.shortener',
 {'content': 'meme.user.comments', 'security': 'USER'},
 {'content': 'meme.user.dashboard', 'security': 'USER'},
 {'content': 'meme.user.following', 'security': 'USER'},
 {'content': 'meme.user.posts', 'security': 'USER'},
 'microformats',
 'music.artist.id',
 'music.artist.popular',
 'music.artist.search',
 'music.artist.similar',
 'music.release.artist',
 'music.release.id',
 'music.release.popular',
 'music.release.search',
 'music.track.id',
 'music.track.popular',
 'music.track.search',
 'music.video.category',
 'music.video.id',
 'music.video.popular',
 'music.video.search',
 'music.video.similar',
 'mybloglog.community.find',
 'mybloglog.member',
 'mybloglog.member.contacts',
 'mybloglog.member.newwithcontacts',
 'mybloglog.member.newwithme',
 'mybloglog.members.find',
 {'content': 'mybloglog.stats.find', 'security': 'APP'},
 'ocp-sanitize',
 'rss',
 'search.images',
 'search.news',
 'search.siteexplorer.inlinks',
 'search.siteexplorer.pages',
 'search.spelling',
 'search.suggest',
 'search.termextract',
 'search.web',
 {'content': 'social.connections', 'security': 'USER'},
 {'content': 'social.connections.updates', 'security': 'APP'},
 {'content': 'social.contacts', 'security': 'USER'},
 {'content': 'social.contacts.connections', 'security': 'USER'},
 {'content': 'social.contacts.sync', 'security': 'USER'},
 {'content': 'social.contacts.updates', 'security': 'USER'},
 {'content': 'social.entities', 'security': 'APP'},
 {'content': 'social.favorites', 'security': 'USER'},
 {'content': 'social.notifications', 'security': 'USER'},
 {'content': 'social.notifications.summary', 'security': 'APP'},
 {'content': 'social.presence', 'security': 'APP'},
 {'content': 'social.profile', 'security': 'APP'},
 {'content': 'social.profile.image', 'security': 'APP'},
 {'content': 'social.profile.status', 'security': 'APP'},
 {'content': 'social.relationships', 'security': 'USER'},
 {'content': 'social.relationships.updates', 'security': 'APP'},
 {'content': 'social.updates', 'security': 'APP'},
 {'content': 'social.updates.activitystreams', 'security': 'APP'},
 {'content': 'social.updates.search', 'security': 'APP'},
 'upcoming.category',
 'upcoming.country',
 'upcoming.events',
 'upcoming.events.bestinplace',
 'upcoming.groups',
 'upcoming.metro',
 'upcoming.state',
 'upcoming.user',
 'upcoming.venue',
 'uritemplate',
 'weather.forecast',
 'xml',
 'xslt',
 'yahoo.coke',
 'yahoo.dht',
 {'content': 'yahoo.identity', 'security': 'APP'},
 'yahoo.memcache',
 'yahoo.shortener',
 'yahoo.ucsdata',
 'yahoo.urldb',
 'yahoo.y.ahoo.it',
 'yap.setsmallview',
 {'content': 'ymail.folders', 'security': 'USER'},
 {'content': 'ymail.messages', 'security': 'USER'},
 {'content': 'ymail.msgcontent', 'security': 'USER'},
 {'content': 'ymail.search', 'security': 'USER'},
 {'content': 'yql.env', 'security': 'APP'},
 {'content': 'yql.queries', 'security': 'USER'},
 {'content': 'yql.queries.query', 'security': 'USER'},
 'yql.query.multi',
 'yql.storage',
 'yql.storage.admin',
 'yql.table.desc',
 'yql.table.list',
 'yql.tables']
175 results returned
Time: Service: 0; User: 1; Exec: n/a
> select * from geo.places where text = 'united states';
place:
{'admin1': None,
 'admin2': None,
 'admin3': None,
 'areaRank': '14',
 'boundingBox': {'northEast': {'latitude': '71.441048',
                               'longitude': '-66.940643'},
                 'southWest': {'latitude': '18.911720',
                               'longitude': '-179.150558'}},
 'centroid': {'latitude': '37.167931', 'longitude': '-95.845016'},
 'country': {'code': 'US', 'content': 'United States', 'type': 'Country'},
 'lang': 'en-US',
 'locality1': None,
 'locality2': None,
 'name': 'United States',
 'placeTypeName': {'code': '12', 'content': 'Country'},
 'popRank': '0',
 'postal': None,
 'uri': 'http://where.yahooapis.com/v1/place/23424977',
 'woeid': '23424977'}
1 results returned
Time: Service: 124; User: 125; Exec: 124
> select *
>>> from geo.places
>>> where text = 'london';
place:
[{'admin1': {'code': 'GB-ENG', 'content': 'England', 'type': 'Country'},
  'admin2': {'code': 'GB-LND', 'content': 'Greater London', 'type': 'County'},
  'admin3': None,
  'areaRank': '7',
  'boundingBox': {'northEast': {'latitude': '51.686031',
                                'longitude': '0.280360'},
                  'southWest': {'latitude': '51.261318',
                                'longitude': '-0.563000'}},
  'centroid': {'latitude': '51.506321', 'longitude': '-0.127140'},
  'country': {'code': 'GB', 'content': 'United Kingdom', 'type': 'Country'},
  'lang': 'en-US',
  'locality1': {'content': 'London', 'type': 'Town'},
  'locality2': None,
  'name': 'London',
  'placeTypeName': {'code': '7', 'content': 'Town'},
  'popRank': '13',
  'postal': None,
  'uri': 'http://where.yahooapis.com/v1/place/44418',
  'woeid': '44418'},
 {'admin1': {'code': 'CA-ON', 'content': 'Ontario', 'type': 'Province'},
  'admin2': {'code': '', 'content': 'Middlesex', 'type': 'County'},
  'admin3': None,
  'areaRank': '6',
  'boundingBox': {'northEast': {'latitude': '43.073051',
                                'longitude': '-81.107582'},
                  'southWest': {'latitude': '42.824558',
                                'longitude': '-81.390648'}},
  'centroid': {'latitude': '42.986889', 'longitude': '-81.246208'},
  'country': {'code': 'CA', 'content': 'Canada', 'type': 'Country'},
  'lang': 'en-US',
  'locality1': {'content': 'London', 'type': 'Town'},
  'locality2': None,
  'name': 'London',
  'placeTypeName': {'code': '7', 'content': 'Town'},
  'popRank': '11',
  'postal': None,
  'uri': 'http://where.yahooapis.com/v1/place/4063',
  'woeid': '4063'},
 {'admin1': {'code': 'US-KY', 'content': 'Kentucky', 'type': 'State'},
  'admin2': {'code': '', 'content': 'Laurel', 'type': 'County'},
  'admin3': None,
  'areaRank': '3',
  'boundingBox': {'northEast': {'latitude': '37.152210',
                                'longitude': '-84.038658'},
                  'southWest': {'latitude': '37.102821',
                                'longitude': '-84.126663'}},
  'centroid': {'latitude': '37.127171', 'longitude': '-84.083771'},
  'country': {'code': 'US', 'content': 'United States', 'type': 'Country'},
  'lang': 'en-US',
  'locality1': {'content': 'London', 'type': 'Town'},
  'locality2': None,
  'name': 'London',
  'placeTypeName': {'code': '7', 'content': 'Town'},
  'popRank': '8',
  'postal': None,
  'uri': 'http://where.yahooapis.com/v1/place/2441293',
  'woeid': '2441293'},
 {'admin1': {'code': 'US-TX', 'content': 'Texas', 'type': 'State'},
  'admin2': {'code': '', 'content': 'Kimble', 'type': 'County'},
  'admin3': None,
  'areaRank': '1',
  'boundingBox': {'northEast': {'latitude': '30.693800',
                                'longitude': '-99.555527'},
                  'southWest': {'latitude': '30.677750',
                                'longitude': '-99.574188'}},
  'centroid': {'latitude': '30.685770', 'longitude': '-99.564850'},
  'country': {'code': 'US', 'content': 'United States', 'type': 'Country'},
  'lang': 'en-US',
  'locality1': {'content': 'London', 'type': 'Town'},
  'locality2': None,
  'name': 'London',
  'placeTypeName': {'code': '7', 'content': 'Town'},
  'popRank': '8',
  'postal': {'content': '76854', 'type': 'Zip Code'},
  'uri': 'http://where.yahooapis.com/v1/place/2441291',
  'woeid': '2441291'},
 {'admin1': {'code': 'US-CA', 'content': 'California', 'type': 'State'},
  'admin2': {'code': '', 'content': 'Tulare', 'type': 'County'},
  'admin3': None,
  'areaRank': '1',
  'boundingBox': {'northEast': {'latitude': '36.482731',
                                'longitude': '-119.431328'},
                  'southWest': {'latitude': '36.467670',
                                'longitude': '-119.445732'}},
  'centroid': {'latitude': '36.475281', 'longitude': '-119.438530'},
  'country': {'code': 'US', 'content': 'United States', 'type': 'Country'},
  'lang': 'en-US',
  'locality1': {'content': 'London', 'type': 'Town'},
  'locality2': None,
  'name': 'London',
  'placeTypeName': {'code': '7', 'content': 'Town'},
  'popRank': '1',
  'postal': {'content': '93618', 'type': 'Zip Code'},
  'uri': 'http://where.yahooapis.com/v1/place/2441279',
  'woeid': '2441279'},
 {'admin1': {'code': 'US-OH', 'content': 'Ohio', 'type': 'State'},
  'admin2': {'code': '', 'content': 'Madison', 'type': 'County'},
  'admin3': None,
  'areaRank': '3',
  'boundingBox': {'northEast': {'latitude': '39.921780',
                                'longitude': '-83.393143'},
                  'southWest': {'latitude': '39.859211',
                                'longitude': '-83.478882'}},
  'centroid': {'latitude': '39.885960', 'longitude': '-83.448128'},
  'country': {'code': 'US', 'content': 'United States', 'type': 'Country'},
  'lang': 'en-US',
  'locality1': {'content': 'London', 'type': 'Town'},
  'locality2': None,
  'name': 'London',
  'placeTypeName': {'code': '7', 'content': 'Town'},
  'popRank': '8',
  'postal': {'content': '43140', 'type': 'Zip Code'},
  'uri': 'http://where.yahooapis.com/v1/place/2441292',
  'woeid': '2441292'},
 {'admin1': {'code': 'US-WV', 'content': 'West Virginia', 'type': 'State'},
  'admin2': {'code': '', 'content': 'Kanawha', 'type': 'County'},
  'admin3': None,
  'areaRank': '2',
  'boundingBox': {'northEast': {'latitude': '38.195419',
                                'longitude': '-81.334877'},
                  'southWest': {'latitude': '38.177238',
                                'longitude': '-81.358017'}},
  'centroid': {'latitude': '38.186329', 'longitude': '-81.346451'},
  'country': {'code': 'US', 'content': 'United States', 'type': 'Country'},
  'lang': 'en-US',
  'locality1': {'content': 'London', 'type': 'Town'},
  'locality2': None,
  'name': 'London',
  'placeTypeName': {'code': '7', 'content': 'Town'},
  'popRank': '1',
  'postal': {'content': '25126', 'type': 'Zip Code'},
  'uri': 'http://where.yahooapis.com/v1/place/2441289',
  'woeid': '2441289'},
 {'admin1': {'code': 'US-AR', 'content': 'Arkansas', 'type': 'State'},
  'admin2': {'code': '', 'content': 'Pope', 'type': 'County'},
  'admin3': None,
  'areaRank': '2',
  'boundingBox': {'northEast': {'latitude': '35.342129',
                                'longitude': '-93.187340'},
                  'southWest': {'latitude': '35.319279',
                                'longitude': '-93.267769'}},
  'centroid': {'latitude': '35.330799', 'longitude': '-93.253883'},
  'country': {'code': 'US', 'content': 'United States', 'type': 'Country'},
  'lang': 'en-US',
  'locality1': {'content': 'London', 'type': 'Town'},
  'locality2': None,
  'name': 'London',
  'placeTypeName': {'code': '7', 'content': 'Town'},
  'popRank': '1',
  'postal': {'content': '72847', 'type': 'Zip Code'},
  'uri': 'http://where.yahooapis.com/v1/place/2441278',
  'woeid': '2441278'},
 {'admin1': {'code': 'US-OR', 'content': 'Oregon', 'type': 'State'},
  'admin2': {'code': '', 'content': 'Lane', 'type': 'County'},
  'admin3': None,
  'areaRank': '0',
  'boundingBox': {'northEast': {'latitude': '43.639599',
                                'longitude': '-123.084770'},
                  'southWest': {'latitude': '43.630501',
                                'longitude': '-123.097328'}},
  'centroid': {'latitude': '43.635551', 'longitude': '-123.091049'},
  'country': {'code': 'US', 'content': 'United States', 'type': 'Country'},
  'lang': 'en-US',
  'locality1': {'content': 'London', 'type': 'Town'},
  'locality2': None,
  'name': 'London',
  'placeTypeName': {'code': '7', 'content': 'Town'},
  'popRank': '1',
  'postal': {'content': '97424', 'type': 'Zip Code'},
  'uri': 'http://where.yahooapis.com/v1/place/2441286',
  'woeid': '2441286'},
 {'admin1': {'code': 'US-MI', 'content': 'Michigan', 'type': 'State'},
  'admin2': {'code': '', 'content': 'Monroe', 'type': 'County'},
  'admin3': None,
  'areaRank': '2',
  'boundingBox': {'northEast': {'latitude': '42.029301',
                                'longitude': '-83.595573'},
                  'southWest': {'latitude': '42.011120',
                                'longitude': '-83.620049'}},
  'centroid': {'latitude': '42.020210', 'longitude': '-83.607811'},
  'country': {'code': 'US', 'content': 'United States', 'type': 'Country'},
  'lang': 'en-US',
  'locality1': {'content': 'London', 'type': 'Town'},
  'locality2': None,
  'name': 'London',
  'placeTypeName': {'code': '7', 'content': 'Town'},
  'popRank': '1',
  'postal': {'content': '48159', 'type': 'Zip Code'},
  'uri': 'http://where.yahooapis.com/v1/place/2441281',
  'woeid': '2441281'}]
10 results returned
Time: Service: 206; User: 207; Exec: 206
>