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: 2008/11/25 08:58 by deva