myql.readthedocs.orgGitHub - readthedocsreadthedocsorg The source code that

Home 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 tables >>> import myql >>> yql = myql.MYQL(community=False) Response format (xml or json) The response format is by default json . >>> import myql >>> from myql.utils import pretty_json, pretty_xml >>> yql = 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"> <name>Cuvette-Ouest Department</name> <woeid>55998384</woeid> </place> <place xmlns="http://where.yahooapis.com/v1/schema.rng"> <name>Cuvette Department</name> <woeid>2344968</woeid> </place> <place xmlns="http://where.yahooapis.com/v1/schema.rng"> <name>Plateaux District</name> <woeid>2344973</woeid> </place> <place xmlns="http://where.yahooapis.com/v1/schema.rng"> <name>Sangha</name> <woeid>2344974</woeid> </place> <place xmlns="http://where.yahooapis.com/v1/schema.rng"> <name>Lekoumou</name> <woeid>2344970</woeid> </place> <place xmlns="http://where.yahooapis.com/v1/schema.rng"> <name>Pool Department</name> <woeid>2344975</woeid> </place> <place xmlns="http://where.yahooapis.com/v1/schema.rng"> <name>Likouala Department</name> <woeid>2344971</woeid> </place> <place xmlns="http://where.yahooapis.com/v1/schema.rng"> <name>Niari Department</name> <woeid>2344972</woeid> </place> <place xmlns="http://where.yahooapis.com/v1/schema.rng"> <name>Brazzaville</name> <woeid>2344976</woeid> </place> <place xmlns="http://where.yahooapis.com/v1/schema.rng"> <name>Bouenza Department</name> <woeid>2344967</woeid> </place> <place xmlns="http://where.yahooapis.com/v1/schema.rng"> <name>Kouilou</name> <woeid>2344969</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 description >>> response = 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 query >>> response = 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 dump >>> dump(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 dump >>> response = 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_json >>> response = 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_json >>> response = 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 records >>> from myql.utils import pretty_json >>> response = self.yql.delete('yql.storage').where(['name','=','store://Rqb5fbQyDvrfHJiClWnZ6q']) >>> print(pretty_json(response.content)) { "query": { "count": 1, "created": "2015-05-14T...