python_postgres_frankenlanguage

python_postgres_frankenlanguage.py.sql

CREATE OR REPLACE FUNCTION bz_select_html(param_search text)
RETURNS SETOF text AS
$$
from lxml import html
import requests
page = requests.get('http://econpy.pythonanywhere.com/ex/001.html')

param = param_search.lower()

tree = html.fromstring(page.text)
if param == 'buyers':
    results = tree.xpath('//div[@title="buyer-name"]/text()')
elif param == 'prices':
    results = tree.xpath('//span[@class="item-price"]/text()')
else:
    results = []
return results

$$
LANGUAGE 'plpython2u' VOLATILE SECURITY DEFINER;

SELECT search_term, bz_select_html(search_term) As 
result FROM (VALUES ('buyers')) As X(search_term);

results

 search_term |         result         
-------------+------------------------
 buyers      | Carson Busses
 buyers      | Earl E. Byrd
 buyers      | Patty Cakes
 buyers      | Derri Anne Connecticut
 buyers      | Moe Dess
 buyers      | Leda Doggslife
 buyers      | Dan Druff
 buyers      | Al Fresco
 buyers      | Ido Hoe
 buyers      | Howie Kisses