broly 0.2.0

small (wip) wrapper for rds data api for lambda

Broly

Small module for managing models with the AWS rds data-api from lambda. Should be set into a lambda layer.

Uses pypika to generate MySQL and boto3's rds-data client.

MVP Features:

• Generic model class
• Model manipulation
• Insert
• Update
• Autoincrement option
• Read by column and parse response
  • Parsing datetimes
• Table creation
• Bulk get
• Take pypika get queries to execute directly
• Main MySQL column classes
• Wait for serverless wakeup, boto3 doesn't retry automatically if db is 'asleep'
• Delete
• Order results for get queries
• Raw SQL escape hatch

To add to lambda layer

mkdir python
pip3 install broly --target python/
zip -r python layer

Then just upload it to your lambda's layer.

Usage

from broly.model import Model
from broly.column import IntColumn, VarChar

class Example(Model):

    table_name = 'example'
    secret_arn = 'secret-arn'
    resource_arn = 'resource-arn'
    database = 'db-name'

    id = IntColumn(primary_key=True)
    name = VarChar(nullable=False)
    description = VarChar(size=1000)

e = Example(name="name")
e.set_value('description', 'desc')
print(e)
e = e.save()
print(e)