Compiled SQL function objects.

"""
Compiled SQL function objects.
"""
import sqlalchemy


class Result(object):
    def transform(self, r):
        raise NotImplementedError()

    @property
    def display_type(self):
        raise NotImplementedError()


class One(Result):
    def transform(self, r):
        row = r.first()
        if row:
            return { k: v for k, v in zip(r.keys(), row) }
        return None

    @property
    def display_type(self):
        return 'row'


class Many(Result):
    def transform(self, r):
        ks = r.keys()
        return ({ k: v for k, v in zip(ks, row)} for row in r.fetchall())

    @property
    def display_type(self):
        return 'rows'


class Affected(Result):
    def transform(self, r):
        return r.rowcount

    @property
    def display_type(self):
        return 'rowcount'


class Insert(Result):
    def transform(self, r):
        return r.lastrowid

    @property
    def display_type(self):
        return 'insert'


class Raw(Result):
    def transform(self, r):
        return r

    @property
    def display_type(self):
        return 'raw'


class Statement(object):
    def __init__(self, name, sql, doc, result, filename=None):
        if not name:
            raise ValueError('Statement must have a name.')

        if sql is None:
            raise ValueError('Statement must have a SQL string.')
        sql = sql.strip()
        if not len(sql):
            raise ValueError('SQL string cannot be empty.')

        if not result:
            raise ValueError('Statement must have a result type.')

        self.name = name
        self.sql = sql
        self.doc = doc
        self.result = result
        self.filename = filename
        self._module = None
        self._text = sqlalchemy.sql.text(self.sql)

    def set_module(self, module):
        self._module = module

    def __call__(self, **params):
        if self._module is None:
            raise RuntimeError(
                'This statement is not associated with a module')

        r = self._module._execute(self._text, **params)
        return self.result.transform(r)

    def _param_names(self):
        def kfn(p):
            return self.sql.index(':' + p)
        return sorted(self._text._bindparams.keys(), key=kfn)

    def __str__(self):
        paramstr = ', '.join(['%s=None' % k for k in self._param_names()])
        return 'pugsql.statement.Statement: %s(%s) :: %s' % (
            self.name, paramstr, self.result.display_type)

    def __repr__(self):
        return str(self)

Classes

class Affected (*args, **kwargs)

Source code

class Affected(Result):
    def transform(self, r):
        return r.rowcount

    @property
    def display_type(self):
        return 'rowcount'

Ancestors

• Result

Instance variables

var display_type

Source code

@property
def display_type(self):
    return 'rowcount'

Methods

def transform(self, r)

Source code

def transform(self, r):
    return r.rowcount

class Insert (*args, **kwargs)

Source code

class Insert(Result):
    def transform(self, r):
        return r.lastrowid

    @property
    def display_type(self):
        return 'insert'

Ancestors

• Result

Instance variables

var display_type

Source code

@property
def display_type(self):
    return 'insert'

Methods

def transform(self, r)

Source code

def transform(self, r):
    return r.lastrowid

class Many (*args, **kwargs)

Source code

class Many(Result):
    def transform(self, r):
        ks = r.keys()
        return ({ k: v for k, v in zip(ks, row)} for row in r.fetchall())

    @property
    def display_type(self):
        return 'rows'

Ancestors

• Result

Instance variables

var display_type

Source code

@property
def display_type(self):
    return 'rows'

Methods

def transform(self, r)

Source code

def transform(self, r):
    ks = r.keys()
    return ({ k: v for k, v in zip(ks, row)} for row in r.fetchall())

class One (*args, **kwargs)

Source code

class One(Result):
    def transform(self, r):
        row = r.first()
        if row:
            return { k: v for k, v in zip(r.keys(), row) }
        return None

    @property
    def display_type(self):
        return 'row'

Ancestors

• Result

Instance variables

var display_type

Source code

@property
def display_type(self):
    return 'row'

Methods

def transform(self, r)

Source code

def transform(self, r):
    row = r.first()
    if row:
        return { k: v for k, v in zip(r.keys(), row) }
    return None

class Raw (*args, **kwargs)

Source code

class Raw(Result):
    def transform(self, r):
        return r

    @property
    def display_type(self):
        return 'raw'

Ancestors

• Result

Instance variables

var display_type

Source code

@property
def display_type(self):
    return 'raw'

Methods

def transform(self, r)

Source code

def transform(self, r):
    return r

class Result (*args, **kwargs)

Source code

class Result(object):
    def transform(self, r):
        raise NotImplementedError()

    @property
    def display_type(self):
        raise NotImplementedError()

Subclasses

• One
• Many
• Affected
• Insert
• Raw

Instance variables

var display_type

Source code

@property
def display_type(self):
    raise NotImplementedError()

Methods

def transform(self, r)

Source code

def transform(self, r):
    raise NotImplementedError()

class Statement (name, sql, doc, result, filename=None)

Source code

class Statement(object):
    def __init__(self, name, sql, doc, result, filename=None):
        if not name:
            raise ValueError('Statement must have a name.')

        if sql is None:
            raise ValueError('Statement must have a SQL string.')
        sql = sql.strip()
        if not len(sql):
            raise ValueError('SQL string cannot be empty.')

        if not result:
            raise ValueError('Statement must have a result type.')

        self.name = name
        self.sql = sql
        self.doc = doc
        self.result = result
        self.filename = filename
        self._module = None
        self._text = sqlalchemy.sql.text(self.sql)

    def set_module(self, module):
        self._module = module

    def __call__(self, **params):
        if self._module is None:
            raise RuntimeError(
                'This statement is not associated with a module')

        r = self._module._execute(self._text, **params)
        return self.result.transform(r)

    def _param_names(self):
        def kfn(p):
            return self.sql.index(':' + p)
        return sorted(self._text._bindparams.keys(), key=kfn)

    def __str__(self):
        paramstr = ', '.join(['%s=None' % k for k in self._param_names()])
        return 'pugsql.statement.Statement: %s(%s) :: %s' % (
            self.name, paramstr, self.result.display_type)

    def __repr__(self):
        return str(self)

Methods

def set_module(self, module)

Source code

def set_module(self, module):
    self._module = module