pracro:pracro
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| pracro:pracro [2008/11/25 08:58] – deva | pracro:pracro [2012/11/08 10:36] (current) – deva | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ======Pracro - Praxis Macro system ====== | ======Pracro - Praxis Macro system ====== | ||
| + | =====New concepts===== | ||
| + | [[pracro: | ||
| + | [[pracro: | ||
| + | [[pracro: | ||
| + | [[pracro: | ||
| + | [[pracro: | ||
| + | [[pracro: | ||
| + | =====Upgrade from old to new database structure===== | ||
| + | Remove duplicate entries from fieldnames table: | ||
| + | < | ||
| + | delete from fieldnames where ctid not in (select max(dup.ctid) from fieldnames as dup group by dup.name); | ||
| + | </ | ||
| + | |||
| + | Remove duplicates from fields: | ||
| + | < | ||
| + | delete from fields where ctid not in (select max(dup.ctid) from fields as dup group by dup.transaction, | ||
| + | </ | ||
| + | |||
| + | < | ||
| + | ALTER TABLE transactions RENAME TO transactions_old; | ||
| + | </ | ||
| + | |||
| + | < | ||
| + | CREATE TYPE session_status AS ENUM (' | ||
| + | </ | ||
| =====Roadmap===== | =====Roadmap===== | ||
| See the [[pracro: | See the [[pracro: | ||
| Line 10: | Line 35: | ||
| =====Random Stuff===== | =====Random Stuff===== | ||
| + | [[Devas corner]]\\ | ||
| + | [[Senators corner]] | ||
| + | |||
| + | ====Open/ | ||
| + | GOALS: | ||
| + | * Only one open macro at any point of time. | ||
| + | * Not possible to close an unchanged macro by saving it. | ||
| + | * Warn the user if an unsaved macro is about to be collapsed. | ||
| + | When clicking on the expand/ | ||
| + | Initially the ' | ||
| + | The only exception to this is if the macro is loaded, prefilled with commit-able data, ie. data from Pentominos or other external sources, that simply needs to be committed to the database without further actions of the user.\\ | ||
| + | When the commit button (or optionally abort button) is clicked, the macro will be collapsed, and its data either committed to the server, or thrown away.\\ | ||
| + | If the expand/ | ||
| + | If the macro contains no changes, it will simply be collapsed.\\ | ||
| + | If the macro contains unsaved data, the user will be prompted to save these data and collapse, ignore the changes and collapse or stay open and do nothing.\\ | ||
| + | If another macro is already open when the expansion is about to be initiated, the already open macro will enter 'about to collapse' | ||
| ====Types==== | ====Types==== | ||
| Line 146: | Line 187: | ||
| * < | * < | ||
| * < | * < | ||
| + | |||
| + | |||
| ====Documentation==== | ====Documentation==== | ||
| Line 151: | Line 194: | ||
| * {{: | * {{: | ||
| * {{: | * {{: | ||
| - | * {{: | + | * {{: |
| * {{: | * {{: | ||
| + | * {{: | ||
| + | * {{: | ||
| + | |||
| ====Macros (local)==== | ====Macros (local)==== | ||
| * {{: | * {{: | ||
| * {{: | * {{: | ||
pracro/pracro.1227599934.txt.gz · Last modified: by deva
