search

josuebrunel / myql

mYQL is a Python wrapper of the Yahoo! Query Language a.k.a YQL (Finances, ...)
https://myql.readthedocs.org/en/latest/
MIT License
31 stars 8 forks source link

IN in Condition doesn't work #106

Closed josuebrunel closed 9 years ago

josuebrunel commented 9 years ago

Check this out 

>>> response = yql.select('weather.forecast',['units','atmosphere']).where(['woeid','in','select woeid from geo.places(1) where text="Paris,Fr"'])
[2015-06-03 07:22:24,612 INFO] [mYQL.myql.payloadBuilder] QUERY = env 'store://datatables.org/alltableswithkeys'; SELECT units,atmosphere FROM weather.forecast  WHERE woeid in ('s','e','l','e','c','t',' ','w','o','e','i','d',' ','f','r','o','m',' ','g','e','o','.','p','l','a','c','e','s','(','1',')',' ','w','h','e','r','e',' ','t','e','x','t','=','"','P','a','r','i','s',',','F','r','"')
[2015-06-03 07:22:24,612 INFO] [mYQL.myql.payloadBuilder] PAYLOAD = {'format': 'xml', 'q': 'env \'store://datatables.org/alltableswithkeys\'; SELECT units,atmosphere FROM weather.forecast  WHERE woeid in (\'s\',\'e\',\'l\',\'e\',\'c\',\'t\',\' \',\'w\',\'o\',\'e\',\'i\',\'d\',\' \',\'f\',\'r\',\'o\',\'m\',\' \',\'g\',\'e\',\'o\',\'.\',\'p\',\'l\',\'a\',\'c\',\'e\',\'s\',\'(\',\'1\',\')\',\' \',\'w\',\'h\',\'e\',\'r\',\'e\',\' \',\'t\',\'e\',\'x\',\'t\',\'=\',\'"\',\'P\',\'a\',\'r\',\'i\',\'s\',\',\',\'F\',\'r\',\'"\')', 'callback': '', 'jsonCompact': False, 'diagnostics': False, 'debug': False}