SQL database: Difference between revisions
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
The SQL database is also the main interface between the control application and the outside world (webpage, Apps). | The SQL database is also the main interface between the control application and the outside world (webpage, Apps). | ||
The empty SQL dump of the | The empty SQL dump of the databases are stored in the bitbucket repository: | ||
git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-database.git | git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-database.git | ||
After cloning the database repository, first create the databases with the statement provided in <code>create_databases.sql</code>. | As of December 2024, the databases are empty. | ||
The databases for the tests are emptied and filled programmatically by the test cases before the execution of each test case. | |||
The high number of test databases shall allow maximum parallelisation of the test case execution which takes several minutes. | |||
After cloning the database repository, first create the test databases with the statement provided in <code>create_databases.sql</code>. | |||
You might want to consider using different accounts for the databases between normal operation and test execution. The account data (user and password) are stated in the .toml configuration files. | |||
Second, create the user(s): <code>CREATE USER aquarium@localhost;</code> | |||
Revision as of 14:36, 30 December 2024
The control application uses a MySQL database for persistent storing of states and logging of activities as well as storage of input data.
The SQL database is also the main interface between the control application and the outside world (webpage, Apps).
The empty SQL dump of the databases are stored in the bitbucket repository: git clone https://in-dubio@bitbucket.org/in-dubio/aquarium-database.git
As of December 2024, the databases are empty. The databases for the tests are emptied and filled programmatically by the test cases before the execution of each test case. The high number of test databases shall allow maximum parallelisation of the test case execution which takes several minutes.
After cloning the database repository, first create the test databases with the statement provided in create_databases.sql.
You might want to consider using different accounts for the databases between normal operation and test execution. The account data (user and password) are stated in the .toml configuration files.
Second, create the user(s): CREATE USER aquarium@localhost;