pasteque-server issueshttps://framagit.org/pasteque/pasteque-server/-/issues2018-06-25T10:44:49Zhttps://framagit.org/pasteque/pasteque-server/-/issues/84Database initialization2018-06-25T10:44:49ZKaramelDatabase initializationSet the routine to at least initialize an empty database with the correct structure.
- Get current database version from VersionAPI
- Add a request to initialize the database
- Automatically generate user configuration for database acce...Set the routine to at least initialize an empty database with the correct structure.
- Get current database version from VersionAPI
- Add a request to initialize the database
- Automatically generate user configuration for database access if the script can even create new databases
Default data-set could be installed on the server to pick one available when requesting database population.v8.0https://framagit.org/pasteque/pasteque-server/-/issues/86Database integrity check2017-09-11T14:03:54ZKaramelDatabase integrity checkCreate a script, API or report that checks fiscal tickets integrity. It is an incremental check.
That is for each chain:
- For new chains check that the first ticket is number 1 (0 is EOS)
- For further checks, start at the last checked...Create a script, API or report that checks fiscal tickets integrity. It is an incremental check.
That is for each chain:
- For new chains check that the first ticket is number 1 (0 is EOS)
- For further checks, start at the last checked ticket and check if the signature wasn't changed
- Check that the following ticket signatures are OK and their number is n + 1
- Check that the signature of the EOS (end of sequence) ticket is OK
The result should give the list of errors and the last signature (before EOS). This signature is passed to the next check to see if the hole chain wasn't alterated between 2 checks and allow to recheck only this one instead of the whole chain again. This allow fast and frequent checks.
The whole chain must be checked on fiscal control. It will be resource and time consuming.v8.0