-- Name: _namePart(); Type: FUNCTION; Schema: py_functions; Owner: bien

--

CREATE FUNCTION "_namePart"() RETURNS trigger

    LANGUAGE plpythonu IMMUTABLE

    AS $$

new = TD['new']

_name_parts_slices_items = [

    ('first', slice(None, 1)),

    ('middle', slice(1, -1)),

    ('last', slice(-1, None)),

]

name_parts_slices = dict(_name_parts_slices_items)

name_parts = [name for name, slice_ in _name_parts_slices_items]

def _name(items):

    items = dict(items)

    parts = []

    for part in name_parts:

        if part in items: parts.append(items[part])

    return ' '.join(parts)

out_items = []

for part, value in new.iteritems():

    if value == None: continue

    try: slice_ = name_parts_slices[part]

    except KeyError: pass # a non-value column

    else: out_items.append((part, ' '.join(value.split(' ')[slice_])))

new['result'] = _name(out_items)

return 'MODIFY'

$$;

ALTER FUNCTION py_functions."_namePart"() OWNER TO bien;

--

-- Name: _namePart; Type: TABLE; Schema: py_functions; Owner: bien; Tablespace: 

--

CREATE TABLE "_namePart" (

    result text,

    not_null_col boolean DEFAULT true NOT NULL,

    first text,

    middle text,

    last text

);

ALTER TABLE py_functions."_namePart" OWNER TO bien;

--

-- Name: _namePart_unique; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: 

--

CREATE UNIQUE INDEX "_namePart_unique" ON "_namePart" USING btree (functions.ensure_not_null(first), functions.ensure_not_null(middle), functions.ensure_not_null(last));

--

-- Name: _namePart; Type: TRIGGER; Schema: py_functions; Owner: bien

--

CREATE TRIGGER "_namePart" BEFORE INSERT OR UPDATE ON "_namePart" FOR EACH ROW EXECUTE PROCEDURE "_namePart"();

--