 Z TABLE
|
Login | |||||||||||||||||||
| Admin | ||||||||||||||||||||
| Buy Me A Coffee | Repo | |||||||||||||||||||
| This page aims to introduce all available features using Z Table, it IS in fact a Z Table itself. It also serves at auto-testing all functionnalities. | ||||||||||||||||||||
| Interested ? Send me an email: z.table.tech@gmail.com | ||||||||||||||||||||
| This solution is based on Python using Django framework with a PostgreSQL database and a redis server, it is dockerized with docker-compose (can be integrated easily) | ||||||||||||||||||||
| Main concepts of solution | ||||||||||||||||||||
| 1/ Display | ||||||||||||||||||||
| A display, is an association of: | ||||||||||||||||||||
| - a list of elements to display and their respective positions (Only elements of type Table for the moment) | ||||||||||||||||||||
| - a security config | ||||||||||||||||||||
| - a style config (Config Style, css) | ||||||||||||||||||||
| -> So the same data can be viewed with different security permissions and style ! | ||||||||||||||||||||
| 2/ Cell | ||||||||||||||||||||
| On each cell you can (if appropriate permission given): | ||||||||||||||||||||
| - edit a 'dataFormula' that will compute the data (pure value, match calculation, date calculation, API calls...) | ||||||||||||||||||||
| - edit a 'viewFormula' that will compute the view displayed (adding css style, html_attributes, javascript...) | ||||||||||||||||||||
| - (re)calculate content | ||||||||||||||||||||
| - lock cell to prevent formulas modification | ||||||||||||||||||||
| - see cell information | ||||||||||||||||||||
| 3/ Function | ||||||||||||||||||||
| A Function is a Python function that can be defined on the admin panel in order to be used in cell formulas ('dataFormula' and 'viewFormula'), limitless possibilities: | ||||||||||||||||||||
| - create functions to gather data (API Calls, Maths, string & date manipulation...) to be used in 'dataFormula' | ||||||||||||||||||||
| - create functions to do view rendering (adding css style, html_attributes, javascript...) to be used in 'viewFormula' | ||||||||||||||||||||
| - create function to enhance security | ||||||||||||||||||||
| 4/ Synchronization | ||||||||||||||||||||
| - all display that relates to same data table content and structure (rows and columns) are synchronized in real time | ||||||||||||||||||||
| - for a same table data or group of table (can reference each other) a queue handles request in received order | ||||||||||||||||||||
| - it is possible to schedule batches to recalculate 1 Cell / 1 Row / 1 Table each X seconds | ||||||||||||||||||||
| 5/ Examples of possibilities (and Tests at the same time) | ||||||||||||||||||||
|
NB: TEST is a function that change text color to green if it matches, else shows difference like so: expected: What was expected actual: What result is |
||||||||||||||||||||
|
||||||||||||||||||||
| 6/ Schedule Re-calculation | ||||||||||||||||||||
|
||||||||||||||||||||
| Test - Calculate batch Table | ||||||||||||||||||||
| 7/ Auto Security Tests | ||||||||||||||||||||
|
||||||||||||||||||||
| 8/ Technical Auto doc (Documentation auto-generated, not shown to all for security reasons!) | ||||||||||||||||||||
|
||||||||||||||||||||