Skip to content

A serverless python example that periodically removes entries from AWS RDS

License

Notifications You must be signed in to change notification settings

caulagi/serverless-python-rds-cron

Repository files navigation

  _________________________________
< 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

  • Error reporting (sentry)
  • 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.

About

A serverless python example that periodically removes entries from AWS RDS

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Languages