GwWebDbRestPattern¶
This pattern provides functions to easily create REST interfaces to create and edit the content of database tables.
All you need is the database table object, which was created during its registration by the usage of the GwDatabasePattern from the groundwork-database package.
Example¶
The following example creates a database and a related model is created by the help of the GwDatabasePattern.
To get the needed REST views to add and manipulate our database, we only need to add one line
self.web.rest.register(...)
, which is provided by the GwWebDbRestPattern.:
from sqlalchemy import Column, Integer, String
from groundwork_web.patterns import GwWebDbRestPattern
from groundwork_database.patterns import GwDatabasePattern
class MyPlugin(GwWebDbRestPattern, GwDatabasePattern):
def __init__(self, *args, **kwargs):
self.name = self.__class__.__name__
super().__init__(*args, **kwargs)
self.db = None
def activate(self):
""" Activation routine for our plugin """
# Set up database
self.db = self.app.databases.get("My_Database")
# Get and register own database model
MyUserTable = self.get_user_table(self.db)
self.db.classes.register(MyUserTable)
self.db.create_all()
# Register model for new REST views
self.web.rest.register(MyUserTable, self.db.session)
def get_user_table(database):
"""
Helper function, which sets our database as base class
and returns our model class
"""
class MyUserTable(database):
id = Column(Integer, primary_key=True)
name = Column(String(255))
return MyUserTable
Technical background¶
groundwork-web uses the Flask extension Flask-Restless to provide this functionality.
The used Flask-Restlessd object is available under self.app.web.rest.flask_restless
and can be used to
implement or activate each documented functionality for Flask-Restless.