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 until the connection has been tested and returns success. When the user clicks on it, the user will be redirected to Migrate OpenStack Database page
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. "Table Prefix" field will be displayed "Connect to an existing Postgres DB" is selected 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?)
9. "Server IP Address" field will be displayed on all cases and needs to meet the following restrictions:
   1. Required
   2. Minimum length: 7 characters
   3. Maximum length: 15 characters
   4. Only numbers and period characters are allowed (IPv6? Hostnames?)
10. "Next" button is disabled by default and enabled once all form fields meets their specified requirements and restrictions.
11. "Next" button will trigger the Database creation if "Create a new Postgres DB" button is selected.
12. "Next" button will will be disabled when "Connect to an existing Postgres DB" button is selected.
13. "Test Connection" button tests the connection and enables the "Next" button on success.
14. Once the Database connection or creation is completed, the user will be redirected to Migrate OpenStack Database page.
15. Validation errors will be notified to the Crowbar Administrator after he clicks on the "Test Connection" button, the "Next" button and whenever a form field doesn't meet all specified restrictions.
16. Backend problems will be notified to the Crowbar Administrator after he clicks on the "Next" button.

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)