Created: 2021-03-11 18:43:55.291389

From Prototype: 1.1 (Mar 3, 2021)

Clone from: /Users/val/xdev/ApiLogicServer/prototype

API Logic Server is based on the projects shown below. Consult their documentation for important information.

SAFRS: Python OpenAPI & JSON:API Framework

SAFRS is an acronym for SqlAlchemy Flask-Restful Swagger. The purpose of this framework is to help python developers create a self-documenting JSON API for sqlalchemy database objects and relationships.

These objects can be serialized to JSON and can be created, retrieved, updated and deleted through the JSON API. Optionally, custom resource object methods can be exposed and invoked using JSON.

Class and method descriptions and examples can be provided in yaml syntax in the code comments.

The description is parsed and shown in the swagger web interface. The result is an easy-to-use swagger/OpenAPI and JSON:API compliant API implementation.

Transaction Rules for SQLAlchemy Object Models

Use Logic Bank to govern SQLAlchemy update transaction logic - multi-table derivations, constraints, and actions such as sending mail or messages. Logic consists of both:

• Rules - 40X more concise using a spreadsheet-like paradigm, and

• Python - control and extensibility, using standard tools and techniques

Logic Bank is based on SQLAlchemy - it handles before_flush events to enforce your logic. Your logic therefore applies to any SQLAlchemy-based access - JSON:Api, Flask App Builder, etc.

Declare your logic in: logic/logic_bank.py

Object Relational Mapping for Python.

SQLAlchemy provides Python-friendly database access for Python.

It is used by JSON:Api, Logic Bank, and Flask App Builder.

SQLAlchemy processing is based on Python model classes, created automatically by API Logic Server from your database, and saved in the database directory.

This generated project also contains a basic web app

• Multi-page - including page transitions to "drill down"

• Multi-table - master / details (with tab sheets)

• Intelligent layout - favorite fields first, predictive joins, etc

  Edit your pages in: ui/basic_web_app/app/view.py

Before you run your app, you must create admin data, and address certain restrictions. For more information, see Working with Flask AppBuilder.

Install your projects' environment:

cd <your project>
test> cd my_new_project
virtualenv venv
source venv/bin/activate  # windows venv\Scripts\activate
pip install -r requirements.txt
python api_logic_server_run.py

Then, run:

• Open API (Swagger) - localhost:5000/api

• Basic Web App - localhost:8080

Logic: /logic/logic_bank.py
SQLAlchemy Models: /database
Services: /api
Flask App: /ui