SQLAlchemy-style ORM for Amazon's DynamoDB
Project description
Flywheel
- Master Build:
- 0.2 Build:
- 0.3 Build:
- Documentation:
- Downloads:
- Source:
Object mapper for Amazon’s DynamoDB
Getting Started
This is what a basic model looks like (schema taken from this DynamoDB API documentation)
from flywheel import Model, Field, GlobalIndex class GameScore(Model): __metadata__ = { 'global_indexes': [ GlobalIndex('GameTitleIndex', 'title', 'top_score') ], } userid = Field(hash_key=True) title = Field(range_key=True) top_score = Field(data_type=int) top_score_time = Field(data_type=datetime) wins = Field(data_type=int) losses = Field(data_type=int) def __init__(self, title, userid): self.title = title self.userid = userid
Create a new top score:
>>> score = GameScore('Master Blaster', 'abc') >>> score.top_score = 9001 >>> score.top_score_time = datetime.utcnow() >>> engine.sync(score)
Get all top scores for a user:
>>> scores = engine.query(GameScore).filter(userid='abc').all()
Get the top score for Galaxy Invaders:
>>> top_score = engine.query(GameScore).filter(title='Galaxy Invaders')\ ... .first(desc=True)
Atomically increment a user’s “wins” count on Alien Adventure:
>>> score = GameScore('Alien Adventure', 'abc') >>> score.incr_(wins=1) >>> engine.sync(score)
Get all scores on Comet Quest that are over 9000:
>>> scores = engine.query(GameScore).filter(GameScore.top_score > 9000, ... title='Comet Quest').all()
Changelog
0.3.0
Breakage: Engine namespace is slightly different. If you pass in a string it will be used as the table name prefix with no additional ‘-’ added.
0.2.1
Breakage: Certain queries may now require you to specify an index where it was auto-detected before
Feature: Queries can now filter on non-indexed fields
Feature: More powerful “sync-if” constraints
Feature: Can OR together filter constraints in queries
All changes are due to an update in the DynamoDB API
0.2.0
Breakage: Engine no longer accepts boto connections (using dynamo3 instead)
Breakage: Removing S3Type (no longer have boto as dependency)
Feature: Support Python 3.2 and 3.3
Feature: .count() terminator for queries
Feature: Can override throughputs in Engine.create_schema()
Bug fix: Engine namespace is truly isolated
0.1.3
Bug fix: Some queries fail when global index has no range key
0.1.2
Bug fix: Field names can begin with an underscore
Feature: Models have a nice default __init__ method
0.1.1
Bug fix: Can call incr_() on models that have not been saved yet
Bug fix: Model comparison with None
0.1.0
First public release
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for flywheel-0.3.0-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 01a94865ea0ae7e43aeda99034097b0e4259fe3ac140e85ee1b6602ef2a0b95b |
|
MD5 | 0f6900ad1833516c0186f81c5653ada1 |
|
BLAKE2b-256 | 5a5d85d87c315b315e9143343a15f149ea1d9ec123eb74b8847a4b4a9994787c |