myql.readthedocs.orgmYQL: Yahoo! Query Language Documentation and Support

Yahoo! Query Language Documentation and Support Installation Quick Start Response format (xml or json) Methods Using OAuth Utils Yahoo-OAuth StockScraper Weather Open Tables Contribute Docs » Home Edit on GitHub is a Python wrapper of the Yahoo Query Language. Yahoo! Query Language Documentation and Support Yahoo! Query Language Yahoo! Developer Network Yahoo! Application Platform Yahoo! Social APIs Yahoo! Query Language Console Installation $ pip install myql Quick Start It’s important to know that response is a just requests.models.Response object. Yes indeed, uses requests :smile: By default, you have access to the community tables . If for whatsoever reason you would like to not have access to those tablesimport myqlyql = myql.MYQL(community=False) Response format (xml or json) The response format is by default json .import myqlfrom myql.utils import pretty_json, pretty_xmlyql = myql.MYQL(format=’xml’, community=True)resp = yql.raw_query(’select name, woeid from geo.states where place="Congo"’)print(pretty_xml(resp.content)) ?xml version="1.0" encoding="utf-8"? query xmlns:yahoo="http://www.yahooapis.com/v1/base.rng" yahoo:count="11" yahoo:created="2015-06-07T11:56:11Z" yahoo:lang="en-US" results place xmlns="http://where.yahooapis.com/v1/schema.rng" nameCuvette-Ouest Department/name woeid55998384/woeid /place place xmlns="http://where.yahooapis.com/v1/schema.rng" nameCuvette Department/name woeid2344968/woeid /place place xmlns="http://where.yahooapis.com/v1/schema.rng" namePlateaux District/name woeid2344973/woeid /place place xmlns="http://where.yahooapis.com/v1/schema.rng" nameSangha/name woeid2344974/woeid /place place xmlns="http://where.yahooapis.com/v1/schema.rng" nameLekoumou/name woeid2344970/woeid /place place xmlns="http://where.yahooapis.com/v1/schema.rng" namePool Department/name woeid2344975/woeid /place place xmlns="http://where.yahooapis.com/v1/schema.rng" nameLikouala Department/name woeid2344971/woeid /place place xmlns="http://where.yahooapis.com/v1/schema.rng" nameNiari Department/name woeid2344972/woeid /place place xmlns="http://where.yahooapis.com/v1/schema.rng" nameBrazzaville/name woeid2344976/woeid /place place xmlns="http://where.yahooapis.com/v1/schema.rng" nameBouenza Department/name woeid2344967/woeid /place place xmlns="http://where.yahooapis.com/v1/schema.rng" nameKouilou/name woeid2344969/woeid /place /results /query ! total: 33! pprd1-node1003-lh3.manhattan.bf1.yahoo.com resp = yql.raw_query(’select name, woeid from geo.states where place="Congo"’, format=’json’)print(pretty_json(resp.content)) { "query": { "count": 11, "created": "2015-06-07T11:58:20Z", "lang": "en-US", "results": { "place": [ { "name": "Cuvette-Ouest Department", "woeid": "55998384" }, { "name": "Cuvette Department", "woeid": "2344968" }, { "name": "Plateaux District", "woeid": "2344973" }, { "name": "Sangha", "woeid": "2344974" }, { "name": "Lekoumou", "woeid": "2344970" }, { "name": "Pool Department", "woeid": "2344975" }, { "name": "Likouala Department", "woeid": "2344971" }, { "name": "Niari Department", "woeid": "2344972" }, { "name": "Brazzaville", "woeid": "2344976" }, { "name": "Bouenza Department", "woeid": "2344967" }, { "name": "Kouilou", "woeid": "2344969" } ] } } }Methods use(yql_table_url,name=yql_table_name) Maps a table name to the URL of an Open Data Table.yql.use(’http://www.josuebrunel.org//users.xml’, name=’myusers’) desc(tablename) Returns table descriptionresponse = yql.desc(’weather.forecast’)print(pretty_json(response.content)) { "query": { "count": 1, "created": "2015-06-07T12:00:27Z", "lang": "en-US", "results": { "table": { "hash": "aae78b1462a6a8fbc748aec4cf292767", "meta": { "author": "Yahoo! Inc", "description": "Weather forecast table", "documentationURL": "http://developer.yahoo.com/weather/", "sampleQuery": "select * from weather.forecast where woeid=2502265" }, "name": "weather.forecast", "request": { "select": [ { "key": [ { "name": "location", "required": "true", "type": "xs:string" }, { "name": "u", "type": "xs:string" } ] }, { "key": [ { "name": "woeid", "required": "true", "type": "xs:string" }, { "name": "u", "type": "xs:string" } ] } ] }, "security": "ANY" } } } }raw_query(query) Allows you to directly type your queryresponse = yql.raw_query("select * from geo.countries where place=’North America’")# deal with the response select(table, fields, limit, **kwargs).where(filters, ...) NB : A simple select doesn’t return any data. Use GET instead.response = yql.select(’geo.countries’, [’name’, ’code’, ’woeid’]).where([’name’, ’=’, ’Canada’])print(pretty_json(response.content)) { "query": { "count": 1, "created": "2015-06-07T12:10:39Z", "lang": "en-US", "results": { "place": { "name": "Canada", "woeid": "23424775" } } } }...response = yql.select(’geo.countries’, [’name’, ’woeid’], 2).where([’place’, ’in’, (’Africa’, ’Europe’)])from myql.utils import dumpdump(response) { "query": { "count": 2, "created": "2015-06-07T12:27:04Z", "lang": "en-US", "results": { "place": [ { "name": "Algeria", "woeid": "23424740" }, { "name": "Angola", "woeid": "23424745" } ] } } }get(table, fields, limit, **kwargs) Same as SELECT , but instead returns data. REMINDER : Some tables require a where clause , therefore GET won’t work on those tables, use select(...).where(...) instead .from myql.utils import dumpresponse = yql.get(’geo.countries’, [’name’, ’woeid’], 1)dump(response) { "query": { "count": 1, "created": "2015-06-07T12:29:01Z", "lang": "en-US", "results": { "place": { "name": "Sao Tome and Principe", "woeid": "23424966" } } } }insert(table, (field1, field2, ..., fieldN),(value1, value2, ..., valueN)) Insert values into a table. Arguments 2 and 3 may be tuples or list .from myql.utils import pretty_jsonresponse = yql.insert(’yql.storage.admin’,(’value’,),(’http://josuebrunel.org’,))print(pretty_json(response.content)) { "query": { "count": 1, "created": "2015-05-14T13:25:56Z", "lang": "en-US", "results": { "inserted": { "execute": "store://KkkC5xDw4v32IcWWSQ4YRe", "select": "store://Zc5LHXcmYM7XBfSbo9tzFL", "update": "store://Rqb5fbQyDvrfHJiClWnZ6q" } } } } update(table,[field1, ..., fieldN],[value1, ..., ...valueN]).where(filters, ...) Update fields values. This method is always followed by where() . Arguments 2 and 3 may be tuples or list .from myql.utils import pretty_jsonresponse = yql.update(’yql.storage’,(’value’,),(’https://josuebrunel.org’,)).where([’name’,’=’,’store://Rqb5fbQyDvrfHJiClWnZ6q’])print(pretty_json(response.content)) { "query": { "count": 1, "created": "2015-05-14T13:32:52Z", "lang": "en-US", "results": { "success": "Updated store://KkkC5xDw4v32IcWWSQ4YRe" } } } delete(table).where(filters, ...) Delete recordsfrom myql.utils import pretty_jsonresponse = self.yql.delete(’yql.storage’).where([’name’,’=’,’store://Rqb5fbQyDvrfHJiClWnZ6q’])print(pretty_json(response.content)) { "query": { "count": 1, "created": "2015-05-14T13:38:28Z", "lang": "en-US", "results": { "success": "store://Rqb5fbQyDvrfHJiClWnZ6q deleted" } } } Using OAuth comes with yahoo_oauth , which is an OAuth library for Yahoo! APIs.from yahoo_oauth import OAuth1oauth = OAuth1(None, None, from_file=’credentials.json’) # only consumer_key and consumer_secret are required.from myql import MYQLyql = MYQL(format=’xml’, oauth=oauth)response = yql.get_guid(’josue_brunel’) # Deal with the response Utils comes with some useful functions, such as: prettyty(response, format) According to the format, call pretty_json or pretty_xml pretty_json(response.content) prettyfy a JSON response content pretty_xml(response.content) Prettyfy a XML response content dump(response) Print a prettyfied response Next Built with MkDocs using a theme provided by Read the Docs . Read the...