SELECT method

[josuebrunel]

To make it simple. The idea is to be able to something like this :

from lokingyql import LokingYQL as yql
lk = yql()
lk.select(<tablename>).where(<dict: conditions>)

Got it ?

[josuebrunel]

I didn't test it. Shame on me (--_)

[josuebrunel]

New thing. I was thinking about doing something like this

>>> yql.select().where([('name', '=', 'alain')])

In this case, we select the table from _self.current_table_

>>>yql.select('country', ['name', 'pop', 'capital']).where([('zone', '=', 'africa')])

This means that we select the table country. If _self.current_table_ is different from country, then _self.current_table_ = country.

All that leads to a new prototype of the method

def select(self, table, items=[]):
   #code

[josuebrunel]

A new parameter is added : _limit_
The new prototype looks like

def select(self, table, items=[], limit=None):
    #code

Use as follow:

>>> yql.select('geo.countries', ['name', 'woeid'], 5).where(['place', '=', 'North America'])