simple select sql select api

#!/usr/bin/env python3

class SqlUI(object):
    """
    Pseudo databazove api
    
    """
    class Postgresql(object):
        __con_state = None
        
        def __init__(self, hostname, username, password, database, debug = False):
            self.__debug = debug

class Select(object):
        __sql_template = "SELECT {cols} FROM {tables}{where}"

def __init__(self):
            self._select_fields = dict(cols=None, tables=None, where=None)

def _tuple_to_str(self, *args):
            return ", ".join([ "'"+ str(val) +"'" for val in args ])

def _dict_to_str(self, **kw):
            return ", ".join([" = ".join(["'"+str(k)+"'", "'"+str(v)+"'"]) for k, v in kw.items()])

def tables(self, *args):
            if self._select_fields['tables'] is None:
                self._select_fields['tables'] = self._tuple_to_str(*args)
            return self

def cols(self, *args):
            if self._select_fields['cols'] is None:
                self._select_fields['cols'] = self._tuple_to_str(*args)
            return self

def where(self, **kw):
            if self._select_fields['where'] is None:
                self._select_fields['where'] = " WHERE " + self._dict_to_str(**kw)

def __str__(self):
            return self.__sql_template.format(**self._select_fields)

if __name__ == '__main__':
    q = SqlUI.Select()
    q.cols('name', 'age').tables('users').where(active='t')
    print(q)

Browser Version Not Supported

Due to Python Fiddle's reliance on advanced JavaScript techniques, older browsers might have problems running it correctly. Please download the latest version of your favourite browser.
Chrome 10+ Firefox 4+ Safari 5+
IE 10+

Let me try anyway!

Python Fiddle

Python Cloud IDE