Clips from a tweet about ibis-datasette analyzing the scotrail datasette

scotrail_ibis.py

import ibis
from ibis import _

con = ibis.datasette.connect("https://scotrail.datasette.io/scotrail")
t = con.tables.announcements

def random(category):
    return (
        t.filter(_.Category == category)
        .sort_by(ibis.random())
        .limit(1)
    )

def phrase(text):
    return t.filter(_.Transcription == text).limit(1)

query = ibis.union(
    random("Apology"),
    random("Train operating company"),
    random("Destination"),
    phrase("has been cancelled"),
    phrase("due to"),
    random("Reason"),
).Transcription.group_concat(" ")

print(query.execute())
# 'I am sorry to announce that the Southeastern service to Bentley has been
# cancelled due to Overcrowding because of a football match'