Jam.py
Jam.py Application Design Tips
Development Checklist
Application Design
“How-to” guides
How was Demo built?
MS Access migration
Users application screenshots
Acknowledgements
Jam.py
Jam.py Application Design Tips
Jam.py Application Design Tips
Development Checklist
Development Checklist
Built in Code Editor
Python version
Using Python Virtual Environments
Using the Source Control
Unit Testing
Continuous Integration (CI)
Generating Documentation
Limited introduction to the tool
Debugging
Profiling
Containers
Choosing the Web Server
Apache Web Server and
mod_wsgi
IIS Web Server
CPanel
Choosing the Database
Database triggers
Database views
Database indexes
Database sequences
admin.sqlite Database
Application Design
Getting Started
Top 5 Questions
1. What is Jam.py?
2. Why using Jam.py?
3. Why not to use Jam.py?
4. Does it scale?
5. What can I use it for?
Terminology
Catalogs (Catalogues)
Journals
Details
Reports
Virtual Tables
Need more Groups?
Wrapping up
Journal/Detail (or Master/Child) scenario
Forms, Buttons and other user interaction items
Bulk updates, inserts or delete
Authentication Decision
Built in Authentication
Non built in Authentication
External Authentication
LDAP (Active Directory) Authentication
SAML or SSO Authentication
OAuth2, OpenID or SiteMinder (CA) Authentication
MFA or Two Factor Authentication
User Registration Form
Forgotten Password Method
Using Python libraries
Generated Images
“How-to” guides
How to install Jam.py on Windows
Install Python
About
pip
Setting up a virtual environment
Install Jam.py
Common pitfalls
How was Demo built?
Demo project
Demo database
What to expect?
DropDown Menu(s)
Data Grid(s)
More Data Grid(s)
Data Grid Header/Footer
Any questions?
Ok, how do I start?
Invoices
Customers
Invoice items
How did we go?
Click on!
Your 1st task!
A little code
Invoices
Error handling!
So, how was it?
More code
Invoices Details
Server code
Invoices
Why Server Code?
Debugging
And finally…
…the End of Code
index.html
Templates
Template Code
Wrapping up
Dashboard
Dashboard template
Dashboard Menu Item
Dashboard Code
Cosmetic code
End of Dashs
MS Access migration
MS Access migration
Top Migration Questions
1. Complacency
2. VBA?
3. Excel?
4. Queries
5. Primary Keys
6. Deployment
7. Compile Error
8. Cannot open the database
Conclusion
Where from here?
Notes/Issues
Terms and Conditions
Now what?
Tables
Using UTF8
Field Captions
Reserved Words
Deleted Flag
Primary Keys
Foreign Keys
Indexes
Users table
Some migrated examples
Personal Account Ledger
Northwind Traders
Inventory transactions
Users application screenshots
Acknowledgements
About the author
Copyright