oinopion

-- Create a group
CREATE ROLE readaccess;

-- Grant access to existing tables
GRANT USAGE ON SCHEMA public TO readaccess;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;

-- Grant access to future tables
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;

dmpayton

#!/usr/bin/env python

"""
Sends an SMS reminder to eat food at 10a, 1p, 4p, 7p, and 10p.

cron: 0 10,13,16,19,22 * * *  /path/to/food_reminder.py
"""

from twilio.rest import TwilioRestClient

robcowie

from MySQLdb.cursors import SSDictCursor

def iterate_query(query, connection, arraysize=1):
    c = connection.cursor(cursorclass=SSDictCursor)
    c.execute(query)
    while True:
        nextrows = c.fetchmany(arraysize)
        if not nextrows:
            break