Serverless python rds cron

A serverless python example that periodically removes entries from AWS RDS

  _________________________________
< CRON jobs in a cloud native world >
  ---------------------------------
         \   ^__^
          \  (oo)\_______
             (__)\       )\/\
                 ||----w |
                 ||     ||

serverless-python-rds-cron

Build status

A serverless python example that periodically updates entries in RDS. For instance, you might want to mark users as inactive if they have not verified their email after 30 days.

In other words, this project shows how cron jobs can be scheduled as lambda functions.

Features

  • [x] Error reporting (sentry)
  • [x] Logging (via structlog, to stdout)
  • [ ] Monitoring (TODO: probably send slack notification/emails)
$ python3.7 -m venv .venv
$ source ./venv/bin/activate
$ pip install -r requirements-dev.txt

$ export DATABASE_URL='mysql+pymysql://apa:apa@localhost/customer?charset=utf8mb4'
$ python src/task.py

$ python -m pytest -v

Deploying

This script is meant to be deployed as a Lambda Cron using serverless. You also need yarn

$ yarn global add serverless
$ cp .env.yml.example .env.yml

# We can deploy to different stages (environments)
$ serverless deploy -v

# See what we have
$ serverless info

# tail logs for the cronjob function
$ serverless logs -f cleanupCron -t

# invoke the function manually (if a pm pings you or because you can)
$ serverless invoke -f cleanupCron

Fineprint/Don't forget

The tricky/hard part is to make your lambda talk to resources like RDS and outside world. Follow the tutorial here

Bonus point

Put the database url in secrets manager and get it from there

LICENSE

Licensed under MIT.