Upgrade67 Create or Connect To PostgreSQL Database

Wireframes

Upgrade Database Configuration - Create Database

Upgrade Database Configuration - Connect to Database

Upgrade Database Configuration - Connect to Database - Errors

Annotations

#	Component	Description
1	Database Configuration Section	This section contains allows for either the creation of a new database or to connect to an existing database.
1.1	Create or Connect Tabs	Offers options to "Create Database" or "Connect to Existing Database"
1.2	Database creation or connection input fields	Collects the data necessary to either create a database or connect to one. Errors in when testing the connection (see Annotation 1.3 below) will be visually demarcated.
1.3	Test Connection Button	This button initiates a test connection to the database with the information provided by the user. This button is enabled on page load and only disabled as long as the test is running. If the test takes more than 2 seconds a spinner is shown until the action has completed. Once the test is successfully run the "Next" button will be enabled.
2	Main Control Area	This area contains the "Next" button which controls the main flow of the wizard.
2.1	Cancel Upgrade Button	This button is always enabled although styled differently than other buttons. It cancels the current process and returns the cloud to the state before starting the upgrade.
2.2	Next Button	This button will be disabled by default. When creating a new database it will be enabled when the username and password fields are filled. When connecting to a database it will be enabled when the connection has been tested and returns success. When the user clicks on it, the user will be redirected to Add-On Product Repository Check.
3	Status Section	This section shows the overall status and current step of the upgrade process.
3.1	Status Item	All steps necessary to upgrade the cloud is displayed here. The current step is displayed to the user. No user interaction is possible.

Business Rules

1. Upgrade Database Configuration page can only be accessed by the Crowbar Administrator.
2. Crowbar Administrator must specify a Postgres database for Crowbar to connect with, either by creating a new one or specifying an existing one.
3. "Create a new Postgres DB" button will be enabled and selected by default.
4. "Connect to an existing Postgres DB" button will be enabled and unselected by default.
5. "Create a new Postgres DB" and "Connect to an existing Postgres DB" buttons are mutually exclusive.
6. "Username" field will be displayed on all cases and needs to meet the following restrictions:
   1. Required
   2. Minimum length: 4 characters
   3. Maximum length: 250 characters
   4. Only Alphanumeric characters are allowed
7. "Password" field will be displayed on all cases and needs to meet the following restrictions:
   1. Required
   2. Minimum length: 4 characters
   3. Maximum length: 250 characters
   4. Only Alphanumeric characters are allowed (Special characters? Encoding? UTF-8?)
8. "Next" button is disabled by default.
9. When "Create a new Postgres DB" button is selected:
10. "Next" button will trigger the Database creation.
11. After Database creation, the Crowbar Administrator will be redirected to Add-On Product Repository Check.
12. When "Connect to an existing Postgres DB" button is selected:
13. "Table Prefix" field will be displayed when "Connect to an existing Postgres DB" is selected and needs to meet the following restrictions: 1. Required 1. Minimum length: 4 characters 1. Maximum length: 250 characters 1. Only Alphanumeric characters are allowed (Special characters? Encoding? UTF-8?)
14. "Server IP Address" field will be displayed when "Connect to an existing Postgres DB" is selected and needs to meet the following restrictions: 1. Required 1. Minimum length: 7 characters 1. Maximum length: 15 characters 1. Only numbers and period characters are allowed (IPv6? Hostnames?)
15. "Port" field will be displayed when "Connect to an existing Postgres DB" is selected and needs to meet the following restrictions: 1. Required 1. Minimum length: 1 character 1. Maximum length: 5 characters 1. Only numbers are allowed 1. Default value: 5432
16. "Test Connection" button is displayed.
17. "Test Connection" button is enabled once all form fields meets their specified requirements and restrictions.
18. "Test Connection" tests the database connection with the provided IP/hostname, port number, table prefix, username and password.
19. If the database connection is successfully made, "Test Connection" button will be disabled and "Next" button will be enabled.
20. When clicked, "Next" button will redirect the Crowbar Administrator to Add-On Product Repository Check.
21. When any form element change its values, "Next" button will be disabled and "Test Connection" button will be enabled.
22. In case of errors, the Crowbar Administrator will be notified.

Test Cases

TC.UPGRADE.DATABASE.NEW.01

TC.UPGRADE.DATABASE.EXISTING.01

User Stories

• (A list of Trello cards to track the implementation of this page)